public Reservation(int idR, Vehicule IdV, Employe IdE, DateTime dtResa, TimeSpan hDbt, TimeSpan hFin)
{
this.idResa = idR;
this.unVehicule = IdV;
this.unEmploye = IdE;
this.dateResa = dtResa;
this.heureDebutResa = hDbt;
this.heureFinResa = hFin;
}
/// <summary>
/// Fonction qui verifie la présence ou non d'une réservation recue en paramètre
/// </summary>
/// <param name="unV">Objet Vehicule</param>
/// <param name="unE">Objet Employe</param>
/// <param name="dtResa">date de réservation</param>
/// <param name="hdbt">heure de debut</param>
/// <param name="hfin">heure de fin</param>
/// <returns>true/false</returns>
public bool etatReservation(Vehicule unV, Employe unE, DateTime dtResa, TimeSpan hdbt, TimeSpan hfin)
{
String recup = "";
bool possible = true;
String DateModif = dtResa.ToString("yyyy-MM-dd");
try
{
this.connection.Open();
MySqlCommand maReq = this.connection.CreateCommand();
maReq.CommandText = "SELECT COUNT(*) " +
"FROM `reservation` " +
"WHERE idEmploye=@idEmp " +
"AND idVehicule=@idVeh " +
"AND dateReservation=@dtResa " +
"AND heureDebutReservation=@heuredbt " +
"AND HeureFinReservation=@heurefin";
maReq.Parameters.AddWithValue("@idEmp", unE.getId());
maReq.Parameters.AddWithValue("@idVeh", unV.getId());
maReq.Parameters.AddWithValue("@dtResa", DateModif);
maReq.Parameters.AddWithValue("@heuredbt", hdbt);
maReq.Parameters.AddWithValue("@heurefin", hfin);
maReq.ExecuteNonQuery();
Console.WriteLine(maReq);
MySqlDataReader reader = maReq.ExecuteReader();
while (reader.Read())
{
recup = reader[0].ToString();
Console.WriteLine(reader[0]);
if (recup != "0")
{
possible = false;
}
}
this.connection.Close();
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
return(possible);
}
public void deleteVehicule(Vehicule unV)
{
try
{
this.connection.Open();
MySqlCommand maReq = this.connection.CreateCommand();
maReq.CommandText = "DELETE FROM employes " +
"WHERE nom=@nomEmp " +
"AND prenom=@prenomEmp " +
"AND dateNaissance=@dtNaiss";
maReq.Parameters.AddWithValue("@nomEmp", unV.getImmat());
maReq.Parameters.AddWithValue("@prenomEmp", unV.getDateMEC());
maReq.ExecuteNonQuery();
this.connection.Close();
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
}
public void setIdVehicule(Vehicule idV)
{
this.unVehicule = idV;
}
