public static bool existQuart(QuartEmploye quart)
{
QuartEmploye qe = null;
if (ConnexionBD.Instance().EstConnecte())
{
// Si oui, on execute la requête que l'on veut effectuer
// SqlDR (MySqlDataReader) emmagasine une liste des citoyens de la BD
ConnexionBD.Instance().ExecuterRequete(
"SELECT date dt, dep.nom nmDep, shift.periode typeQ " +
"FROM quarts qe " +
"INNER JOIN periodesjournee shift on shift.idPeriodeJournee = qe.idPeriodeJournee " +
"INNER JOIN departements dep on dep.idDepartement = qe.idDepartement " +
"WHERE qe.date = '" + quart.Date.ToShortDateString() + "' && shift.periode = '" + quart.TypeDeQuart + "' && dep.nom = '" + quart.DepartementAssocie.Nom + "';"
, SqlDR =>
{
qe = new QuartEmploye
{
Date = SqlDR.GetDateTime("dt"),
DepartementAssocie = new Departement
{
Nom = SqlDR.GetString("nmDep")
},
TypeDeQuart = (TypeQuart)System.Enum.Parse(typeof(TypeQuart), SqlDR.GetString("typeQ"))
};
});
}
return(qe != null);
}
public static void DELETE_quartEmploye(QuartEmploye qe)
{
string requete = string.Format("DELETE FROM quartsEmployes " +
"WHERE idQuart = (SELECT idQuart FROM quarts WHERE date = '{0}' " +
"&& idDepartement = (SELECT idDepartement FROM departements WHERE nom = '{1}') " +
"&& idPeriodeJournee = (SELECT idPeriodeJournee FROM periodesjournee WHERE periode = '{2}')) " +
"&& idEmploye = {3};",
qe.Date.ToShortDateString(), qe.DepartementAssocie.Nom, qe.TypeDeQuart, qe.Employe.idEmploye);
ConnexionBD.Instance().ExecuterRequete(requete);
}
public static void AjouterQuart(string nom, Grid gridHoraireParam, QuartEmploye quart)
{
foreach (UIElement item in gridHoraireParam.Children)
{
if (item is Border && (item as Border).Name == nom)
{
((item as Border).Child as Label).Content = quart.DepartementAssocie.Nom;
((item as Border).Child as Label).Visibility = Visibility.Visible;
(item as Border).Background = Brushes.DodgerBlue;
}
}
}
