public ActionResult DeleteCart(int id) { uid = id; tblCart tb = _db.tblCarts.Where(u => u.CartId == id).FirstOrDefault(); return(View(tb)); }
public HttpResponseMessage removeFromCart(int cartid, int productid) { tblCart result = db.tblCarts.Find(cartid, productid); db.tblCarts.Remove(result); db.SaveChanges(); return(Request.CreateResponse(HttpStatusCode.OK, "Success")); }
public ActionResult DeleteCart() { tblCart tb = _db.tblCarts.Where(u => u.CartId == uid).FirstOrDefault(); _db.tblCarts.Remove(tb); _db.SaveChanges(); return(RedirectToAction("Cart", "Home")); }
public HttpResponseMessage InsertCart(string useremail, int productid, int cartquantity) { tblCart cart = new tblCart() { useremail = useremail, productid = productid, cartquantity = cartquantity }; db.tblCarts.Add(cart); db.SaveChanges(); return(Request.CreateResponse(HttpStatusCode.OK, "Success")); }
public string InsertProduct(tblCart cart) { try { OnlineKitchenDBEntities db = new OnlineKitchenDBEntities(); db.tblCarts.Add(cart); db.SaveChanges(); return(cart.DatePurchased + " was successfully inserted"); } catch (Exception e) { return("Error: " + e); } }
public ActionResult AddToCart(int id) { tblCart tc = new tblCart(); tc.ProductId = id; tblUser ur = _db.tblUsers.Where(m => m.Email == User.Identity.Name).FirstOrDefault(); if (ur == null) { return(RedirectToAction("Login", "Account")); } tc.UserId = ur.UserId; _db.tblCarts.Add(tc); _db.SaveChanges(); tc = _db.tblCarts.Where(m => m.UserId == ur.UserId).FirstOrDefault(); return(RedirectToAction("Cart", "Home")); }
public ActionResult AddCart(tblModel TestRoute1) { tblCart cart = new tblCart(); cart.CusId = 3; cart.ModelId = TestRoute1.ModelId; cart.PurcharseDate = TestRoute1.PurcharseDate; if (ModelState.IsValid) { db.tblCarts.Add(cart); db.SaveChanges(); TempData["AlertMessage"] = "my alert message"; return(RedirectToAction("index", "product")); } return(RedirectToAction("index", new { id = "1" })); }
public string DeleteProduct(int id) { try { OnlineKitchenDBEntities db = new OnlineKitchenDBEntities(); tblCart cart = db.tblCarts.Find(id); db.tblCarts.Attach(cart); db.tblCarts.Remove(cart); db.SaveChanges(); return(cart.DatePurchased + " was successfully deleted"); } catch (Exception e) { return("Error: " + e); } }
public string Remove(int CartId) //This method is used for removing a book from the cart. { string message; try { using (var db = new Orchard9Entities()) { tblCart a1 = db.tblCarts.Find(CartId); db.tblCarts.Remove(a1); db.SaveChanges(); message = CartId + " removed from cart"; } } catch (Exception e) { message = e.Message; } return(message); }
protected void btnAdd_Click(object sender, EventArgs e) { if (!string.IsNullOrWhiteSpace(Request.QueryString["id"])) { string clientId = "-1"; int id = Convert.ToInt32(Request.QueryString["id"]); int amount = Convert.ToInt32(ddlAmount.SelectedValue); tblCart cart = new tblCart { Amount = amount, ClientID = clientId, DatePurchased = DateTime.Now, IsInCart = true, ProductID = id }; CartModel model = new CartModel(); lblResult.Text = model.InsertProduct(cart); } }
public string UpdateProduct(int id, tblCart cart) { try { OnlineKitchenDBEntities db = new OnlineKitchenDBEntities(); //Fetch object from db tblCart p = db.tblCarts.Find(id); p.DatePurchased = cart.DatePurchased; p.ClientID = cart.ClientID; p.Amount = cart.Amount; p.IsInCart = cart.IsInCart; p.ProductID = cart.ProductID; db.SaveChanges(); return(cart.DatePurchased + " was successfully updated"); } catch (Exception e) { return("Error: " + e); } }
public ActionResult AddToCart(int id, int uID, decimal qty, string size) { try { string usrID = uID.ToString(); decimal quantity = qty; using (linqDBContext db = new linqDBContext()) { var cartQty = (from us in db.tblCarts where us.userMob == usrID && us.itemID == id && us.size == size select us).FirstOrDefault(); if (cartQty != null) { quantity += cartQty.itemQty.Value; } //Availibity var chkAvailibity = (from us in db.Inventory_Latest where us.itemId == id && us.network == 3 && us.localID == 0 && us.size == size select us).FirstOrDefault(); if (quantity > chkAvailibity.qty) { if (chkAvailibity.qty == 0) { return(Json(new { status = "error", Data = size + " size if out of stock." }, JsonRequestBehavior.AllowGet)); } else { return(Json(new { status = "error", Data = "Inventory has only " + chkAvailibity.qty + " " + size + " items left." }, JsonRequestBehavior.AllowGet)); } } var q = (from us in db.tblCarts join item in db.tblItems on us.itemID equals item.id where us.userMob == usrID && us.itemID == id && us.size == size select new { us, item }).FirstOrDefault(); if (q != null) { if (qty < 0) { if ((q.us.itemQty == null) || (q.us.itemQty == 1)) { return(Json(new { status = "error", Data = "Cannot remove further." }, JsonRequestBehavior.AllowGet)); } } if (q.us.itemQty != null) { q.us.itemQty += qty; q.us.Price = Convert.ToDecimal(q.us.itemQty.Value * q.item.netPrice.Value); db.SaveChanges(); } else { q.us.itemQty = qty; q.us.Price = Convert.ToDecimal(q.us.itemQty.Value * q.item.netPrice.Value); db.SaveChanges(); } return(Json(new { status = "success", Data = GetItem(q.us.id, usrID).ToList() }, JsonRequestBehavior.AllowGet)); } else { var itemPrice = (from us in db.tblItems where us.id == id select us.netPrice.Value).FirstOrDefault(); //Add tblCart c = new tblCart(); c.userMob = usrID; c.itemQty = qty; c.itemID = id; c.size = size; c.Price = Convert.ToDecimal(qty * itemPrice); db.tblCarts.Add(c); db.SaveChanges(); return(Json(new { status = "success", Data = GetItem(c.id, usrID).ToList() }, JsonRequestBehavior.AllowGet)); } } } catch (Exception x) { return(Json(new { status = "error", Data = x.Message }, JsonRequestBehavior.AllowGet)); } }