//------------------------------------------------------------------------------------------------------------------------------------------+
public void AddItem(string cartID, int productID, int quantity)
{
using (CommerceEntities db = new CommerceEntities())
{
try
{
var myItem = (from c in db.ShoppingCarts where c.CartID == cartID && c.ProductID == productID select c).FirstOrDefault();
if (myItem == null)
{
ShoppingCart cartadd = new ShoppingCart();
cartadd.CartID = cartID;
cartadd.Quantity = quantity;
cartadd.ProductID = productID;
cartadd.DateCreated = DateTime.Now;
db.ShoppingCarts.AddObject(cartadd);
}
else
{
myItem.Quantity += quantity;
}
db.SaveChanges();
}
catch (Exception exp)
{
throw new Exception("ERROR: Unable to Add Item to Cart - " + exp.Message.ToString(), exp);
}
}
}
//------------------------------------------------------------------------------------------------------------------------------------------+
protected void ReviewAddBtn_Click(object sender, ImageClickEventArgs e)
{
if (Page.IsValid == true)
{
// Obtain ProductID from Page State
int productID = Int32.Parse(Request["productID"]);
// Obtain Rating number of RadioButtonList
int rating = Int32.Parse(Rating.SelectedItem.Value);
// Add Review to ReviewsDB. HtmlEncode before entry
using (CommerceEntities db = new CommerceEntities())
{
try
{
ShoppingCart cartadd = new ShoppingCart();
Review newReview = new Review()
{
ProductID = productID,
Rating = rating,
CustomerName = HttpUtility.HtmlEncode(Name.Text),
CustomerEmail = HttpUtility.HtmlEncode(Email.Text),
Comments = HttpUtility.HtmlEncode(UserComment.Content)
};
db.Reviews.AddObject(newReview);
db.SaveChanges();
}
catch (Exception exp)
{
throw new Exception("ERROR: Unable to Update Cart Item - " + exp.Message.ToString(), exp);
}
}
Response.Redirect("ProductDetails.aspx?ProductID=" + productID);
}
Response.Redirect("ProductList.aspx");
}
/// <summary>
/// Deprecated Method for adding a new object to the ShoppingCarts EntitySet. Consider using the .Add method of the associated ObjectSet<T> property instead.
/// </summary>
public void AddToShoppingCarts(ShoppingCart shoppingCart)
{
base.AddObject("ShoppingCarts", shoppingCart);
}
/// <summary>
/// Create a new ShoppingCart object.
/// </summary>
/// <param name="recordID">Initial value of the RecordID property.</param>
/// <param name="quantity">Initial value of the Quantity property.</param>
/// <param name="productID">Initial value of the ProductID property.</param>
/// <param name="dateCreated">Initial value of the DateCreated property.</param>
public static ShoppingCart CreateShoppingCart(global::System.Int32 recordID, global::System.Int32 quantity, global::System.Int32 productID, global::System.DateTime dateCreated)
{
ShoppingCart shoppingCart = new ShoppingCart();
shoppingCart.RecordID = recordID;
shoppingCart.Quantity = quantity;
shoppingCart.ProductID = productID;
shoppingCart.DateCreated = dateCreated;
return shoppingCart;
}