public ActionResult _DetailsDateToDate(DetailsDateToDateModel model) { try { if (ModelState.IsValid) { var newContext = context.Orders.ToList(); //Количество продаж var qyeryCountOrdersProducts = newContext .Where(emp => emp.DateOrder >= model.StartDate) .Where(emp => emp.DateOrder <= model.FinishDate) .Select(emp => emp.CountProduct) .Sum(); //Количество продаж var qyerySumPriceProducts = newContext .Where(emp => emp.DateOrder >= model.StartDate) .Where(emp => emp.DateOrder <= model.FinishDate) .Select(emp => emp.CountProduct * emp.Products.Price) .Sum(); ViewBag.CountOrder = qyeryCountOrdersProducts; ViewBag.SummPrice = qyerySumPriceProducts; } return(PartialView("_DetailDateToDate")); } catch (Exception exp) { ViewBag.Error = exp.Message; return(View("Error")); } }
public ActionResult DetailsDateToDate(DetailsDateToDateModel model) { return(View()); }