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