public ActionResult GetsParentsService(ServiceTemplateTreeSearchModel model) { AllItems = db.ServiceTemplateTrees.Where(w => w.ProjectTreeRef == model.ProjectTreeRef & w.ServiceTemplateTreeRef == null & w.Level == "2").ToList(); //AllItems = JsonConvert.DeserializeObject<List<ServiceTemplateTreeModel>>(JsonConvert.SerializeObject(select)); var filtered = AllItems; if (model.Title != null) { filtered = filtered.Where(x => x.Title.Contains(model.Title)).ToList(); } if (model.Description != null) { filtered = filtered.Where(x => x.Description.Contains(model.Description)).ToList(); } PagedList <ServiceTemplateTreeModel> result = new PagedList <ServiceTemplateTreeModel>(); var a = filtered.Skip((model.PageIndex * model.PageSize)).Take(model.PageSize).ToList(); result.Items = filtered.Skip((model.PageIndex * model.PageSize)).Take(model.PageSize).ToList(); result.PageIndex = model.PageIndex; result.PageSize = model.PageSize; result.TotalItemsCount = filtered.Count; return(Ok(result)); }
public ActionResult GetAllPaged(ServiceTemplateTreeSearchModel model) { var select = db.ProjectTrees.Select(s => new { s.Title, s.State, s.ProjectTreeId, ProjectParent = s.ProjectTreechild.Title, s.ReginalPowerCorpRef, s.Code, s.Description, s.Level, s.LevelCode, ReginalPowerCorpTitle = s.ReginalPowerCorp.Title }); AllItems = JsonConvert.DeserializeObject <List <ServiceTemplateTreeModel> >(JsonConvert.SerializeObject(select)); var filtered = AllItems; if (model.Title != null) { filtered = filtered.Where(x => x.Title.Contains(model.Title)).ToList(); } if (model.Description != null) { filtered = filtered.Where(x => x.Description.Contains(model.Description)).ToList(); } PagedList <ServiceTemplateTreeModel> result = new PagedList <ServiceTemplateTreeModel>(); var a = filtered.Skip((model.PageIndex * model.PageSize)).Take(model.PageSize).ToList(); result.Items = filtered.Skip((model.PageIndex * model.PageSize)).Take(model.PageSize).ToList(); result.PageIndex = model.PageIndex; result.PageSize = model.PageSize; result.TotalItemsCount = filtered.Count; return(Ok(result)); }