// Вывод public ListEmployeeVacancy selectEmployeeVacancy(string query, string connectionString) { string sqlExpresion = query; ListEmployeeVacancy listEmployee; using (MySqlConnection myConnection = new MySqlConnection(connectionString)) { listEmployee = new ListEmployeeVacancy(); try { myConnection.Open(); MySqlCommand command = new MySqlCommand(sqlExpresion, myConnection); MySqlDataReader reader = command.ExecuteReader(); while (reader.Read()) { listEmployee.idVacancy = Convert.ToInt32(reader["IdVacancy"]); listEmployee.idEmployee = Convert.ToInt32(reader["IdEmployee"]); } reader.Close(); myConnection.Close(); } catch (Exception ex) { message = ex.Message; } return(listEmployee); } }
// Изменение public void updateEmplyeeVacancy(string query, string connectionString, ListEmployeeVacancy listEmployee) { // название хранимой процедуры string sqlExpression = query; try { using (MySqlConnection connection = new MySqlConnection(connectionString)) { connection.Open(); MySqlCommand command = new MySqlCommand(sqlExpression, connection); // Указываем, что команда представляет хранимую процедуру command.CommandType = System.Data.CommandType.StoredProcedure; // Параметры для выполнения MySqlParameter idVacancyParam = new MySqlParameter { ParameterName = "@IdVacancy", Value = listEmployee.idVacancy, MySqlDbType = MySqlDbType.Int32 }; // Добавляем параметр command.Parameters.Add(idVacancyParam); MySqlParameter idEmployeeParam = new MySqlParameter { ParameterName = "@IdEmployee", Value = listEmployee.idEmployee, MySqlDbType = MySqlDbType.Int32 }; // Добавляем параметр command.Parameters.Add(idEmployeeParam); command.ExecuteNonQuery(); connection.Close(); } } catch (Exception ex) { message = ex.Message; } }
// Удаление public void deleteEmployeeVacancy(string query, string connectionString, ListEmployeeVacancy listEmployee) { // запрос string sqlExpression = query; try { using (MySqlConnection connection = new MySqlConnection(connectionString)) { connection.Open(); MySqlCommand command = new MySqlCommand(sqlExpression, connection); command.Parameters.AddWithValue("@IdVacancy", listEmployee.idVacancy); command.ExecuteNonQuery(); connection.Close(); } } catch (Exception ex) { message = ex.Message; } }