/// <summary>
/// Place an order to the database
/// </summary>
/// <param name="customer">id of customer placeing order</param>
/// <param name="order">object containing the list of order items</param>
public static void AddOrder(int customer, IOrderList order)
{
using (var context = new POneContext(connection))
{
decimal price = 0;
foreach (var orderdata in order.Cart)
{
price += orderdata.Price * orderdata.Quantity;
}
var ticket = new Orders
{
CustId = customer,
Total = price,
Stamp = DateTime.Now,
OrderData = order.Cart
};
foreach (var orderdata in order.Cart)
{
context.Products.Find(orderdata.PrdId).Stock -= orderdata.Quantity;
orderdata.OrdId = ticket.OrdId;
}
context.Add(ticket);
context.SaveChanges();
}
}
/// <summary>
/// remove a customer from the database
/// </summary>
/// <param name="ID">id of customer</param>
public static void RemoveCustomer(int ID)
{
using (var context = new POneContext(connection))
{
context.Customers.Remove(context.Customers.Find(ID));
context.SaveChanges();
}
}
/// <summary>
/// remove a store from the database
/// only works when the store has no products
/// </summary>
/// <param name="activeStore">id of store</param>
public static void RemoveStore(int activeStore)
{
using (var context = new POneContext(connection))
{
context.Locations.Remove(context.Locations.Find(activeStore));
context.SaveChanges();
}
}
/// <summary>
/// increce the stock of an item
/// </summary>
/// <param name="ID">items id</param>
/// <param name="stock">quantity to9 add</param>
public static void StockProduct(int ID, int stock)
{
using (var context = new POneContext(connection))
{
context.Products.Find(ID).Stock += stock;
context.SaveChanges();
}
}
/// <summary>
/// removes a product from the database
/// </summary>
/// <param name="ID">id of item</param>
public static void RemoveProduct(int ID)
{
using (var context = new POneContext(connection))
{
context.Remove(context.Products.Find(ID));
context.SaveChanges();
}
}
/// <summary>
/// Add a location to the database
/// </summary>
/// <param name="name">Name of location</param>
public static void AddLocation(string name)
{
using (var context = new POneContext(connection))
{
var location = new Locations {
Name = name
};
context.Add(location);
context.SaveChanges();
}
}
/// <summary>
/// add a customer to the database
/// </summary>
/// <param name="name">name of customer</param>
public static void AddCustomer(string name)
{
using (var context = new POneContext(connection))
{
var customer = new Customers {
Name = name
};
context.Add(customer);
context.SaveChanges();
}
}
/// <summary>
/// adds a product to the database
/// </summary>
/// <param name="name">name of product</param>
/// <param name="LocID">id of products location</param>
/// <param name="p">price of item</param>
/// <param name="s">ctock of item</param>
public static void AddProduct(string name, int LocID, decimal p, int s)
{
using (var context = new POneContext(connection))
{
var product = new Products
{
Name = name,
Loc = context.Locations.Find(LocID),
Price = p,
Stock = s
};
context.Add(product);
context.SaveChanges();
}
}