Exemple #1
0
        public string SubCategory_Update(SubCategory_Class obj)
        {
            if (obj.Active == "True")
            {
                obj.Active = "1";
            }
            else
            {
                obj.Active = "0";
            }

            SqlConnection con = new SqlConnection(objCon.ConnectionReturn());
            SqlCommand    cmd = new SqlCommand("SubCategory_Update", con);

            cmd.CommandType = CommandType.StoredProcedure;
            cmd.Parameters.AddWithValue("@SubCategoryId", obj.SubCategoryId);
            cmd.Parameters.AddWithValue("@SubCategoryName", obj.SubCategoryDescription);
            cmd.Parameters.AddWithValue("@CategoryId", obj.CategoryId);
            cmd.Parameters.AddWithValue("@MetaDescription", obj.MetaDescription);
            cmd.Parameters.AddWithValue("@SearchKeyword", obj.SearchKeyword);
            cmd.Parameters.AddWithValue("@Active", obj.Active);

            con.Open();
            cmd.ExecuteNonQuery();
            con.Close();
            string Return = "Data Update";

            return(Return);
        }
        public string SubCategory_Update(SubCategory_Class obj)
        {
            string Return = objModels.SubCategory_Update(obj);

            return(Return);
        }
        public string SubCategory_Insert(SubCategory_Class obj)
        {
            string Return = objModels.SubCategory_Insert(obj);

            return(Return);
        }