private void ConfimAddAirplane_Click(object sender, RoutedEventArgs e)
{
if (AddAirplaneID.Text != "" && AddAirplaneName.Text != "" && EconomClass.Text != "" && BusinessClass.Text != "" && FirstClass.Text != "")
{
try
{
string connectionString = ConfigurationManager.ConnectionStrings["MainConnection"].ConnectionString;
string query = $"INSERT INTO Airplane (Id,Model,Econom,Business,First) " +
$"VALUES ('{AddAirplaneID.Text}', '{AddAirplaneName.Text}', '{EconomClass.Text}', '{BusinessClass.Text}', '{FirstClass.Text}');";
using (SqlConnection connection = new SqlConnection(connectionString))
{
connection.Open();
SqlCommand command = new SqlCommand(query, connection);
command.ExecuteNonQuery();
connection.Close();
}
AddAirplaneID.Clear();
AddAirplaneName.Clear();
EconomClass.Clear();
BusinessClass.Clear();
FirstClass.Clear();
}
catch (Exception ee)
{
MessageBox.Show(ee.Message);
}
}
else
{
MessageBox.Show("Something wrong");
}
}
private void ConfimAddAirplane_Click(object sender, RoutedEventArgs e)
{
if (AddAirplaneID.Text != "" && AddAirplaneName.Text != "" && EconomClass.Text != "" && BusinessClass.Text != "" && FirstClass.Text != "")
{
try
{
string connectionString = @"Data Source=(localdb)\MSSQLLocalDB;Initial Catalog=testdb;Integrated Security=True";
string query = $"INSERT INTO Airplane (Id,Model,Econom,Business,First) VALUES ('{AddAirplaneID.Text}', '{AddAirplaneName.Text}', '{EconomClass.Text}', '{BusinessClass.Text}', '{FirstClass.Text}');";
using (SqlConnection connection = new SqlConnection(connectionString))
{
connection.Open();
SqlCommand command = new SqlCommand(query, connection);
command.ExecuteNonQuery();
connection.Close();
}
AddAirplaneID.Clear();
AddAirplaneName.Clear();
EconomClass.Clear();
BusinessClass.Clear();
FirstClass.Clear();
}
catch (Exception ee)
{
MessageBox.Show(ee.Message);
}
}
else
{
MessageBox.Show("Something wrong");
}
}
