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));
}
