public void AddToCart(string shoppingCartID, int productID, int quantity)
{
using (var db = new AdventureWorks2008R2Entities())
{
ShoppingCartItem myItem =
(from c in db.ShoppingCartItems
where c.ShoppingCartID == shoppingCartID && c.ProductID == productID
select c).FirstOrDefault();
if (myItem == null)
{
var cartadd = new ShoppingCartItem
{
ShoppingCartID = shoppingCartID,
Quantity = quantity,
ProductID = productID,
DateCreated = DateTime.Now,
ModifiedDate = DateTime.Now
};
db.ShoppingCartItems.AddObject(cartadd);
}
else
{
myItem.Quantity += quantity;
}
db.SaveChanges();
}
}
public void CreateProductInDatabase(Product product)
{
using (var db = new AdventureWorks2008R2Entities())
{
db.Products.AddObject(product);
db.SaveChanges();
}
}
private int RemoveFromCart(string shoppingCartId, int cartItemId)
{
using (var db = new AdventureWorks2008R2Entities())
{
int itemCount = 0;
//Get the cart
var cartItem = db.ShoppingCartItems.Single(
cart => cart.ShoppingCartID == shoppingCartId
&& cart.ShoppingCartItemID == cartItemId);
if (cartItem != null)
{
if (cartItem.Quantity > 1)
{
cartItem.Quantity--;
itemCount = cartItem.Quantity;
}
else
{
db.ShoppingCartItems.DeleteObject(cartItem);
}
db.SaveChanges();
}
return itemCount;
}
}