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));
        }
示例#3
0
        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);
        }
示例#4
0
        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));
        }
示例#5
0
        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());
            }
        }
示例#6
0
        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);
        }
示例#7
0
        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.
        }