public void UpdateStatus(string email, Data_AppUserFile.eUserStatus newStatus, IMyLog log)
{
SqlCmdBuilder cmd = new SqlCmdBuilder(TABLE_NAME);
cmd.Add("[AccountStatus]", newStatus.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("UpdateAll: *** unexpected RecordsAffected != 1");
}
}
}
public void UpdateCounters_Queued(string email, long timeNow, int howMany, IMyLog log)
{
SqlCmdBuilder cmd = new SqlCmdBuilder(TABLE_NAME);
cmd.Add("[LastMsgQueuedUtc]", SqlExtensions.SqlDateUtcNow().ToString());
cmd.AddInc("[NoOfQueuedMessages]", howMany);
cmd.AddDec("[RemainingMessages]", howMany);
cmd.Add("[AccountStatus]", String.Format("CASE WHEN {0}={1} THEN {2} ELSE {0} END",
"[AccountStatus]",
Data_AppUserFile.eUserStatus.verified_welcome_No_sent.ToIntString(),
Data_AppUserFile.eUserStatus.verified_welcome_queued.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");
}
}
}
public void UpdateAll(
string email,
string userName,
string password,
string creationIp,
string telNumbers,
Data_AppUserFile.eUserStatus status,
Int32 minDelayInSeconds,
Int64 noOfQueuedMessages,
Int64 noOfSentMessages,
Int64 noOfBytesSent,
Int64 remainingMsg,
IMyLog log)
{
SqlCmdBuilder cmd = new SqlCmdBuilder(TABLE_NAME);
cmd.Add("[UserName]", userName.Quote());
cmd.Add("[Password]", password.Quote());
cmd.Add("[CreationIp]", creationIp.Quote());
cmd.Add("[MobileNumbers]", telNumbers.Quote());
cmd.Add("[AccountStatus]", status.ToIntString());
cmd.Add("[MinDelayInSeconds]", minDelayInSeconds.ToString());
cmd.Add("[NoOfQueuedMessages]", noOfQueuedMessages.ToString());
cmd.Add("[NoOfSentMessages]", noOfSentMessages.ToString());
cmd.Add("[NoOfBytesSent]", noOfBytesSent.ToString());
cmd.Add("[RemainingMessages]", remainingMsg.ToString());
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("UpdateAll: *** unexpected RecordsAffected != 1");
}
}
}
