private IEnumerable<StoreCouponUsageViewModel> searchCouponLog(StoreCouponUsageOption search) { var dbContext = _productRepo.Context; return dbContext.Set<CouponLogEntity>().Where(p => p.Type == (int)CouponType.StorePromotion && p.Code == search.Code) .GroupJoin(dbContext.Set<StoreRealEntity>(),o=>o.ConsumeStoreNo,i=>i.StoreNo,(o,i)=>new {C=o,S=i.FirstOrDefault()}) .OrderByDescending(c=>c.C.Id) .ToList() .Select(l => new StoreCouponUsageViewModel().FromEntity<StoreCouponUsageViewModel>(l.C,p=>{ p.StoreName = l.S == null ? string.Empty : l.S.Name; })); }
public ActionResult StoreCouponUsage(PagerRequest request, StoreCouponUsageOption search) { if (!ModelState.IsValid) { ViewBag.SearchOptions = search; return View(); } var prods = searchCouponLog(search); var v = new Pager<StoreCouponUsageViewModel>(request, prods.Count()) { Data = prods.ToList() }; ViewBag.SearchOptions = search; return View(v); }
public ActionResult DownloadSCU(string reportname, StoreCouponUsageOption search) { return RenderReport(reportname, r => { r.SetDataSource(searchCouponLog(search).ToList()); }); }