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); } }