//окно добавления записи в БД
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();
}
}
