public IEnumerable <SubCategory_Class> GetSubCategoryData(string ID)
        {
            List <SubCategory_Class> list = new List <SubCategory_Class>();
            DataTable dt = new DataTable();

            dt = new SubCategory_Models().BindSubCategoryDatabasedonCategory(ID);
            if (dt.Rows.Count > 0)
            {
                foreach (DataRow dr in dt.Rows)
                {
                    list.Add(new SubCategory_Class()
                    {
                        SubCategoryId   = Convert.ToString(dr["SubCategoryId"]),
                        SubCategoryName = Convert.ToString(dr["SubCategoryName"]),
                        SearchKeyword   = Convert.ToString(dr["SearchKeyword"]),
                        MetaDescription = Convert.ToString(dr["MetaDescription"]),

                        CategoryId = Convert.ToString(dr["CategoryId"]),
                        Category   = Convert.ToString(dr["Category Name"]),

                        Active = Convert.ToString(dr["Active"])
                    });
                }
            }
            return(list);
        }
        public string GetData()
        {
            string    data = "";
            DataTable dt   = new DataTable();

            dt = new SubCategory_Models().BindSubCategoryData();
            if (dt.Rows.Count > 0)
            {
                data = JsonConvert.SerializeObject(dt);
            }
            return(data);
        }