public bool AdddtCart(cart_detail ca)
{
LQDataContext ctxs = new LQDataContext();
ctxs.cart_details.InsertOnSubmit(ca);
ctxs.SubmitChanges();
return(true);
}
public void updatedtCart(cart_detail dtc)
{
LQDataContext ctxx = new LQDataContext();
var q = ctxx.cart_details.Where(d => d.id_dtcart == dtc.id_dtcart).SingleOrDefault();
q.id_pro = dtc.id_pro;
q.quantity = dtc.quantity;
ctxx.SubmitChanges();
}
public ActionResult Thanks(FormCollection form)
{
if (Session["customer"] == null)
{
return(RedirectToAction("Login", "Account"));
}
List <CartItem> cart = Session["cart"] as List <CartItem>;
cart = cart == null ? new List <CartItem>() : cart;
cart newCart = new cart();
try
{
db.ExecuteQuery <cart>("insert into cart values({0}, {1}, {2})",
(Session["customer"] as customer).customer_id,
Utility.GetNowToSQLDateTime(),
0);
}
catch (Exception e) {
}
//0 = chưa xử lý - 1 = đã xử lý
db.SubmitChanges();
int cartId = db.carts.OrderByDescending(u => u.cart_id).FirstOrDefault().cart_id;
foreach (CartItem item in cart)
{
cart_detail cart_Detail = new cart_detail();
cart_Detail.cart_id = cartId;
cart_Detail.product_id = item.Product.Id;
cart_Detail.quantum = item.Quantity;
cart_Detail.size_id = item.Size;
cart_Detail.color_id = item.Color;
var product = db.products.FirstOrDefault(m => m.product_id.Equals(item.Product.Id));
product.product_quantum -= item.Quantity;
db.SubmitChanges();
//db.ExecuteQuery<product>("update product set product_quantum = product_quantum - {0} where product_id = {1}",
// item.Quantity,
// item.Product.Id);
db.ExecuteQuery <cart_detail>("insert into cart_detail values({0}, {1}, {2}, {3}, {4})",
cart_Detail.cart_id,
cart_Detail.product_id,
cart_Detail.quantum,
cart_Detail.size_id,
cart_Detail.color_id);
db.SubmitChanges();
}
Session["cart"] = null;
return(View());
}
public void add_dtCart()
{
if (cart1 != null)
{
DataTable ca = Session["guest"] as DataTable;
foreach (RepeaterItem it in rpguest.Items)
{
Label n1 = (Label)it.FindControl("lblID");
TextBox n2 = (TextBox)it.FindControl("tbqty");
Label n3 = (Label)it.FindControl("lblsum");
Label n4 = (Label)it.FindControl("lbltsum");
dc = new cart_detail();
dc.id_cart = cart1.id_cart;
dc.id_pro = Convert.ToInt32(n1.Text);
dc.quantity = Convert.ToInt32(n2.Text);
dc.total_price = float.Parse(n3.Text);
//n4.Text = tbguest.Compute("Sum(lblsum)", "").ToString();
cl.AdddtCart(dc);
}
}
}
