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