public ActionResult Details(string itemno, int ProductId) { string UserId = Session["userid"].ToString(); decimal noofunits = decimal.Parse(itemno); var p = db.Products.Where(pro => pro.productid.Equals(ProductId)).FirstOrDefault(); if (noofunits > p.Availableunits) { ViewBag.Error = "No stock available"; return(View("Details", p)); } else { if (db.CartDetails.Where(car => car.Productid.Value.Equals(ProductId) && car.userid.Equals(UserId)).FirstOrDefault() != null) { CartDetail cart = db.CartDetails.Where(car => car.Productid.Value.Equals(ProductId) && car.userid.Equals(UserId)).FirstOrDefault(); cart.quantity = cart.quantity + noofunits; db.Entry(cart).State = EntityState.Modified; ViewBag.Added = "Added to Existing Cart"; p.Availableunits = p.Availableunits - cart.quantity > 0? p.Availableunits - cart.quantity:0; db.SaveChanges(); return(View("Details", p)); } else { CartDetail cart = new CartDetail(); cart.userid = Session["userid"].ToString(); cart.Productid = p.productid; cart.quantity = noofunits; cart.Price = (p.price - (p.price * (p.discount) / 100)) * noofunits; db.CartDetails.Add(cart); ViewBag.Added = "Added to Cart"; p.Availableunits = p.Availableunits - cart.quantity; db.SaveChanges(); return(View("Details", p)); } } //return RedirectToAction("Index", "Home"); }
public ActionResult Edit([Bind(Include = "productid,productName,CategoryName,Availableunits,price,discount")] Product product) { if (ModelState.IsValid) { db.Entry(product).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(product)); }
public ActionResult Edit([Bind(Include = "Transactionid,userid,amount,TransactionDate")] TransactionBill transactionBill) { if (ModelState.IsValid) { db.Entry(transactionBill).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(transactionBill)); }
public ActionResult Edit([Bind(Include = "id,userid,productname,Feedback1,FBDate")] Feedback feedback) { if (ModelState.IsValid) { db.Entry(feedback).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.userid = new SelectList(db.tblusers, "userid", "firstname", feedback.userid); return(View(feedback)); }
public ActionResult Edit([Bind(Include = "id,Productid,userid,quantity,Price")] CartDetail cartDetail) { if (ModelState.IsValid) { db.Entry(cartDetail).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.Productid = new SelectList(db.Products, "productid", "productName", cartDetail.Productid); ViewBag.userid = new SelectList(db.tblusers, "userid", "firstname", cartDetail.userid); return(View(cartDetail)); }