public static Specialite GetSpecialiteDuMedecin(Medecin med) { Specialite spe = Passerelle.GetSpeMedecin(med.Id); med.Specialite = spe; return(spe); }
public Rapport(int Id, DateTime Date, string Motif, String Bilan, Visiteur Visiteur, Medecin Medecin) { id = Id; date = Date; motif = Motif; bilan = Bilan; visiteur = Visiteur; medecin = Medecin; }
private static Medecin MapperLigneMedecin(MySqlDataReader reader) { string nom, prenom, adresse, tel, id; int departement; id = reader["id"].ToString(); nom = (string)reader["nom"]; prenom = (string)reader["prenom"]; adresse = (string)reader["adresse"]; tel = (string)reader["tel"]; departement = (int)reader["departement"]; Medecin med = new Medecin(id, nom, prenom, adresse, tel, departement); return(med); }
public static Medecin GetMedecin(string idMedecin) { Medecin medecin = null; MySqlConnection cnx = InitConnection(); if (cnx != null) { string query = "select * from medecin where id = @idMedecin"; MySqlCommand cmd = new MySqlCommand(query, cnx); cmd.Parameters.AddWithValue("@idMedecin", idMedecin); MySqlDataReader reader = cmd.ExecuteReader(); if (reader.HasRows) { while (reader.Read()) { medecin = MapperLigneMedecin(reader); } } reader.Close(); } return(medecin); }