public IQueryable <DTO_CUS_DOC_File> Get() { var result = BS_CUS_DOC_File.get_CUS_DOC_File(db, PartnerID, QueryStrings, true).ToList(); if (QueryStrings.Any(d => d.Key == "IncludeOwner")) { var query = db.tbl_CUS_DOC_File .Where(d => d.IsDeleted == false && d.IsHidden != true && d.IDPartner == PartnerID && (d.ModifiedBy == Username || d.CreatedBy == Username)); if (QueryStrings.Any(d => d.Key == "IDFolder")) { var IDList = QueryStrings.FirstOrDefault(d => d.Key == "IDFolder").Value.Replace("[", "").Replace("]", "").Split(','); List <int> IDs = new List <int>(); foreach (var item in IDList) { if (int.TryParse(item, out int i)) { IDs.Add(i); } else if (item == "null") { query = query.Where(d => !d.tbl_CUS_DOC_FileInFolder.Any()); } } if (IDs.Count > 0) { query = query.Where(d => d.tbl_CUS_DOC_FileInFolder.Any(c => c.IDFolder.HasValue && IDs.Contains(c.IDFolder.Value))); } } var result2 = BS_CUS_DOC_File.ctoDTO(query).ToList(); if (result2.Count > 0) { foreach (var item in result2) { if (!result.Any(d => d.ID == item.ID)) { result.Add(item); } } } } return(result.AsQueryable()); }
public IQueryable <DTO_CUS_DOC_File> GetMissingFile() { var result = BS_CUS_DOC_File.get_CUS_DOC_File(db, PartnerID, QueryStrings, true).ToList(); List <DTO_CUS_DOC_File> r2 = new List <DTO_CUS_DOC_File>(); if (QueryStrings.Any(d => d.Key == "IncludeOwner")) { var query = db.tbl_CUS_DOC_File .Where(d => d.IsDeleted == false && d.IDPartner == PartnerID && (d.ModifiedBy == Username || d.CreatedBy == Username)); if (QueryStrings.Any(d => d.Key == "IDFolder")) { var IDList = QueryStrings.FirstOrDefault(d => d.Key == "IDFolder").Value.Replace("[", "").Replace("]", "").Split(','); List <int> IDs = new List <int>(); foreach (var item in IDList) { if (int.TryParse(item, out int i)) { IDs.Add(i); } else if (item == "null") { query = query.Where(d => !d.tbl_CUS_DOC_FileInFolder.Any()); } } if (IDs.Count > 0) { query = query.Where(d => d.tbl_CUS_DOC_FileInFolder.Any(c => c.IDFolder.HasValue && IDs.Contains(c.IDFolder.Value))); } } var result2 = BS_CUS_DOC_File.ctoDTO(query).ToList(); if (result2.Count > 0) { foreach (var item in result2) { if (!result.Any(d => d.ID == item.ID)) { result.Add(item); } } } } string mapPath = System.Web.HttpContext.Current.Server.MapPath("~/"); foreach (var item in result) { if ((item.Extension == "doc" || item.Extension == "docx") && !File.Exists(mapPath + item.Code)) { if (File.Exists(mapPath + item.Path)) { r2.Add(item); convertWordToPDF(mapPath + item.Path, mapPath + item.Code); } else { item.Remark = "Ko file goc"; r2.Add(item); } } } return(r2.AsQueryable()); }
public DTO_APP_UserInfo GetUserInfo() { DTO_APP_UserInfo result = new DTO_APP_UserInfo(); result.Id = ""; result.Roles = new DTO_AppRole(); result.Roles.CUSRoles = new List <int>(); result.Roles.SYSRoles = new List <string>(); result.Partners = new List <DTO_Partner>(); result.MenuItems = new List <DTO_APP_FormGroup>(); if (User.Identity.IsAuthenticated) { ApplicationUser user = UserManager.FindById(User.Identity.GetUserId()); if (user != null) { result.Id = user.Id; result.UserName = user.UserName; result.Email = user.Email; result.PartnerID = user.PartnerID; result.StaffID = user.StaffID; result.FullName = user.FullName; result.PhoneNumber = user.PhoneNumber; result.Avatar = user.Avatar; var CUSRoles = db.tbl_CUS_SYS_Role.Where(d => d.tbl_CUS_HRM_STAFF_NhanSu.Any(s => s.ID == user.StaffID)); foreach (var ro in CUSRoles) { result.Roles.CUSRoles.Add(ro.ID); } foreach (var ro in user.Roles) { result.Roles.SYSRoles.Add(ro.RoleId); } } } //if (result.Roles.SYSRoles.Count == 0 && result.Roles.CUSRoles.Count == 0) //{ // result.Roles.SYSRoles.Add("GUEST"); //} if (QueryStrings.Any(d => d.Key == "GetMenu")) { var qValue = QueryStrings.FirstOrDefault(d => d.Key == "GetMenu").Value; if (bool.TryParse(qValue, out bool qBoolValue)) { result.MenuItems = BS_SYS_Form.get_SYS_Form(db, PartnerID, result.Roles); if (result.Roles.SYSRoles.Contains("HOST")) { var partners = BS_PAR_Partner.get_PAR_Partner(db, QueryStrings).Select(partner => new DTO_Partner() { ID = partner.ID, Code = partner.Code, Name = partner.Name, LogoURL = partner.LogoURL, Remark = partner.Remark, BannerURL = partner.BannerURL, TemplateHeader = partner.TemplateHeader, TemplateFooter = partner.TemplateFooter }); result.Partners = partners.ToList(); } else { var partner = BS_PAR_Partner.get_PAR_Partner(db, result.PartnerID); if (partner != null) { result.Partners.Add(new DTO_Partner() { ID = partner.ID, Code = partner.Code, Name = partner.Name, LogoURL = partner.LogoURL, Remark = partner.Remark, BannerURL = partner.BannerURL, TemplateHeader = partner.TemplateHeader, TemplateFooter = partner.TemplateFooter }); } } } } //if (result.MenuItems == null) // result.MenuItems = new List<DTO_APP_FormGroup>(); if (User.Identity.IsAuthenticated) { if (result.MenuItems != null && result.MenuItems.Count > 0) { result.MenuItems.Insert(0, new DTO_APP_FormGroup { ID = 0, AppID = 0, Code = "Home", AppName = "Home", FormMenu = new List <DTO_APP_Form> { new DTO_APP_Form { ID = 0, Code = "page-default", Name = "Home", IsHiddenMenu = true } }, Forms = new List <DTO_APP_Form> { new DTO_APP_Form { ID = 0, Code = "page-default", Name = "Home", IsHiddenMenu = true } } }); } } return(result); }