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) { } }
public SousTraitance[] sousTraitance() { SousTraitance[] valiny = new SousTraitance[100]; Connexion con = new Connexion(); SqlConnection conn = con.ConnectToSql(); conn.Open(); /*DateTime dt1 = Convert.ToDateTime(date1); * DateTime dt2 = Convert.ToDateTime(date2); * String dd1 = String.Format("{0}/{1}/{2} ",dt1.Year,dt1.Month,dt1.Day); * String dd2 = String.Format("{0}/{1}/{2} ",dt2.Year,dt2.Month,dt2.Day);*/ SqlCommand cmd; SqlDataReader reader; string requete = ("select nbre.compagnie,nbre.classe,nbre.nombre,nbre.type,SUM(((c.prixBillet+cl.tarif)*t.tarif)-t.remise)*nbre.nombre as montantDu,SUM((((c.prixBillet+cl.tarif)*t.tarif)-t.remise)+(c.prixBillet+((c.prixBillet*5)/100)))*nbre.nombre as montantVente from nombreBillet nbre,compagnie c, classe cl, types t where cl.nom = nbre.classe and t.nom = nbre.type group by nbre.compagnie,nbre.classe,nbre.nombre,nbre.type "); cmd = new SqlCommand(requete, conn); reader = cmd.ExecuteReader(); for (int i = 0; reader.Read(); i++) { String compagnie = reader["compagnie"].ToString(); String classe = reader["classe"].ToString(); int nombre = int.Parse(reader["nombre"].ToString()); String type = reader["type"].ToString(); float montantDu = float.Parse(reader["montantDu"].ToString()); float montantVente = float.Parse(reader["montantVente"].ToString()); valiny[i] = new SousTraitance(compagnie, classe, nombre, type, montantDu, montantVente); } reader.Close(); cmd.Dispose(); conn.Close(); return(valiny); }
public SousTraitance[] benefice() { SousTraitance[] valiny = new SousTraitance[100]; Connexion con = new Connexion(); SqlConnection conn = con.ConnectToSql(); conn.Open(); SqlCommand cmd; SqlDataReader reader; string requete = ("select c.CarburantTotal as avion,s.salaire,s.salaire+c.CarburantTotal as depense,r.prix as reservation,sT.benefice as sousTraitance,(r.prix-(s.salaire+c.CarburantTotal))+sT.benefice as benefice from SalaireTotal s,CarbuTotal c,ReservationTotal r,TotalSousT2 sT"); cmd = new SqlCommand(requete, conn); reader = cmd.ExecuteReader(); for (int i = 0; reader.Read(); i++) { float avion = float.Parse(reader["avion"].ToString()); float salaire = float.Parse(reader["salaire"].ToString()); float consommation = float.Parse(reader["depense"].ToString()); float reservation = float.Parse(reader["reservation"].ToString()); float sousTraitance = float.Parse(reader["sousTraitance"].ToString()); float benefice = float.Parse(reader["benefice"].ToString()); valiny[i] = new SousTraitance(avion, salaire, consommation, reservation, sousTraitance, benefice); } reader.Close(); cmd.Dispose(); conn.Close(); return(valiny); }
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) { } }