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; }