// Вывод public TopVacancy selectTopVacancy(string procedure, string connectionString) { // Можно заменить обычным запросом string sqlExpresion = procedure; TopVacancy topVacancy; using (MySqlConnection myConnection = new MySqlConnection(connectionString)) { topVacancy = new TopVacancy(); try { myConnection.Open(); MySqlCommand command = new MySqlCommand(sqlExpresion, myConnection); MySqlDataReader reader = command.ExecuteReader(); while (reader.Read()) { topVacancy.idVacancy = Convert.ToInt32(reader["IdVacancy"]); topVacancy.lastDate = Convert.ToDateTime(reader["LastDate"]); } reader.Close(); myConnection.Close(); } catch (Exception ex) { message = ex.Message; } return(topVacancy); } }
// Добавление public void insertTopVacancy(string query, string connectionString, TopVacancy topVacancy) { string sqlExpression = query; try { using (MySqlConnection connection = new MySqlConnection(connectionString)) { connection.Open(); MySqlCommand command = new MySqlCommand(sqlExpression, connection); // Параметры для выполнения MySqlParameter idVacancyParam = new MySqlParameter { ParameterName = "@IdVacancy", Value = topVacancy.idVacancy, MySqlDbType = MySqlDbType.Int32 }; // Добавляем параметр command.Parameters.Add(idVacancyParam); MySqlParameter lastDateParam = new MySqlParameter { ParameterName = "@LastDate", Value = topVacancy.lastDate, MySqlDbType = MySqlDbType.DateTime }; // Добавляем параметр command.Parameters.Add(lastDateParam); command.ExecuteNonQuery(); connection.Close(); } } catch (Exception ex) { message = ex.Message; } }
// Удаление public void deleteTopVacancy(string query, string connectionString, TopVacancy topVacancy) { // запрос string sqlExpression = query; try { using (MySqlConnection connection = new MySqlConnection(connectionString)) { connection.Open(); MySqlCommand command = new MySqlCommand(sqlExpression, connection); command.Parameters.AddWithValue("@IdVacancy", topVacancy.idVacancy); command.ExecuteNonQuery(); connection.Close(); } } catch (Exception ex) { message = ex.Message; } }