private void bGWorkerLogFinished_DoWork(object sender, DoWorkEventArgs e)
{
RequestsDB requestDB = new RequestsDB();
CleanProcedure mReq = (CleanProcedure)e.Argument;
e.Result = requestDB.FinishClean(mReq);
if ((int)e.Result > 0)
{
SendEmail(mReq.mReqID);
}
}
public int FinishClean(CleanProcedure reqCleanProcedures)
{
String now = DateTime.Now.ToString();
OleDbCommand cmd = new OleDbCommand();
cmd.CommandText = "UPDATE " + REQUESTTABLE + " SET [FinishedOn] = @date, [Decon] = @decon, [Dishwasher] = @dishwasher, " +
"[WaterPik] = @waterpik, [Ultrasonic] = @ultrasonic, [Crest10] = @crest10, [Crest20] = @crest20, [CrestLong] = @crestlong WHERE [RequestID] = @reqID";
cmd.Parameters.AddWithValue("@date", now);
cmd.Parameters.AddWithValue("@decon", reqCleanProcedures.mDecon);
cmd.Parameters.AddWithValue("@dishwasher", reqCleanProcedures.mDishWasher);
cmd.Parameters.AddWithValue("@waterpik", reqCleanProcedures.mWaterPik);
cmd.Parameters.AddWithValue("@ultrasonic", reqCleanProcedures.mUltrasonic);
cmd.Parameters.AddWithValue("@crest10", reqCleanProcedures.mCrest10);
cmd.Parameters.AddWithValue("@crest20", reqCleanProcedures.mCrest20);
cmd.Parameters.AddWithValue("@crestlong", reqCleanProcedures.mCrestLong);
cmd.Parameters.AddWithValue("@reqID", reqCleanProcedures.mReqID);
return(requestDB.Update(cmd));
}
public FinishForm(int req)
{
InitializeComponent();
reqId = req;
cleanProcedure = new CleanProcedure();
}