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) {
}
}
