// // GET: /BrandAdmin/ public ActionResult AjaxRead(CategorySearchVM searchOptions, StoreRequestParams parameters) { using (DatisEntities pe = new DatisEntities()) { var all = pe.Categories.Where(x => (x.Name.Contains(searchOptions.Name) || searchOptions.Name == null)).Select(m => new CategoryVM() { Id = m.Id, Name = m.Name, ParentId = m.ParentId ?? 0 //BrandsIds = m.BrandCategories.Select(n=>n.BrandId).ToList() }); var result = all.OrderBy(x => x.Id).ApplyPaging(parameters).ToList(); foreach (var categoryVM in result) { categoryVM.BrandsIds = pe.BrandCategories.Where(p => p.CategoryId == categoryVM.Id).Select(n => n.BrandId).ToList(); } return(this.Store(result, all.Count())); } }
// // GET: /BrandAdmin/ public ActionResult AjaxRead(CategorySearchVM searchOptions, StoreRequestParams parameters) { using (DatisEntities pe = new DatisEntities()) { var all = pe.Features.Where(x => (x.Name.Contains(searchOptions.Name) || searchOptions.Name == null) && (x.CategoryId == searchOptions.CategoryId || searchOptions.CategoryId == 0)).Select(m => new FeatureVM() { Id = m.Id, Name = m.Name, CategoryId = m.CategoryId ?? 0, CategoryName = "" }); var result = all.OrderBy(x => x.Id).ApplyPaging(parameters).ToList(); foreach (var item in result) { var cat = pe.Categories.Where(m => m.Id == item.CategoryId).FirstOrDefault(); item.CategoryName = cat.Name; } return(this.Store(result, all.Count())); } }