internal static List <Order> GetPastOrdersFromCustomer(Customer customer, P1Context _context)
{
List <Order> OrdersByCustomer = new List <Order>();
var DB = _context;
OrderDAO.LoadOrdersList(DB);
OrderProductsDAO.LoadOrderProductsList(DB);
ProductDAO.LoadProductsList(DB);
LocationDAO.LoadLocationsList(DB);
BillingDAO.LoadBillingList(DB);
CustomerDAO.LoadCustomersList(DB);
ShippingDAO.LoadShippingInfomrationList(DB);
OrdersByCustomer = DB.OrdersList.Where(o => o.CustomerID == customer.CustomerID).ToList();
for (int i = 0; i < OrdersByCustomer.Count; i++)
{
Order o = OrdersByCustomer[i];
List <ProductInStock> prodsOrdered = new List <ProductInStock>();
List <OrderProducts> prodIDsAndQuantityInOrder = DB.OrderProductsList.Where(op => op.OrderID == OrdersByCustomer[i].OrderID).ToList();
foreach (OrderProducts OP in prodIDsAndQuantityInOrder)
{
ProductInStock prodOrdered = new ProductInStock();
Product p = DB.ProductsList.First(p => p.ProductID == OP.ProductID);
prodOrdered.Name = p.Name;
prodOrdered.Price = p.Price;
prodOrdered.Description = p.Description;
prodOrdered.Quantity = OP.Quantity;
prodsOrdered.Add(prodOrdered);
}
o.ShoppingCart = prodsOrdered;
o.Billing = DB.BillingInformationList.First(b => b.BillingID == OrdersByCustomer[i].BillingID);
o.Shipping = DB.ShippingInformation.First(s => s.ShippingID == OrdersByCustomer[i].ShippingID);
o.Location = DB.LocationList.First(l => l.LocationID == OrdersByCustomer[i].LocationID);
o.Customer = DB.CustomersList.First(c => c.CustomerID == OrdersByCustomer[i].CustomerID);
OrdersByCustomer[i] = o;
}
return(OrdersByCustomer);
}
public static Shipping GetAddress(int ShippingID, P1Context _context)
{
Shipping addy = new Shipping();
var DB = _context;
ShippingDAO.LoadShippingInfomrationList(DB);
foreach (Shipping a in DB.ShippingInformationList)
{
if (a.ShippingID == ShippingID)
{
addy = a;
break;
}
}
return(addy);
}
internal static List <Shipping> GetShippingAddresssesOnFileForCustomer(Customer customer, P1Context _context)
{
List <Shipping> ships = new List <Shipping>();
var DB = _context;
CustomerShippingDAO.LoadCustomersShippingList(DB);
ShippingDAO.LoadShippingInfomrationList(DB);
foreach (CustomerShipping cs in DB.CustomerShippingList)
{
if (cs.CustomerID == customer.CustomerID)
{
foreach (Shipping s in DB.ShippingInformationList)
{
if (cs.ShippingID == s.ShippingID)
{
ships.Add(s);
}
}
}
}
return(ships);
}
