// GET: Orders/Details/5
public ActionResult Details(int id)
{
IEnumerable <Lib.Customer> customers = CRepo.GetCustomers();
IEnumerable <Lib.Store> stores = SRepo.GetStores();
IEnumerable <Lib.Order> orders = ORepo.GetOrders();
List <Lib.OrderList> orderLists = ORepo.GetOrderLists(id).OrderBy(o => o.OrderId).ToList();
List <Lib.Products> products = PRepo.GetProducts().OrderBy(p => p.ItemId).ToList();
Lib.Order order = ORepo.GetOrderByOrderId(id);
var viewModels = orders.Select(o => new Orders
{
OrderId = o.OrderId,
StoreId = o.StoreId,
CustomerId = o.CustomerId,
DatePurchased = o.DatePurchased,
Total = o.Total,
//double total = db.tblCustomerOrders.Where(x => x.CustomerID == customer.CustomerID).Select(t => t.Amount ?? 0).Sum();
StoreName = stores.Single(s => s.Id == o.StoreId).Name,
FirstName = customers.Single(c => c.Id == o.CustomerId).FirstName,
LastName = customers.Single(c => c.Id == o.CustomerId).LastName,
FullName = customers.Single(c => c.Id == o.CustomerId).FirstName + " " + customers.Single(c => c.Id == o.CustomerId).LastName
}).ToList();
return(View());
}
// GET: Orders
public ActionResult Index()
{
IEnumerable <Lib.Customer> customers = CRepo.GetCustomers();
IEnumerable <Lib.Store> stores = SRepo.GetStores();
IEnumerable <Lib.Products> products = PRepo.GetProducts();
IEnumerable <Lib.Order> orders = ORepo.GetOrders();
var viewModels = orders.Select(o => new Orders
{
OrderId = o.OrderId,
StoreId = o.StoreId,
CustomerId = o.CustomerId,
DatePurchased = o.DatePurchased,
Total = o.Total,
StoreName = stores.Single(s => s.Id == o.StoreId).Name,
FirstName = customers.Single(c => c.Id == o.CustomerId).FirstName,
LastName = customers.Single(c => c.Id == o.CustomerId).LastName,
FullName = customers.Single(c => c.Id == o.CustomerId).FirstName + " " + customers.Single(c => c.Id == o.CustomerId).LastName
}).ToList();
decimal?totalSum = 0;
decimal?maxNum = viewModels.Any() ? viewModels.Max(ma => ma.Total) : 0;
decimal?minNum = viewModels.Any() ? viewModels.Min(ma => ma.Total) : 0;
foreach (var item in viewModels)
{
totalSum += item.Total;
}
ViewBag.totalSum = totalSum;
ViewBag.averageSum = totalSum / viewModels.Count();
ViewBag.maxNum = maxNum;
ViewBag.minNum = minNum;
return(View(viewModels));
}
public ActionResult AddProduct(Orders Order, ICollection <Lib.Order> o)
{
try
{
if (Order.OrderLists == null)
{
Order.OrderLists = new List <Lib.OrderList>();
}
Order.OrderList.Product = PRepo.GetProductsById(Order.OrderList.ItemId);
Order.OrderList.Price = Order.OrderList.GetCostOfPurchase();
Order.OrderList.OrderId = (int)TempData.Peek("Order Id");
ORepo.InsertOrderlist(Order.OrderList);
return(RedirectToAction(nameof(Index)));
}
catch
{
return(View());
}
}
// let's add in our AddProduct here
public ActionResult AddProduct(Orders order)
{
order.Products = PRepo.GetProducts().ToList();
order.Specials = new Dictionary <int, string>();
order.Specials.Add(1, "Standard");
order.Specials.Add(2, "Leather");
order.Specials.Add(3, "Silk");
order.OrderList = new Lib.OrderList
{
ItemId = 1,
Special = 1,
Price = 20
};
if (order.OrderLists == null)
{
order.OrderLists = new List <Lib.OrderList>();
}
return(View(order));
}
// GET: Orders/Create
public ActionResult Create()
{
List <Lib.Products> products = PRepo.GetProducts().OrderBy(p => p.ItemId).ToList();
List <Lib.OrderList> orderLists = new List <Lib.OrderList>();
List <Lib.Customer> Customers = CRepo.GetCustomers().ToList();
foreach (var product in products)
{
orderLists.Add(new Lib.OrderList
{
OrderId = 0,
ItemId = 0,
OrderListId = 0,
ItemBought = 0
});
}
List <SelectListItem> customerItems = new List <SelectListItem>();
foreach (var customer in Customers)
{
customerItems.Add(new SelectListItem()
{
Text = customer.FirstName + " " + customer.LastName, Value = customer.Id.ToString()
});
}
var viewModel = new Orders
{
Stores = SRepo.GetStores().ToList(),
customerItems = customerItems,
Products = products,
OrderLists = orderLists
};
return(View());
}
//Constructor
public PController()
{
this.pRepo = new PRepo(new Pcontext());
}
