private void panelEnregistrer_Click_1(object sender, EventArgs e)
        {
            bool res = ExistErreur();

            Entities.Doctorant Doct = new Entities.Doctorant();
            //Entitée.DossierAffectation DA = new Entitée.DossierAffectation();

            DataTable dt1 = new DataTable();

            if (res == true)
            {
                AfficherErreur();
            }
            else
            {
                Doct = GetDoctorantFromInterface();
                // DA = GetDossierFromInterface();


                //try
                //{
                DAL.DALDoctorant D = new DAL.DALDoctorant();
                D.InsertDoctorant(Doct);
                dt1 = D.SelectIdByCIN(Doct.CIN_Passeport);
                int IdDoct = int.Parse(dt1.Rows[0][0].ToString());

                MessageBox.Show("Opération d'ajout bien éffectuée");
                this.Close();
            }
        }
        //void BindEnseignantToInterface(Entities.Doctorant Doct)
        //{
        //    txtCinFr.Text = Ens.CIN;
        //    txtRibFr.Text = Ens.RIB;
        //    txtNomFr.Text = Ens.NomFr;
        //    txtNomAr.Text = Ens.NomAr;
        //    txtNomFr.Text = Ens.PrenomFr;
        //    txtNomPrenomPereFr.Text = Ens.NomPrenomPereFr;
        //    txtNomPrenomPereAr.Text = Ens.NomPrenomPereAr;
        //    txtNomPrenomMereFr.Text = Ens.NomPrenomMereFr;
        //    txtNomPrenomMereAr.Text = Ens.NomPrenomMereAr;
        //    txtPrenomAr.Text = Ens.PrenomAr;
        //    txtAliasFr.Text = Ens.Alias;
        //    cmbSexeFr.Text = Ens.Sexe;
        //    DateTimePickerDateNaissance.Value = Ens.DateNaissance;
        //    txtLieuNaissanceFr.Text = Ens.LieuNaissanceFr;
        //    txtLieuNaissanceAr.Text = Ens.LieuNaissanceAr;
        //    txtNationnaliteFr.Text = Ens.NationnaliteFr;
        //    txtNationnaliteAr.Text = Ens.NationnaliteAr;
        //    cmbCivilite.Text = Ens.Civilite;
        //    txtNbEnfant.Text = "" + Ens.NbEnfant;
        //    txtTel1.Text = Ens.Telephone1.ToString();
        //    txtTel2.Text = Ens.Telephone2.ToString();
        //    txtMailFr.Text = Ens.EMail;
        //    txtAdresseFr.Text = Ens.AdresseFr;
        //    txtAdresseAr.Text = Ens.AdresseAr;
        //    cmbVilleFr.Text = Ens.VilleFr;
        //    cmbVilleAr.Text = Ens.VilleAr;
        //    txtCodePostaleFr.Text = Ens.CodePostale.ToString();
        //}

        Entities.Doctorant GetDoctorantFromInterface()
        {
            Entities.Doctorant Doct = new Entities.Doctorant();


            Doct.CIN_Passeport   = txtCin.Text;
            Doct.NumInscription  = txtNumInsc.Text;
            Doct.NomFr           = txtNomFr.Text;
            Doct.NomAr           = txtNomAr.Text;
            Doct.PrenomFr        = txtPrenomFr.Text;
            Doct.PrenomAr        = txtPrenomAr.Text;
            Doct.NomJeuneFilleFr = txtNomJeuFilleFr.Text;
            Doct.NomJeuneFilleAr = txtNomJeuFilleAr.Text;
            Doct.Sexe            = cmbxSexe.Text;
            Doct.DateNaissance   = (DateTime)DateTimePickerDateNaissance.Value;
            Doct.LieuNaissance   = txtLieuNaiss.Text;
            Doct.Nationalite     = cmbxNationalite.Text;
            Doct.PaysOrigine     = cmbxPaysOrig.Text;
            Doct.Civilite        = cmbxCivilite.Text;
            Doct.Profession      = txtProfession.Text;
            Doct.Employeur       = txtEmployeur.Text;
            Doct.Email           = txtMail.Text;
            try { Doct.Telephone = int.Parse(txtTel.Text); }
            catch { Doct.Telephone = 0; }
            try { Doct.CodePostal = int.Parse(txtCodePost.Text); }
            catch { Doct.CodePostal = 0; }
            Doct.Email          = txtMail.Text;
            Doct.Gouvernorat    = txtGouvernat.Text;
            Doct.Ville          = txtVille.Text;
            Doct.Adresse        = txtAdresse.Text;
            Doct.DernierDiplome = cmbxDerDiplome.Text;
            Doct.LieuObtention  = txtLieuObtention.Text;
            Doct.DateObtention  = (DateTime)dateTimePickerDateObt.Value;
            Doct.EcoleDoctorale = cmbxEcoleDoctoral.Text;
            Doct.Specialite     = cmbxSpecialite.Text;
            Doct.Sujet          = txtSujet.Text;

            //byte[] img = null;
            //FileStream fs = new FileStream(chemain, FileMode.Open);
            //BinaryReader br = new BinaryReader(fs);
            //img = br.ReadBytes((int)fs.Length);
            //fs.Close();
            //Doct.Photo = img;
            MemoryStream stream = new MemoryStream();

            pictureBox1.Image.Save(stream, System.Drawing.Imaging.ImageFormat.Jpeg);
            byte[] img = stream.ToArray();
            Doct.Photo                  = img;
            Doct.DateDepot              = new DateTime(2008, 12, 25);
            Doct.DateSoutenance         = new DateTime(2008, 12, 25);;
            Doct.TitreSoutenance        = "sdfsdf";
            Doct.EtatDossierInscription = "null";
            Doct.EtatThese              = "null";

            Doct.Observations = TxtObs.Text;
            return(Doct);
        }