public ActionResult Add() { Tbl_products tbl = new Tbl_products(); tbl.brand_id = 0; tbl.category_id = 0; return(View(tbl)); }
public JsonResult DeleteProduct(int pid) { try { using (InventryDBEntities db = new InventryDBEntities()) { Tbl_products std = db.Tbl_products.Where(x => x.product_id == pid).FirstOrDefault(); db.Tbl_products.Remove(std); db.SaveChanges(); } return(Json(true, JsonRequestBehavior.AllowGet)); } catch (Exception e) { return(Json(false, JsonRequestBehavior.DenyGet)); } }
public ActionResult Add(Tbl_products Product, HttpPostedFileBase filesrefdoc) { //update student in DB using EntityFramework in real-life application try { using (InventryDBEntities db = new InventryDBEntities()) { //update list by removing old student and adding updated student for demo purpose db.Tbl_products.Add(Product); db.SaveChanges(); return(RedirectToAction("index")); } } catch (Exception e) { return(Json(true, JsonRequestBehavior.AllowGet)); } }
public ActionResult Edit(Tbl_products std, HttpPostedFileBase filesrefdoc) { //update student in DB using EntityFramework in real-life application try { using (InventryDBEntities db = new InventryDBEntities()) { ////update list by removing old student and adding updated student for demo purpose var student = db.Tbl_products.Where(s => s.product_id == std.product_id).FirstOrDefault(); db.Tbl_products.Remove(student); db.Tbl_products.Add(std); db.SaveChanges(); return(RedirectToAction("home/index")); } } catch (Exception e) { return(Json(true, JsonRequestBehavior.AllowGet)); } }