public static void UpdateAcknowledgmentFlag(string mailRowId)
{
string strSQL = "UPDATE DIC_UserMail SET MAIL_AcknowledgementRequested ='0' WHERE MAIL_RowID ='" + mailRowId + "'";
CACHEDAL.ConnectionClass cache = new CACHEDAL.ConnectionClass();
cache.Transaction(strSQL);
}
public static bool updateNTMCallbackNotes(string accession, string notes)
{
StringBuilder sbSQL = new StringBuilder();
sbSQL.Append("UPDATE ORD_NoTestMarked SET ");
sbSQL.Append("NTM_CallbackNotes = '");
sbSQL.Append(notes);
sbSQL.Append("' ");
sbSQL.Append("WHERE NTM_AccessionDR ='");
sbSQL.Append(accession);
sbSQL.Append("'");
CACHEDAL.ConnectionClass cache = new CACHEDAL.ConnectionClass();
return(cache.Transaction(sbSQL.ToString()));
}
