Ejemplo n.º 1
0
        private void mbsearch_Click(object sender, EventArgs e)
        {
            CopieIntegral.list_ci.Clear();
            ocon = new SqlDbConnect();
            ocon.SqlQuery("select * from personne where num=@num and anneeAct=@aa");
            ocon.Cmd.Parameters.Add("num", MySql.Data.MySqlClient.MySqlDbType.VarChar).Value = tnumact.Text;
            ocon.Cmd.Parameters.Add("aa", MySql.Data.MySqlClient.MySqlDbType.VarChar).Value  = tyear.Text;
            numact = tnumact.Text;
            year   = tyear.Text;
            CopieIntegral c = new CopieIntegral();

            c.AnneeAct = year;
            c.Num      = numact;
            CopieIntegral.list_ci.Add(c);
            try
            {
                namewewanttosee.Text = ocon.QueryEx().Rows[0][2].ToString() + " " + ocon.QueryEx().Rows[0][4].ToString();
                filltext();
            }
            catch
            {
                if (MessageBox.Show("Personne n'existe pas voulez-vous l'ajouter ?", "Erreur", MessageBoxButtons.YesNo, MessageBoxIcon.Error) == DialogResult.Yes)
                {
                    AjoutActe ac = new AjoutActe();
                    ac.Show();
                }
            }
        }
Ejemplo n.º 2
0
 //search fonction we give the num and date
 public void search(string num, string date)
 {
     if (date != "" && num != "")
     {
         ocon = new SqlDbConnect();
         ocon.SqlQuery("select * from personne where num=@num and anneeAct=@annee");
         ocon.Cmd.Parameters.Add("num", MySqlDbType.VarChar).Value   = num;
         ocon.Cmd.Parameters.Add("annee", MySqlDbType.VarChar).Value = date;
     }
 }
Ejemplo n.º 3
0
 private void metroButton2_Click(object sender, EventArgs e)
 {
     Acte.list_act.Clear();
     errorProvider1.Clear();
     if (checkall() == true)
     {
         ocon = new SqlDbConnect();
         ocon.SqlQuery("select num,anneeAct,nom,nomAr,prenom,preAr,nationnalite,nationAr,lieuNaiss,lieuNaissAr,jour,mois,annee,pere,pereAr,mere,mereAr,deces,decesAr,jourAr,moisAr,anneeAr from acte1 where  num=@num and anneeAct=@anneeAct");
         ocon.Cmd.Parameters.Add("num", MySql.Data.MySqlClient.MySqlDbType.VarChar).Value      = YEAR.Text;
         ocon.Cmd.Parameters.Add("anneeAct", MySql.Data.MySqlClient.MySqlDbType.VarChar).Value = NUMACT.Text;
         //dataGridView1.DataSource = ocon.QueryEx();
         try
         {
             acte.AnneeAct     = (string)ocon.QueryEx().Rows[0][0];
             acte.Num          = (string)ocon.QueryEx().Rows[0][1];
             acte.Nom          = (string)ocon.QueryEx().Rows[0][2];
             acte.NomAr        = (string)ocon.QueryEx().Rows[0][3];
             acte.Prenom       = (string)ocon.QueryEx().Rows[0][4];
             acte.PreAr        = (string)ocon.QueryEx().Rows[0][5];
             acte.Nationnalite = (string)ocon.QueryEx().Rows[0][6];
             acte.NationAr     = (string)ocon.QueryEx().Rows[0][7];
             acte.LieuNaiss    = (string)ocon.QueryEx().Rows[0][8];
             acte.LieuNaissAr  = (string)ocon.QueryEx().Rows[0][9];
             acte.Jour         = (string)ocon.QueryEx().Rows[0][10];
             acte.Mois         = (string)ocon.QueryEx().Rows[0][11];
             acte.Annee        = (string)ocon.QueryEx().Rows[0][12];
             acte.Pere         = (string)ocon.QueryEx().Rows[0][13];
             acte.PereAr       = (string)ocon.QueryEx().Rows[0][14];
             acte.Mere         = (string)ocon.QueryEx().Rows[0][15];
             acte.MereAr       = (string)ocon.QueryEx().Rows[0][16];
             acte.Deces        = (string)ocon.QueryEx().Rows[0][17];
             acte.DecesAr      = (string)ocon.QueryEx().Rows[0][18];
             acte.JourH        = (string)ocon.QueryEx().Rows[0][19];
             acte.MoisH        = (string)ocon.QueryEx().Rows[0][20];
             acte.AnneeH       = (string)ocon.QueryEx().Rows[0][21];
             Acte.list_act.Add(acte);
             MessageBox.Show("Personne Trouvé");
             CreateActHtml();
         }
         catch (Exception)
         {
             errorProvider1.SetError(NUMACT, "هذا الشخص لا يتواجد في قاعدة البيانات المرجو إضافته");
         }
     }
 }
Ejemplo n.º 4
0
        public void DoSearch(string num, string year)
        {
            ocon = new SqlDbConnect();
            ocon.SqlQuery("select * from personne where num=@num and anneeAct=@aa");
            ocon.Cmd.Parameters.Add("num", MySql.Data.MySqlClient.MySqlDbType.VarChar).Value = num;
            ocon.Cmd.Parameters.Add("aa", MySql.Data.MySqlClient.MySqlDbType.VarChar).Value  = year;

            try
            {
                namewewanttosee.Text = ocon.QueryEx().Rows[0][2].ToString() + " " + ocon.QueryEx().Rows[0][4].ToString();
            }
            catch
            {
                if (MessageBox.Show("Personne n'existe pas voulez-vous l'ajouter ?", "Erreur", MessageBoxButtons.YesNo, MessageBoxIcon.Error) == DialogResult.Yes)
                {
                    AjoutActe ac = new AjoutActe();
                    ac.Show();
                }
            }
        }
Ejemplo n.º 5
0
        private void button1_Click(object sender, EventArgs e)
        {
            dataGridView1.DataSource = null;
            //we need to show an error if user keeps txt box empty
            //this one for the name
            ocon1 = new SqlDbConnect();
            ocon  = new SqlDbConnect();
            if (RBname.Checked && Tname.Text != "")
            {
                errorProvider1.Clear();


                //continue the aliasses for tomorrow , 25/02/2017
                ocon1.SqlQuery("select num AS `رقم العقد`,anneeAct AS `السنة`,nom AS `Nom`,nomAr AS `الاسم العائلي`,prenom AS `Prenom`,preAr AS `الاسم الشخصي`,nationnalite AS `Nationalité`,nationAr AS `الجنسية`,lieuNaiss,lieuNaissAr,jour,mois,annee,pere,pereAr,mere,mereAr,deces,decesAr,jourH,moisH,anneeH from personne WHERE nom like @nom ");
                ocon1.Cmd.Parameters.Add("nom", MySql.Data.MySqlClient.MySqlDbType.VarChar).Value = '%' + Tname.Text.ToUpper() + '%';
                dataGridView1.DataSource = ocon1.QueryEx();
            }
            else
            {
                errorProvider1.SetError(Tname, "المرجوا ملء الإسم قبل البحث");
            }


            //this one for year and number , this one is specific so we use = instead of like
            if (RBnum.Checked && Tyear.Text != "" && textBox1.Text != "")
            {
                errorProvider1.Clear();


                //dont forget to add them here as well dude ! I LOVE YOU , You from the past
                ocon.SqlQuery("select num,anneeAct,nom,nomAr,prenom,preAr,nationnalite,nationAr,lieuNaiss,lieuNaissAr,jour,mois,annee,pere,pereAr,mere,mereAr,deces,decesAr,jourH,moisH,anneeH from personne WHERE num=@num AND anneeAct=@anneeAct ");
                ocon.Cmd.Parameters.Add("num", MySql.Data.MySqlClient.MySqlDbType.VarChar).Value      = textBox1.Text;
                ocon.Cmd.Parameters.Add("anneeAct", MySql.Data.MySqlClient.MySqlDbType.VarChar).Value = Tyear.Text;
                dataGridView1.DataSource = ocon.QueryEx();
            }
            else
            {
                errorProvider1.SetError(Tyear, "المرجوا ملء الخانة قبل البحث");
                errorProvider1.SetError(textBox1, "المرجوا ملء الخانة قبل البحث");
            }
        }
Ejemplo n.º 6
0
 private void Bupdate_Click(object sender, EventArgs e)
 {
     if (checkclearall() == true)
     {
         ocon = new SqlDbConnect();
         //100 mb ram needed
         ocon.SqlQuery
             ("update personne set nom=@nom,nomAr=@nomAr,prenom=@prenom,preAr=@preAr,nationnalite=@nationnalite,nationAr=@nationAr,lieuNaiss=@lieuNaiss,lieuNaissAr=@lieuNaissAr,jour=@jour,mois=@mois,annee=@annee,pere=@pere,pereAr=@pereAr,mere=@mere,mereAr=@mereAr,deces=@deces,decesAr=@decesAr,jourH=@jourH,moisH=@moisH,anneeH=@anneeH where num=@num and anneeAct=@anneeAct");
         #region ajout_des_parametres
         ocon.Cmd.Parameters.Add("num", MySql.Data.MySqlClient.MySqlDbType.VarChar).Value           = Tnum.Text.ToUpper();
         ocon.Cmd.Parameters.Add("anneeAct", MySql.Data.MySqlClient.MySqlDbType.VarChar).Value      = Tdate.Text.ToUpper();
         ocon.Cmd.Parameters.Add("nom", MySql.Data.MySqlClient.MySqlDbType.VarChar).Value           = Tnom.Text.ToUpper();
         ocon.Cmd.Parameters.Add("nomAr", MySql.Data.MySqlClient.MySqlDbType.VarChar).Value         = TnomAr.Text;
         ocon.Cmd.Parameters.Add("prenom", MySql.Data.MySqlClient.MySqlDbType.VarChar).Value        = Tprn.Text.ToUpper();
         ocon.Cmd.Parameters.Add("preAr", MySql.Data.MySqlClient.MySqlDbType.VarChar).Value         = Tprnar.Text;
         ocon.Cmd.Parameters.Add("nationnalite", MySql.Data.MySqlClient.MySqlDbType.VarChar).Value  = Tnatio.Text;
         ocon.Cmd.Parameters.Add("nationAr", MySql.Data.MySqlClient.MySqlDbType.VarChar).Value      = TnatioAr.Text;
         ocon.Cmd.Parameters.Add("lieuNaiss", MySql.Data.MySqlClient.MySqlDbType.VarString).Value   = textBox2.Text;
         ocon.Cmd.Parameters.Add("lieuNaissAr", MySql.Data.MySqlClient.MySqlDbType.VarString).Value = textBox1.Text;
         ocon.Cmd.Parameters.Add("jour", MySql.Data.MySqlClient.MySqlDbType.UInt64).Value           = int.Parse(tjf.Text);
         ocon.Cmd.Parameters.Add("mois", MySql.Data.MySqlClient.MySqlDbType.UInt64).Value           = int.Parse(tmf.Text);
         ocon.Cmd.Parameters.Add("annee", MySql.Data.MySqlClient.MySqlDbType.UInt64).Value          = int.Parse(taf.Text);
         ocon.Cmd.Parameters.Add("pere", MySql.Data.MySqlClient.MySqlDbType.VarChar).Value          = tperefr.Text;
         ocon.Cmd.Parameters.Add("pereAr", MySql.Data.MySqlClient.MySqlDbType.VarChar).Value        = Tperear.Text;
         ocon.Cmd.Parameters.Add("mere", MySql.Data.MySqlClient.MySqlDbType.VarChar).Value          = tmerefr.Text;
         ocon.Cmd.Parameters.Add("mereAr", MySql.Data.MySqlClient.MySqlDbType.VarChar).Value        = tmerear.Text;
         ocon.Cmd.Parameters.Add("deces", MySql.Data.MySqlClient.MySqlDbType.VarChar).Value         = decesfr.Text;
         ocon.Cmd.Parameters.Add("decesAr", MySql.Data.MySqlClient.MySqlDbType.VarChar).Value       = decesar.Text;
         ocon.Cmd.Parameters.Add("jourH", MySql.Data.MySqlClient.MySqlDbType.UInt64).Value          = int.Parse(tja.Text);
         ocon.Cmd.Parameters.Add("moisH", MySql.Data.MySqlClient.MySqlDbType.UInt64).Value          = int.Parse(tma.Text);
         ocon.Cmd.Parameters.Add("anneeH", MySql.Data.MySqlClient.MySqlDbType.UInt64).Value         = int.Parse(taa.Text);
         #endregion ajout_des_parametres
         ocon.NonQueryEx();
         MessageBox.Show("تم التعديل بنجاح");
     }
 }
Ejemplo n.º 7
0
        private void button1_Click(object sender, EventArgs e)
        {
            acte_u = new Acte();
            if (Checkcombos() == true)
            {
                ocon = new SqlDbConnect();
                ocon.SqlQuery
                    ("insert into personne(num,anneeAct,nom,nomAr,prenom,preAr,nationnalite,nationAr,lieuNaiss,lieuNaissAr,jour,mois,annee,pere,pereAr,mere,mereAr,deces,decesAr,jourh,moish,anneeh) values(@num,@anneeAct,@nom,@nomAr,@prenom,@preAr,@nationnalite,@nationAr,@lieuNaiss,@lieuNaissAr,@jour,@mois,@annee,@pere,@pereAr,@mere,@mereAr,@deces,@decesAr,@jourH,@moisH,@anneeH)");
                #region ajout_des_parametres
                ocon.Cmd.Parameters.Add("num", MySql.Data.MySqlClient.MySqlDbType.VarChar).Value           = Tnum.Text.ToUpper();
                ocon.Cmd.Parameters.Add("anneeAct", MySql.Data.MySqlClient.MySqlDbType.VarChar).Value      = Tdate.Text.ToUpper();
                ocon.Cmd.Parameters.Add("nom", MySql.Data.MySqlClient.MySqlDbType.VarChar).Value           = Tnom.Text.ToUpper();
                ocon.Cmd.Parameters.Add("nomAr", MySql.Data.MySqlClient.MySqlDbType.VarChar).Value         = TnomAr.Text;
                ocon.Cmd.Parameters.Add("prenom", MySql.Data.MySqlClient.MySqlDbType.VarChar).Value        = Tprn.Text.ToUpper();
                ocon.Cmd.Parameters.Add("preAr", MySql.Data.MySqlClient.MySqlDbType.VarChar).Value         = Tprnar.Text;
                ocon.Cmd.Parameters.Add("nationnalite", MySql.Data.MySqlClient.MySqlDbType.VarChar).Value  = Tnatio.Text.ToUpper();
                ocon.Cmd.Parameters.Add("nationAr", MySql.Data.MySqlClient.MySqlDbType.VarChar).Value      = TnatioAr.Text;
                ocon.Cmd.Parameters.Add("lieuNaiss", MySql.Data.MySqlClient.MySqlDbType.VarString).Value   = textBox2.Text.ToUpper();
                ocon.Cmd.Parameters.Add("lieuNaissAr", MySql.Data.MySqlClient.MySqlDbType.VarString).Value = textBox1.Text;
                ocon.Cmd.Parameters.Add("jour", MySql.Data.MySqlClient.MySqlDbType.UInt64).Value           = (int)CBJ.SelectedItem;
                ocon.Cmd.Parameters.Add("mois", MySql.Data.MySqlClient.MySqlDbType.UInt64).Value           = (int)CBM.SelectedItem;
                ocon.Cmd.Parameters.Add("annee", MySql.Data.MySqlClient.MySqlDbType.UInt64).Value          = (int)CBA.SelectedItem;
                ocon.Cmd.Parameters.Add("pere", MySql.Data.MySqlClient.MySqlDbType.VarChar).Value          = tperefr.Text.ToUpper();
                ocon.Cmd.Parameters.Add("pereAr", MySql.Data.MySqlClient.MySqlDbType.VarChar).Value        = Tperear.Text.ToUpper();
                ocon.Cmd.Parameters.Add("mere", MySql.Data.MySqlClient.MySqlDbType.VarChar).Value          = tmerefr.Text.ToUpper();
                ocon.Cmd.Parameters.Add("mereAr", MySql.Data.MySqlClient.MySqlDbType.VarChar).Value        = tmerear.Text.ToUpper();
                ocon.Cmd.Parameters.Add("deces", MySql.Data.MySqlClient.MySqlDbType.VarChar).Value         = decesfr.Text.ToUpper();
                ocon.Cmd.Parameters.Add("decesAr", MySql.Data.MySqlClient.MySqlDbType.VarChar).Value       = decesar.Text.ToUpper();
                ocon.Cmd.Parameters.Add("jourH", MySql.Data.MySqlClient.MySqlDbType.UInt64).Value          = (int)CBAJ.SelectedItem;
                ocon.Cmd.Parameters.Add("moisH", MySql.Data.MySqlClient.MySqlDbType.UInt64).Value          = (int)CBAM.SelectedItem;
                ocon.Cmd.Parameters.Add("anneeH", MySql.Data.MySqlClient.MySqlDbType.UInt64).Value         = (int)CBAA.SelectedItem;
                #endregion ajout_des_parametres

                /*    acte_u.Num = Tnum.Text.ToUpper();
                 *  acte_u.AnneeAct = Tdate.Text.ToUpper();
                 *  acte_u.Nom = Tnom.Text.ToUpper();
                 *  acte_u.NomAr = TnomAr.Text;
                 *  acte_u.Prenom = Tprn.Text.ToUpper();
                 *  acte_u.PreAr = Tprnar.Text;
                 *  acte_u.Nationnalite = Tnatio.Text.ToUpper();
                 *  acte_u.NationAr = TnatioAr.Text;
                 *  acte_u.LieuNaiss = textBox2.Text.ToUpper();
                 *  acte_u.LieuNaissAr = textBox1.Text;
                 *  acte_u.Jour = CBJ.SelectedItem.ToString();
                 *  acte_u.Mois = CBM.SelectedItem.ToString();
                 *  acte_u.Annee =CBA.SelectedItem.ToString();
                 *  acte_u.Pere = tperefr.Text.ToUpper();
                 *  acte_u.PereAr = Tperear.Text.ToUpper();
                 *  acte_u.Mere =tmerefr.Text.ToUpper();
                 *  acte_u.MereAr = tmerear.Text.ToUpper();
                 *  acte_u.Deces =decesfr.Text.ToUpper();
                 *  acte_u.DecesAr = decesar.Text.ToUpper();
                 *  acte_u.JourH = CBAJ.SelectedItem.ToString();
                 *  acte_u.MoisH = CBAM.SelectedItem.ToString();
                 *  acte_u.AnneeH = CBAA.SelectedItem.ToString();
                 *  Acte.list_act.Add(acte_u);
                 *
                 *  //ajout des parametres pour echaper sql injection!*/
                ocon.NonQueryEx();
                MessageBox.Show("لقد تمت الإضافة بنجاح ");
                clearall();
            }
        }
Ejemplo n.º 8
0
        private void bajout_Click(object sender, EventArgs e)
        {
            errorProvider1.Clear();

            if (comboBox1.Text == "")
            {
                errorProvider1.SetError(comboBox1, "a Remplir");
            }
            else
            {
                try
                {
                    majcon = new SqlDbConnect();
                    majcon.SqlQuery("update personne set sexe=@sexe, sexeAr=@sexeAr, nationPere=@nationPere, nationPereAr=@nationPereAr, nationMere=@nationMere, nationMereAr=@nationMereAr, lieuPere=@lieuPere, lieuPereAr=@lieuPereAr, lieuMere=@lieuMere, lieuMereAr=@lieuMereAr, jourPere=@jourPere, moisPere=@moisPere, anneePere=@anneePere, jourHP=@jourHP, moisHP=@moisHP, anneeHP=@anneeHP, jourM=@jourM, moisM=@moisM, anneeM=@anneeM, jourHM=@jourHM, moisHM=@moisHM, anneeHM=@anneeHM, domicile=@domicile, domicileAr=@domicileAr, jourDr=@jourDr, moisDr=@moisDr, anneeDr=@anneeDr, jourHD=@jourHD, moisHD=@moisHD, anneeHD=@anneeHD, faitePar=@faitePar, faiteAr=@faiteAr, signe=@signe, signeAr=@signeAr, officier=@officier, officierAr=@officierAr, professionP=@professionP, professionPAr=@professionPAr, professionM=@professionM, professionMAr=@professionMAr, ham=@ham, hamAr=@hamAr where num=@num and anneeAct=@anneeAct");

                    /**/
                    #region parametres_du_requetes!
                    string sexe;
                    if (comboBox1.Text == "ذكر")
                    {
                        sexe = "masculin";
                    }
                    else
                    {
                        sexe = "feminin";
                    }
                    majcon.Cmd.Parameters.Add("sexe", MySqlDbType.VarChar).Value         = sexe;
                    majcon.Cmd.Parameters.Add("sexeAr", MySqlDbType.VarChar).Value       = comboBox1.Text;
                    majcon.Cmd.Parameters.Add("nationPere", MySqlDbType.VarChar).Value   = tnatiofrpr.Text;
                    majcon.Cmd.Parameters.Add("nationPereAr", MySqlDbType.VarChar).Value = tnatioarpr.Text;
                    majcon.Cmd.Parameters.Add("nationMere", MySqlDbType.VarChar).Value   = tnatiofrmr.Text;
                    majcon.Cmd.Parameters.Add("nationMereAr", MySqlDbType.VarChar).Value = tnatioarmr.Text;
                    majcon.Cmd.Parameters.Add("lieuPere", MySqlDbType.VarChar).Value     = tnaissperefr.Text;
                    majcon.Cmd.Parameters.Add("lieuPereAr", MySqlDbType.VarChar).Value   = Tnaisperear.Text;
                    majcon.Cmd.Parameters.Add("lieuMere", MySqlDbType.VarChar).Value     = tnaissmerefrr.Text;
                    majcon.Cmd.Parameters.Add("lieuMereAr", MySqlDbType.VarChar).Value   = tnaismerear.Text;
                    majcon.Cmd.Parameters.Add("jourPere", MySqlDbType.VarChar).Value     = cbdayfrpr.Text;
                    majcon.Cmd.Parameters.Add("moisPere", MySqlDbType.VarChar).Value     = cpmonthprfr.Text;
                    majcon.Cmd.Parameters.Add("anneePere", MySqlDbType.VarChar).Value    = cbyearfrpr.Text;
                    majcon.Cmd.Parameters.Add("jourHP", MySqlDbType.VarChar).Value       = cbdayarpr.Text;
                    majcon.Cmd.Parameters.Add("moisHP", MySqlDbType.VarChar).Value       = cbmontharpr.Text;
                    majcon.Cmd.Parameters.Add("anneeHP", MySqlDbType.VarChar).Value      = cbyeararpr.Text;
                    //professionP = @professionP, professionPAr = @professionPAr, professionM = @professionM, professionMAr = @professionMAr, ham = @ham, hamAr = @hamAr where num = @num anneeAct = @anneeAct*/
                    majcon.Cmd.Parameters.Add("jourM", MySqlDbType.VarChar).Value         = cbdayfrmr.Text;
                    majcon.Cmd.Parameters.Add("moisM", MySqlDbType.VarChar).Value         = cbmonthfrmr.Text;
                    majcon.Cmd.Parameters.Add("anneeM", MySqlDbType.VarChar).Value        = cbyearfrmr.Text;
                    majcon.Cmd.Parameters.Add("jourHM", MySqlDbType.VarChar).Value        = cbdayarmr.Text;
                    majcon.Cmd.Parameters.Add("moisHM", MySqlDbType.VarChar).Value        = cbmontharmr.Text;
                    majcon.Cmd.Parameters.Add("anneeHM", MySqlDbType.VarChar).Value       = cbyearfrmr.Text;
                    majcon.Cmd.Parameters.Add("domicile", MySqlDbType.VarChar).Value      = residencefr.Text;
                    majcon.Cmd.Parameters.Add("domicileAr", MySqlDbType.VarChar).Value    = residencear.Text;
                    majcon.Cmd.Parameters.Add("jourDr", MySqlDbType.VarChar).Value        = cbjour1.Text;
                    majcon.Cmd.Parameters.Add("moisDr", MySqlDbType.VarChar).Value        = cbmois1.Text;
                    majcon.Cmd.Parameters.Add("anneeDr", MySqlDbType.VarChar).Value       = cbyear1.Text;
                    majcon.Cmd.Parameters.Add("jourHD", MySqlDbType.VarChar).Value        = cbdayhorira.Text;
                    majcon.Cmd.Parameters.Add("moisHD", MySqlDbType.VarChar).Value        = cbmonthhorira.Text;
                    majcon.Cmd.Parameters.Add("anneeHD", MySqlDbType.VarChar).Value       = cbyearhorira.Text;
                    majcon.Cmd.Parameters.Add("faitePar", MySqlDbType.VarChar).Value      = declarationparfr.Text;
                    majcon.Cmd.Parameters.Add("faiteAr", MySqlDbType.VarChar).Value       = declarationparar.Text;
                    majcon.Cmd.Parameters.Add("signe", MySqlDbType.VarChar).Value         = parnousfr.Text;
                    majcon.Cmd.Parameters.Add("signeAr", MySqlDbType.VarChar).Value       = parnousar.Text;
                    majcon.Cmd.Parameters.Add("officier", MySqlDbType.VarChar).Value      = officierfr.Text;
                    majcon.Cmd.Parameters.Add("officierAr", MySqlDbType.VarChar).Value    = officierar.Text;
                    majcon.Cmd.Parameters.Add("professionP", MySqlDbType.VarChar).Value   = professionfrpr.Text;
                    majcon.Cmd.Parameters.Add("professionPAr", MySqlDbType.VarChar).Value = professionarpr.Text;
                    majcon.Cmd.Parameters.Add("professionM", MySqlDbType.VarChar).Value   = professionfrmr.Text;
                    majcon.Cmd.Parameters.Add("professionMAr", MySqlDbType.VarChar).Value = professionaarmr.Text;
                    majcon.Cmd.Parameters.Add("ham", MySqlDbType.VarChar).Value           = hamfr.Text;
                    majcon.Cmd.Parameters.Add("hamAr", MySqlDbType.VarChar).Value         = hamfr.Text;
                    majcon.Cmd.Parameters.Add("num", MySqlDbType.VarChar).Value           = tnumact.Text;
                    majcon.Cmd.Parameters.Add("anneeAct", MySqlDbType.VarChar).Value      = tyear.Text;
                    //fkn finally 1:11 morning 18/03
                    majcon.NonQueryEx();



                    #endregion
                    MessageBox.Show("لقد تم التعديل بنجاح !");
                    if ((MessageBox.Show("هل تريد طباعة النسخة الكاملة ؟", "نافدة", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes))
                    {
                        //add code to the print form and variables so that when we open it it will contain this shiiiiiiiiiiiiiit :D
                    }
                }
                catch (Exception)
                {
                    MessageBox.Show("Erreur");
                }
            }
        }