示例#1
0
        public ActionResult DeeperLook(
            bool? ajax, bool? scrolling, bool? paging, bool? filtering, bool? sorting, bool? grouping, bool? showFooter)
        {
            // Total Sales, Gross Revenue, Line Item Promotion Total
            var model = new List<DeeperLookViewModel>();

            IQueryable<Order> orders = db.Orders.Include(o => o.OrderDetails);
            List<decimal> orderTotalList = orders.Select(order => order.TotalCost).ToList();
            List<decimal> orderRevenueList = orders.Select(order => order.TotalCost + order.SalesTax).ToList();
            List<decimal> lineItemPromoTotalList =
                (from order in orders
                 from line in order.OrderDetails
                 select (line.UnitPrice - line.UnitPriceAfterPromo) * line.Quantity).ToList();

            var totalSales = new DeeperLookViewModel
                {
                    DeeperLookViewModelId = 1, 
                    Stat = "Total Sales", 
                    Average = (float)orderTotalList.Average(), 
                    Median = (float)orderTotalList.Median()
                };
            model.Add(totalSales);

            var grossRevenue = new DeeperLookViewModel
                {
                    DeeperLookViewModelId = 2, 
                    Stat = "Gross Revenue", 
                    Average = (float)orderRevenueList.Average(), 
                    Median = (float)orderRevenueList.Median()
                };
            model.Add(grossRevenue);

            var lineItemPromoTotal = new DeeperLookViewModel
                {
                    DeeperLookViewModelId = 3, 
                    Stat = "Line Item Promo Total", 
                    Average = (float)lineItemPromoTotalList.Average(), 
                    Median = (float)lineItemPromoTotalList.Median()
                };
            model.Add(lineItemPromoTotal);

            ViewData["ajax"] = ajax ?? true;
            ViewData["scrolling"] = scrolling ?? true;
            ViewData["paging"] = paging ?? true;
            ViewData["filtering"] = filtering ?? true;
            ViewData["grouping"] = grouping ?? true;
            ViewData["sorting"] = sorting ?? true;
            ViewData["showFooter"] = showFooter ?? true;
            return View(model);
        }
示例#2
0
        public ActionResult _DeeperLook()
        {
            var model = new List<DeeperLookViewModel>();

            IQueryable<Order> orders = db.Orders.Include(o => o.OrderDetails);
            List<decimal> orderTotalList = orders.Select(order => order.TotalCost).ToList();
            List<decimal> orderRevenueList = orders.Select(order => order.TotalCost + order.SalesTax).ToList();
            List<decimal> lineItemPromoTotalList =
                (from order in orders
                 from line in order.OrderDetails
                 select (line.UnitPrice - line.UnitPriceAfterPromo) * line.Quantity).ToList();

            var totalSales = new DeeperLookViewModel
                {
                    DeeperLookViewModelId = 1, 
                    Stat = "TotalSales", 
                    Average = (float)orderTotalList.Average(), 
                    Median = (float)orderTotalList.Median()
                };
            model.Add(totalSales);

            var grossRevenue = new DeeperLookViewModel
                {
                    DeeperLookViewModelId = 2, 
                    Stat = "GrossRevenue", 
                    Average = (float)orderRevenueList.Average(), 
                    Median = (float)orderRevenueList.Median()
                };
            model.Add(grossRevenue);

            var lineItemPromoTotal = new DeeperLookViewModel
                {
                    DeeperLookViewModelId = 3, 
                    Stat = "Line Item Promo Total", 
                    Average = (float)lineItemPromoTotalList.Average(), 
                    Median = (float)lineItemPromoTotalList.Median()
                };
            model.Add(lineItemPromoTotal);
            return View(new GridModel(model));
        }
示例#3
0
        public ActionResult _DeeperStat(int id)
        {
            var model = new List<DeeperLookViewModel>();

            if (id == 1)
            {
                // GrossSalesHourly id =1
                IQueryable<Order> orders = db.Orders.Include(o => o.OrderDetails);
                DateTime oneHourAgo = DateTime.Now.AddHours(-1.00);

                List<Order> ordersPlacedInTheLastHour = orders.Where(order => order.TimeProcessed > oneHourAgo).ToList();
                List<decimal> ordersPlacedInTheLastHourGrossSalesList =
                    ordersPlacedInTheLastHour.Select(order => order.TotalCost).ToList();

                /*List<Order> ordersPlacedBeforeOneHourAgo =
                    orders.Where(order => order.TimeProcessed < oneHourAgo).ToList();
                List<decimal> ordersPlacedBeforeOneHourAgoGrossSalesList =
                    ordersPlacedBeforeOneHourAgo.Select(order => order.TotalCost).ToList();*/

                /*var totalSalesWithinLastHour = new DeeperLookViewModel
                    {
                        DeeperLookViewModelId = 1, 
                        Stat = "Orders Placed In The Last Hour", 
                        Average = (float)ordersPlacedInTheLastHourGrossSalesList.Average(), 
                        Median = (float)ordersPlacedInTheLastHourGrossSalesList.Median()
                    };
                model.Add(totalSalesWithinLastHour);

                var totalSalesBeforeLastHour = new DeeperLookViewModel
                    {
                        DeeperLookViewModelId = 2, 
                        Stat = "Orders Placed Before The Last Hour", 
                        Average = (float)ordersPlacedBeforeOneHourAgoGrossSalesList.Average(), 
                        Median = (float)ordersPlacedBeforeOneHourAgoGrossSalesList.Median()
                    };
                model.Add(totalSalesBeforeLastHour);*/

                var calendarStartOfBusiness = new DateTime(DateTime.Now.Year, DateTime.Now.Month, DateTime.Now.Day, 05, 00, 00, DateTimeKind.Local);
                DateTime todaysStartOfBusiness = calendarStartOfBusiness;
                if (DateTime.Now < calendarStartOfBusiness)
                {
                    todaysStartOfBusiness = calendarStartOfBusiness.AddDays(-1);
                }
                        
                DateTime endDate = todaysStartOfBusiness.AddDays(1);

                var hourId = 1;
                while (todaysStartOfBusiness != endDate)
                {
                    Console.WriteLine(todaysStartOfBusiness.ToString());

                    // this will show orders from all hours -- not just hours in the past 24 hours
                    List<Order> ordersPlacedDuringThisHour =
                    orders.Where(order => order.TimeProcessed.Hour == todaysStartOfBusiness.Hour).ToList();
                    List<decimal> ordersPlacedDuringThisHourList =
                        ordersPlacedDuringThisHour.Select(order => order.TotalCost).ToList();
                    float thisHourAverage = 0;
                    float thisHourMedian = 0;
                    if (ordersPlacedDuringThisHourList.Count() != 0)
                    {
                        thisHourAverage = (float)ordersPlacedDuringThisHourList.Average();
                    }
                    if (ordersPlacedDuringThisHourList.Count() != 0)
                    {
                        thisHourMedian = (float)ordersPlacedDuringThisHourList.Median();
                    }

                    var totalSales = new DeeperLookViewModel
                    {
                        DeeperLookViewModelId = hourId,
                        Stat = "Orders Placed at hour " + todaysStartOfBusiness.Hour,
                        Average = thisHourAverage,
                        Median = thisHourMedian
                    };
                    model.Add(totalSales);
                    todaysStartOfBusiness = todaysStartOfBusiness.AddHours(1);
                    hourId++;
                }
            }

            if (id == 2)
            {
                // GrossRevHourly id =2
                IQueryable<Order> orders = db.Orders.Include(o => o.OrderDetails);
                DateTime oneHourAgo = DateTime.Now.AddHours(-1.00);

                List<Order> ordersPlacedInTheLastHour = orders.Where(order => order.TimeProcessed > oneHourAgo).ToList();
                List<decimal> ordersPlacedInTheLastHourRevenueList =
                    ordersPlacedInTheLastHour.Select(order => order.TotalCost + order.SalesTax).ToList();

                List<Order> ordersPlacedBeforeOneHourAgo =
                    orders.Where(order => order.TimeProcessed < oneHourAgo).ToList();
                List<decimal> ordersPlacedBeforeOneHourAgoRevenueList =
                    ordersPlacedBeforeOneHourAgo.Select(order => order.TotalCost + order.SalesTax).ToList();

                var totalSalesWithinLastHour = new DeeperLookViewModel
                    {
                        DeeperLookViewModelId = 1, 
                        Stat = "Orders Placed In The Last Hour", 
                        Average = (float)ordersPlacedInTheLastHourRevenueList.Average(), 
                        Median = (float)ordersPlacedInTheLastHourRevenueList.Median()
                    };
                model.Add(totalSalesWithinLastHour);

                var totalSalesBeforeLastHour = new DeeperLookViewModel
                    {
                        DeeperLookViewModelId = 2, 
                        Stat = "Orders Placed Before The Last Hour", 
                        Average = (float)ordersPlacedBeforeOneHourAgoRevenueList.Average(), 
                        Median = (float)ordersPlacedBeforeOneHourAgoRevenueList.Median()
                    };
                model.Add(totalSalesBeforeLastHour);
            }

            if (id == 3)
            {
                // Do promo numbers
                // TotalPromoHourly id =3
                IQueryable<Order> orders = db.Orders.Include(o => o.OrderDetails);
                DateTime oneHourAgo = DateTime.Now.AddHours(-1.00);

                IEnumerable<double> ordersPlacedInTheLastHourLinePromoTotalList = (from order in orders
                                                                                   where
                                                                                       order.TimeProcessed >= oneHourAgo
                                                                                   from orderDetail in
                                                                                       order.OrderDetails
                                                                                   where
                                                                                       orderDetail.LineItemPromoId
                                                                                       != null
                                                                                   select
                                                                                       (orderDetail.LineItemPromo.Promo.
                                                                                            PercentOff
                                                                                        * (double)orderDetail.UnitPrice)
                                                                                       * orderDetail.Quantity).ToList().
                    DefaultIfEmpty();

                IEnumerable<double> ordersPlacedBeforeOneHourAgoLinePromoTotalList = (from order in orders
                                                                                      where
                                                                                          order.TimeProcessed
                                                                                          < oneHourAgo
                                                                                      from orderDetail in
                                                                                          order.OrderDetails
                                                                                      where
                                                                                          orderDetail.LineItemPromoId
                                                                                          != null
                                                                                      select
                                                                                          (orderDetail.LineItemPromo.
                                                                                               Promo.PercentOff
                                                                                           *
                                                                                           (double)orderDetail.UnitPrice)
                                                                                          * orderDetail.Quantity).ToList
                    ().DefaultIfEmpty();

                if (ordersPlacedInTheLastHourLinePromoTotalList.FirstOrDefault() != null)
                {
                    var totalSalesWithinLastHour = new DeeperLookViewModel
                        {
                            DeeperLookViewModelId = 1, 
                            Stat = "Orders Placed In The Last Hour", 
                            Average = (float)ordersPlacedInTheLastHourLinePromoTotalList.Average(), 
                            Median = (float)ordersPlacedInTheLastHourLinePromoTotalList.Median()
                        };
                    model.Add(totalSalesWithinLastHour);
                }
                else
// ReSharper disable HeuristicUnreachableCode
                {
                    var totalSalesWithinLastHour = new DeeperLookViewModel
                        {
                           DeeperLookViewModelId = 1, Stat = "Orders Placed In The Last Hour", Average = 0, Median = 0 
                        };
                    model.Add(totalSalesWithinLastHour);
                }
// ReSharper restore HeuristicUnreachableCode
                if (ordersPlacedBeforeOneHourAgoLinePromoTotalList.FirstOrDefault() != null)
                {
                    var totalSalesBeforeLastHour = new DeeperLookViewModel
                        {
                            DeeperLookViewModelId = 2, 
                            Stat = "Orders Placed Before The Last Hour", 
                            Average = (float)ordersPlacedBeforeOneHourAgoLinePromoTotalList.Average(), 
                            Median = (float)ordersPlacedBeforeOneHourAgoLinePromoTotalList.Median()
                        };
                    model.Add(totalSalesBeforeLastHour);
                }
                else
// ReSharper disable HeuristicUnreachableCode
                {
                    var totalSalesBeforeLastHour = new DeeperLookViewModel
                        {
                            DeeperLookViewModelId = 2, 
                            Stat = "Orders Placed Before The Last Hour", 
                            Average = 0, 
                            Median = 0
                        };
                    model.Add(totalSalesBeforeLastHour);
                }
// ReSharper restore HeuristicUnreachableCode
            }

            return View(new GridModel(model));
        }
示例#4
0
        public ActionResult GrossRevHourly(
            bool? ajax, bool? scrolling, bool? paging, bool? filtering, bool? sorting, bool? grouping, bool? showFooter)
        {
            // GrossRevHourly
            var model = new List<DeeperLookViewModel>();

            IQueryable<Order> orders = db.Orders.Include(o => o.OrderDetails);
            DateTime oneHourAgo = DateTime.Now.AddHours(-1.00);

            List<Order> ordersPlacedInTheLastHour = orders.Where(order => order.TimeProcessed > oneHourAgo).ToList();
            List<decimal> ordersPlaceInTheLastHourRevenueList =
                ordersPlacedInTheLastHour.Select(order => order.TotalCost + order.SalesTax).ToList();

            List<Order> ordersPlacedBeforeOneHourAgo = orders.Where(order => order.TimeProcessed < oneHourAgo).ToList();
            List<decimal> ordersPlacedBeforeOneHourAgoRevenueList =
                ordersPlacedBeforeOneHourAgo.Select(order => order.TotalCost + order.SalesTax).ToList();

            var totalSalesWithinLastHour = new DeeperLookViewModel
                {
                    DeeperLookViewModelId = 1, 
                    Stat = "Orders Placed In The Last Hour", 
                    Average = (float)ordersPlaceInTheLastHourRevenueList.Average(), 
                    Median = (float)ordersPlaceInTheLastHourRevenueList.Median()
                };
            model.Add(totalSalesWithinLastHour);

            var totalSalesBeforeLastHour = new DeeperLookViewModel
                {
                    DeeperLookViewModelId = 2, 
                    Stat = "Orders Placed Before The Last Hour", 
                    Average = (float)ordersPlacedBeforeOneHourAgoRevenueList.Average(), 
                    Median = (float)ordersPlacedBeforeOneHourAgoRevenueList.Median()
                };
            model.Add(totalSalesBeforeLastHour);

            ViewData["ajax"] = ajax ?? true;
            ViewData["scrolling"] = scrolling ?? true;
            ViewData["paging"] = paging ?? true;
            ViewData["filtering"] = filtering ?? true;
            ViewData["grouping"] = grouping ?? true;
            ViewData["sorting"] = sorting ?? true;
            ViewData["showFooter"] = showFooter ?? true;
            return View("DeeperLook", model);
        }