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 InventoryContainsTest()
{
var shark = new Library.Animal();
shark.Name = "shark";
var nyc = new Library.Store();
nyc.Inventory = new Dictionary <Library.Animal, int>();
nyc.AddToInventory(shark, 20);
var actual = nyc.InInventory(shark);
Assert.True(actual == true);
}
public void RemoveFromInventoryTest2()
{
var penguin = new Library.Animal();
penguin.Name = "penguin";
var nyc = new Library.Store();
nyc.Inventory = new Dictionary <Library.Animal, int>();
nyc.AddToInventory(penguin, 20);
var actual = nyc.RemoveFromInventory(penguin, 100);
Assert.True(actual == false);
}
public void AddInventoryTestFail()
{
var shark = new Library.Animal();
shark.Name = "shark";
var nyc = new Library.Store();
nyc.Inventory = new Dictionary <Library.Animal, int>();
nyc.AddToInventory(shark, 0);
var actual = nyc.InInventory(shark);
Assert.True(actual == false);
}
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 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);
}
public void AddToInventoryTest2()
{
// Arrange
var penguin = new Library.Animal();
penguin.Name = "penguin";
var nyc = new Library.Store();
nyc.Inventory = new Dictionary <Library.Animal, int>();
nyc.AddToInventory(penguin, 1555);
// Act
var actual = nyc.Inventory[penguin];
// Assert
Assert.True(actual == 1555);
}
public void AddToInventoryTest()
{
// Arrange
var newAnimal = new Library.Animal();
newAnimal.Name = "whale";
var nyc = new Library.Store();
nyc.Inventory = new Dictionary <Library.Animal, int>();
// Act
nyc.AddToInventory(newAnimal, 5);
// Assert
var actual = nyc.Inventory[newAnimal];
Assert.True(actual == 5);
}
// Update
public void UpdateInventory(string city, Library.Animal animal, int stock)
{
StoreRepo.UpdateInventoryDb(city, animal, stock);
}
public void CreateAnimal(Library.Animal animal)
{
StoreRepo.AddToAnimalDb(animal);
}
// Delete
public void RemoveFromInventory(int storeid, Library.Animal animal, int quantity)
{
StoreRepo.RemoveFromInventoryDb(storeid, animal, quantity);
}
public void UpdateAnimal(Library.Animal animal)
{
StoreRepo.UpdateAnimalDb(animal);
}
