public void InsertToCart(CartViewModel model, int accountId)
{
var quantity = FindQuanity(accountId, model.ItemId);
Console.WriteLine("I'm inserting to cart table in database");
Console.WriteLine("quantity is: " + quantity);
//if there is no cart create a new one
if (quantity == 0)
{
var newItemInCart = new CartEntityModel
{
AccountId = accountId,
BookId = model.ItemId,
Quantity = 1,
Finished = false
};
_db.Add(newItemInCart);
}
//update an existing cart
else
{
var cartId = FindCartId(accountId, model.ItemId);
quantity++;
var newItemInCart = new CartEntityModel
{
Id = cartId,
AccountId = accountId,
BookId = model.ItemId,
Quantity = quantity,
Finished = false
};
_db.Update(newItemInCart);
}
_db.SaveChanges();
}
public void RemoveOneFromCart(CartViewModel model, int accountId)
{
//var quantity = FindQuanity(accountId,model.ItemId);
var quantity = model.Quantity;
var cartId = FindCartId(accountId, model.ItemId);
if (quantity == 0)
{
return;
}
Console.WriteLine("quantity is: " + quantity);
quantity--;
var newItemInCart = new CartEntityModel
{
Id = cartId,
AccountId = accountId,
BookId = model.ItemId,
Quantity = quantity,
Finished = false
};
if (quantity == 0)
{
_db.Remove(newItemInCart);
}
else
{
_db.Update(newItemInCart);
}
_db.SaveChanges();
}
public void InsertAllItems(List <CartViewModel> model, int accountId)
{
foreach (var item in model)
{
var cartItem = new CartEntityModel
{
AccountId = accountId,
BookId = item.ItemId,
Quantity = item.Quantity,
Finished = false
};
_db.Add(cartItem);
}
_db.SaveChanges();
}
public void RemoveCart(CartViewModel model, int accountId)
{
int bookId = model.ItemId;
var cartId = FindCartId(accountId, bookId);
var updateCart = new CartEntityModel
{
Id = cartId,
AccountId = accountId,
BookId = model.ItemId,
Quantity = model.Quantity,
Finished = true
};
_db.Remove(updateCart);
_db.SaveChanges();
}
