public static void Delete(Employe employe) { if (ConnexionBD.Instance().EstConnecte()) { ConnexionBD.Instance().ExecuterRequete( string.Format("DELETE FROM Employes WHERE numEmploye = '{0}'", employe.NumEmploye)); DataModelCitoyen.Delete(employe as Citoyen); } }
public static void Post(Employe employe) { if (ConnexionBD.Instance().EstConnecte()) { DataModelCitoyen.PostCitoyen(employe as Citoyen); ConnexionBD.Instance().ExecuterRequete( string.Format( "INSERT INTO Employes (numEmploye, numPermis, NAS, idCitoyen, idPoste) " + "VALUES (" + " '{0}', " + " '{1}', " + " '{2}', " + " (SELECT idCitoyen FROM Citoyens WHERE numAssuranceMaladie = '{3}'), " + " (SELECT idPoste FROM Postes WHERE nom = '{4}') " + ")", employe.NumEmploye, employe.NumPermis, employe.NAS, employe.AssMaladie, employe.Poste ) ); } }
public static List <Lit> GetLitsDepartement(Departement departement, bool expandCitoyen = false) { List <Lit> lits = new List <Lit>(); if (ConnexionBD.Instance().EstConnecte()) { ConnexionBD.Instance().ExecuterRequete( string.Format( "SELECT idLit _id, l.numero NumLit, el.nom etat, c.Nom chNom, d.Nom depNom " + "FROM Lits l " + "JOIN EtatsLits el ON l.idEtatLit = el.idEtatLit " + "JOIN Chambres c ON c.idChambre = l.idChambre " + "JOIN Departements d ON d.idDepartement = c.idDepartement " + "WHERE d.Nom = '" + departement.Nom + "' " ), lecteur => lits.Add( new Lit { _identifiant = int.Parse(lecteur.GetString("_id")), Numero = lecteur.GetString("NumLit"), EtatLit = (EtatLit)Enum.Parse(typeof(EtatLit), lecteur.GetString("etat")), Chambre = new Chambre { Numero = lecteur.GetString("chNom"), UnDepartement = new Departement { Nom = lecteur.GetString("depNom") } } } ) ); if (expandCitoyen) { lits.ForEach(lit => DataModelCitoyen.GetUnCitoyenParLit(lit)); } } return(lits); }