public void StoreNew(Data_AppUserFile data, out bool fileArleadyUsed, IMyLog log) { fileArleadyUsed = false; if (HasAccount(data.Email, log)) { fileArleadyUsed = true; return; } SqlCmdBuilder cmd = new SqlCmdBuilder(TABLE_NAME); cmd.Add("[UserName]", data.UserName.Quote()); cmd.Add("[MobileNumbers]", data.MoblieAllNumbers.Quote()); cmd.Add("[Email]", data.Email.Quote()); cmd.Add("[Password]", data.Password.Quote()); cmd.Add("[CreationDateUtc]", data.CreationDate.SqlDate().ToString()); cmd.Add("[CreationIp]", data.CreationIp.Quote()); cmd.Add("[ApiGuId]", data.ApiGuId.Quote()); cmd.Add("[NoOfQueuedMessages]", data.NoOfQueuedMessages.ToString()); cmd.Add("[NoOfSentMessages]", data.NoOfSentMessages.ToString()); cmd.Add("[NoOfBytesSent]", data.NoOfBytesSent.ToString()); cmd.Add("[RemainingMessages]", data.RemainingMessages.ToString()); cmd.Add("[MinDelayInSeconds]", data.MinDelayInSeconds.ToString()); cmd.Add("[AccountStatus]", data.AccountStatus.ToIntString()); string strCmd = cmd.GetSql_InsertSelect(); //System.Diagnostics.Debug.WriteLine(strCmd);//mg remove using (SqlDisposable s = new SqlDisposable(Db, strCmd)) { if (s.Reader.RecordsAffected != 1) { log.Error("StoreNew: *** unexpected RecordsAffected != 1"); } } }