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(); } } }
//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; } }
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, "هذا الشخص لا يتواجد في قاعدة البيانات المرجو إضافته"); } } }
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(); } } }
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, "المرجوا ملء الخانة قبل البحث"); } }
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("تم التعديل بنجاح"); } }
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(); } }
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"); } } }