public bool UpdateFile(FilesApiModel _FilesApiModel) { try { File _File = new File(); using (var Entity = new WebMailEntities()) { int _id = _FilesApiModel.Id; _File = Entity.Files.Where(z => z.Id == _id).FirstOrDefault(); if (_File != null) { _File.IsValid = _FilesApiModel.IsValid; _File.Name = _FilesApiModel.Name; _File.Path = _FilesApiModel.Path; _File.TypeId = _FilesApiModel.TypeId; Entity.SaveChanges(); } } return(true); } catch (Exception ex) { return(false); } }
public List <System.Web.Mvc.SelectListItem> UserMailBox(int UserId, string request) { List <UserMailBoxApiModel> _Model = new List <UserMailBoxApiModel>(); List <System.Web.Mvc.SelectListItem> _MainBoxList = new List <System.Web.Mvc.SelectListItem>(); string Result = string.Empty; using (var Entity = new WebMailEntities()) { _Model = Entity.UserMailBoxes.Where(x => x.UserId == UserId && x.PermitionLevel != "0").Select(s => new UserMailBoxApiModel { MailboxId = s.MailboxId, FullName = s.MailBox.FullName, ShortName = s.MailBox.ShortName, IsDefoultMailBox = s.IsDefoultMailBox, IsMainContact = s.IsMainContact, PermitionLevel = s.PermitionLevel, }).OrderByDescending(x => x.IsDefoultMailBox).ToList(); } if (request == "DRP") { _MainBoxList = _Model.Select(s => new System.Web.Mvc.SelectListItem { Text = s.FullName, Value = s.MailboxId.ToString(), Selected = s.IsDefoultMailBox == true ? true : false }).ToList(); } ; return(_MainBoxList); }
public IHttpActionResult GetEmailList([ModelBinder(typeof(WebApiDataSourceRequestModelBinder))] DataSourceRequest request, string MailBoxId, string UserId, string AjaxRequest = null) { List <FilesApiModel> result = new List <FilesApiModel>(); try { long _UserId = Convert.ToInt32(UserId); long _MailBoxId = Convert.ToInt32(MailBoxId); using (var Entity = new WebMailEntities()) { result = Entity.Files.Where(x => x.Folder.MailBoxId == _MailBoxId).Select(message => new FilesApiModel { FolderId = message.FolderId.ToString(), Id = message.Id, IsValid = message.IsValid, Name = message.Name, Path = message.Path, StatusId = message.StatusId, TypeId = message.TypeId, PermitionLevel = Entity.UserMailBoxes.Where(z => z.UserId == _UserId && z.MailboxId == _MailBoxId).Select(a => a.PermitionLevel).FirstOrDefault() }).ToList(); } } catch (Exception ex) { } return(Json(result.ToDataSourceResult(request))); }
public bool SaveNewFile(FilesApiModel _FilesApiModel) { try { if (ModelState.IsValid) { File _File = new File(); _File.FolderId = Convert.ToInt32(_FilesApiModel.FolderId); _File.IsValid = _FilesApiModel.IsValid; _File.Name = _FilesApiModel.Name; _File.Path = _FilesApiModel.Path; _File.StatusId = 1; using (var Entity = new WebMailEntities()) { Entity.Files.Add(_File); Entity.SaveChanges(); } return(true); } else { return(false); } } catch (Exception ex) { return(false); } }
public bool AddEditFolder(MailBoxFolderModel Model) { try { MailBoxFolder _MailBoxFolders = new MailBoxFolder(); //For Add if (string.IsNullOrEmpty(Model.MailBoxFolderId.ToString()) || Model.MailBoxFolderId == 0) { using (var Entity = new WebMailEntities()) { _MailBoxFolders.MailBoxFolderName = Model.MailBoxFolderName; _MailBoxFolders.MailBoxId = Model.MailBoxId; _MailBoxFolders.Sequence = 0; _MailBoxFolders.IsActive = true; Entity.MailBoxFolders.Add(_MailBoxFolders); Entity.SaveChanges(); } } else { using (var Entity = new WebMailEntities()) { MailBoxFolder _MailBoxUpdate = Entity.MailBoxFolders.Where(s => s.MailBoxFolderId == Model.MailBoxFolderId).FirstOrDefault(); if (_MailBoxUpdate != null) { _MailBoxUpdate.MailBoxFolderName = Model.MailBoxFolderName; _MailBoxUpdate.MailBoxId = Model.MailBoxId; Entity.SaveChanges(); } } } using (var entity = new WebMailEntities()) { var SequenceArry = Model.Sequenseids.Split(','); for (int i = 0; i < SequenceArry.Count(); i++) { MailBoxFolder _UpdateSequence = new MailBoxFolder(); if (SequenceArry[i].ToString() == "NEWREC") { _UpdateSequence = entity.MailBoxFolders.SingleOrDefault(b => b.MailBoxFolderId == _MailBoxFolders.MailBoxFolderId); } else { Int32 id = Convert.ToInt32(SequenceArry[i].ToString()); _UpdateSequence = entity.MailBoxFolders.SingleOrDefault(b => b.MailBoxFolderId == id); } _UpdateSequence.Sequence = i + 1; entity.SaveChanges(); } } return(true); } catch (Exception ex) { return(false); } }
public User ValidateUser(string UserName, string PassWord) { User _User = new User(); string Result = string.Empty; using (var Entity = new WebMailEntities()) { _User = Entity.Users.Where(s => s.Email.ToUpper() == UserName.ToUpper() && s.Password.ToUpper() == PassWord.ToUpper()).FirstOrDefault(); } return(_User); }
public string CheckMailBoxPermition(string MailBoxId, string UserId) { long _UserId = Convert.ToInt32(UserId); long _MailBoxId = Convert.ToInt32(MailBoxId); string result = string.Empty; using (var Entity = new WebMailEntities()) { result = Entity.UserMailBoxes.Where(s => s.UserId == _UserId && s.MailboxId == _MailBoxId).Select(s => s.PermitionLevel).FirstOrDefault(); } return(result); }
public bool AddEditFolder(FolderApiModel Model) { try { if (Model.TypeId == "0") { using (var Entity = new WebMailEntities()) { int _MailBoxid = Convert.ToInt32(Model.MailBoxId); List <Folder> _FolderList = Entity.Folders.Where(s => s.MailBoxId == _MailBoxid).ToList(); _FolderList.ForEach(s => s.TypeId = 1); Entity.SaveChanges(); } } Folder _Folders = new Folder(); //For Add if (string.IsNullOrEmpty(Model.Id.ToString()) || Model.Id == 0) { using (var Entity = new WebMailEntities()) { _Folders.MailBoxId = Convert.ToInt32(Model.MailBoxId); _Folders.Name = Model.Name; _Folders.StatusId = Convert.ToByte(Model.StatusId); _Folders.TypeId = Convert.ToByte(Model.TypeId); _Folders.StatusId = 1; Entity.Folders.Add(_Folders); Entity.SaveChanges(); } } else { using (var Entity = new WebMailEntities()) { Folder _FoldersUpdate = Entity.Folders.Where(s => s.Id == Model.Id).FirstOrDefault(); if (_FoldersUpdate != null) { _FoldersUpdate.MailBoxId = Convert.ToInt32(Model.MailBoxId); _FoldersUpdate.Name = Model.Name; _FoldersUpdate.StatusId = 1; _FoldersUpdate.TypeId = Convert.ToByte(Model.TypeId); Entity.SaveChanges(); } } } return(true); } catch (Exception ex) { return(false); } }
public List <SelectListItem> MailBoxList() { List <SelectListItem> _MainBoxList = new List <SelectListItem>(); using (var Entity = new WebMailEntities()) { _MainBoxList = Entity.MailBoxes.Select(s => new SelectListItem { Text = s.FullName, Value = s.id.ToString(), }).ToList(); } return(_MainBoxList); }
public List <SelectListItem> MailBoxList(int UserId) { List <SelectListItem> _MainBoxList = new List <SelectListItem>(); using (var Entity = new WebMailEntities()) { _MainBoxList = Entity.MailBoxes.Where(x => x.UserId == UserId).Select(s => new SelectListItem { Text = s.MailBoxName, Value = s.MailBoxId.ToString(), }).ToList(); } return(_MainBoxList); }
public IHttpActionResult GetMailBoxFolderList(long MailBoxId, string Defoult = null, string SerchedFolderString = null, string UserId = null) { long _UserId = Convert.ToInt32(UserId); long DefoultFolderId = 0; List <FolderApiModel> Model = new List <FolderApiModel>(); using (var Entity = new WebMailEntities()) { Model = Entity.Folders.Where(x => x.MailBoxId == MailBoxId && x.StatusId != 0).Select(s => new FolderApiModel { Id = s.Id, Name = s.Name, MailBoxId = s.MailBoxId.ToString(), TypeId = s.TypeId.ToString(), StatusId = s.StatusId.ToString(), MailBoxName = s.MailBox.FullName, }).OrderBy(x => x.TypeId).ThenBy(z => z.Name).ToList(); } List <Folders> _FolderList = new List <Folders>(); if (string.IsNullOrEmpty(SerchedFolderString)) { _FolderList = Model.Select(x => new Folders { MailBoxName = MailBoxId.ToString(), text = x.Name, value = x.Id.ToString(), }).ToList(); } else { _FolderList = Model.Where(x => x.Name.ToUpper().Contains(SerchedFolderString.ToUpper())).Select(x => new Folders { MailBoxName = x.MailBoxName, text = x.Name, value = x.Id.ToString(), }).ToList(); } if (!string.IsNullOrEmpty(Defoult)) { DefoultFolderId = Model.Select(x => x.Id).Take(1).FirstOrDefault(); return(Json(DefoultFolderId)); } else { return(Json(_FolderList)); } }
public MailBoxFolderModel GetFolderDeatiles(long FolderId) { MailBoxFolderModel Model = new MailBoxFolderModel(); using (var Entity = new WebMailEntities()) { Model = Entity.MailBoxFolders.Select(s => new MailBoxFolderModel { MailBoxFolderId = s.MailBoxFolderId, MailBoxFolderName = s.MailBoxFolderName, MailBoxId = s.MailBoxId, Sequence = s.Sequence, }).Where(x => x.MailBoxFolderId == FolderId).FirstOrDefault(); } return(Model); }
public IHttpActionResult UpdateEmailDetailes([ModelBinder(typeof(WebApiDataSourceRequestModelBinder))] DataSourceRequest request, FilesApiModel _FilesApiModel) { if (_FilesApiModel.FolderId == "Disable") { using (var Entity = new WebMailEntities()) { File Files = Entity.Files.Where(s => s.Id == _FilesApiModel.Id).FirstOrDefault(); if (Files != null) { Files.StatusId = 0; Entity.SaveChanges(); } } } else if (_FilesApiModel.FolderId == "Deleted") { using (var Entity = new WebMailEntities()) { File Mail = Entity.Files.Where(s => s.Id == _FilesApiModel.Id).FirstOrDefault(); if (Mail != null) { Entity.Files.Remove(Mail); Entity.SaveChanges(); } } } else { using (var Entity = new WebMailEntities()) { File target = Entity.Files.Where(x => x.Id == _FilesApiModel.Id).FirstOrDefault(); if (target != null) { int _FolderId = Convert.ToInt32(_FilesApiModel.FolderId); target.FolderId = _FolderId; target.IsValid = _FilesApiModel.IsValid; target.Name = _FilesApiModel.Name; target.Path = _FilesApiModel.Path; // target.StatusId = _FilesApiModel.StatusId; target.TypeId = _FilesApiModel.TypeId; Entity.SaveChanges(); } } } return(Json(new[] { _FilesApiModel }.ToDataSourceResult(request))); }
public List <SelectListItem> MailBoxList(int UserId, string request) { List <MailBoxModel> _Model = new List <MailBoxModel>(); List <MailBoxModel> AssinedMailBox = new List <MailBoxModel>(); List <SelectListItem> _MainBoxList = new List <SelectListItem>(); string Result = string.Empty; using (var Entity = new WebMailEntities()) { _Model = Entity.MailBoxes.Where(x => x.UserId == UserId).Select(s => new MailBoxModel { MailBoxId = s.MailBoxId, MailBoxName = s.MailBoxName, MailBoxSequence = s.MailBoxSequence, UserId = s.UserId, Owener = "YES" }).OrderBy(x => x.MailBoxSequence).ToList(); } using (var Entity = new WebMailEntities()) { AssinedMailBox = Entity.MailBoxAccesses.Where(x => x.UserId == UserId).Select(s => new MailBoxModel { MailBoxId = s.MailBoxId, MailBoxName = s.MailBox.MailBoxName + " : " + s.MailBox.User.FullName, MailBoxSequence = s.MailBox.MailBoxSequence, UserId = s.UserId, Owener = "NO" }).OrderBy(x => x.MailBoxSequence).ToList(); } if (AssinedMailBox.Count() > 0) { _Model.AddRange(AssinedMailBox); } if (request == "DRP") { _MainBoxList = _Model.Select(s => new SelectListItem { Text = s.MailBoxName, Value = s.MailBoxId.ToString(), // Selected = s.MailBoxSequence == 1 ? true : false }).ToList(); } ; return(_MainBoxList); }
public IHttpActionResult FolderList([ModelBinder(typeof(WebApiDataSourceRequestModelBinder))] DataSourceRequest request) { List <FolderApiModel> Model = new List <FolderApiModel>(); using (var Entity = new WebMailEntities()) { Model = Entity.Folders.Select(s => new FolderApiModel { Id = s.Id, Name = s.Name, MailBoxId = s.MailBoxId.ToString(), MailBoxName = s.MailBox.FullName.ToString(), StatusId = s.StatusId.ToString(), TypeId = s.TypeId.ToString() }).OrderBy(x => x.MailBoxName).ThenBy(x => x.Name).ToList(); } return(Json(Model.ToDataSourceResult(request))); }
public IHttpActionResult ValidateUser(SignIn Model) { UserApIModel _User = new UserApIModel(); string Result = string.Empty; using (var Entity = new WebMailEntities()) { _User = Entity.Users.Where(s => s.Email.ToUpper() == Model.UserName.ToUpper() ).Select(x => new UserApIModel { Email = x.Email, FirstName = x.FirstName, LastName = x.LastName, id = x.id }).FirstOrDefault(); } return(Json(_User)); }
public FilesApiModel ReadMailDetails(string MailId) { long _MailId = Convert.ToInt32(MailId); FilesApiModel result = new Models.FilesApiModel(); using (var Entity = new WebMailEntities()) { result = Entity.Files.Where(x => x.Id == _MailId).Select(message => new FilesApiModel { Id = message.Id, Name = message.Name, Path = message.Path, TypeId = message.TypeId, StatusId = message.StatusId }).FirstOrDefault(); } return(result); }
public List <MailBoxFolderModel> MailBoxFolderList(long MailBoxId, string UserId) { long _UserId = Convert.ToInt32(UserId); List <MailBoxFolderModel> Model = new List <MailBoxFolderModel>(); using (var Entity = new WebMailEntities()) { Model = Entity.MailBoxFolders.Where(x => x.MailBoxId == MailBoxId && x.IsActive == true).Select(s => new MailBoxFolderModel { MailBoxFolderId = s.MailBoxFolderId, MailBoxFolderName = s.MailBoxFolderName, MailBoxId = s.MailBoxId, Owner = s.MailBox.UserId == _UserId ? "YES" : "NO", Sequence = s.Sequence, }).OrderBy(x => x.Sequence).ToList(); } return(Model); }
public string GetFirstFolderId(string UserId, int MailBoxId = 0) { long _UserId = Convert.ToInt32(UserId); int _MailBoxId = Convert.ToInt32(MailBoxId); int FolderId = 0; if (_MailBoxId == 0) { using (var Entity = new WebMailEntities()) { _MailBoxId = Entity.UserMailBoxes.Where(s => s.IsDefoultMailBox == true && s.UserId == _UserId).Select(z => z.MailboxId).FirstOrDefault(); } } using (var Entity = new WebMailEntities()) { FolderId = Entity.Folders.Where(s => s.MailBoxId == _MailBoxId && s.TypeId == 0).Select(z => z.Id).FirstOrDefault(); } return(FolderId.ToString()); }
public FolderApiModel GetFolderDeatiles(string FolderId) { long _FolderId = Convert.ToInt32(FolderId); FolderApiModel Model = new FolderApiModel(); using (var Entity = new WebMailEntities()) { Model = Entity.Folders.Where(x => x.Id == _FolderId).Select(s => new FolderApiModel { Id = s.Id, MailBoxName = s.MailBox.FullName, MailBoxId = s.MailBoxId.ToString(), Name = s.Name, StatusId = s.StatusId.ToString(), TypeId = s.TypeId.ToString(), }).FirstOrDefault(); } return(Model); }
public bool UpdateMailStatus(string Id, string flag) { try { int _Id = Convert.ToInt32(Id); using (var Entity = new WebMailEntities()) { Mail _Mail = Entity.Mails.Where(x => x.MessageID == _Id).FirstOrDefault(); if (_Mail != null) { _Mail.Status = flag; Entity.SaveChanges(); } } return(true); } catch (Exception ex) { return(false); } }
public bool SaveNewEmail(MailViewModel _MailViewModel) { try { Mail _Mail = new Mail(); _Mail.Category = Convert.ToInt32(_MailViewModel.Category); _Mail.IsValid = _MailViewModel.IsValid; _Mail.Name = _MailViewModel.Name; _Mail.Url = _MailViewModel.Url; using (var Entity = new WebMailEntities()) { Entity.Mails.Add(_Mail); Entity.SaveChanges(); } return(true); } catch (Exception ex) { return(false); } }
public bool UpdateFileStatus(string Id, string StatusId) { try { int _Id = Convert.ToInt32(Id); byte _StatusId = Convert.ToByte(StatusId); using (var Entity = new WebMailEntities()) { File _File = Entity.Files.Where(x => x.Id == _Id).FirstOrDefault(); if (_File != null) { _File.StatusId = _StatusId; Entity.SaveChanges(); } } return(true); } catch (Exception ex) { return(false); } }
public bool FunctionDeleteFolder(string Id) { try { long _Id = Convert.ToInt32(Id); MailBoxFolder _MailBoxFolders = new MailBoxFolder(); using (var Entity = new WebMailEntities()) { MailBoxFolder _MailBoxUpdate = Entity.MailBoxFolders.Where(s => s.MailBoxFolderId == _Id).FirstOrDefault(); if (_MailBoxUpdate != null) { _MailBoxUpdate.IsActive = false; Entity.SaveChanges(); } } return(true); } catch (Exception ex) { return(false); } }
public bool DeleteFolder(string Id) { try { long _Id = Convert.ToInt32(Id); Folder _Folder = new Folder(); using (var Entity = new WebMailEntities()) { _Folder = Entity.Folders.Where(s => s.Id == _Id).FirstOrDefault(); if (_Folder != null) { _Folder.StatusId = 0; Entity.SaveChanges(); } } return(true); } catch (Exception ex) { return(false); } }