public int GetCount(QualityBooksContext db)
{
int?count =
(from cartItems in db.CartItems where cartItems.CartID == ShoppingCartId select(int?) cartItems.Count).Sum();
return(count ?? 0);
}
public decimal GetTotal(QualityBooksContext db)
{
decimal?total = (from cartItems in db.CartItems
where cartItems.CartID == ShoppingCartId
select(int?) cartItems.Count *cartItems.Product.ProductPrice).Sum();
return(total ?? decimal.Zero);
}
public void EmptyCart(QualityBooksContext db)
{
var cartItems = db.CartItems.Where(cart => cart.CartID == ShoppingCartId);
foreach (var cartItem in cartItems)
{
db.CartItems.Remove(cartItem);
}
db.SaveChanges();
}
public void ClearCart(QualityBooksContext apContext)
{
var cartItems = apContext.CartItems.Where(ci => ci.CartID == ShoppingCartId);
foreach (var cartItem in cartItems)
{
apContext.CartItems.Remove(cartItem);
}
apContext.SaveChanges();
}
public int RemoveFromCart(int id, QualityBooksContext db)
{
var cartItem = db.CartItems.SingleOrDefault(cart => cart.CartID == ShoppingCartId && cart.Product.Id == id);
int itemCount = 0;
if (cartItem != null)
{
if (cartItem.Count > 1)
{
cartItem.Count--;
itemCount = cartItem.Count;
}
else
{
db.CartItems.Remove(cartItem);
}
db.SaveChanges();
}
return(itemCount);
}
public void AddToCart(Product product, QualityBooksContext db)
{
var cartItem = db.CartItems.SingleOrDefault(c => c.CartID == ShoppingCartId && c.Product.Id == product.Id);
if (cartItem == null)
{
cartItem = new CartItem
{
Product = product,
CartID = ShoppingCartId,
Count = 1,
DateCreated = DateTime.Now
};
db.CartItems.Add(cartItem);
}
else
{
cartItem.Count++;
}
db.SaveChanges();
}
public ShoppingCartViewModelViewComponent(QualityBooksContext context)
{
_context = context;
}
public OrdersController(QualityBooksContext context, UserManager <ApplicationUser> userManager)
{
_context = context;
_userManager = userManager;
}
public ProductsController(QualityBooksContext context)
{
_context = context;
}
public AdminCategoriesController(QualityBooksContext context)
{
_context = context;
}
public AdminProductsController(QualityBooksContext context, IHostingEnvironment hEnv)
{
_context = context;
_hostingEnv = hEnv;
}
public AdminSuppliersController(QualityBooksContext context)
{
_context = context;
}
public AdminApplicationUsersController(QualityBooksContext context, IServiceProvider serviceProvider)
{
_context = context;
_userManager = serviceProvider.GetRequiredService <UserManager <ApplicationUser> >();
}
public ShoppingCartController(QualityBooksContext context)
{
_context = context;
}
public List <CartItem> GetCartItems(QualityBooksContext db)
{
List <CartItem> cartItems = db.CartItems.Include(i => i.Product).Where(cartItem => cartItem.CartID == ShoppingCartId).ToList();
return(cartItems);
}
