private void FillDataGrid() { var entities = (from n in DataContext.LP_Careers where n.DateDeleted == null orderby n.OrderIndex, n.DateCreated select n).ToList(); var converter = new CareerEntityModelConverter(DataContext); var models = (from n in entities let m = converter.Convert(n) select m).ToList(); var model = new CareersModel(); model.List = models; careersControl.Model = model; }
private void FillCareers() { var parentID = DataConverter.ToNullableGuid(Request["ID"]); var currentLanguage = LanguageUtil.GetLanguage(); var query = from n in DataContext.LP_Careers where n.DateDeleted == null && (n.Language == currentLanguage || n.Language == null || n.Language == "") select n; if (parentID == null) { query = from n in query where n.ParentID == null select n; } else { query = from n in query where n.ParentID == parentID select n; } query = from n in query orderby n.OrderIndex, n.DateCreated select n; var entities = query.ToList(); var converter = new CareerEntityModelConverter(DataContext); var models = (from n in entities let m = converter.Convert(n) select m).ToList(); var model = new CareersModel(); model.List = models; careersControl.Model = model; }
public string GetAllProducts(CareersModel model) { long resultCount = 0; var pageSize = 5; var page = Convert.ToDouble(model.Page); if (ModelState.IsValid) { var careersContentId = model.CTID; int jobCount = 0; String Department = model.Department; String Team = model.Team; String Country = model.Country; Logger.Info <CareersModel>(jobCount + "fffffffffff page:" + page + "Department: " + Department + " Team:" + Team + "Country :" + Country); if (Department != "all" && Team == "all" && Country == "all") { jobsResult = Umbraco.Content(Guid.Parse(careersContentId)).Children() .Where(x => x.IsVisible()) .Where(x => (string.Join(",", x.Value <IEnumerable <string> >("jobDepartment")).ToLower().Contains(Department.ToLower()))); } else if (Department != "all" && Team == "all" && Country != "all") { jobsResult = Umbraco.Content(Guid.Parse(careersContentId)).Children() .Where(x => x.IsVisible()) .Where(x => x.Value <IPublishedContent>("country") != null) .Where(x => x.Value <IPublishedContent>("country").Value <string>("locationName").ToLower() == Country.ToLower()) .Where(x => (string.Join(",", x.Value <IEnumerable <string> >("jobDepartment")).ToLower().Contains(Department.ToLower()))); } else if (Department == "all" && Team == "all" && Country == "all") { jobsResult = Umbraco.Content(Guid.Parse(careersContentId)).Children() .Where(x => x.IsVisible()); } else if (Department != "all" && Team != "all" && Country == "all") { jobsResult = Umbraco.Content(Guid.Parse(careersContentId)).Children() .Where(x => (string.Join(",", x.Value <IEnumerable <string> >("jobDepartment")).ToLower().Contains(Department.ToLower()))) .Where(x => (string.Join(",", x.Value <IEnumerable <string> >("team")).ToLower().Contains(Team.ToLower()))) .Where(x => x.IsVisible()); } else if (Department != "all" && Country != "all" && Team != "all") { jobsResult = Umbraco.Content(Guid.Parse(careersContentId)).Children() .Where(x => x.IsVisible()) .Where(x => x.Value <IPublishedContent>("country") != null) .Where(x => x.Value <IPublishedContent>("country").Value <string>("locationName").ToLower() == Country.ToLower()) .Where(x => (string.Join(",", x.Value <IEnumerable <string> >("jobDepartment")).ToLower().Contains(Department.ToLower()))) .Where(x => (string.Join(",", x.Value <IEnumerable <string> >("team")).ToLower().Contains(Team.ToLower()))); } else if (Department == "all" && Country != "all" && Team == "all") { jobsResult = Umbraco.Content(Guid.Parse(careersContentId)).Children() .Where(x => x.IsVisible()) .Where(x => x.Value <IPublishedContent>("country") != null) .Where(x => x.Value <IPublishedContent>("country").Value <string>("locationName").ToLower() == Country.ToLower()); } resultCount = jobsResult != null && jobsResult.Any() ? jobsResult.Count() : 0; var totalPages = (int)Math.Ceiling((double)resultCount / (double)pageSize); if (page > totalPages) { page = totalPages; } else if (page < 1) { page = 1; } Logger.Info <CareersModel>(jobCount + "fffffffffff"); if (resultCount > 0) { foreach (var jobsearchItem in jobsResult.Skip(((int)page - 1) * pageSize).Take(pageSize)) { CareersModel item = new CareersModel(); item.Name = jobsearchItem.Name; item.Url = jobsearchItem.Url; //item.Location = jobsearchItem.Value("jobLocation").ToString(); listCareers.Add(item); /*jobs = jobsearchItem.Name;*/ } Logger.Info <CareersModel>(jobCount + "fffffffffff" + JsonConvert.SerializeObject(listCareers), JsonConvert.SerializeObject(listCareers)); PaginationModel pagination = new PaginationModel(); pagination.Careers = listCareers; pagination.Page = page; pagination.Total = totalPages; return(JsonConvert.SerializeObject(pagination)); } else { PaginationModel pagination = new PaginationModel(); pagination.Total = 0; return(JsonConvert.SerializeObject(pagination)); } } /* return name;*/ return(JsonConvert.SerializeObject(jobsResult)); /*return JsonConvert.SerializeObject(data);*/ }