private void button3_Click(object sender, EventArgs e) { string q = "INSERT INTO LOTY("; q += "data_wylotu,"; q += "czas_lotu,"; q += "lotnisko_docelowe,"; q += "lotnisko_zrodlowe,"; q += "samolot) "; q += "VALUES("; q += "'" + NFdate.Text + "',"; q += NFtime.Text + ","; q += NFdest.Text + ","; q += NFsrc.Text + ","; q += NFplane.Text + ");"; CommonQuery cq = new CommonQuery(q); if (dataBase.executeInsert(cq)) { MessageBox.Show("Lot został poprawnie dodany."); } }
private void button2_Click(object sender, EventArgs e) { string q = "INSERT INTO REZERWACJE("; q += "ID_KLIENTA,"; q += "ID_LOTU,"; q += "KLASA) "; q += "VALUES("; q += NRclient.Text + ","; q += NRflight.Text + ","; q += "'" + NRclass.SelectedItem + "');"; CommonQuery cq = new CommonQuery(q); if (dataBase.executeInsert(cq)) { MessageBox.Show("Rezerwacja została poprawnie dodana."); } }