public ActionResult Delete(Int32 id)
        {
            tbl_sub_category tb = db.tbl_sub_categories.Where(x => x.sub_cat_id == id).Single <tbl_sub_category>();

            db.tbl_sub_categories.DeleteOnSubmit(tb);
            db.SubmitChanges();
            return(RedirectToAction("Index"));
        }
        public ActionResult DeleteConfirmed(int id)
        {
            tbl_sub_category tbl_sub_category = db.tbl_sub_category.Find(id);

            db.tbl_sub_category.Remove(tbl_sub_category);
            db.SaveChanges();
            return(RedirectToAction("Index"));
        }
        public ActionResult Edit(Model_sub_category obj)
        {
            tbl_sub_category tb = db.tbl_sub_categories.Where(x => x.sub_cat_id == obj.sub_cat_id).Single <tbl_sub_category>();

            tb.sub_cat_id   = obj.sub_cat_id;
            tb.cat_id       = obj.cat_id;
            tb.sub_cat_name = obj.sub_cat_name;
            tb.sub_cat_des  = obj.sub_cat_des;
            db.SubmitChanges();
            return(RedirectToAction("Index"));
        }
        public ActionResult Create(Model_sub_category obj)
        {
            tbl_sub_category tb = new tbl_sub_category();

            tb.cat_id       = obj.cat_id;
            tb.sub_cat_name = obj.sub_cat_name;
            tb.sub_cat_des  = obj.sub_cat_des;
            db.tbl_sub_categories.InsertOnSubmit(tb);
            db.SubmitChanges();
            return(RedirectToAction("Index"));
        }
 public ActionResult Edit([Bind(Include = "subID,catID,subcategory")] tbl_sub_category tbl_sub_category)
 {
     if (ModelState.IsValid)
     {
         db.Entry(tbl_sub_category).State = EntityState.Modified;
         db.SaveChanges();
         return(RedirectToAction("Index"));
     }
     ViewBag.catID = new SelectList(db.tbl_category, "catID", "category", tbl_sub_category.catID);
     return(View(tbl_sub_category));
 }
        public ActionResult Create([Bind(Include = "subID,catID,subcategory")] tbl_sub_category tbl_sub_category)
        {
            if (ModelState.IsValid)
            {
                db.tbl_sub_category.Add(tbl_sub_category);
                db.SaveChanges();
                return(RedirectToAction("Index"));
            }

            ViewBag.catID = new SelectList(db.tbl_category, "catID", "category", tbl_sub_category.catID);
            return(View(tbl_sub_category));
        }
        // GET: sub_category/Details/5
        public ActionResult Details(int?id)
        {
            if (id == null)
            {
                return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
            }
            tbl_sub_category tbl_sub_category = db.tbl_sub_category.Find(id);

            if (tbl_sub_category == null)
            {
                return(HttpNotFound());
            }
            return(View(tbl_sub_category));
        }
        // GET: sub_category/Edit/5
        public ActionResult Edit(int?id)
        {
            if (id == null)
            {
                return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
            }
            tbl_sub_category tbl_sub_category = db.tbl_sub_category.Find(id);

            if (tbl_sub_category == null)
            {
                return(HttpNotFound());
            }
            ViewBag.catID = new SelectList(db.tbl_category, "catID", "category", tbl_sub_category.catID);
            return(View(tbl_sub_category));
        }