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