public Entities.EMailQueueItem GetEmailFromQueue(int queueid) { using (MessagingEntities db = new MessagingEntities()) { var emailqueue = db.EMailQueues.Where(a => a.Id == queueid).FirstOrDefault(); if (emailqueue != null) { var messagingemailqueue = new Entities.EMailQueueItem { Id = emailqueue.Id, ApplicationID = emailqueue.ApplicationID, CreatedDate = emailqueue.CreatedDate, EmailObject = emailqueue.EmailObject, DeliveryDate = emailqueue.DeliveryDate, DeliveryResponse = emailqueue.DeliveryResponse, NumberOfAttempts = emailqueue.NumberOfAttempts, StatusID = emailqueue.StatusID }; return(messagingemailqueue); } } return(null); }
public void AddEmailToQueue(Entities.EMailQueueItem queue) { using (MessagingEntities db = new MessagingEntities()) { EMailQueue mailqueue = new EMailQueue { ApplicationID = queue.ApplicationID, StatusID = queue.StatusID, EmailObject = queue.EmailObject, CreatedDate = queue.CreatedDate, DeliveryDate = queue.DeliveryDate, NumberOfAttempts = queue.NumberOfAttempts, DeliveryResponse = queue.DeliveryResponse }; db.EMailQueues.Add(mailqueue); db.SaveChanges(); } }
public DataOperationStatus UpdateEmailToQueue(Entities.EMailQueueItem queue) { using (MessagingEntities db = new MessagingEntities()) { var mailqueue = db.EMailQueues.Where(q => q.Id == queue.Id).FirstOrDefault(); if (mailqueue != null) { mailqueue.ApplicationID = queue.ApplicationID; mailqueue.StatusID = queue.StatusID; mailqueue.EmailObject = queue.EmailObject; mailqueue.CreatedDate = queue.CreatedDate; mailqueue.DeliveryDate = queue.DeliveryDate; mailqueue.NumberOfAttempts = queue.NumberOfAttempts; mailqueue.DeliveryResponse = queue.DeliveryResponse; db.SaveChanges(); return(DataOperationStatus.SavedSuccessfully); } else { return(DataOperationStatus.RecordNotExist); } } }