public ActionResult DeleteConfirmed(int id) { SPro sPro = db.SProes.Find(id); db.SProes.Remove(sPro); db.SaveChanges(); return(RedirectToAction("Index")); }
public ActionResult Edit([Bind(Include = "SID,ProductID,Quantity")] SPro sPro) { if (ModelState.IsValid) { db.Entry(sPro).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.ProductID = new SelectList(db.Products, "ProductID", "PName", sPro.ProductID); return(View(sPro)); }
// GET: SProes/Details/5 public ActionResult Details(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } SPro sPro = db.SProes.Find(id); if (sPro == null) { return(HttpNotFound()); } return(View(sPro)); }
// GET: SProes/Edit/5 public ActionResult Edit(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } SPro sPro = db.SProes.Find(id); if (sPro == null) { return(HttpNotFound()); } ViewBag.ProductID = new SelectList(db.Products, "ProductID", "PName", sPro.ProductID); return(PartialView("../SProes/_partialEdit", sPro)); }
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 = "SID,ProductID,Quantity")] SPro sPro) { var sp = db.SProes.SingleOrDefault(a => a.ProductID.Equals(sPro.ProductID)); if (sp == null) { if (ModelState.IsValid) { db.SProes.Add(sPro); db.SaveChanges(); return(RedirectToAction("Index", "Products")); } } else { sp.Quantity = sp.Quantity + sPro.Quantity; db.SaveChanges(); return(RedirectToAction("Index", "Products")); } ViewBag.ProductID = new SelectList(db.Products, "ProductID", "PName", sPro.ProductID); return(View(sPro)); }