private void FormHospitalisation_Load(object sender, EventArgs e)
{
mdl.Bind("SELECT * FROM consultation", medecinDataSet.consultation);
mdl.Bind(dataGridView1, bindingNavigator1, medecinDataSet.hospitalisation, hospitalisationBindingSource, "SELECT * FROM hospitalisation");
Utilitaire.chargerToolStripComboListe(hospitalisationBindingSource, medecinDataSet.hospitalisation, toolStripComboBox1, 1);
Utilitaire.desactiverColonnes_All(dataGridView1);
}
private void FormPatient_Load(object sender, EventArgs e)
{
Tools.Connect();
mdl.Bind(dataGridView1, bindingNavigator1, medecinDataSet.patient, patientBindingSource, "SELECT * FROM patient");
Utilitaire.chargerToolStripComboListe(patientBindingSource, medecinDataSet.patient, toolStripComboBox1, 7);
Utilitaire.desactiverColonnes_All(dataGridView1);
}
private void FormPersonnels_Load(object sender, EventArgs e)
{
mdl.Bind("select * from service", paramDataSet.service);
mdl.Bind("select * from specialite", paramDataSet.specialite);
Utilitaire.chargerToolStripComboListe(specialiteBindingSource, paramDataSet.specialite, toolStripComboBox1, 1);
mdl.Bind(dataGridView1, bindingNavigator1, paramDataSet.Personnel, personnelBindingSource, "select * from personnel");
Utilitaire.desactiverColonnes_All(dataGridView1);
}
private void FormSalle_Load(object sender, EventArgs e)
{
mdl.Bind("select * from service", paramDataSet.service);
mdl.Bind("select * from typedesalle", paramDataSet.typedesalle);
Utilitaire.chargerToolStripComboListe(serviceBindingSource, paramDataSet.service, toolStripComboBox1, 2);
mdl.Bind(dataGridView1, bindingNavigator1, paramDataSet.Salle, salleBindingSource, "select * from salle");
Utilitaire.desactiverColonnes_All(dataGridView1);
}
public override void Refresh()
{
mdl.Bind(dataGridView1, bindingNavigator1, medecinDataSet.patient, patientBindingSource, "SELECT * FROM patient");
toolStripComboBox1.Text = string.Empty;
toolStripComboBox1.Items.Clear();
Utilitaire.chargerToolStripComboListe(patientBindingSource, medecinDataSet.patient, toolStripComboBox1, 7);
Utilitaire.desactiverColonnes_All(dataGridView1);
}
private void FormConsultation_Load(object sender, EventArgs e)
{
mdl.Bind("SELECT * FROM pathologie", medecinDataSet.pathologie);
mdl.Bind("SELECT * FROM personnel", medecinDataSet.personnel);
mdl.Bind("SELECT * FROM patient", medecinDataSet.patient);
mdl.Bind(dataGridView1, bindingNavigator1, medecinDataSet.consultation, consultationBindingSource, "SELECT * FROM consultation");
Utilitaire.chargerToolStripComboListe(consultationBindingSource, medecinDataSet.consultation, toolStripComboBox1, 4);
Utilitaire.desactiverColonnes_All(dataGridView1);
}
public override void Refresh()
{
medecinDataSet.consultation.Clear();
medecinDataSet.hospitalisation.Clear();
mdl.Bind("SELECT * FROM consultation", medecinDataSet.consultation);
mdl.Bind(dataGridView1, bindingNavigator1, medecinDataSet.hospitalisation, hospitalisationBindingSource, "SELECT * FROM hospitalisation");
toolStripComboBox1.Text = string.Empty;
toolStripComboBox1.Items.Clear();
Utilitaire.chargerToolStripComboListe(hospitalisationBindingSource, medecinDataSet.hospitalisation, toolStripComboBox1, 1);
Utilitaire.desactiverColonnes_All(dataGridView1);
}
public override void Refresh()
{
medecinDataSet.pathologie.Clear();
medecinDataSet.patient.Clear();
medecinDataSet.personnel.Clear();
medecinDataSet.consultation.Clear();
mdl.Bind("SELECT * FROM pathologie", medecinDataSet.pathologie);
mdl.Bind("SELECT * FROM personnel", medecinDataSet.personnel);
mdl.Bind("SELECT * FROM patient", medecinDataSet.patient);
mdl.Bind(dataGridView1, bindingNavigator1, medecinDataSet.consultation, consultationBindingSource, "SELECT * FROM consultation");
toolStripComboBox1.Text = string.Empty;
toolStripComboBox1.Items.Clear();
Utilitaire.chargerToolStripComboListe(consultationBindingSource, medecinDataSet.consultation, toolStripComboBox1, 4);
Utilitaire.desactiverColonnes_All(dataGridView1);
}
private void Form2_Load(object sender, EventArgs e)
{
// Tools.Connect();
model.Bind("select * from patient", test.patient);
model.Bind("select * from personnel", test.personnel);
dataGridView1.RowCount = 10;
Utilitaire.chargerToolStripComboListe(medecinSource1, test.personnel, toolStripComboBox2, 5);
MessageBoxButtons button = MessageBoxButtons.YesNoCancel;
MessageBoxIcon icon = MessageBoxIcon.Warning;
// MessageBox.Show(dateDebut.DayOfWeek+"", "Tester", button, icon);
gererDate(dateDebut.DayOfWeek + "");
toolStripLabel3.Text = dateDebut.ToString("dd/MM/yyyy");
toolStripLabel4.Text = dateFin.ToString("dd/MM/yyyy");
}