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