public void UpdateCounters_Processed(string email, int noOfBytes, IMyLog log) { SqlCmdBuilder cmd = new SqlCmdBuilder(TABLE_NAME); cmd.Add("[LastMsgProcessedUtc]", SqlExtensions.SqlDateUtcNow().ToString()); cmd.AddDec("[NoOfQueuedMessages]"); cmd.AddInc("[NoOfBytesSent]", noOfBytes); cmd.AddInc("[NoOfSentMessages]"); cmd.Add("[AccountStatus]", String.Format("CASE WHEN {0}={1} THEN {2} ELSE {0} END", "[AccountStatus]", Data_AppUserFile.eUserStatus.verified_welcome_queued.ToIntString(), Data_AppUserFile.eUserStatus.active.ToIntString())); string strCmd = cmd.GetSql_Update(string.Format("WHERE [Email] like '{0}'", email)); using (SqlDisposable s = new SqlDisposable(Db, strCmd)) { if (s.Reader.RecordsAffected != 1) { log.Error("StoreNew: *** unexpected RecordsAffected != 1"); } } }