public async void CartInDb()
{
DbContextOptions <ShoeDesignzDbContext> options = new DbContextOptionsBuilder <ShoeDesignzDbContext>()
.UseInMemoryDatabase("CartFromDB")
.Options;
using (ShoeDesignzDbContext context = new ShoeDesignzDbContext(options))
{
//CRUD
//CREATE
Cart cart = new Cart();
cart.ID = 1;
cart.UserID = "UserOne";
context.Cart.Add(cart);
await context.SaveChangesAsync();
//READ
var cartID = await context.Cart.FirstOrDefaultAsync(c => c.ID == cart.ID);
var cartName = await context.Cart.FirstOrDefaultAsync(n => n.UserID == cart.UserID);
Assert.Equal(1, cart.ID);
Assert.Equal("UserOne", cart.UserID);
//UPDATE
//cartName.ID = 2;
//cartName.UserID = "UserTwo";
//context.Update(cartName);
//context.SaveChanges();
//var updateCart = await context.Cart.FirstOrDefaultAsync(c => c.ID == cartName.ID);
//updateCart = await context.Cart.FirstOrDefaultAsync(c => c.UserID == cartName.UserID);
//Assert.Equal(2, updateCart.ID);
//Assert.Equal("UserTwo", updateCart.UserID);
//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);
}
}
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 InventoryManagementServices(ShoeDesignzDbContext context)
{
_context = context;
}
public CartService(ShoeDesignzDbContext context)
{
_context = context;
}
public PolicyController(ShoeDesignzDbContext context)
{
_context = context;
}
/// <summary>
/// Constructs past orders with DB context
/// </summary>
/// <param name="context">DB Context</param>
public DeleteModel(ShoeDesignzDbContext context)
{
_context = context;
}
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);
}
}
/// <summary>
/// To construct past orders with shoes DB context
/// </summary>
/// <param name="context"></param>
public IndexModel(ShoeDesignzDbContext context)
{
_context = context;
}
public OrderService(ShoeDesignzDbContext context)
{
_context = context;
}
public CreateModel(ShoeDesignzDbContext context)
{
_context = context;
}
