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);
}
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));
}
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));
}
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);
}