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; } } }