private void detach_SMSLists(SMSList entity) { this.SendPropertyChanging(); entity.Person = null; }
private void attach_SMSLists(SMSList entity) { this.SendPropertyChanging(); entity.Person = this; }
private void detach_SMSLists(SMSList entity) { this.SendPropertyChanging(); entity.SmsReceived = null; }
private void detach_SMSLists(SMSList entity) { this.SendPropertyChanging(); entity.SMSGroup = null; }
private void attach_SMSLists(SMSList entity) { this.SendPropertyChanging(); entity.SMSGroup = this; }
public static void QueueSMS(Guid iQBID, int iSendGroupID, string sTitle, string sMessage) { var q = DbUtil.Db.PeopleQuery(iQBID); // Create new SMS send list var list = new SMSList(); list.Created = DateTime.Now; list.SendAt = DateTime.Now; list.SenderID = Util.UserPeopleId ?? 1; list.SendGroupID = iSendGroupID; list.Title = sTitle; list.Message = sMessage; DbUtil.Db.SMSLists.InsertOnSubmit(list); DbUtil.Db.SubmitChanges(); // Load all people but tell why they can or can't be sent to foreach (var i in q) { var item = new SMSItem(); item.ListID = list.Id; item.PeopleID = i.PeopleId; if (i.CellPhone != null && i.CellPhone.Length > 0) { item.Number = i.CellPhone; } else { item.Number = ""; item.NoNumber = true; } if (!i.ReceiveSMS) { item.NoOptIn = true; } DbUtil.Db.SMSItems.InsertOnSubmit(item); } DbUtil.Db.SubmitChanges(); // Check for how many people have cell numbers and want to receive texts var qSMS = from p in q where p.CellPhone != null where p.ReceiveSMS == true select p; var countSMS = qSMS.Count(); /* if (countSMS > 0) { foreach (var i in qSMS) { var item = new SMSItem(); item.ListID = list.Id; item.PeopleID = i.PeopleId; item.Number = i.CellPhone; DbUtil.Db.SMSItems.InsertOnSubmit(item); } } */ // Add counts for SMS, e-Mail and none list.SentSMS = countSMS; list.SentNone = q.Count() - countSMS; DbUtil.Db.SubmitChanges(); ProcessQueue(list.Id); }