/// <summary>
/// Saves the order to the database
/// </summary>
/// <param name="order">The checked out order to be saved</param>
public void saveOrder(lib.Order order)
{
try
{
var locationDict = getLocationDict();
using var context = new StoreDBContext(_options);
var dataOrder = new DataAccess.Order();
dataOrder.CustomerId = order.CustomerId;
dataOrder.OrderTime = order.Time;
dataOrder.LocationId = context.Locations.Where(l => l.Name == order.Location).Select(l => l.LocationId).FirstOrDefault();
context.Add(dataOrder);
context.SaveChanges();
foreach (var p in order.Products)
{
var dataOrderLine = new DataAccess.OrderLine();
dataOrderLine.OrderId = dataOrder.OrderId;
dataOrderLine.ProductId = p.ProductId;
dataOrderLine.Amount = p.Amount;
context.Add(dataOrderLine);
}
context.SaveChanges();
}
catch (Exception)
{
Console.WriteLine("Error creating new orders");
}
}
/// <summary>
/// Returns all orders.
/// </summary>
/// <returns>Returns a List of all the stored orders</returns>
public List <lib.Order> getAllOrders()
{
var ordersDict = new Dictionary <int, lib.Order>();
try
{
using var context = new StoreDBContext(_options);
var locationDict = getLocationDict();
var data = context.OrderLines.Include(o => o.Product).Include(o => o.Order);
foreach (var orderline in data)
{
var orderId = orderline.OrderId;
if (!ordersDict.ContainsKey(orderId))
{
ordersDict.Add(orderline.OrderId, new lib.Order(orderId, locationDict[orderline.Order.LocationId], orderline.Order.CustomerId, orderline.Order.OrderTime));
}
ordersDict[orderId].addOrder(new lib.Product(orderline.ProductId, orderline.Product.Name, orderline.Product.Price, orderline.Amount));
}
}
catch (Exception)
{
return(ordersDict.Values.ToList());
}
return(ordersDict.Values.ToList());
}
/// <summary>
/// Returns all inventory information
/// </summary>
/// <returns>Returns a dictionary with LocationName:List<Product> as Key/Value</returns>
public Dictionary <string, List <lib.Product> > getAllInventory()
{
var storeInventory = new Dictionary <string, List <lib.Product> >();
try
{
using var context = new StoreDBContext(_options);
var locationDict = getLocationDict();
var productDict = getProductInfoDict();
foreach (var inventoryLine in context.Inventories)
{
var locationId = locationDict[inventoryLine.LocationId];
if (!storeInventory.ContainsKey(locationId))
{
storeInventory.Add(locationId, new List <lib.Product>());
}
var productId = inventoryLine.ProductId;
storeInventory[locationId].Add(new lib.Product(productId, productDict[productId].Item1, productDict[productId].Item2, inventoryLine.Amount));
}
}
catch (Exception e)
{
return(storeInventory);
}
return(storeInventory);
}
/// <summary>
/// Saves the customer to the database
/// </summary>
/// <param name="customer">The customer with changes to be saved</param>
public void saveCustomer(lib.Customer customer)
{
try
{
using var context = new StoreDBContext(_options);
var dataCustomer = context.Customers.Where(c => c.CustomerId == customer.CustomerId).FirstOrDefault();
dataCustomer.Balance = customer.Balance;
context.Update(dataCustomer);
context.SaveChanges();
}
catch (Exception)
{
Console.WriteLine("Error saving customer's.");
}
}
/// <summary>
/// Adds a new customer to the database
/// </summary>
/// <param name="customer">The newly created customer</param>
public void addCustomer(lib.Customer customer)
{
try
{
using var context = new StoreDBContext(_options);
var dataCustomer = new DataAccess.Customer();
dataCustomer.Balance = customer.Balance;
dataCustomer.FirstName = customer.FirstName;
dataCustomer.LastName = customer.LastName;
context.Add(dataCustomer);
context.SaveChanges();
}
catch (Exception)
{
Console.WriteLine("Error saving customer.");
}
}
/// <summary>
/// Get a List of Customers
/// </summary>
/// <returns>List of Customers</returns>
public List <lib.Customer> readAllCustomers()
{
var customers = new List <lib.Customer>();
try
{
using var context = new StoreDBContext(_options);
foreach (var customerLine in context.Customers)
{
customers.Add(new lib.Customer(customerLine.CustomerId, customerLine.FirstName, customerLine.LastName, customerLine.Balance));
}
}
catch (Exception e)
{
return(customers);
}
return(customers);
}
/// <summary>
/// Saves all the inventory to the database
/// </summary>
/// <param name="inventory">The inventory stored as a dictionary with LocationName:List<Product> as its Key/Value</param>
public void saveAllInventory(Dictionary <string, List <lib.Product> > inventory)
{
try
{
using var context = new StoreDBContext(_options);
foreach (var dataProduct in context.Inventories.Include(i => i.Location).Include(i => i.Product))
{
dataProduct.Amount = inventory[dataProduct.Location.Name]
.Where(prod => prod.ProductId == dataProduct.ProductId)
.FirstOrDefault()
.Amount;
context.Update(dataProduct);
}
context.SaveChanges();
}
catch (Exception)
{
Console.WriteLine("Error creating new orders");
}
}
/// <summary>
/// Gets a dictionary with all products and their information
/// </summary>
/// <returns>Returns a dictionary with ProductId:(ProductName, ProductPrice) as Key/Value</returns>
public Dictionary <int, (string, double)> getProductInfoDict()
{
var productDict = new Dictionary <int, (string, double)>();
try
{
using var context = new StoreDBContext(_options);
foreach (var productLine in context.Products)
{
if (!productDict.ContainsKey(productLine.ProductId))
{
productDict.Add(productLine.ProductId, (productLine.Name, productLine.Price));
}
}
}
catch (Exception e)
{
return(productDict);
}
return(productDict);
}
/// <summary>
/// Returns a dictionary with locationId and locationName information
/// </summary>
/// <returns>Dictionary with LocationId:LocationName as Key/Value</returns>
public Dictionary <int, string> getLocationDict()
{
var locationDict = new Dictionary <int, string>();
try
{
using var context = new StoreDBContext(_options);
foreach (var locationLine in context.Locations)
{
if (!locationDict.ContainsKey(locationLine.LocationId))
{
locationDict.Add(locationLine.LocationId, locationLine.Name);
}
}
}
catch (Exception e)
{
return(locationDict);
}
return(locationDict);
}
/// <summary>
/// Returns the options for the DBContext
/// </summary>
/// <param name="options">The DBContext options</param>
public StoreRespository(StoreDBContext context)
{
_context = context;
}
