public void UpdateAnimalDb(Library.Animal animal)
{
using var context = new AquariumContext(_contextOptions);
var dbAnimal = context.Animals
.Where(a => a.AnimalId == animal.AnimalId)
.FirstOrDefault();
dbAnimal.Name = animal.Name;
dbAnimal.Price = animal.Price;
context.SaveChanges();
}
// Meant to be used to subtract the quantity of the animal from a processed order
// Not using Library.order object directly since I want the option to remove from inventory even without a new order subtraction
public void RemoveFromInventoryDb(int storeid, Library.Animal animal, int quantity)
{
using var context = new AquariumContext(_contextOptions);
var dbInventory = context.Inventories
.Where(i => i.StoreId == storeid)
.Where(i => i.AnimalId == animal.AnimalId)
.FirstOrDefault();
dbInventory.Quantity -= quantity;
context.SaveChanges();
}
public void UpdateInventoryDb(string city, Library.Animal animal, int stock)
{
using var context = new AquariumContext(_contextOptions);
var currentStore = GetStoreByCity(city);
var dbInventory = context.Inventories
.Include(i => i.Animal)
.Where(i => i.StoreId == currentStore.StoreId && i.Animal.Name == animal.Name)
.FirstOrDefault();
dbInventory.Quantity += stock;
context.SaveChanges();
}
// Creates a new animal. All animal repository methods are optional
public void AddToAnimalDb(Library.Animal animal)
{
using var context = new AquariumContext(_contextOptions);
var newEntry = new DataModel.Animal
{
Name = animal.Name,
Price = animal.Price
};
context.Animals.Add(newEntry);
context.SaveChanges();
}
public void UpdateCustomerDb(Library.Customer customer)
{
using var context = new AquariumContext(_contextOptions);
var dbCust = context.Customers
.Where(c => c.CustomerId == customer.CustomerId)
.FirstOrDefault();
dbCust.FirstName = customer.FirstName;
dbCust.LastName = customer.LastName;
dbCust.Email = customer.Email;
context.SaveChanges();
}
public List <Library.Order> GetStoreOrders(Library.Store store)
{
using var context = new AquariumContext(_contextOptions);
var dbOrders = context.Orders
.Where(o => o.StoreId == store.StoreId);
var orders = new List <Library.Order>();
foreach (var obj in dbOrders)
{
orders.Add(GetOrderById(obj.OrderId));
}
return(orders);
}
public void AddToCustomerDb(Library.Customer customer)
{
using var context = new AquariumContext(_contextOptions);
var newCust = new DataModel.Customer()
{
FirstName = customer.FirstName,
LastName = customer.LastName,
Email = customer.Email
};
context.Customers.Add(newCust);
context.SaveChanges();
}
public void UpdateOrderDb(Library.Order order)
{
using var context = new AquariumContext(_contextOptions);
var dbOrders = context.Orders
.Where(o => o.OrderId == order.OrderId)
.FirstOrDefault();
dbOrders.StoreId = order.StoreId;
dbOrders.CustomerId = order.Customer.CustomerId;
dbOrders.Date = order.Date;
dbOrders.AnimalId = order.Animal.AnimalId;
dbOrders.Quantity = order.Quantity;
dbOrders.Total = order.Total;
context.SaveChanges();
}
public void AddToInventoryDb(string city, Library.Animal animal, int stock)
{
using var context = new AquariumContext(_contextOptions);
var currentStore = GetStoreByCity(city);
var currentAnimal = GetAnimalByName(animal.Name);
var newEntry = new DataModel.Inventory()
{
StoreId = currentStore.StoreId,
AnimalId = currentAnimal.AnimalId,
Quantity = stock
};
context.Inventories.Add(newEntry);
context.SaveChanges();
}
public List <Library.Customer> GetCustomerByName(string first, string last)
{
using var context = new AquariumContext(_contextOptions);
var dbCust = context.Customers
.Where(c => c.FirstName == first)
.Where(c => c.LastName == last)
.ToList();
var appCust = new List <Library.Customer>();
foreach (var cust in dbCust)
{
appCust.Add(GetCustomerById(cust.CustomerId));
}
return(appCust);
}
public Dictionary <Library.Animal, int> GetStoreInventory(Library.Store store)
{
using var context = new AquariumContext(_contextOptions);
var dbInventory = context.Inventories
.Where(i => i.StoreId == store.StoreId)
.Include(i => i.Animal)
.ToList();
var appInventory = new Dictionary <Library.Animal, int>();
foreach (var thing in dbInventory)
{
appInventory.Add(GetAnimalByName(thing.Animal.Name), thing.Quantity);
}
return(appInventory);
}
public Library.Animal GetAnimalByName(string name)
{
using var context = new AquariumContext(_contextOptions);
var dbAnimal = context.Animals
.Where(a => a.Name == name)
.FirstOrDefault();
var newAnimal = new Library.Animal()
{
AnimalId = dbAnimal.AnimalId,
Name = dbAnimal.Name,
Price = dbAnimal.Price
};
return(newAnimal);
}
// Used to convert entity to C# class
public Library.Customer GetCustomerById(int id)
{
using var context = new AquariumContext(_contextOptions);
var dbCust = context.Customers
.Where(c => c.CustomerId == id)
.FirstOrDefault();
var newCust = new Library.Customer()
{
CustomerId = dbCust.CustomerId,
LastName = dbCust.LastName,
FirstName = dbCust.FirstName,
Email = dbCust.Email
};
return(newCust);
}
public Library.Customer GetCustomerByEmail(string email)
{
using var context = new AquariumContext(_contextOptions);
var dbCust = context.Customers
.Where(c => c.Email == email)
.FirstOrDefault();
var appCust = new Library.Customer()
{
CustomerId = dbCust.CustomerId,
LastName = dbCust.LastName,
FirstName = dbCust.FirstName,
Email = dbCust.Email
};
return(appCust);
}
public void AddToOrderDb(Library.Order order)
{
using var context = new AquariumContext(_contextOptions);
var newEntry = new DataModel.Order
{
StoreId = order.StoreId,
CustomerId = order.Customer.CustomerId,
AnimalId = order.Animal.AnimalId,
Quantity = order.Quantity,
Total = order.Total,
Date = order.Date
};
context.Orders.Add(newEntry);
context.SaveChanges();
}
public Library.Store GetStoreByCity(string city)
{
using var context = new AquariumContext(_contextOptions);
var dbStore = context.Stores
.Where(s => s.City == city)
.First();
var appStore = new Library.Store()
{
StoreId = dbStore.StoreId,
City = dbStore.City,
Country = dbStore.Country,
Inventory = new Dictionary <Library.Animal, int>()
};
var appInv = GetStoreInventory(appStore); // Returns a dictionary with animals and their quantity in the store
foreach (var thing in appInv)
{
appStore.Inventory.Add(thing.Key, thing.Value);
}
return(appStore);
}
// Conversion from DataModel.order to Library.Order
public Library.Order GetOrderById(int id)
{
using var context = new AquariumContext(_contextOptions);
var dbOrders = context.Orders
.Where(o => o.OrderId == id)
.Include(o => o.Store)
.Include(o => o.Customer)
.Include(o => o.Animal)
.FirstOrDefault();
var newOrder = new Library.Order
{
OrderId = dbOrders.OrderId,
StoreId = dbOrders.StoreId,
Customer = GetCustomerByEmail(dbOrders.Customer.Email),
Animal = GetAnimalByName(dbOrders.Animal.Name),
Quantity = dbOrders.Quantity,
Total = dbOrders.Total,
Date = dbOrders.Date
};
return(newOrder);
}
