public void CreatingNewInventorySucceedsWithValidLocationAndIngredient()
{
// Arrange
RepoTesting repo = new RepoTesting();
repo.ResetDatabase("Inventory_Test_3");
dbm.Location dbLocation = new dbm.Location {
Id = 2, Name = "a"
};
dbm.Ingredient dbIngredient = new dbm.Ingredient {
Id = 2, Name = "pepperoni", Price = 2.0m
};
repo.locationRepo.Create(dbLocation);
repo.ingredientRepo.Create(dbIngredient);
repo.SaveChanges();
// Ensure the required entities exist
Assert.NotNull(repo.locationRepo.GetById(dbLocation.Id));
Assert.NotNull(repo.ingredientRepo.GetById(dbIngredient.Id));
dbm.InventoryJunction dbInventory = new dbm.InventoryJunction
{
LocationId = dbLocation.Id, IngredientId = dbIngredient.Id, Count = 1
};
// Act
// Create the new inventory
repo.inventoryRepo.Create(dbInventory);
// Assert
// Searching for this inventory should now succeed
Assert.NotNull(repo.inventoryRepo.GetById(dbLocation.Id, dbIngredient.Id));
}
public void UserCreateSucceedsWithValidDefaultLocation()
{
// Arrange
RepoTesting repo = new RepoTesting();
repo.ResetDatabase("User_Test_2");
dbm.Location dbLocation = new dbm.Location {
Name = "a"
};
repo.locationRepo.Create(dbLocation);
repo.SaveChanges();
// Ensure the location exists
Assert.NotNull(repo.locationRepo.GetById(dbLocation.Id));
dbm.User dbUser = new dbm.User
{
Id = 2,
FirstName = "John",
LastName = "Pot",
DefaultLocationId = dbLocation.Id
};
// Act
repo.userRepo.Create(dbUser);
// Assert
// User should now exist within the database
Assert.NotNull(repo.userRepo.GetById(dbUser.Id));
}
public static lib.Location Map(db.Location dbLocation)
{
lib.Location libLocation = new lib.Location
{
Id = dbLocation.Id,
Name = dbLocation.Name
};
// Populate the inventory
List <db.InventoryJunction> inventories = inventoryRepo.GetAllInventoryJunctions()
.Where(i => i.LocationId == libLocation.Id).ToList();
foreach (var inventory in inventories)
{
libLocation.UpdateInventory(ingredientRepo.GetById(inventory.IngredientId).Name, inventory.Count);
}
return(libLocation);
}
public void OrderCreateSucceedsWithValidLocationIdAndUserId()
{
// Arrange
RepoTesting repo = new RepoTesting();
repo.ResetDatabase("Order_Test_2");
dbm.Location dbLocation = new dbm.Location {
Name = "a"
};
repo.locationRepo.Create(dbLocation);
repo.SaveChanges();
dbm.User dbUser = new dbm.User {
Id = 2, FirstName = "John", LastName = "Pot", DefaultLocationId = dbLocation.Id
};
repo.userRepo.Create(dbUser);
repo.SaveChanges();
// Ensure the entities exist
Assert.NotNull(repo.locationRepo.GetById(dbLocation.Id));
Assert.NotNull(repo.userRepo.GetById(dbUser.Id));
dbm.Order dbOrder = new dbm.Order
{
Id = 2,
LocationId = dbLocation.Id,
UserId = dbUser.Id,
TimePlaced = DateTime.Now,
TotalPrice = 20.50m
};
// Act
repo.orderRepo.Create(dbOrder);
repo.SaveChanges();
// Assert
// New order should be findable
Assert.NotNull(repo.orderRepo.GetById(dbOrder.Id));
}
public ActionResult Create(lib.Location formLocation)
{
try
{
db.Location dbLocation = new db.Location();
List <db.InventoryJunction> dbInventory;
dbLocation = db.Mapper.Map(formLocation, out dbInventory);
locationRepo.Create(dbLocation);
foreach (var ingredient in dbInventory)
{
locationRepo.inventoryRepo.Create(ingredient);
}
locationRepo.SaveChanges();
return(RedirectToAction(nameof(Index)));
}
catch
{
return(View());
}
}
public static db.Location Map(lib.Location libLocation, out List <db.InventoryJunction> inventoryList)
{
db.Location dbLocation = new db.Location
{
Id = libLocation.Id,
Name = libLocation.Name
};
inventoryList = new List <db.InventoryJunction>();
foreach (var inventory in libLocation.Inventory)
{
db.InventoryJunction dbInventory = new db.InventoryJunction
{
IngredientId = inventory.Key,
LocationId = libLocation.Id,
Count = inventory.Value
};
inventoryList.Add(dbInventory);
}
return(dbLocation);
}
public void OrderCreateFailsWithInvalidUserId()
{
// Arrange
RepoTesting repo = new RepoTesting();
repo.ResetDatabase("Order_Test_4");
dbm.Location dbLocation = new dbm.Location {
Id = 2, Name = "a"
};
repo.locationRepo.Create(dbLocation);
repo.SaveChanges();
int invalidUserId = -1;
// Ensure the location is valid
Assert.NotNull(repo.locationRepo.GetById(dbLocation.Id));
// Ensure the user is invalid
Assert.Throws <e.InvalidIdException>(() => repo.userRepo.GetById(invalidUserId));
dbm.Order dbOrder = new dbm.Order
{
Id = 2,
LocationId = dbLocation.Id,
UserId = invalidUserId,
TimePlaced = DateTime.Now,
TotalPrice = 20.50m
};
// Act
// Create should throw an exception
Assert.Throws <e.InvalidIdException>(() => repo.orderRepo.Create(dbOrder));
// Assert
// New order should not be searchable
Assert.Throws <e.InvalidIdException>(() => repo.orderRepo.GetById(dbOrder.Id));
}
public void ResetDatabase(string dbName)
{
var options = new DbContextOptionsBuilder <db.PizzaStoreDBContext>()
.UseInMemoryDatabase(dbName).Options;
database = new db.PizzaStoreDBContext(options);
ingredientRepo = new IngredientRepository(database);
locationRepo = new LocationRepository(database);
userRepo = new UserRepository(database);
inventoryRepo = new InventoryJunctionRepository(database);
pizzaRepo = new PizzaJunctionRepository(database);
orderJunctionRepo = new OrderJunctionRepository(database);
orderRepo = new OrderRepository(database);
// Going to add one entry to each repo for testing purposes.
dbIngredient = new dbm.Ingredient {
Id = 9999, Name = "cheese", Price = 1.50m
};
ingredientRepo.Create(dbIngredient);
dbLocation = new dbm.Location {
Id = 9999, Name = "John's Pizzaria"
};
locationRepo.Create(dbLocation);
// Save should populate the above entities' Ids
SaveChanges();
dbUser = new dbm.User {
Id = 9999, FirstName = "John", LastName = "Pot", DefaultLocationId = dbLocation.Id
};
userRepo.Create(dbUser);
dbInventory = new dbm.InventoryJunction {
LocationId = dbLocation.Id, IngredientId = dbIngredient.Id, Count = 100
};
inventoryRepo.Create(dbInventory);
// Have to manually set the pizza junction id since it is a nested many-to-many relationship
Random rand = new Random(DateTime.Now.TimeOfDay.Milliseconds);
dbPizza = new dbm.PizzaJunction {
PizzaId = dbm.PizzaJunction.GetNewId(), IngredientId = dbIngredient.Id, Count = 2
};
pizzaRepo.Create(dbPizza);
// Update user id for order usage
SaveChanges();
dbOrder = new dbm.Order {
Id = 9999, LocationId = dbLocation.Id, UserId = dbUser.Id, TimePlaced = DateTime.Now, TotalPrice = 20.50m
};
orderRepo.Create(dbOrder);
// Order junction needs order to have an Id
SaveChanges();
dbOrderJunction = new dbm.OrderJunction {
OrderId = dbOrder.Id, PizzaId = dbPizza.PizzaId
};
orderJunctionRepo.Create(dbOrderJunction);
SaveChanges();
// All tables should now have one entry.
}
