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