What everybody doing right now?
#12
RE: What everybody doing right now?
Working at continuing to improve our web application for those that hunt and fish to track their time outdoors based on weather and stand location. www.tighttrack.com
#13
Banned
Join Date: Oct 2006
Location: Inside your Mom
Posts: 2,231
RE: What everybody doing right now?
Just arrived at work, now starting to check my e-mail, check all of my sites I go to. I usually arrive at work around 7:30, but don't get started actually working around 9ish.
#16
RE: What everybody doing right now?
Just arrived at work, now starting to check my e-mail, check all of my sites I go to. I usually arrive at work around 7:30, but don't get started actually working around 9ish.
#19
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");
}
#20
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");
}
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");
}
Looks like we have a programming dork on our hands. Just kidding...but am I right, are you a programmer?