private void SaveB_Click(object sender, EventArgs e)
{
if (checkApparatus() != null)
{
Apparatus apparatus = checkApparatus();
string queryText = "INSERT INTO `apparatus`( `Name`, `Description`, `Weight`, `Volume`, `Pressure`, `WorkTime`, `Reserve`) VALUES ('" +
apparatus.getName() + "','" +
apparatus.getDescription() + "'," +
apparatus.getWeight() + "," +
apparatus.getVolume() + "," +
apparatus.getPressure() + "," +
apparatus.getWorkTime() + "," +
apparatus.getReserve() + ");";
MySqlCommand commandDatabase = new MySqlCommand(queryText, databaseConnection);
commandDatabase.CommandTimeout = 60;
try
{
databaseConnection.Open();
commandDatabase.ExecuteNonQuery();
databaseConnection.Close();
NameBox.Text = "";
DescriptionBox.Text = "";
WeightBox.Text = "";
VolumeBox.Text = "";
TimeBox.Text = "";
ReserveBox.Text = "";
PressureBox.Text = "";
}
catch (Exception ex)
{
NameBox.Text = ex.Message;
}
}
}
