Classe bi3ao chria

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using System.Data.SqlClient;
using System.Globalization;

namespace DesktopKinésie1
{
    public partial class Gestion_des_employes : MetroFramework.Forms.MetroForm
    {
        public Gestion_des_employes()
        {
            InitializeComponent();
        }
        int currentvalue;

        private void Gestion_des_employes_Load(object sender, EventArgs e)
        {
            this.WindowState = FormWindowState.Maximized;

            Employé em = new Employé();
            cb_nom.ValueMember = "Id_Employée";
            cb_nom.DisplayMember = "Nom et Prénom";
            cb_nom.DataSource = em.lister();


            dataGridViewX1.DataSource = em.lister();
        }

        public void b_ajouter_Click(object sender, EventArgs e)
        {

            string rb;
            if (rb_h.Checked)
            {
                rb = "h";
            }
            else
            {
                rb = "f";
            }
            string[] cb = cb_nom.Text.Split(' ');
            //Employé em = new Employé(0, cb[0],cb[1],tb_adresse.Text, rb, int.Parse(num_age.Value.ToString()), tb_cin.Text, tb_tele.Text, date_entre.Value, tb_grade.Text, int.Parse(num_salaire.Value.ToString()), date_sortie.Value);
            //em.Ajouter_employé();
            DateTime dd = date_entre.Value;
            DateTime df = date_sortie.Value;

            Employé em = new Employé(0, cb[0], cb[1], tb_adresse.Text, rb, int.Parse(num_age.Text), tb_cin.Text, tb_tele.Text, dd, tb_grade.Text, Double.Parse(num_salaire.Text), df);
            em.Ajouter_employé();
            MessageBox.Show("ajouter sucsse");
            foreach (Control Co in this.Controls)
            {
                if (Co.GetType() == typeof(TextBox))
                    Co.Text = "";
            }
            Gestion_des_employes_Load(sender, e);
        }

        private void b_annuler_Click(object sender, EventArgs e)
        {
            Gestion_admine ga = new Gestion_admine();
            ga.Show();
            this.Hide();
        }

        private void Gestion_des_employes_FormClosing(object sender, FormClosingEventArgs e)
        {
            DialogResult dialog = MessageBox.Show("Voulez-vous vraiment fermer le programme ?", "Quitter", MessageBoxButtons.YesNo);
            if (dialog == DialogResult.Yes)
            {
                Application.Exit();
            }
            else if (dialog == DialogResult.No)
            {
                e.Cancel = true;
            }
        }

        private void b_supprimer_Click(object sender, EventArgs e)
        {
            Employé em = new Employé();
            em.supprimer_employés(int.Parse(cb_nom.SelectedValue.ToString()));
            MessageBox.Show("supprimer sucsse");

            foreach (Control Co in this.Controls)
            {
                if (Co.GetType() == typeof(TextBox))
                    Co.Text = "";
            }
            Gestion_des_employes_Load(sender, e);
        }


        private void b_rechercher_Click_1(object sender, EventArgs e)
        {
            Employé em = new Employé();
            DataRow dn = em.Rechercher(int.Parse(cb_nom.SelectedValue.ToString()));
           tb_adresse.Text = dn[2].ToString();
           if (dn[3].ToString().Equals("H", StringComparison.OrdinalIgnoreCase))
            {
                rb_h.Checked = true;
                rb_f.Checked = false;
            }
            else
            {
                rb_f.Checked = true;
                rb_h.Checked = false;
            }

                     num_age.Value =int.Parse(dn[4].ToString());
             tb_cin.Text = dn[5].ToString();
             tb_tele.Text = dn[6].ToString();
            date_entre.Text = Convert.ToDateTime(dn[7]).ToString("yyyy-MM-dd");
            tb_grade.Text = dn[8].ToString();
            num_salaire.Value = decimal.Parse(dn[9].ToString());
            date_sortie.Text = Convert.ToDateTime(dn[10]).ToString("yyyy-MM-dd");

        }

        private void cb_nom_SelectedIndexChanged(object sender, EventArgs e)
        {
        }

        private void cb_nom_SelectionChangeCommitted(object sender, EventArgs e)
        {

            currentvalue = int.Parse(cb_nom.SelectedValue.ToString());
            Employé em = new Employé();
            DataRow dn = em.Rechercher(int.Parse(cb_nom.SelectedValue.ToString()));
            tb_adresse.Text = dn[2].ToString();
            if (dn[3].ToString().Equals("H", StringComparison.OrdinalIgnoreCase))
            {
                rb_h.Checked = true;
                rb_f.Checked = false;
            }
            else
            {
                rb_f.Checked = true;
                rb_h.Checked = false;
            }

            num_age.Value = int.Parse(dn[4].ToString());
            tb_cin.Text = dn[5].ToString();
            tb_tele.Text = dn[6].ToString();
            date_entre.Text = Convert.ToDateTime(dn[7]).ToString("yyyy-MM-dd");
            tb_grade.Text = dn[8].ToString();
            num_salaire.Value = decimal.Parse(dn[9].ToString());
            date_sortie.Text = Convert.ToDateTime(dn[10]).ToString("yyyy-MM-dd");
        }

        private void b_modifier_Click(object sender, EventArgs e)
        {
            string rb;
            if (rb_h.Checked)
            {
                rb = "h";
            }
            else
            {
                rb = "f";
            }
            string[] cb = cb_nom.Text.Split(' ');
            //MessageBox.Show(cb_nom.SelectedValue.ToString());
            //MessageBox.Show(cb[0]);
            //MessageBox.Show(cb[1]);
            //MessageBox.Show(tb_adresse.Text);
            //MessageBox.Show(rb);
            //MessageBox.Show(num_age.Value.ToString());
            //MessageBox.Show(tb_cin.Text);
            //MessageBox.Show(tb_tele.Text);
            //MessageBox.Show(date_entre.Value.ToString());
            //MessageBox.Show(tb_grade.Text);
            //MessageBox.Show(num_salaire.Value.ToString());
            //MessageBox.Show(date_sortie.Value.ToString());

            DateTime dd = date_entre.Value;
            DateTime df = date_sortie.Value;

            Employé em = new Employé(currentvalue, cb[0], cb[1], tb_adresse.Text, rb, int.Parse(num_age.Text), tb_cin.Text, tb_tele.Text, dd, tb_grade.Text, Double.Parse(num_salaire.Text), df);
            em.Modifier_employés();
        }

        private void nouveau_Click(object sender, EventArgs e)
        {
            foreach (Control Co in this.Controls)
            {
                if (Co.GetType() == typeof(TextBox))
                    Co.Text = "";

            }
            Gestion_des_employes_Load(sender, e);
        }


    }


}