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