public int CartItemsCount(int cartId)
{
using (var context = new ECommerceDataContext(_connectionString))
{
if (cartId != 0)
{
IEnumerable<CartItem> items = context.CartItems.Where(c => c.CartId == cartId);
if(items != null)
{
return items.Sum(i => i.Quantity);
}
else
{
return 0;
}
}
else
{
return 0;
}
}
}
public IEnumerable<Category> GetCategories()
{
using(var context = new ECommerceDataContext(_connectionString))
{
return context.Categories.ToList();
}
}
public CartItem AlreadyAdded(int productId, int cartId)
{
using(var context = new ECommerceDataContext(_connectionString))
{
return context.CartItems.FirstOrDefault(c => c.CartId == cartId && c.ProductId == productId);
}
}
public void AddProduct(Product p)
{
using (ECommerceDataContext context = new ECommerceDataContext(_connectionString))
{
context.Products.InsertOnSubmit(p);
context.SubmitChanges();
}
}
public void AddImage(Image i)
{
using (ECommerceDataContext context = new ECommerceDataContext(_connectionString))
{
context.Images.InsertOnSubmit(i);
context.SubmitChanges();
}
}
public void AddCategory(Category c)
{
using (ECommerceDataContext context = new ECommerceDataContext(_connectionString))
{
context.Categories.InsertOnSubmit(c);
context.SubmitChanges();
}
}
public void DeleteItem(int itemId)
{
using(var context = new ECommerceDataContext(_connectionString))
{
context.ExecuteCommand("DELETE FROM CartItems WHERE ItemId = {0}",itemId);
}
}
public void AddCartItem(CartItem cI)
{
using (var context = new ECommerceDataContext(_connectionString))
{
context.CartItems.InsertOnSubmit(cI);
context.SubmitChanges();
}
}
public Product GetProductById(int id)
{
using (var context = new ECommerceDataContext(_connectionString))
{
var dataLoadOptions = new DataLoadOptions();
dataLoadOptions.LoadWith<Product>(p => p.Images);
context.LoadOptions = dataLoadOptions;
return context.Products.Where(p => p.ProductId == id).First();
}
}
public void AddAdmin(string username, string password)
{
string salt = PasswordManager.GenerateSalt();
string passwordHash = PasswordManager.HashPassword(password, salt);
using (var context = new ECommerceDataContext())
{
context.Administrators.InsertOnSubmit(new Administrator { UserName = username, PasswordHash = passwordHash, PasswordSalt = salt });
context.SubmitChanges();
}
}
public IEnumerable<Product>GetProcuctsByCategory(int? categoryId)
{
using (var context = new ECommerceDataContext(_connectionString))
{
var dataLoadOptions = new DataLoadOptions();
dataLoadOptions.LoadWith<Product>(p => p.Images);
context.LoadOptions = dataLoadOptions;
return context.Products.Where(p => p.CategoryId == categoryId).ToList();
}
}
public IEnumerable<CartItem> GetItems(int cartId)
{
using (var context = new ECommerceDataContext(_connectionString))
{
var dataLoadOptions = new DataLoadOptions();
dataLoadOptions.LoadWith<CartItem>(c => c.Product);
dataLoadOptions.LoadWith<Product>(p => p.Images);
context.LoadOptions = dataLoadOptions;
return context.CartItems.Where(c => c.CartId == cartId).ToList();
}
}
private Administrator GetAdmin(string username, string password)
{
using(ECommerceDataContext context = new ECommerceDataContext(_connectionString))
{
return context.Administrators.Where(a => a.UserName == username).First();
}
}
public int NewCart()
{
using(var context = new ECommerceDataContext(_connectionString))
{
Cart c = new Cart();
c.DateCreated = DateTime.Now;
context.Carts.InsertOnSubmit(c);
context.SubmitChanges();
return c.CartId;
}
}
public void UpdateItem(CartItem cartItem)
{
using(var context = new ECommerceDataContext(_connectionString))
{
context.CartItems.Attach(cartItem);
context.Refresh(RefreshMode.KeepCurrentValues, cartItem);
context.SubmitChanges();
}
}
public void Remove(int itemId)
{
using(var context = new ECommerceDataContext(_connectionString))
{
context.ExecuteCommand("DELETE * FROM CartItems Where ItemId = {0}", itemId);
}
}
