// Изменение
public void updateFavorites(string query, string connectionString, Favorites favorites)
{
// запрос
string sqlExpression = query;
try
{
using (MySqlConnection connection = new MySqlConnection(connectionString))
{
connection.Open();
MySqlCommand command = new MySqlCommand(sqlExpression, connection);
// Параметры для выполнения
MySqlParameter idAccountParam = new MySqlParameter
{
ParameterName = "@IdAccount",
Value = favorites.idAccount,
MySqlDbType = MySqlDbType.Int32
};
// Добавляем параметр
command.Parameters.Add(idAccountParam);
MySqlParameter idVacancyParam = new MySqlParameter
{
ParameterName = "@IdVacancy",
Value = favorites.idVacancy,
MySqlDbType = MySqlDbType.Int32
};
// Добавляем параметр
command.Parameters.Add(idVacancyParam);
command.ExecuteNonQuery();
connection.Close();
}
}
catch (Exception ex)
{
message = ex.Message;
}
}
// Удаление
public void deleteFavorites(string query, string connectionString, Favorites favorites)
{
// запрос
string sqlExpression = query;
try
{
using (MySqlConnection connection = new MySqlConnection(connectionString))
{
connection.Open();
MySqlCommand command = new MySqlCommand(sqlExpression, connection);
command.Parameters.AddWithValue("@IdAccount", favorites.idAccount);
command.ExecuteNonQuery();
connection.Close();
}
}
catch (Exception ex)
{
message = ex.Message;
}
}
