I was just messing with gr8 and gmmat on another post about trail cams. hehehe

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

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.

Leaving for Wisconsin soon, get some chores done and last minute preps fot the early season Sept.15

Right now I'm waiting on the Benadryl to kick in. Got into some kind of serious pollen at the range last night. My sinuses are screwed and my eyes are nearly swelled shut.[&:]

Damn, that makes two of us. That is the downfall of finding good websites....it pushes my 'work' time back. While I was working on my first whitetail mount a couple weeks ago, I wouldn't start 'working' until 11:00 because I couldn't leave the forums at www.taxidermy.net. [:-]

Typing this reply ....

At work, reading the forums...

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");
}

Quote:

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");
}

Looks like we have a programming dork on our hands. Just kidding...but am I right, are you a programmer?