//окно добавления записи в БД private void AddMenuItem_Click(object sender, RoutedEventArgs e) { if (dtGrid.SelectedItem == null) { RowAddEditWindow win = new RowAddEditWindow("Добавление записи"); win.Owner = this; if (win.ShowDialog() == true) { string query; win.trade.setDataBaseParams(dBconnection.DB, dBconnection.Table); query = win.trade.AddQuery(); try { MySqlConnection connection = new MySqlConnection(dBconnection.makeConnectionString()); MySqlCommand cmdAddDB = new MySqlCommand(query, connection); //создание БД connection.Open(); cmdAddDB.ExecuteNonQuery(); connection.Close(); MessageBox.Show("Запись добавлена"); } catch (Exception exc) { MessageBox.Show("НЕУДАЧА!\n" + exc.ToString()); } refreshData(); } } else if (dtGrid.SelectedItem != null) { DataRowView row = dtGrid.SelectedItem as DataRowView; Trade trade = new Trade(row); string query; trade.setDataBaseParams(dBconnection.DB, dBconnection.Table); query = trade.AddQuery(); try { MySqlConnection connection = new MySqlConnection(dBconnection.makeConnectionString()); MySqlCommand cmdAddDB = new MySqlCommand(query, connection); //создание БД connection.Open(); cmdAddDB.ExecuteNonQuery(); connection.Close(); MessageBox.Show("Запись добавлена"); } catch (Exception exc) { MessageBox.Show("НЕУДАЧА!\n" + exc.ToString()); } refreshData(); } }
private void EditMenuItem_Click(object sender, RoutedEventArgs e) { DataRowView row = dtGrid.SelectedItem as DataRowView; if (row == null) { MessageBox.Show("Ошибка!\nНе выбрана запись! Выберите запись в таблице и повторите попытку.", "Ошибка"); return; } RowAddEditWindow win = new RowAddEditWindow("Редактирование записи", row); win.Owner = this; if (win.ShowDialog() == true) { string query; win.trade.setDataBaseParams(dBconnection.DB, dBconnection.Table); query = win.trade.EditQuery(); try { MySqlConnection connection = new MySqlConnection(dBconnection.makeConnectionString()); MySqlCommand cmdAddDB = new MySqlCommand(query, connection); //создание БД connection.Open(); cmdAddDB.ExecuteNonQuery(); connection.Close(); MessageBox.Show("Запись отредактирована", "ОК"); } catch (Exception exc) { MessageBox.Show("НЕУДАЧА!\n" + exc.ToString()); } refreshData(); } }