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); }