public ActionResult Create(int id = 0) { TransactionBill bill = new TransactionBill(); if (!db.CartDetails.Any()) { ViewBag.Error = "Cart is Empty"; } else { string UserId = Session["userid"].ToString(); bill.userid = UserId; var cart = db.CartDetails.Where(pro => pro.userid.Equals(UserId)).FirstOrDefault(); bill.amount = db.CartDetails.Select(t => t.Price ?? 0).Sum(); bill.TransactionDate = DateTime.Now; db.TransactionBills.Add(bill); db.CartDetails.Remove(cart); db.SaveChanges(); ViewBag.Success = "Paid"; return(RedirectToAction("Index")); } //ViewBag.cid = new SelectList(db.CartDetails, "id", "userid", transactionBill.cid); return(View(bill)); }
public ActionResult Create([Bind(Include = "productid,productName,CategoryName,Availableunits,price,discount")] Product product) { if (ModelState.IsValid) { db.Products.Add(product); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(product)); }
public ActionResult Create([Bind(Include = "id,Productid,userid,quantity,Price")] CartDetail cartDetail) { if (ModelState.IsValid) { db.CartDetails.Add(cartDetail); 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)); }
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 Create(string feedback1, int productid1) { var p = db.Products.Where(pro => pro.productid.Equals(productid1)).FirstOrDefault(); if (ModelState.IsValid) { Feedback feed1 = new Feedback(); feed1.userid = Session["UserId"].ToString(); feed1.productname = p.productName; feed1.FBDate = DateTime.Now; feed1.Feedback1 = feedback1; db.Feedbacks.Add(feed1); db.SaveChanges(); return(RedirectToAction("Index", "Home")); } return(RedirectToAction("Index", "Home")); }
public ActionResult AddorEdit(tbluser user) { using (ECommerceEntities2 db = new ECommerceEntities2()) { if (db.tblusers.Any(x => x.userid == user.userid)) { ViewBag.DuplicateMessage = "User Name Already Exists."; return(View("AddorEdit", user)); } else { db.tblusers.Add(user); db.SaveChanges(); } } ModelState.Clear(); ViewBag.SuccessMessage = "Registration Successful."; return(View("AddorEdit", new tbluser())); }