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