public void UpdateCustomerUpdatesCustomerInfoInDB() { //arrange var options = new DbContextOptionsBuilder <DAOUtility>() .UseInMemoryDatabase(databaseName: "TestDb") .Options; //act Customer c1 = new Customer(); using (var context = new DAOUtility(options)) { context.Database.EnsureDeleted(); context.Database.EnsureCreated(); DAOMethodsImpl repo = new DAOMethodsImpl(context); c1.Fname = "Chris"; c1.Lname = "Sophiea"; c1.EmailAddress = "*****@*****.**"; c1 = repo.AddCustomer(c1); repo.UpdateCustomer(c1, "David", "Sophiea", "*****@*****.**"); } //assert using (var context1 = new DAOUtility(options)) { DAOMethodsImpl repo = new DAOMethodsImpl(context1); Assert.True(context1.customers.Where(x => x.Fname == "David").FirstOrDefault() != null); } }
public void RemoveItemDeletesItemFromDB() { //arrange var options = new DbContextOptionsBuilder <DAOUtility>() .UseInMemoryDatabase(databaseName: "TestDb") .Options; //act Item i1 = new Item() { ItemName = "PlayStation", ItemType = "Console", ItemDescription = "The first sony video-game console.", ItemPrice = 199.99 }; using (var context = new DAOUtility(options)) { context.Database.EnsureDeleted(); context.Database.EnsureCreated(); DAOMethodsImpl repo = new DAOMethodsImpl(context); repo.AddItem(i1); repo.DeleteItem(i1); } //assert using (var context1 = new DAOUtility(options)) { DAOMethodsImpl repo = new DAOMethodsImpl(context1); Assert.True(context1.items.Where(x => x.ItemName == "PlayStation").FirstOrDefault() == null); } }
public void UpdateStoreUpdatesStoreInfoInDB() { //arrange var options = new DbContextOptionsBuilder <DAOUtility>() .UseInMemoryDatabase(databaseName: "TestDb") .Options; //act Store s1 = new Store() { StoreAddress = "123 Fake St, Phoenix, AZ", PhoneNumber = "123-555-4567" }; using (var context = new DAOUtility(options)) { context.Database.EnsureDeleted(); context.Database.EnsureCreated(); DAOMethodsImpl repo = new DAOMethodsImpl(context); repo.AddStore(s1); repo.UpdateStore(s1, "123 Fake St, Phoenix, AZ", "555-555-5555"); } //assert using (var context1 = new DAOUtility(options)) { DAOMethodsImpl repo = new DAOMethodsImpl(context1); Assert.True(context1.stores.Where(x => x.PhoneNumber == "555-555-5555").FirstOrDefault() != null); } }
public void AddCustomerSavesCustomerToDB() { //arrange var options = new DbContextOptionsBuilder <DAOUtility>() .UseInMemoryDatabase(databaseName: "TestDb") .Options; //act Customer c1 = new Customer(); using (var context = new DAOUtility(options)) { context.Database.EnsureDeleted(); context.Database.EnsureCreated(); DAOMethodsImpl repo = new DAOMethodsImpl(context); c1.Fname = "Chris"; c1.Lname = "Sophiea"; c1.EmailAddress = "*****@*****.**"; c1 = repo.AddCustomer(c1); } //assert using (var context1 = new DAOUtility(options)) { Customer c2 = new Customer(); DAOMethodsImpl repo = new DAOMethodsImpl(context1); c2.Fname = "Chris"; c2.Lname = "Sophiea"; c2.EmailAddress = "*****@*****.**"; c2 = repo.AddCustomer(c2); Assert.Equal(c1.CustomerId, c2.CustomerId); } }
public void ReduceInventoryReducesInventoryInDB() { //arrange var options = new DbContextOptionsBuilder <DAOUtility>() .UseInMemoryDatabase(databaseName: "TestDb") .Options; Item i1 = new Item() { ItemName = "PlayStation", ItemType = "Console", ItemDescription = "The first sony video-game console.", ItemPrice = 199.99 }; Store s1 = new Store() { StoreAddress = "123 Fake St, Phoenix, AZ", PhoneNumber = "123-555-4567" }; using (var context = new DAOUtility(options)) { context.Database.EnsureDeleted(); context.Database.EnsureCreated(); DAOMethodsImpl repo = new DAOMethodsImpl(context); repo.AddInventory(s1, i1, 40); Inventory inventory = context.inventories.Where(x => x.Store1.StoreAddress == s1.StoreAddress && x.Item1.ItemId == i1.ItemId && x.InventoryAmount == 40).FirstOrDefault(); repo.ReduceInventory(inventory, 30); } //assert using (var context1 = new DAOUtility(options)) { DAOMethodsImpl repo = new DAOMethodsImpl(context1); Assert.True(context1.inventories.Where(x => x.Store1.StoreAddress == s1.StoreAddress && x.InventoryAmount == 10).FirstOrDefault() != null); } }