public ActionResult DeleteConfirmed(int id)
        {
            SUBCATEGORy sUBCATEGORY = db.SUBCATEGORIES.Find(id);

            db.SUBCATEGORIES.Remove(sUBCATEGORY);
            db.SaveChanges();
            return(RedirectToAction("Index"));
        }
        public ActionResult Create([Bind(Include = "subcategoryID,subcategoryName,categoryID")] SUBCATEGORy sUBCATEGORY)
        {
            if (ModelState.IsValid)
            {
                db.SUBCATEGORIES.Add(sUBCATEGORY);
                db.SaveChanges();
                return(RedirectToAction("Index"));
            }

            ViewBag.categoryID = new SelectList(db.CATEGORIES, "categoryID", "categoryName", sUBCATEGORY.categoryID);
            return(View(sUBCATEGORY));
        }
        public ActionResult Edit(int?id)
        {
            if (id == null)
            {
                return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
            }
            SUBCATEGORy sUBCATEGORY = db.SUBCATEGORIES.Find(id);

            if (sUBCATEGORY == null)
            {
                return(HttpNotFound());
            }
            ViewBag.categoryID = new SelectList(db.CATEGORIES, "categoryID", "categoryName", sUBCATEGORY.categoryID);
            return(View(sUBCATEGORY));
        }