public ActionResult Index(ReportViewModel model)
{
if (ModelState.IsValid)
{
model.Orders = db.Orders.Where(o => o.OrderDate.Day == model.SelectedDate.Day && o.OrderDate.Month == model.SelectedDate.Month && o.OrderDate.Year == model.SelectedDate.Year).Include(x => x.Payment).ToList();
model.OrderCount = model.Orders.Count();
model.Revenue = 0.0M;
for (int i = 0; i < model.OrderCount; i++)
{
model.Revenue += model.Orders.ElementAt(i).Subtotal;
}
return Json(Jsonfy(model));
}
return View(HttpStatusCode.BadRequest);
}
public JsonResult Init()
{
ReportViewModel model = new ReportViewModel
{
SelectedDate = DateTime.Now,
Revenue = 0.0M
};
model.Orders = db.Orders.Where(o => o.OrderDate.Day == model.SelectedDate.Day && o.OrderDate.Month == model.SelectedDate.Month && o.OrderDate.Year == model.SelectedDate.Year).Include(x => x.Payment);
model.OrderCount = model.Orders.Count();
for (int i = 0; i < model.OrderCount; i++)
{
model.Revenue += model.Orders.ElementAt(i).Subtotal;
}
return Json(Jsonfy(model),JsonRequestBehavior.AllowGet);
}
private dynamic Jsonfy(ReportViewModel model)
{
dynamic Orders = new List<dynamic>();
foreach (var item in model.Orders)
{
Orders.Add(new { Id = item.Id, OrderDate = item.OrderDate.ToString("dd/MM/yyyy hh:mm:ss tt"), Subtotal = item.Subtotal, Payment = item.Payment, TakeAway = item.TakeAway });
}
var result = new { Orders, SelectedDate = model.SelectedDate.ToString("dd/MM/yyyy hh:mm:ss tt"), OrderCount = model.OrderCount, Revenue = model.Revenue };
return result;
}
