private void Fconge_employe_Load(object sender, EventArgs e)
{
Employe E = new Employe(FMenu.C);
E.lister();
for (int i = 0; i < E.GetConnextion().dt.Rows.Count; i++)
{
TxtMatricule.Items.Add(E.GetConnextion().dt.Rows[i][0].ToString());
}
}
private void TxtRecherchNom_KeyDown(object sender, KeyEventArgs e)
{
if (e.KeyCode == Keys.Enter)
{
E = new Employe(FMenu.C);
E.rechercher_nom(TxtRecherchNom.Text);
DGV.DataSource = E.GetConnextion().dt;
}
}
private void TxtCode_SelectedIndexChanged(object sender, EventArgs e)
{
if (TxtCode.Text != "")
{
Service s = new Service(TxtCode.Text, FMenu.C);
Employe E = new Employe(s, FMenu.C);
E.employe_service();
DGV.DataSource = E.GetConnextion().dt;
TxtNombre.Text = E.nbre_employé_service();;
}
}
private void TxtMatricule_Leave(object sender, EventArgs e)
{
if (TxtMatricule.Text != "")
{
E = new Employe(TxtMatricule.Text, FMenu.C);
if (E.existance_matricule() == false)
{
BtnAjouter.Enabled = true;
BtnSupprimer.Enabled = false;
BtnModifier.Enabled = false;
}
else
{
E.rechercher_matricule();
TxtNom.Text = E.GetConnextion().dt.Rows[0][1].ToString();
TxtPénom.Text = E.GetConnextion().dt.Rows[0][2].ToString();
TxtDateNaissance.Text = E.GetConnextion().dt.Rows[0][3].ToString();
TxtGrade.Text = E.GetConnextion().dt.Rows[0][4].ToString();
TxtEchelle.Text = E.GetConnextion().dt.Rows[0][5].ToString();
TxtCodeService.Text = E.GetConnextion().dt.Rows[0][6].ToString();
TxtCodeService.ReadOnly = true;
BtnAjouter.Enabled = false;
BtnSupprimer.Enabled = true;
BtnModifier.Enabled = true;
}
}
}
public void fill_matricule()
{
TxtMatricule.Items.Clear();
E = new Employe(FMenu.C);
E.lister();
DataTable dt = E.GetConnextion().dt;
foreach (DataRow row in dt.Rows)
{
TxtMatricule.Items.Add(row.Field <string>(0));
}
}
// ********************************************************************
// Functions
public void actualiser()
{
E = new Employe(FMenu.C);
E.lister();
DGV.DataSource = E.GetConnextion().dt;
TxtMatricule.Text = "";
TxtNom.Text = "";
TxtPénom.Text = "";
TxtDateNaissance.Text = "__/__/";
TxtGrade.Text = "";
TxtEchelle.Text = "";
TxtCodeService.Text = "";
TxtMatricule.Select();
TxtCodeService.ReadOnly = false;
msg.Text = "";
// ----------------------------------------------------------------------------
// HACK
TxtDateNaissance.Enter += new System.EventHandler(this.TxtDateNaissance_Enter);
TxtDateNaissance.Leave += new System.EventHandler(this.TxtDateNaissance_Leave);
// ----------------------------------------------------------------------------
}
private void TxtRecherchNom_TextChanged(object sender, EventArgs e)
{
E = new Employe(FMenu.C);
E.rechercher_nom(TxtRecherchNom.Text);
DGV.DataSource = E.GetConnextion().dt;
}
