public static void InsererMedecin(Medecin medecin)
{
DbCommand dbc = GetConnexion().CreateCommand();
dbc.CommandText = "INSERT INTO medecin(nom,prenom, adresse, tel, idSpecialite, departement) VALUES ( "
+ "'" + medecin.GetNom() + "',"
+ "'" + medecin.GetPrenom() + "',"
+ "'" + medecin.GetAdresse() + "',"
+ "'" + medecin.GetTel() + "',"
+ "'" + medecin.GetSpecialite().GetId() + "',"
+ "'" + medecin.GetDepartement() + "'"
+ " )";
MessageBox.Show(dbc.CommandText);
dbc.ExecuteNonQuery();
}
private void listMedecins_SelectedIndexChanged(object sender, EventArgs e)
{
// récupération de l'indice du médicament sélectionné
int indexMed = this.listMedecins.SelectedIndex;
// récupération du médicament dans la classe manager
Medecin med = Manager.GetMedecin(indexMed);
// mise à jour des champs de texte
this.txtId.Text = med.GetId();
this.txtNom.Text = med.GetNom();
this.txtPrenom.Text = med.GetPrenom();
this.txtAdresse.Text = med.GetAdresse();
this.txtTel.Text = med.GetTel();
this.txtSpecialite.Text = Manager.ChargerSpecialiteDuMedecin(med).GetSpecialite();
this.txtDepartement.Text = med.GetDepartement().ToString();
}
