예제 #1
0
        public void UserCreateFailsWithInvalidDefaultLocationId()
        {
            // Arrange
            RepoTesting repo = new RepoTesting();

            repo.ResetDatabase("User_Test_3");

            int invalidLocationId = -1;

            // Ensure the locationId is invalid
            Assert.Throws <e.InvalidIdException>(() => repo.locationRepo.GetById(invalidLocationId));

            dbm.User dbUser = new dbm.User
            {
                Id                = 2,
                FirstName         = "John",
                LastName          = "Pot",
                DefaultLocationId = invalidLocationId
            };

            // Act
            // Create should throw exception
            Assert.Throws <e.InvalidIdException>(() => repo.userRepo.Create(dbUser));

            // Assert
            // User should not be findable
            Assert.Throws <e.InvalidIdException>(() => repo.userRepo.GetById(dbUser.Id));
        }
예제 #2
0
        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
        /***** Library -> Database *****/
        public static db.User Map(lib.User libUser)
        {
            db.User dbUser = new db.User
            {
                Id                = libUser.Id,
                FirstName         = libUser.FirstName,
                LastName          = libUser.LastName,
                DefaultLocationId = libUser.DefaultLocationId
            };

            return(dbUser);
        }
예제 #4
0
        public ActionResult Delete(int id, view.User formUser)
        {
            try
            {
                lib.User libUser = lib.User.GetById(id);
                lib.User.Users.Remove(libUser);
                db.User dbUser = db.Mapper.Map(libUser);
                userRepo.Delete(dbUser);
                userRepo.SaveChanges();

                return(RedirectToAction(nameof(Index)));
            }
            catch
            {
                return(View());
            }
        }
예제 #5
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));
        }
예제 #6
0
        public void OrderCreateFailsWithInvalidLocationId()
        {
            // Arrange
            RepoTesting repo = new RepoTesting();

            repo.ResetDatabase("Order_Test_3");
            dbm.User dbUser = new dbm.User {
                Id = 2, FirstName = "John", LastName = "Pot"
            };
            repo.userRepo.Create(dbUser);
            repo.SaveChanges();
            int invalidLocationId = -1;

            // Ensure the user is valid
            Assert.NotNull(repo.userRepo.GetById(dbUser.Id));
            // Ensure the invalidLocationId is in fact invalid
            Assert.Throws <e.InvalidIdException>(() => repo.locationRepo.GetById(invalidLocationId));

            dbm.Order dbOrder = new dbm.Order
            {
                Id         = 2,
                LocationId = invalidLocationId,
                UserId     = dbUser.Id,
                TimePlaced = DateTime.Now,
                TotalPrice = 20.50m
            };

            // Act

            Assert.Throws <e.InvalidIdException>(() => repo.orderRepo.Create(dbOrder));


            // Assert
            // New order should not have been added to the database
            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.
        }