Beispiel #1
0
        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"));
            }
        }
Beispiel #2
0
 public ActionResult DetailsDateToDate(DetailsDateToDateModel model)
 {
     return(View());
 }