public static void AddResultatLabo(Hospitalisation hospit, ResultatLabo resultLabo, int numEmp) { resultLabo.DateEvenement = DateTime.Now; resultLabo.EmployeImplique = DataModelEmploye.GetEmploye(numEmp); if (ConnexionBD.Instance().EstConnecte()) { string requete = string.Format("INSERT INTO evenements " + "(idHospitalisation, idEmploye, dateHeure, estNotifier) " + "VALUES (" + "(SELECT idHospitalisation FROM hospitalisations WHERE dateDebut = '{0}')," + "{1}," + "'{2}'," + "{3})", hospit.DateDebut.ToString(), numEmp, resultLabo.DateEvenement.ToString(), resultLabo.EstNotifier); ConnexionBD.Instance().ExecuterRequete(requete); requete = string.Format("INSERT INTO resultatsLabo " + "(idEvenement, lienImage, nomAnalyse) " + "VALUES (" + "(SELECT idEvenement FROM evenements WHERE dateHeure = '{0}')," + "'{1}'," + "'{2}')" , resultLabo.DateEvenement.ToString(), resultLabo.LienImage, resultLabo.NomAnalyse); ConnexionBD.Instance().ExecuterRequete(requete); ControlModel.ControlModelDossierPatientResultatsLabo.LstResultsLabo.Add(resultLabo); } }
public static void AddPrescription(Hospitalisation hospit, Prescription prescript, int numEmp) { prescript.DateEvenement = DateTime.Now; prescript.EmployeImplique = DataModelEmploye.GetEmploye(numEmp); if (ConnexionBD.Instance().EstConnecte()) { string requete = string.Format("INSERT INTO evenements " + "(idHospitalisation, idEmploye, dateHeure, estNotifier) " + "VALUES (" + "(SELECT idHospitalisation FROM hospitalisations WHERE dateDebut = '{0}')," + "{1}," + "'{2}'," + "{3})", hospit.DateDebut.ToString(), numEmp, prescript.DateEvenement.ToString(), prescript.EstNotifier); ConnexionBD.Instance().ExecuterRequete(requete); requete = string.Format("INSERT INTO Prescriptions " + "(idEvenement, produit, posologie, dateDebut, nbJour) " + "VALUES (" + "(SELECT idEvenement FROM evenements WHERE dateHeure = '{0}')," + "'{1}'," + "'{2}'," + "'{3}'," + "{4})" , prescript.DateEvenement.ToString(), prescript.Produit, prescript.Posologie, prescript.DateDebut.ToString(), prescript.NbJour); ConnexionBD.Instance().ExecuterRequete(requete); ControlModel.ControlModelDossierPatientPrescriptions.LstPrescriptions.Add(prescript); } }
public static void AddNoteInf(Hospitalisation hospit, NoteInfirmiere noteInf, int numEmp) { noteInf.DateEvenement = DateTime.Now; noteInf.EmployeImplique = DataModelEmploye.GetEmploye(numEmp); if (ConnexionBD.Instance().EstConnecte()) { string requete = string.Format("INSERT INTO evenements " + "(idHospitalisation, idEmploye, dateHeure, estNotifier) " + "VALUES (" + "(SELECT idHospitalisation FROM hospitalisations WHERE dateDebut = '{0}')," + "{1}," + "'{2}'," + "{3})", hospit.DateDebut.ToString(), numEmp, noteInf.DateEvenement.ToString(), noteInf.EstNotifier); ConnexionBD.Instance().ExecuterRequete(requete); requete = string.Format("INSERT INTO NotesInfirmiere " + "(idEvenement, note) " + "VALUES (" + "(SELECT idEvenement FROM evenements WHERE dateHeure = '{0}')," + "'{1}')" , noteInf.DateEvenement.ToString(), noteInf.NotesInf); ConnexionBD.Instance().ExecuterRequete(requete); ControlModel.ControlModelDossierPatientNotesInf.LstNotesInf.Add(noteInf); } }
public static void Delete(Usager usager) { if (ConnexionBD.Instance().EstConnecte()) { ConnexionBD.Instance().ExecuterRequete( string.Format("DELETE FROM Usagers WHERE nomUtilisateur = '{0}'", usager.NomUtilisateur)); DataModelEmploye.Delete(usager as Employe); } }
public static void AddUsager(Usager usager, string motDePasseHash) { EtatAvecMessage retour = new EtatAvecMessage(); if (ConnexionBD.Instance().EstConnecte()) { string requete = string.Format("INSERT INTO Usagers " + "(idRole, idEmploye, nomUtilisateur, motDePasse) " + "VALUES (" + "(SELECT idEmploye FROM Employes WHERE numEmploye = '{0}'," + "(SELECT idRole FROM Roles WHERE role = '{1}'," + "'{2}'," + "'{3}'" , usager.NumEmploye, usager.RoleUsager.ToString(), usager.NomUtilisateur, motDePasseHash); DataModelEmploye.AddEmploye(usager); ConnexionBD.Instance().ExecuterRequete(requete); // TODO : Recevoir code erreur BD dans cas d'erreur (duplicata) } }
public static void Post(Usager usager, string motDePasseEncrypte) { if (ConnexionBD.Instance().EstConnecte()) { DataModelEmploye.Post(usager as Employe); ConnexionBD.Instance().ExecuterRequete( string.Format( "INSERT INTO Usagers (nomUtilisateur, motDePasse, idEmploye, idRole) " + "VALUES ( " + " '{0}', " + " '{1}', " + " (SELECT idEmploye FROM Employes WHERE NumEmploye = '{2}'), " + " (SELECT idRole FROM Roles WHERE role = '{3}') " + ")", usager.NomUtilisateur, motDePasseEncrypte, usager.NumEmploye, usager.RoleUsager ) ); } }
public static Departement GetDepartementInfChef(Employe employe) { Departement departement = new Departement(); int idEmployeRecherche = DataModelEmploye.GetidEmploye(employe); // On vérifie si la BD est connecté if (ConnexionBD.Instance().EstConnecte()) { ConnexionBD.Instance().ExecuterRequete( "SELECT d.idDepartement _id, d.nom depNom, d.abreviation depAbrev " + "FROM departements d " + "WHERE d.idEmploye = " + idEmployeRecherche + " " , SqlDR => { departement._identifiant = int.Parse(SqlDR.GetString("_id")); departement.Nom = SqlDR.GetString("depNom"); departement.Abreviation = SqlDR.GetString("depAbrev"); } ); } return(departement); }
public static Departement GetDepartement(string abreviation, string expand = "") { Departement departement = null; if (ConnexionBD.Instance().EstConnecte()) { int idEmployeChef = -1; ConnexionBD.Instance().ExecuterRequete( string.Format( "SELECT idDepartement _id, nom, abreviation, idEmploye " + "FROM Departements " + "WHERE abreviation = '{0}'", abreviation ), lecteur => { departement = new Departement { _identifiant = int.Parse(lecteur.GetString("_id")), Nom = lecteur.GetString("nom"), Abreviation = lecteur.GetString("abreviation") }; if (!lecteur.IsDBNull(lecteur.GetOrdinal("idEmploye"))) { idEmployeChef = int.Parse(lecteur.GetString("idEmploye")); } } ); if (departement != null) { departement.PersonnelMedicalEnChef = (idEmployeChef >= 0 ? null : DataModelEmploye.GetEmploye(idEmployeChef)); if (expand.Contains("chambres")) { StringBuilder expandPropagation = new StringBuilder(); if (expand.Contains("lits")) { expandPropagation.Append("lits "); } if (expand.Contains("equipements")) { expandPropagation.Append("equipements "); } departement.Chambres = new ObservableCollection <Chambre>( DataModelChambre.GetChambres( departement._identifiant.ToString(), expandPropagation.ToString() ) ); } } } return(departement); }
public static List <Departement> GetDepartements() { List <Departement> lstDepartement = new List <Departement>(); // On vérifie si la BD est connecté if (ConnexionBD.Instance().EstConnecte()) { List <int> idEmployesChefs = new List <int>(); // 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 * " + "FROM departements" , SqlDR => { lstDepartement.Add(new Departement { _identifiant = int.Parse(SqlDR.GetString("idDepartement")), Nom = SqlDR.GetString("nom"), Abreviation = SqlDR.GetString("abreviation") }); idEmployesChefs.Add(SqlDR.IsDBNull(SqlDR.GetOrdinal("idEmploye")) ? -1 : int.Parse(SqlDR.GetString("idEmploye"))); } ); for (int i = 0; i < lstDepartement.Count; i++) { lstDepartement[i].PersonnelMedicalEnChef = (idEmployesChefs[i] == -1 ? null : DataModelEmploye.GetEmploye(idEmployesChefs[i])); } for (int i = 0; i < lstDepartement.Count; i++) { lstDepartement[i].Chambres = new ObservableCollection <Chambre>(DataModelChambre.GetChambres(lstDepartement[i]._identifiant.ToString(), "lits, equipements")); } } return(lstDepartement); }