public ActionResult MonthSales(DateTime date) { MonthSalesVM ms = new MonthSalesVM(); ms.MDate = date; ms.MonthSalesTotal = 0; List <DaySalesVM> lista = new List <DaySalesVM>(); int days = DateTime.DaysInMonth(date.Year, date.Month); for (int day = 1; day <= days; day++) { DaySalesVM ds = new DaySalesVM(); ds.Date = new DateTime(date.Year, date.Month, day); ds.Sales = db.Sales.ToList().FindAll(x => x.SaleDate == ds.Date & x.SaleState == SaleState.Finalizada); ds.DaySalesTotal = 0; if (ds.Sales.Count > 0) { foreach (var item in ds.Sales) { foreach (var saleline in item.SaleLines) { ds.DaySalesTotal += saleline.LineTotal; } } ms.MonthSalesTotal += ds.DaySalesTotal; } lista.Add(ds); } ms.DaySales = lista; return(View(ms)); }
// GET: Informations public ActionResult DaySales(DateTime date) { DaySalesVM ds = new DaySalesVM(); ds.Date = date; ds.Sales = db.Sales.ToList().FindAll(x => x.SaleDate == date & x.SaleState == SaleState.Finalizada); ds.DaySalesTotal = 0; foreach (var sale in ds.Sales) { foreach (var saleline in sale.SaleLines) { ds.DaySalesTotal += saleline.LineTotal; } } return(View(ds)); }