//permet de recuperer tous les reservations d'un client à partir d'une adresseMail
public static List <Reservation> getReservationClient(string adresseMail)
{
List <Reservation> reservations = new List <Reservation>();
conn.Open();
MySqlCommand query = new MySqlCommand("select * from ladi.DSMSreservation r,ladi.DSMSpersonne p where r.idClient=p.idPersonne and r.realisee=0 and p.adresseMail=@adresseMail", conn);
query.Parameters.AddWithValue("@adresseMail", adresseMail);
using (MySqlDataReader reader = query.ExecuteReader())
{
while (reader.Read())
{
reservations.Add(new Reservation(ControleurClient.getClient(adresseMail), ControleurMoniteur.getMoniteur(reader.GetInt32(2)), ControleurVehicule.getVehicule(reader.GetInt32(3)), Outils.convertirStringToDateTime(reader.GetString(4))));
}
}
conn.Close();
Console.WriteLine("reservations");
return(reservations);
}
//permet de recuperer tous les reservations d'un véhicule à partir d'une adresseMail
public static List <Reservation> getReservationVehicule(string immatriculation)
{
List <Reservation> reservations = new List <Reservation>();
conn.Open();
MySqlCommand query = new MySqlCommand("select * from ladi.DSMSreservation r,ladi.DSMSvehicule v where r.idVehicule=v.idVehicule and r.realisee=0 and v.immatriculation=@immatriculation", conn);
query.Parameters.AddWithValue("@immatriculation", immatriculation);
using (MySqlDataReader reader = query.ExecuteReader())
{
while (reader.Read())
{
reservations.Add(new Reservation(ControleurClient.getClient(reader.GetInt32(1)), ControleurMoniteur.getMoniteur(reader.GetInt32(2)), ControleurVehicule.getVehicule(immatriculation), Outils.convertirStringToDateTime(reader.GetString(4))));
}
}
conn.Close();
Console.WriteLine("reservations");
return(reservations);
}
public FicheVoiture(string immatriculation)
{
vehicule = ControleurVehicule.getVehicule(immatriculation);
InitializeComponent();
completerFenetre();
}
