public int GetFirstFolderId(string UserId, int MailBoxId = 0) { long Id = Convert.ToInt32(UserId); int _MailBoxId = Convert.ToInt32(MailBoxId); int FolderId = 0; if (_MailBoxId == 0) { using (var Entity = new WebMailEntities()) { _MailBoxId = Entity.MailBoxes.Where(s => s.UserId == Id).OrderBy(s => s.MailBoxSequence).Take(1).Select(z => z.MailBoxId).FirstOrDefault(); } } using (var Entity = new WebMailEntities()) { FolderId = Entity.MailBoxFolders.Where(s => s.MailBoxId == _MailBoxId).OrderBy(s => s.Sequence).Take(1).Select(z => z.MailBoxFolderId).FirstOrDefault(); } return(FolderId); }
public void Update(MailViewModel mail) { UpdateDatabase = true; using (var Entity = new WebMailEntities()) { var target = Entity.Mails.Where(x => x.MessageID == mail.ID).FirstOrDefault(); if (target != null) { int _Category = Convert.ToInt32(mail.Category); target.From = mail.From; target.Subject = mail.Subject; target.IsRead = mail.IsRead; target.To = mail.To; target.Category = _Category; target.Email = mail.Email; Entity.SaveChanges(); } } }
public bool UpdateEmailSubject(MailViewModel mail, string UpdateOnlyDisable = null) { try { using (var Entity = new WebMailEntities()) { Mail Mail = Entity.Mails.Where(s => s.MessageID == mail.ID).FirstOrDefault(); if (UpdateOnlyDisable == "Disable") { if (Mail != null) { Mail.Status = "D"; Entity.SaveChanges(); } } else if (UpdateOnlyDisable == "Deleted") { if (Mail != null) { Entity.Mails.Remove(Mail); Entity.SaveChanges(); } } else { if (Mail != null) { Mail.Subject = mail.Subject; Mail.Status = mail.Status; Entity.SaveChanges(); } } return(true); } } catch (Exception ex) { return(false); } }
public TasksService(WebMailEntities entities) { this.entities = entities; }
public ContactsService(WebMailEntities entities) { this.entities = entities; }
public EventsService(WebMailEntities entities) { this.entities = entities; }