void Button1Click(object sender, EventArgs e) { ReservationDAO medoc = new ReservationDAO(); Reservation me = new Reservation(textBox1.Text, textBox2.Text, textBox3.Text, textBox4.Text, Convert.ToDateTime(dateTimePicker1.Text), comboBox1.Text, textBox7.Text, comboBox2.Text, textBox6.Text, textBox8.Text); medoc.insert(me); }
void Button11Click(object sender, EventArgs e) { ReservationDAO vol = new ReservationDAO(); SousTraitance[] volavo = new SousTraitance[100]; try{ volavo = vol.benefice(); listBox1.Items.Clear(); listBox2.Items.Clear(); listBox3.Items.Clear(); listBox4.Items.Clear(); listBox5.Items.Clear(); listBox6.Items.Clear(); for (int i = 0; i < volavo.Length; i++) { listBox1.Items.Add(volavo[i].getavion().ToString("#,##0") + " €"); listBox2.Items.Add(volavo[i].getsalaire().ToString("#,##0") + " €"); listBox3.Items.Add(volavo[i].getconsommation().ToString("#,##0") + " €"); listBox4.Items.Add(volavo[i].getreservation().ToString("#,##0") + " €"); listBox5.Items.Add(volavo[i].getsousTraitance().ToString("#,##0") + " €"); listBox6.Items.Add(volavo[i].getbenefice().ToString("#,##0") + " €"); } }catch (Exception ex) { } }
/**/ void Button3Click(object sender, EventArgs e) { ReservationDAO av = new ReservationDAO(); Reservation[] avion = new Reservation[100]; try{ avion = av.findReserv(); //MessageBox.Show("Affichage reussit 2"); this.dataGridView5.Rows.Clear(); for (int i = 0; i < avion.Length; i++) { this.dataGridView5.Rows.Add(avion[i].getPassager().ToString(), avion[i].getdestination().ToString(), avion[i].getclasse().ToString(), avion[i].getvol().ToString(), avion[i].getvolretour().ToString(), avion[i].gettype().ToString(), avion[i].getprix().ToString("#,##0") + " €"); } }catch (Exception ex) { } } void Button4Click(object sender, EventArgs e) { VolDao av = new VolDao(); Vol[] avion = new Vol[100]; //Avion[]avion1 = new Avion[100]; try{ avion = av.findPlaceLibre(); this.dataGridView3.Rows.Clear(); for (int i = 0; i < avion.Length; i++) { this.dataGridView3.Rows.Add(avion[i].getdestination().ToString(), avion[i].getavion().ToString(), (avion[i].getplaceTotal()).ToString()); } }catch (Exception ex) { } } void Button5Click(object sender, EventArgs e) { Form1 f = new Form1(); f.Show(); } void Button6Click(object sender, EventArgs e) { VolDao vol = new VolDao(); Vol[] volavo = new Vol[100]; try{ volavo = vol.AirFrance(); this.dataGridView4.Rows.Clear(); for (int i = 0; i < volavo.Length; i++) { this.dataGridView4.Rows.Add(volavo[i].getnom().ToString(), volavo[i].getcompagnie().ToString(), volavo[i].getdepart().ToString(), volavo[i].getdestination().ToString(), volavo[i].getheureDepart().ToString(), volavo[i].getheureArrivee().ToString(), volavo[i].getprix().ToString("#,##0") + " €"); } }catch (Exception ex) { } } void Button7Click(object sender, EventArgs e) { ReservationDAO av = new ReservationDAO(); Reservation[] avion = new Reservation[100]; try{ avion = av.volCompose(); this.dataGridView6.Rows.Clear(); for (int i = 0; i < avion.Length; i++) { this.dataGridView6.Rows.Add(avion[i].getvol1().ToString(), avion[i].getvol2().ToString(), avion[i].getPassager().ToString(), avion[i].getavion1().ToString(), avion[i].getavion2().ToString(), avion[i].getclasse().ToString(), avion[i].getdepart().ToString(), avion[i].getescale().ToString(), avion[i].getdestination().ToString(), avion[i].getprix().ToString("#,##0") + " €"); } }catch (Exception ex) { } } /* */ void Button8Click(object sender, EventArgs e) { ReservationDAO av = new ReservationDAO(); Reservation[] avion = new Reservation[100]; try{ avion = av.volComposeII(); this.dataGridView8.Rows.Clear(); for (int i = 0; i < avion.Length; i++) { this.dataGridView8.Rows.Add(avion[i].getPassager().ToString(), avion[i].getavion().ToString(), avion[i].getclasse().ToString(), avion[i].getdepart().ToString(), avion[i].getdestination().ToString(), avion[i].getprix().ToString("#,##0") + " €"); } }catch (Exception ex) { } }
void Button9Click(object sender, EventArgs e) { ReservationDAO vol = new ReservationDAO(); SousTraitance[] volavo = new SousTraitance[100]; try{ /*DateTime dt1 = DateTime.Parse(textBox9.Text); * String dd = String.Format("{0}/{1}/{2} ",dt1.Year,dt1.Month,dt1.Day); * DateTime dt2 = DateTime.Parse(textBox10.Text); * String dd2 = String.Format("{0}/{1}/{2} ",dt2.Year,dt2.Month,dt2.Day); * //MessageBox.Show(dd.ToString());*/ volavo = vol.sousTraitance(); this.dataGridView7.Rows.Clear(); for (int i = 0; i < volavo.Length; i++) { this.dataGridView7.Rows.Add(volavo[i].getcompagnie().ToString(), volavo[i].getclasse().ToString(), volavo[i].getnombre().ToString(), volavo[i].getmontantDu().ToString("#,##0") + " €", volavo[i].getmontantVente().ToString("#,##0") + " €", volavo[i].gettypee().ToString()); //MessageBox.Show(volavo[i].getcompagnie().ToString()); } }catch (Exception ex) { } }