//
// 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()));
}
}
