public ActionResult Download(string reportname, ReportByProductBrandOption search)
{
ReportClass rptH = new ReportClass();
rptH.FileName = ReportPath(reportname);
var data = searchProduct(search).ToList();
rptH.SetDataSource(data);
rptH.SetParameterValue("datefrom", search.FromDate.ToReportFormat());
rptH.SetParameterValue("dateto", search.ToDate.ToReportFormat());
Stream stream = rptH.ExportToStream(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat);
return File(stream, "application/pdf");
}
public ActionResult ProductByBrand(PagerRequest request, ReportByProductBrandOption search)
{
if (!ModelState.IsValid)
{
ViewBag.SearchOptions = search;
return View();
}
var prods = searchProduct(search);
var v = new Pager<ProductByBrandReportViewModel>(request, prods.Count()) { Data = prods.ToList() };
ViewBag.SearchOptions = search;
return View(v);
}
private IEnumerable<ProductByBrandReportViewModel> searchProduct(ReportByProductBrandOption option)
{
var dbContext = _productRepo.Context;
var linq = dbContext.Set<ProductEntity>().Where(p => (!option.FromDate.HasValue || p.CreatedDate >= option.FromDate.Value) &&
(!option.ToDate.HasValue || p.CreatedDate < option.ToDate.Value))
.Join(dbContext.Set<StoreEntity>(), o => o.Store_Id, i => i.Id, (o, i) => new { P = o, S = i })
.Join(dbContext.Set<BrandEntity>(), o => o.P.Brand_Id, i => i.Id, (o, i) => new { P = o.P, S = o.S, B = i })
.GroupBy(l => new { l.P.Store_Id, l.S.Name, l.P.Brand_Id, BName = l.B.Name });
return linq.Select(l => new ProductByBrandReportViewModel()
{
BrandId = l.Key.Brand_Id,
BrandName = l.Key.BName,
StoreId = l.Key.Store_Id,
StoreName = l.Key.Name,
Products = l.Count()
}).OrderByDescending(l=>l.Products);
}
