public async void OrderInDb() { DbContextOptions <ShoeDesignzDbContext> options = new DbContextOptionsBuilder <ShoeDesignzDbContext>() .UseInMemoryDatabase("CartFromDB") .Options; using (ShoeDesignzDbContext context = new ShoeDesignzDbContext(options)) { //CRUD //CREATE Order order = new Order(); order.ID = 7; order.UserID = "CATS"; context.Add(order); await context.SaveChangesAsync(); //READ var orderID = await context.Order.FirstOrDefaultAsync(c => c.ID == order.ID); var orderUserID = await context.Order.FirstOrDefaultAsync(n => n.UserID == order.UserID); Assert.Equal(7, order.ID); Assert.Equal("CATS", order.UserID); //UPDATE /* * orderID.ID = 22; * orderUserID.UserID = "MoreCATS"; * context.Update(orderID); * context.SaveChanges(); * var updateOrderID = await context.Order.FirstOrDefaultAsync(c => c.ID == orderID.ID); * Assert.Equal(22, updateOrderID.ID); */ } }
public async void InventoryInDb() { DbContextOptions <ShoeDesignzDbContext> options = new DbContextOptionsBuilder <ShoeDesignzDbContext>() .UseInMemoryDatabase("InventoryFromDB") .Options; using (ShoeDesignzDbContext context = new ShoeDesignzDbContext(options)) { //CRUD //CREATE Inventory inventory = new Inventory(); inventory.ID = 4; inventory.Name = "TestShoeOne"; inventory.Sku = 4732432; inventory.Price = 32.55m; inventory.DiscountPrice = 12.25m; inventory.Gender = Inventory.Genders.Neutral; inventory.Description = "Awesome Shoes to TEST"; inventory.Image = "/somepath.jpg"; context.Add(inventory);; await context.SaveChangesAsync(); //READ var inventoryTest = await context.Shoes.FirstOrDefaultAsync(c => c.ID == inventory.ID); inventoryTest = await context.Shoes.FirstOrDefaultAsync(n => n.Name == inventory.Name); inventoryTest = await context.Shoes.FirstOrDefaultAsync(s => s.Sku == inventory.Sku); inventoryTest = await context.Shoes.FirstOrDefaultAsync(p => p.Price == inventory.Price); inventoryTest = await context.Shoes.FirstOrDefaultAsync(d => d.DiscountPrice == inventory.DiscountPrice); inventoryTest = await context.Shoes.FirstOrDefaultAsync(desc => desc.Description == inventory.Description); inventoryTest = await context.Shoes.FirstOrDefaultAsync(i => i.Image == inventory.Image); //var inventorySku = Assert.Equal(4, inventoryTest.ID); Assert.Equal("TestShoeOne", inventoryTest.Name); Assert.Equal(4732432, inventoryTest.Sku); Assert.Equal(32.55m, inventoryTest.Price); Assert.Equal(12.25m, inventoryTest.DiscountPrice); Assert.Equal("Awesome Shoes to TEST", inventoryTest.Description); Assert.Equal("/somepath.jpg", inventoryTest.Image); //UPDATE /* * inventoryTest.ID = 5; * inventoryTest.Name = "ShoeUPDATE"; * inventoryTest.Sku = 100101011; * inventoryTest.Price = 44.44m; * inventoryTest.DiscountPrice = 12.00m; * inventoryTest.Description = "Cool cool cool"; * inventoryTest.Image = "/newUpdatePath.png"; * context.Update(inventoryTest); * context.SaveChanges(); * var updateInventory = await context.Shoes.FirstOrDefaultAsync(c => c.ID == inventoryTest.ID); * updateInventory = await context.Shoes.FirstOrDefaultAsync(n => n.Name == inventory.Name); * updateInventory = await context.Shoes.FirstOrDefaultAsync(s => s.Sku == inventory.Sku); * updateInventory = await context.Shoes.FirstOrDefaultAsync(p => p.Price == inventory.Price); * updateInventory = await context.Shoes.FirstOrDefaultAsync(d => d.DiscountPrice == inventory.DiscountPrice); * updateInventory = await context.Shoes.FirstOrDefaultAsync(desc => desc.Description == inventory.Description); * updateInventory = await context.Shoes.FirstOrDefaultAsync(i => i.Image == inventory.Image); * Assert.Equal(5, inventoryTest.ID); * Assert.Equal("ShoeUPDATE", inventoryTest.Name); * Assert.Equal(100101011, inventoryTest.Sku); * Assert.Equal(44.44m, inventoryTest.Price); * Assert.Equal(12.00m, inventoryTest.DiscountPrice); * Assert.Equal("Cool cool cool", inventoryTest.Description); * Assert.Equal("/newUpdatePath.png", inventoryTest.Image); */ //DELETE //context.Remove(updateCart); //context.SaveChanges(); //var deleteCart = await context.Cart.FirstOrDefaultAsync(n => n.Inventory.Name == updateCart.Inventory.Name); //Assert.True(deleteCart == null); //var updateCartCount = await context.Cart.CountAsync(); //Assert.Equal(0, updateCartCount); } }