public Entity.Report.FoodReport Report(string key, string Value = "")
{
Entity.Report.FoodReport obj = new Entity.Report.FoodReport();
obj.lstOrderDetailReport = (from order in dbContext.OrderMasters
select new Entity.Report.OrderDetailReport
{
OrderId = order.OrderID,
StatusNewDate = order.OrderDate,
StatusFullFillDate = order.FullFillDate,
StatusCancelledDate = order.CancleDate,
}).ToList();
obj.lstOrderItemDetailReport = (from order in dbContext.OrderMasters
join item in dbContext.TransactionOrderDetails on order.OrderID equals item.OrderID
select new Entity.Report.OrderItemDetailReport
{
OrderId = order.OrderID,
ItemId = item.ItemId,
ItemQty = item.OrderQuentity,
StatusNewDate = order.OrderDate,
StatusFullFillDate = order.FullFillDate,
StatusCancelledDate = order.CancleDate,
}).ToList();
obj.lstItemDetailReport = dbContext.TransactionOrderDetails.GroupBy(x => x.ItemId).
Select(g => new Entity.Report.ItemDetailReport
{
ItemId = g.Key, ItemQty = g.Sum(y => y.OrderQuentity)
}).ToList();
return(obj);
}
public ActionResult Report()
{
Entity.Report.FoodReport objreport = new Entity.Report.FoodReport();
MasterService masterService = new MasterService();
objreport = masterService.Report(string.Empty);
return(View(objreport));
}
