public static void CreateTrigger(SendMessage model) { using (JazMaxDBProdContext db = new DataAccess.JazMaxDBProdContext()) { MessengerTrigger t = new MessengerTrigger() { BranchId = model.BranchId, CoreUserId = model.CoreUserId, CreatedDate = DateTime.Now, HasBeenProcessed = false, IsCancelled = 0, MessengerComTypeId = 1, CoreProvinceId = model.ProvinceId, CoreUserTypeId = model.CoreUserTypeId, MessageBody = model.MessageBody, MessengerTemplateId = 1, NumberOfContacts = null, ProcessedDateTime = null, SendingDate = model.SendDate, SendingTo = model.SendTo, TriggerSetup = model.TriggerText, MessageSubject = model.MessageSubject }; db.MessengerTriggers.Add(t); db.SaveChanges(); } }
private void MarkAsProcessed(int MessengerTriggerId, int NumberContacts = 0) { using (JazMaxDBProdContext db = new JazMaxDBProdContext()) { MessengerTrigger table = db.MessengerTriggers?.FirstOrDefault(x => x.MessengerTriggerId == MessengerTriggerId); if (table != null) { table.HasBeenProcessed = true; table.ProcessedDateTime = DateTime.Now; table.NumberOfContacts = NumberContacts; } db.SaveChanges(); } }