private int AddSubCategories(string subCategory)
        {
            using (HISDBEntities db = new HISDBEntities())
            {
                System.Data.Entity.Core.Objects.ObjectParameter subcatOut = new System.Data.Entity.Core.Objects.ObjectParameter("SubCategoryID", typeof(Int32));

                db.AddSubCategory(subCategory, subcatOut);
                return(Convert.ToInt32(subcatOut.Value));
            }
        }