public List <InfoEnterprise> ShowFullInfo(Guid id) { var listEnterprise = new EnterpriseDao().ReturnList(); var listArea = new EnterpriseAreaDao().ListEnterpriseArea(); var result = (from enpr in listEnterprise join listA in listArea on enpr.EnterpriseID equals listA.EnterpriseId where enpr.EnterpriseID == id select new { EnterpriseID = enpr.EnterpriseID, EnterpriseName = enpr.EnterpriseName, ImageLogo = enpr.ImageLogo, AmountSize = db.EnterpriseSizes.Find(enpr.EnterpriseSize).AmountSize, NameOfEnterprise = db.TypeOfEnterprises.Find(enpr.TypeOfEnterprise).NameOfEnterprise, EstablishYear = enpr.EstablishYear, Description = enpr.Description, Email = enpr.Email, Mobile = enpr.Mobile, }).AsEnumerable().Select(x => new InfoEnterprise() { EnterpriseID = x.EnterpriseID, EnterpriseName = x.EnterpriseName, ImageLogo = x.ImageLogo, AmountSize = x.AmountSize, NameOfEnterprise = x.NameOfEnterprise, EstablishYear = x.EstablishYear, Description = x.Description, Email = x.Email, Mobile = x.Mobile, }); var finalResult = result.ToList(); int n = finalResult.Count; if (n == 0 || n == 1) { return(finalResult); } var finalResult2 = new List <InfoEnterprise>(); for (int i = 0; i < n; i++) { bool check = true; for (int j = 0; j < finalResult2.Count; j++) { if (finalResult[i].EnterpriseID == finalResult2[j].EnterpriseID) { check = false; break; } } if (check == true) { finalResult2.Add(finalResult[i]); } } return(finalResult2); }
public List <ShowFullEnterprise> ShowEnterprise(Guid EnterpriseID) { try { var listEnterprise = new EnterpriseDao().ReturnList(); var listArea = new EnterpriseAreaDao().ListEnterpriseArea(); var result = (from enpr in listEnterprise join listA in listArea on enpr.EnterpriseID equals listA.EnterpriseId where enpr.EnterpriseID == EnterpriseID select new { EnterpriseID = enpr.EnterpriseID, EnterpriseName = enpr.EnterpriseName, ImageLogo = enpr.ImageLogo, AmountSize = db.EnterpriseSizes.Find(enpr.EnterpriseSize).AmountSize, NameOfEnterprise = db.TypeOfEnterprises.Find(enpr.TypeOfEnterprise).NameOfEnterprise, EstablishYear = enpr.EstablishYear, NameArea = db.Areas.Find(listA.AreaID).NameArea, listJobId = db.EnterpriseJobs.Where(x => x.EnterpriseID == enpr.EnterpriseID && x.JobIdParent == null).Select(x => x.JobId).ToList(), Description = enpr.Description, }).AsEnumerable().Select(x => new ShowFullEnterprise() { EnterpriseID = x.EnterpriseID, EnterpriseName = x.EnterpriseName, ImageLogo = x.ImageLogo, AmountSize = x.AmountSize, NameArea = x.NameArea, NameOfEnterprise = x.NameOfEnterprise, EstablishYear = x.EstablishYear, listJobId = x.listJobId, Description = x.Description }); var finalResult = result.ToList(); int n = finalResult.Count; if (n == 0 || n == 1) { return(finalResult); } var finalResult2 = new List <ShowFullEnterprise>(); for (int i = 0; i < n; i++) { bool check = true; for (int j = 0; j < finalResult2.Count; j++) { if (finalResult[i].EnterpriseID == finalResult2[j].EnterpriseID) { check = false; break; } } if (check == true) { finalResult2.Add(finalResult[i]); } } return(finalResult2); } catch (Exception e) { return(null); } }
public List <FormEnterpriseFull> ReturnFilterList(string EName = "0", int EArea = 0, int ECareer = 0, int ESize = 0) { try { var listEnterprise = new EnterpriseDao().ReturnList(); var listArea = new EnterpriseAreaDao().ListEnterpriseArea(); var listJob = new EnterpriseJobDao().ListEnterpriseJob(); var result = (from listE in listEnterprise join listA in listArea on listE.EnterpriseID equals listA.EnterpriseId join listJ in listJob on listE.EnterpriseID equals listJ.EnterpriseID where (EArea == 0 || listA.AreaID == EArea) && (ECareer == 0 || listJ.JobId == ECareer) && (ESize == 0 || listE.EnterpriseSize == ESize) && (EName == "0" || listE.EnterpriseName.Contains(EName)) && listE.Status == true select new { EnterpriseID = listE.EnterpriseID, EnterpriseName = listE.EnterpriseName, ImageLogo = listE.ImageLogo, NameArea = db.Areas.Find(listA.AreaID).NameArea, listJobId = db.EnterpriseJobs.Where(x => x.EnterpriseID == listE.EnterpriseID && x.JobIdParent == null).Select(x => x.JobId).ToList(), }).AsEnumerable().Select(x => new FormEnterpriseFull() { EnterpriseID = x.EnterpriseID, EnterpriseName = x.EnterpriseName, ImageLogo = x.ImageLogo, NameArea = x.NameArea, listJobId = x.listJobId }); var finalResult = result.ToList(); int n = finalResult.Count; if (n == 0 || n == 1) { return(finalResult); } var finalResult2 = new List <FormEnterpriseFull>(); for (int i = 0; i < n; i++) { bool check = true; for (int j = 0; j < finalResult2.Count; j++) { if (finalResult[i].EnterpriseID == finalResult2[j].EnterpriseID) { check = false; break; } } if (check == true) { finalResult2.Add(finalResult[i]); } } return(finalResult2); } catch (Exception e) { return(null); } }