public void PizzaJunctionDeleteRemovesFromOrderTable() { // Arrange RepoTesting repo = new RepoTesting(); repo.ResetDatabase("PizzaJuntion_Test_3"); db.Models.OrderJunction dbOrderJunction = repo.dbOrderJunction; int orderId = dbOrderJunction.OrderId; int pizzaId = dbOrderJunction.PizzaId; int ingredientId = repo.dbIngredient.Id; // Ensure the entities exist // order junction Assert.NotNull(repo.orderJunctionRepo.GetById(dbOrderJunction.OrderId, dbOrderJunction.PizzaId)); // Pizza junction Assert.NotNull(repo.pizzaRepo.GetById(pizzaId, ingredientId)); // Act repo.pizzaRepo.Delete(repo.dbPizza); repo.SaveChanges(); // Assert // Order junction was removed Assert.Throws <e.InvalidIdException>(() => repo.orderJunctionRepo.GetById(dbOrderJunction.OrderId, dbOrderJunction.PizzaId)); // Pizza junction was removed Assert.Throws <e.InvalidIdException>(() => repo.pizzaRepo.GetById(pizzaId, ingredientId)); }
public void CreatingNewOrderJunctionSucceedsWithValidOrderIdandPizzaId() { // Arrange RepoTesting repo = new RepoTesting(); repo.ResetDatabase("OrderJunction_Test_1"); dbm.PizzaJunction dbPizza = new dbm.PizzaJunction { PizzaId = dbm.PizzaJunction.GetNewId(), Count = 1, IngredientId = repo.dbIngredient.Id }; repo.pizzaRepo.Create(dbPizza); repo.SaveChanges(); // Ensure the required entities exist Assert.NotNull(repo.pizzaRepo.GetById(dbPizza.PizzaId, dbPizza.IngredientId)); dbm.OrderJunction dbOrderJunction = new dbm.OrderJunction { OrderId = repo.dbOrder.Id, PizzaId = dbPizza.PizzaId }; // Act // Create the new order junction repo.orderJunctionRepo.Create(dbOrderJunction); // Assert // Searching for this orderJunction should now succeed Assert.NotNull(repo.orderJunctionRepo.GetById(repo.dbOrder.Id, dbPizza.PizzaId)); }
public void CreatingNewOrderJunctionFailsWithInvalidPizzaId() { // Arrange RepoTesting repo = new RepoTesting(); repo.ResetDatabase("OrderJunction_Test_3"); int invalidPizzaId = -1; // Ensure the required entities exist Assert.NotNull(repo.orderRepo.GetById(repo.dbOrder.Id)); dbm.OrderJunction dbOrderJunction = new dbm.OrderJunction { OrderId = repo.dbOrder.Id, PizzaId = invalidPizzaId }; // Act // Create the new order junction Assert.Throws <e.InvalidIdException>(() => repo.orderJunctionRepo.Create(dbOrderJunction)); // Assert // Searching for this orderJunction should fail Assert.Throws <e.InvalidIdException>(() => repo.orderJunctionRepo.GetById(repo.dbOrder.Id, invalidPizzaId)); }
public static db.Order Map(lib.Order libOrder, out List <db.OrderJunction> orderJunctionList, out List <db.PizzaJunction> pizzaJunctionList) { db.Order dbOrder = new db.Order { Id = libOrder.Id, LocationId = libOrder.LocationId, UserId = libOrder.UserId, TimePlaced = libOrder.TimePlaced, TotalPrice = libOrder.TotalPrice }; orderJunctionList = new List <db.OrderJunction>(); pizzaJunctionList = new List <db.PizzaJunction>(); foreach (var pizza in libOrder.Pizzas) { db.OrderJunction orderJunction = new db.OrderJunction { OrderId = libOrder.Id, PizzaId = pizza.Id }; orderJunctionList.Add(orderJunction); foreach (var ingredient in pizza.Ingredients.Distinct()) { db.PizzaJunction pizzaJunction = new db.PizzaJunction { PizzaId = pizza.Id, IngredientId = ingredient.Id, Count = pizza.Ingredients.Where(i => i.Id == ingredient.Id).Count() }; pizzaJunctionList.Add(pizzaJunction); } } return(dbOrder); }
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. }