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