public ActionResult DeleteConfirmed(int id) { MPro mPro = db.MProes.Find(id); db.MProes.Remove(mPro); db.SaveChanges(); return(RedirectToAction("Index")); }
public ActionResult Edit([Bind(Include = "MID,ProductID,Quantity")] MPro mPro) { if (ModelState.IsValid) { db.Entry(mPro).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.ProductID = new SelectList(db.Products, "ProductID", "PName", mPro.ProductID); return(View(mPro)); }
// GET: MProes/Details/5 public ActionResult Details(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } MPro mPro = db.MProes.Find(id); if (mPro == null) { return(HttpNotFound()); } return(View(mPro)); }
// GET: MProes/Edit/5 public ActionResult Edit(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } MPro mPro = db.MProes.Find(id); if (mPro == null) { return(HttpNotFound()); } ViewBag.ProductID = new SelectList(db.Products, "ProductID", "PName", mPro.ProductID); //return View(mPro); return(PartialView("../MProes/_partialEdit", mPro)); }
public ActionResult Create([Bind(Include = "ProductID,PName,Price,BrandID,Status")] Product product) { if (ModelState.IsValid) { product.Status = true; db.Products.Add(product); db.SaveChanges(); db = new ModelContext1(); Promotion pro = new Promotion(); pro.PromotionID = RandomString(5, true); pro.ProductID = product.ProductID; pro.Promotion1 = 0; db.Promotions.Add(pro); db.SaveChanges(); db = new ModelContext1(); SPro s = new SPro(); s.ProductID = product.ProductID; s.Quantity = 0; db.SProes.Add(s); db.SaveChanges(); db = new ModelContext1(); LPro l = new LPro(); l.ProductID = product.ProductID; l.Quantity = 0; db.LProes.Add(l); db.SaveChanges(); db = new ModelContext1(); MPro m = new MPro(); m.ProductID = product.ProductID; m.Quantity = 0; db.MProes.Add(m); db.SaveChanges(); db = new ModelContext1(); XLPro xl = new XLPro(); xl.ProductID = product.ProductID; xl.Quantity = 0; db.XLProes.Add(xl); db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.BrandID = new SelectList(db.Brands, "BrandID", "BName", product.BrandID); return(View(product)); }
public ActionResult Create([Bind(Include = "MID,ProductID,Quantity")] MPro mPro) { var sp = db.MProes.SingleOrDefault(a => a.ProductID.Equals(mPro.ProductID)); if (sp == null) { if (ModelState.IsValid) { db.MProes.Add(mPro); db.SaveChanges(); return(RedirectToAction("Index", "Products")); } } else { sp.Quantity = sp.Quantity + mPro.Quantity; db.SaveChanges(); return(RedirectToAction("Index", "Products")); } ViewBag.ProductID = new SelectList(db.Products, "ProductID", "PName", mPro.ProductID); return(View(mPro)); }