public ActionResult IndexCustomerActive()
{
var user = new UserProfile();
using (CanteenContext ctx = new CanteenContext())
{
user = (from o in ctx.UserProfiles orderby o.UserId where o.UserName == User.Identity.Name select o).ToList().FirstOrDefault();
}
var orders = new List<Order>();
using (CanteenContext ctx = new CanteenContext())
{
orders = (from o in ctx.Orders.Include("User") orderby o.OrderId where o.User.UserId == user.UserId && o.IsDelivered == false select o).ToList();
}
var fullOrders = new List<OrderDTO>();
foreach (var order in orders)
{
var fullOrder = new OrderDTO(order);
var orderItems = new List<OrderItemDTO>();
using (CanteenContext ctx = new CanteenContext())
{
var orderItemsFull = (from o in ctx.OrderItems orderby o.OrderItemId where o.OrderId == fullOrder.OrderId select o).ToList();
foreach (var i in orderItemsFull)
{
var menuItem = (from o in ctx.MenuItems orderby o.MenuItemId where o.MenuItemId == i.MenuItemId select o).ToList().FirstOrDefault();
var orderX = new OrderItemDTO(i);
orderX.MenuItem = menuItem;
if (menuItem != null)
orderItems.Add(orderX);
}
}
fullOrder.OrderItems = orderItems;
if (fullOrder.OrderItems.Count() > 0)
fullOrders.Add(fullOrder);
}
return View("IndexCustomer", fullOrders);
}
public ActionResult EditEmployee(int id = 0)
{
Order order = db.Orders.Find(id);
if (order == null)
{
return HttpNotFound();
}
var fullOrder = new OrderDTO(order);
var orderItems = new List<OrderItemDTO>();
var orderItemsSorted = new List<OrderItemDTO>();
using (CanteenContext ctx = new CanteenContext())
{
var orderItemsFull = (from o in ctx.OrderItems orderby o.OrderItemId where o.OrderId == fullOrder.OrderId select o).ToList();
foreach (var i in orderItemsFull)
{
var menuItem = (from o in ctx.MenuItems orderby o.MenuItemId where o.MenuItemId == i.MenuItemId select o).ToList().FirstOrDefault();
var orderX = new OrderItemDTO(i);
orderX.MenuItem = menuItem;
if (menuItem != null)
{
orderItems.Add(orderX);
}
}
}
if (orderItems.Count > 0)
{
fullOrder.OrderItems = orderItems.OrderBy(o => o.MenuItemId).ToList();
}
return View(fullOrder);
/* orig
Order order = db.Orders.Find(id);
if (order == null)
{
return HttpNotFound();
}
return View(order);*/
}
public ActionResult Index()
{
var orders = db.Orders.ToList();
var fullOrders = new List<OrderDTO>();
foreach (var order in orders)
{
var fullOrder = new OrderDTO(order);
var orderItems = new List<OrderItemDTO>();
using (CanteenContext ctx = new CanteenContext())
{
var orderItemsFull = (from o in ctx.OrderItems orderby o.OrderItemId where o.OrderId == fullOrder.OrderId select o).ToList();
foreach (var i in orderItemsFull)
{
var menuItem = (from o in ctx.MenuItems orderby o.MenuItemId where o.MenuItemId == i.MenuItemId select o).ToList().FirstOrDefault();
var orderX = new OrderItemDTO(i);
orderX.MenuItem = menuItem;
if (menuItem != null)
orderItems.Add(orderX);
}
}
fullOrder.OrderItems = orderItems;
if (fullOrder.OrderItems.Count() > 0)
fullOrders.Add(fullOrder);
}
return View(fullOrders);
}
//
// GET: /Statistics/
public ActionResult Index()
{
Statistics statistics = new Statistics();
var today = new DateTime();
//var dayOrders = new List<Order>();
//var monthOrders = new List<Order>();
//var fullOrderDay = new List<OrderDTO>();
//var fullOrderMonth = new List<OrderDTO>();
using (CanteenContext ctx = new CanteenContext())
{
statistics.TotalNumberOfUsers = (from o in ctx.UserProfiles select o).Count();
statistics.TotalNumberOfOrders = (from o in ctx.OrderItems select o).Count();
statistics.TotalSalesToday = (from o in ctx.Orders where o.IsDelivered == true && o.DateDelivered.Day == today.Day select o).Count();
statistics.TotalSalesThisMonth = (from o in ctx.Orders where o.IsDelivered == true && o.DateDelivered.Month == today.Month select o).Count();
var dayOrders = (from o in ctx.Orders where o.IsDelivered == true && o.DateDelivered.Day == today.Day select o).ToList();
var monthOrders = (from o in ctx.Orders where o.IsDelivered == true && o.DateDelivered.Month == today.Month select o).ToList();
var orderItemsDay = new List<OrderItemDTO>();
var orderItemsMonth = new List<OrderItemDTO>();
var orderItemsDayFull = new List<OrderItem>();
var orderItemsMonthFull = new List<OrderItem>();
var fullOrderDay = new List<OrderDTO>();
var fullOrderMonth = new List<OrderDTO>();
foreach (var i in dayOrders)
{
fullOrderDay.Add(new OrderDTO(i));
}
foreach (var i in monthOrders)
{
fullOrderMonth.Add(new OrderDTO(i));
}
foreach (var i in fullOrderDay)
{
orderItemsDayFull = (from o in ctx.OrderItems orderby o.OrderItemId where o.OrderId == i.OrderId select o).ToList();
}
foreach (var i in fullOrderMonth)
{
orderItemsMonthFull = (from o in ctx.OrderItems orderby o.OrderItemId where o.OrderId == i.OrderId select o).ToList();
}
foreach (var i in orderItemsDayFull)
{
var menuItem = (from o in ctx.MenuItems orderby o.MenuItemId where o.MenuItemId == i.MenuItemId select o).ToList().FirstOrDefault();
var orderX = new OrderItemDTO(i);
orderX.MenuItem = menuItem;
if (menuItem != null)
{
orderItemsDay.Add(orderX);
}
}
foreach (var i in orderItemsMonthFull)
{
var menuItem = (from o in ctx.MenuItems orderby o.MenuItemId where o.MenuItemId == i.MenuItemId select o).ToList().FirstOrDefault();
var orderX = new OrderItemDTO(i);
orderX.MenuItem = menuItem;
if (menuItem != null)
{
orderItemsMonth.Add(orderX);
}
}
if (orderItemsDay.Count > 0)
{
foreach (var i in orderItemsDay)
{
}
}
//db.Statistics.Add(statistics);
//db.SaveChanges();
}
return View("Details", statistics);
}
