public void TestMethod1() { var host = Program.BuildWebHost(new string[0]); SLICKIceDBContext context = new SLICKIceDBContext(new DbContextOptions <SLICKIceDBContext>()); using (var scope = host.Services.CreateScope()) { var services = scope.ServiceProvider; //try //{ context = services.GetRequiredService <SLICKIceDBContext>(); DbInitializer.InitializeOverwrite(context); WinterGearRepositoryEFC winterGearRepo = new WinterGearRepositoryEFC(context); ICollection <Item> gearItems; ICollection <Item> goodItems; using (ItemBusiness itemBusiness = new ItemBusiness(winterGearRepo)) { gearItems = itemBusiness.QueryItemsByType(ItemType.Gear).ToList(); goodItems = itemBusiness.QueryItemsByCondition(10, 10).ToList(); } // look for test data in selections // gear items Assert.IsNotNull(gearItems.SingleOrDefault(i => i.ItemId == 4)); Assert.IsNotNull(gearItems.SingleOrDefault(i => i.ItemId == 3)); // good-quality items Assert.IsNotNull(goodItems.SingleOrDefault(i => i.ItemId == 1)); } }
public void TestMethod1() { var host = Program.BuildWebHost(new string[0]); SLICKIceDBContext context = new SLICKIceDBContext(new DbContextOptions <SLICKIceDBContext>()); using (var scope = host.Services.CreateScope()) { var services = scope.ServiceProvider; //try //{ context = services.GetRequiredService <SLICKIceDBContext>(); DbInitializer.InitializeOverwrite(context); WinterGearRepositoryEFC winterGearRepo = new WinterGearRepositoryEFC(context); var items = winterGearRepo.SelectAll().ToList(); Assert.IsNotNull(items); var newItem = new Item { ItemId = 5, ItemName = "The Rocket", ItemDescription = "", ItemType = ItemType.Gear, ItemCondition = 10 }; winterGearRepo.Insert(newItem); items = winterGearRepo.SelectAll().ToList(); Assert.AreEqual(items.SingleOrDefault(i => i.ItemId == 5), newItem); newItem = new Item { ItemId = 5, ItemName = "The Raging Rocket", ItemDescription = "", ItemType = ItemType.Gear, ItemCondition = 9 }; winterGearRepo.Update(newItem); items = winterGearRepo.SelectAll().ToList(); Assert.AreEqual(items.SingleOrDefault(i => i.ItemId == 5), newItem); winterGearRepo.Delete(new Item { ItemId = 5 }); items = winterGearRepo.SelectAll().ToList(); Assert.AreNotEqual(items.SingleOrDefault(i => i.ItemId == 5), newItem); //} //catch (Exception ex) //{ // var logger = services.GetRequiredService<ILogger<Program>>(); // logger.LogError(ex, "An error occured while seeding the database."); //} } }
public void TestMethod2() { var host = Program.BuildWebHost(new string[0]); SLICKIceDBContext context = new SLICKIceDBContext(new DbContextOptions <SLICKIceDBContext>()); using (var scope = host.Services.CreateScope()) { var services = scope.ServiceProvider; context = services.GetRequiredService <SLICKIceDBContext>(); DbInitializer.InitializeOverwrite(context); var accountRepo = new AccountRepositoryEFC(context); var items = accountRepo.SelectAll().ToList(); Assert.IsNotNull(items); var account = new Account { AccountId = 3, AccountUsername = "******", AccountPassword = "******", AccountFirstName = "David", AccountLastName = "Humpington" }; accountRepo.Insert(account); items = accountRepo.SelectAll().ToList(); Assert.AreEqual(account, accountRepo.SelectById(account)); account = new Account { AccountId = 3, AccountUsername = "******", AccountPassword = "******", AccountFirstName = "David", AccountLastName = "Humpington" }; accountRepo.Update(account); items = accountRepo.SelectAll().ToList(); Assert.AreEqual(account, accountRepo.SelectById(account)); accountRepo.Delete(account); items = accountRepo.SelectAll().ToList(); Assert.AreNotEqual(account, accountRepo.SelectById(account)); } }
public void TestMethod3() { var host = Program.BuildWebHost(new string[0]); SLICKIceDBContext context = new SLICKIceDBContext(new DbContextOptions <SLICKIceDBContext>()); using (var scope = host.Services.CreateScope()) { var services = scope.ServiceProvider; context = services.GetRequiredService <SLICKIceDBContext>(); DbInitializer.InitializeOverwrite(context); var inventoryRepo = new InventoryRepositoryEFC(context); var items = inventoryRepo.SelectAll(); Assert.IsTrue(items.Count() > 0); var inventory = new Inventory { AccountId = 2, ItemId = 3, ShareKind = ItemShare.Borrower }; inventoryRepo.Insert(inventory); items = inventoryRepo.SelectAll(); Assert.AreEqual(inventory, inventoryRepo.SelectById(inventory)); inventory = new Inventory { AccountId = 2, ItemId = 3, ShareKind = ItemShare.Owner }; inventoryRepo.Update(inventory); items = inventoryRepo.SelectAll(); Assert.AreEqual(inventory, inventoryRepo.SelectById(inventory)); inventoryRepo.Delete(inventory); items = inventoryRepo.SelectAll(); Assert.AreNotEqual(inventory, inventoryRepo.SelectById(inventory)); } }
public void ReadFromContext(SLICKIceDBContext context) { _context = context; }
public AccountRepositoryEFC(SLICKIceDBContext context) { ReadFromContext(context); }
public ItemController(SLICKIceDBContext context) { _itemsRepo = new WinterGearRepositoryEFC(context); }
public WinterGearRepositoryEFC(SLICKIceDBContext context) { ReadFromContext(context); }
public InventoryRepositoryEFC(SLICKIceDBContext context) { ReadFromContext(context); }