public async void CrudOrderInDB()
{
//Arrange
//setup our DB
//set values
DbContextOptions <CookwareDBContext> options =
new DbContextOptionsBuilder <CookwareDBContext>().UseInMemoryDatabase("DbCanSave").Options;
//Act
//creating a variable that "gets" the name
using (CookwareDBContext context = new CookwareDBContext(options))
{
Order order = new Order();
order.FirstName = "Test";
order.LastName = "Subject";
order.OrderDate = DateTime.Now;
order.Total = 500.00M;
order.UserID = "1";
////Act
context.Orders.Add(order);
context.SaveChanges();
var orderName = await context.Orders.FirstOrDefaultAsync(x => x.UserID == order.UserID);
//Assert
Assert.Equal("Test", orderName.FirstName);
//UPDATE
order.FirstName = "Update";
context.Orders.Update(order);
context.SaveChanges();
var updatedOrder = await context.Orders.FirstOrDefaultAsync(x => x.FirstName == order.FirstName);
Assert.Equal("Update", updatedOrder.FirstName);
//DELETE
context.Orders.Remove(order);
context.SaveChanges();
var deletedBasket = await context.Orders.FirstOrDefaultAsync(x => x.FirstName == order.FirstName);
Assert.True(deletedBasket == null);
}
}
public async void CrudProductInDB()
{
//Arrange
//setup our DB
//set values
DbContextOptions <CookwareDBContext> options =
new DbContextOptionsBuilder <CookwareDBContext>().UseInMemoryDatabase("DbCanSave").Options;
//Act
//creating a variable that "gets" the name
using (CookwareDBContext context = new CookwareDBContext(options))
{
Product product = new Product();
product.Name = "Test Product";
product.Description = "123 test";
product.Price = 123.45M;
product.Image = "someUrl";
product.LanguageIsCSharp = true;
////Act
context.Products.Add(product);
context.SaveChanges();
var productName = await context.Products.FirstOrDefaultAsync(x => x.Name == product.Name);
//Assert
Assert.Equal("Test Product", productName.Name);
//UPDATE
product.Name = "Update Product";
context.Products.Update(product);
context.SaveChanges();
var updatedHotel = await context.Products.FirstOrDefaultAsync(x => x.Name == product.Name);
Assert.Equal("Update Product", updatedHotel.Name);
//DELETE
context.Products.Remove(product);
context.SaveChanges();
var deletedProduct = await context.Products.FirstOrDefaultAsync(x => x.Name == product.Name);
Assert.True(deletedProduct == null);
}
}
public async void CrudBasketItemInDB()
{
//Arrange
//setup our DB
//set values
DbContextOptions <CookwareDBContext> options =
new DbContextOptionsBuilder <CookwareDBContext>().UseInMemoryDatabase("DbCanSave").Options;
//Act
//creating a variable that "gets" the name
using (CookwareDBContext context = new CookwareDBContext(options))
{
BasketItem basket = new BasketItem();
basket.ProductID = 1;
basket.UserID = "1";
basket.Quantity = 3;
////Act
context.BasketItems.Add(basket);
context.SaveChanges();
var basketQty = await context.BasketItems.FirstOrDefaultAsync(x => x.UserID == basket.UserID);
//Assert
Assert.Equal(3, basketQty.Quantity);
//UPDATE
basket.Quantity = 7;
context.BasketItems.Update(basket);
context.SaveChanges();
var updatedBasket = await context.BasketItems.FirstOrDefaultAsync(x => x.Quantity == basket.Quantity);
Assert.Equal(7, updatedBasket.Quantity);
//DELETE
context.BasketItems.Remove(basket);
context.SaveChanges();
var deletedBasket = await context.BasketItems.FirstOrDefaultAsync(x => x.Quantity == basket.Quantity);
Assert.True(deletedBasket == null);
}
}
public async Task <IActionResult> CreateBasketItem(int ProductID, int Quantity)
{
var user = await _userManager.GetUserAsync(HttpContext.User);
var ID = user.Id;
var product = await _products.GetProduct(ProductID);
var basketItem = _context.BasketItems.SingleOrDefault(
b => b.ProductID == ProductID && b.UserID == ID && b.OrderID == 1);
if (basketItem == null)
{
BasketItem newItem = new BasketItem()
{
ProductID = ProductID,
Quantity = Quantity,
UserID = _userManager.GetUserId(User),
OrderID = 1
};
await _basketItem.CreateBasketItem(newItem);
}
else
{
basketItem.Quantity++;
}
_context.SaveChanges();
if (product.LanguageIsCSharp == true)
{
return(RedirectToAction("Index", "CSharp"));
}
return(RedirectToAction("Index", "Product"));
}