///<summary>Updates the statements with the send status.</summary> public static void UpdateSmsSendStatus(List <long> listStmtNumsToUpdate, AutoCommStatus sendStatus) { if (listStmtNumsToUpdate.Count == 0) { return; } if (RemotingClient.RemotingRole == RemotingRole.ClientWeb) { Meth.GetVoid(MethodBase.GetCurrentMethod(), listStmtNumsToUpdate, sendStatus); return; } string command = "UPDATE statement SET SmsSendStatus=" + POut.Int((int)sendStatus) + " WHERE StatementNum IN(" + string.Join(",", listStmtNumsToUpdate.Select(x => POut.Long(x))) + ")"; Db.NonQ(command); }
///<summary>Returns nothing because this method utilizes InsertMany which does not correctly return the PK of the item(s) inserted.</summary> public static void CreateInvite(long patNum, long aptNum = 0, long clinicNum = 0, long emailMessageNum = 0, AutoCommStatus emailSendStatus = AutoCommStatus.Undefined, string note = "", string templateEmail = "", string templateEmailSubj = "", TimeSpan tSPrior = default(TimeSpan)) { PatientPortalInvite patientPortalInvite = new PatientPortalInvite() { IsNew = true, AptNum = aptNum, ClinicNum = clinicNum, EmailMessageNum = emailMessageNum, EmailSendStatus = emailSendStatus, Note = note, PatNum = patNum, TemplateEmail = templateEmail, TemplateEmailSubj = templateEmailSubj, TSPrior = tSPrior, }; //Insert was not an available method at the time that this method was created. Not worth enhancing S class ATM. Simply use InsertMany(). PatientPortalInvites.InsertMany(new List <PatientPortalInvite>() { patientPortalInvite }); }