public ActionResult CategoryAdd(Category category)
        {
            category.created_by = "jparagados";
            category.created_date = System.DateTime.Now;
            category.active_flag = true;
            db.Categories.Add(category);
            db.SaveChanges();

            return RedirectToAction("viewCategory");
        }
        public ActionResult DeleteCategoryFinal(Category categories, int id)
        {
            Category category = db.Categories.Find(id);

            category.active_flag = false;
            db.Entry(category).State = EntityState.Modified;
            db.SaveChanges();

            return RedirectToAction("viewCategory");
        }