// Изменение public void updateSpecialization(string query, string connectionString, Specialization specialization) { // название хранимой процедуры string sqlExpression = query; try { using (MySqlConnection connection = new MySqlConnection(connectionString)) { connection.Open(); MySqlCommand command = new MySqlCommand(sqlExpression, connection); // Параметры для выполнения MySqlParameter idSpecializationParam = new MySqlParameter { ParameterName = "@IdSpecialization", Value = specialization.idSpecialization, MySqlDbType = MySqlDbType.Int32 }; // Добавляем параметр command.Parameters.Add(idSpecializationParam); MySqlParameter nameParam = new MySqlParameter { ParameterName = "@Name", Value = specialization.name, MySqlDbType = MySqlDbType.String }; // Добавляем параметр command.Parameters.Add(nameParam); command.ExecuteNonQuery(); connection.Close(); } } catch (Exception ex) { message = ex.Message; } }
// Удаление public void deleteSpecialization(string query, string connectionString, Specialization specialization) { // запрос string sqlExpression = query; try { using (MySqlConnection connection = new MySqlConnection(connectionString)) { connection.Open(); MySqlCommand command = new MySqlCommand(sqlExpression, connection); command.Parameters.AddWithValue("@IdSpecialization", specialization.idSpecialization); command.ExecuteNonQuery(); connection.Close(); } } catch (Exception ex) { message = ex.Message; } }