RE: What everybody doing right now?
Writing this method and SP
if (m_franDb.ExecuteNonQuerySingleRecordAffected(ref franCmd))
{
SqlCommand tbUpdateCmd = m_customerCareDb.GetCommand("spUpdateRecordUpLoad", true);
tbUpdateCmd.Parameters.AddWithValue("@RoyaltyReportWeekTotalsID", DataUtil.GetDBInt32(row["RoyaltyReportWeekTotalsID"]));
tbUpdateCmd.Parameters.AddWithValue("@FranchiseID", DataUtil.GetDBInt32(row["FranchiseID"]));
m_customerCareDb.ExecuteNonQuerySingleRecordAffect ed(ref tbUpdateCmd);
tbUpdateCmd = null;
// record updated successfully
Logger.Log(TraceLevel.Verbose, "Updated TransmittedToFranCISDateTime : '" +
DataUtil.GetDBString(row["FranchiseNumber"]) + "' in the toolbox database");
SqlCommand tbUpdateLRCmd = m_customerCareDb.GetCommand("spUpdateLastReportSent", true);
tbUpdateLRCmd.Parameters.AddWithValue("@FranchiseNumber", DataUtil.GetDBInt32(row["FranchiseNumber"]));
tbUpdateLRCmd.Parameters.AddWithValue("@LastReportSent", lastPostDate);
m_customerCareDb.ExecuteNonQuerySingleRecordAffect ed(ref tbUpdateLRCmd);
tbUpdateLRCmd = null;
Logger.Log(TraceLevel.Verbose, "Updated LastRptdate : '" +
DataUtil.GetDBString(row["FranchiseNumber"]) + "' in the toolbox database");
// record updated successfully
Logger.Log(TraceLevel.Verbose, "Data updated successfully for franchise number: '" +
DataUtil.GetDBString(row["FranchiseNumber"]) + "' in the toolbox database");
SqlCommand tblGetEmailAddress = m_customerCareDb.GetCommand("spGetEmailAddress", true);
tblGetEmailAddress.Parameters.AddWithValue("@frannum", frannum);
DataSet dsEmailData = m_customerCareDb.GetDataSet(ref tblGetEmailAddress);
foreach (DataRow Emailrow in dsEmailData.Tables[0].Rows)
{
string emailaddress = DataUtil.GetDBString(Emailrow["EmailCustomer"]);
emailResponse(emailaddress, SBYear, SBWeek, datereceived, RoyaltyPaid, frannum, WEDate);
}
Logger.Log(TraceLevel.Verbose, "Email Sent successfully for franchise number: '" +
DataUtil.GetDBString(row["FranchiseNumber"]) + "Sent Notification Email");
}
else
{
// failed to update
Logger.Log(TraceLevel.Error, "An error occured while updating franchise number: '" +
DataUtil.GetDBString(row["FranchiseNumber"]) + "' in the toolbox database");
}
franCmd = null;
// throttle loop
Thread.Sleep(200);
}
tbCmd = null;
}
dsFranData = null;
Logger.Log(TraceLevel.Verbose, "End");
}