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