public void AddImage(Image i) { using (ECommerceDataContext context = new ECommerceDataContext(_connectionString)) { context.Images.InsertOnSubmit(i); context.SubmitChanges(); } }
public void AddProduct(Product p) { using (ECommerceDataContext context = new ECommerceDataContext(_connectionString)) { context.Products.InsertOnSubmit(p); context.SubmitChanges(); } }
public void AddCategory(Category c) { using (ECommerceDataContext context = new ECommerceDataContext(_connectionString)) { context.Categories.InsertOnSubmit(c); context.SubmitChanges(); } }
public void AddCartItem(CartItem cI) { using (var context = new ECommerceDataContext(_connectionString)) { context.CartItems.InsertOnSubmit(cI); context.SubmitChanges(); } }
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 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(); } }