public static int DeleteCategory(string id) {
            int count = 0;
            string sql = "delete from Categories where CategoryId = @id";
            SqlParameter param = new SqlParameter("@id", SqlDbType.NVarChar);
            param.Value = id;
            count = Database.ExecuteSQL(sql, param);
            return count;
        }