public frmDernierRapportMedecin(gsbrapportsEntities mesDonneesEF)
{
InitializeComponent();
//Chargement des données
this.mesDonneesEF = mesDonneesEF;
this.bdgSourceRapport.DataSource = this.mesDonneesEF.rapports;
this.bdgSourceMedecin.DataSource = this.mesDonneesEF.medecins;
}
public FrmAjouterMedecin(gsbrapportsEntities mesDonneesEF)
{
InitializeComponent();
for (int i = 0; i <= 9; i++)
{
this.cmbDep.Items.Add(i);
}
this.mesDonneesEF = mesDonneesEF;
this.bdgSourceMedecin.DataSource = mesDonneesEF.medecins;
this.txtId.Text = this.getNumMed().ToString();
}
public frmGererMedecin(gsbrapportsEntities mesDonneesEF)
{
InitializeComponent();
//Chargement des données
this.mesDonneesEF = mesDonneesEF;
this.bdgSourceMedecin.DataSource = this.mesDonneesEF.medecins;
//var lesDepartements = (from medecins in mesDonneesEF.medecins
//orderby medecins.departement ascending
//select medecins.departement).Distinct();
//foreach (var unDepartement in lesDepartements)
//{
//this.cmbDepartement.Items.Add(unDepartement);
//}
}
public FrmGerer(gsbrapportsEntities mesDonneesEF)
{
InitializeComponent();
this.mesDonneesEF = mesDonneesEF;
this.bdgRapports.DataSource = mesDonneesEF.medecins;
var query = (from c in mesDonneesEF.medecins
orderby c.nom
select c.nom).Distinct();
cmbNom.DataSource = query;
var query2 = (from c in mesDonneesEF.medecins
orderby c.departement
select c.departement).Distinct();
cmbDept.DataSource = query2;
}
public FrmModifierMedecin(gsbrapportsEntities mesDonneesEF, string nom, int dept)
{
InitializeComponent();
for (int i = 0; i <= 9; i++)
{
this.cmbDep.Items.Add(i);
}
this.mesDonneesEF = mesDonneesEF;
this.nom = nom;
this.dept = dept;
var result = (from c in mesDonneesEF.medecins
where c.nom == nom && c.departement == dept
select c).First();
txtId.Text = result.id.ToString();
txtNom.Text = result.nom;
txtPrenom.Text = result.prenom;
txtAdresse.Text = result.adresse;
txtTel.Text = result.tel;
txtSpe.Text = result.specialiteComplementaire;
cmbDep.Text = result.departement.ToString();
//bdgModif.DataSource = query;
/*this.id = id;
* this.nom = nom;
* this.prenom = prenom;
* this.adresse = adresse;
* this.tel = tel;
* this.specialitéComplementaire = specialitéComplementaire;
* this.dept = dept;
* bdgModif.DataSource = mesDonneesEF.medecins;
* txtId.Text = Convert.ToString(id);
* txtNom.Text = nom;
* txtPrenom.Text = prenom;
* txtAdresse.Text = adresse;
* txtTel.Text = Convert.ToString(tel);
* txtSpe.Text = Convert.ToString(specialitéComplementaire);
* cmbDep.Text = Convert.ToString(dept);*/
}
public Form1()
{
this.InitializeComponent();
this.mesDonneesEF = new gsbrapportsEntities();
}
public FrmRapportsMedecin(gsbrapportsEntities mesDonneesEF)
{
InitializeComponent();
this.mesDonneesEF = mesDonneesEF;
this.bdgRapportMed.DataSource = mesDonneesEF.medecins;
}
