// Изменение
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;
}
}
