public ActionResult List(PagerRequest request,SectionSearchOption search)
{
int totalCount;
var linq = _sectionRepo.Get(s => (!search.SId.HasValue || search.SId.Value == s.Id) &&
(string.IsNullOrEmpty(search.Name) || s.Name.StartsWith(search.Name)) &&
(!search.BrandId.HasValue || search.BrandId.Value == s.BrandId) &&
(!search.StoreId.HasValue || search.StoreId.Value == s.StoreId) &&
s.Status!=(int)DataStatus.Deleted
, out totalCount
, request.PageIndex
, request.PageSize
, e => e.OrderByDescending(o => o.CreateDate));
var data = linq.Join(_storeRepo.GetAll(), o => o.StoreId, i => i.Id, (o, i) => new { S = o, Store = i })
.Join(_brandRepo.GetAll(), o => o.S.BrandId, i => i.Id, (o, i) => new { S = o.S, Store = o.Store, B = i })
.ToList()
.Select(l => new SectionViewModel().FromEntity<SectionViewModel>(l.S, p=>{
p.Store = new StoreViewModel().FromEntity<StoreViewModel>(l.Store);
p.Brand = new BrandViewModel().FromEntity<BrandViewModel>(l.B);
}));
var v = new Pager<SectionViewModel>(request, totalCount) { Data = data.ToList() };
return View("List", v);
}
public ActionResult Index(PagerRequest request, SectionSearchOption search)
{
return List(request, search);
}