private void button3_Click(object sender, EventArgs e) { ManipulationBD.ConnectionDataBase(); listView1.Items.Clear(); MySqlCommand cmd = new MySqlCommand(" Select * from tarification", ManipulationBD.Cnn); using (MySqlDataReader read = cmd.ExecuteReader()) { while (read.Read()) { string ID = read["Id_tarif"].ToString(); string Cat = read["categorie"].ToString(); string TC = read["tarif_chauff"].ToString(); string TL = read["tarif_loc_jr"].ToString(); string TH = read["tarif_loc_jr"].ToString(); string TKm = read["tarif_km_parc"].ToString(); string DT = read["date_tarif"].ToString(); listView1.Items.Add(new ListViewItem(new[] { ID, Cat, TC, TL, TH, TKm, DT })); } } ManipulationBD.DecoonectionDataBase(); }
private void button1_Click(object sender, EventArgs e) { RadioButton rb1 = null; for (int i = 0; i < groupBox1.Controls.Count; i++) { rb1 = (RadioButton)groupBox1.Controls[i]; // On sort dès qu'on trouve le bouton sélectionné if (rb1.Checked) { break; } } string Insertion1 = "insert into tarification values ('" + numtarif.Text + "',' " + rb1.Text + " ' ,' " + T_chauff.Text + " ','" + T_Loc.Text + "','" + T_heure.Text + "','" + T_km.Text + "','" + Date_T.Text + "')"; MySqlCommand cmd1 = new MySqlCommand(Insertion1, ManipulationBD.Cnn); try { ManipulationBD.ConnectionDataBase(); cmd1.ExecuteNonQuery(); MessageBox.Show("Ajout effectuez"); } catch (Exception r) { MessageBox.Show(r.Message); } finally { ManipulationBD.DecoonectionDataBase(); } }
private void button1_Click(object sender, EventArgs e) { try { ManipulationBD.ConnectionDataBase(); RadioButton rb = null; for (int i = 0; i < groupBox1.Controls.Count; i++) { rb = (RadioButton)groupBox1.Controls[i]; // On sort dès qu'on trouve le bouton sélectionné if (rb.Checked) { break; } } string Insertion = "insert into compte values (?,?,?,?,?,?,?)"; MySqlCommand cmd = new MySqlCommand(Insertion, ManipulationBD.Cnn); MySqlParameter p1 = new MySqlParameter("id_cmp", Id.Text); cmd.Parameters.Add(p1); MySqlParameter p2 = new MySqlParameter("nom_cmp", nom.Text); cmd.Parameters.Add(p2); MySqlParameter p3 = new MySqlParameter("prenom", Prenom.Text); cmd.Parameters.Add(p3); MySqlParameter p5 = new MySqlParameter("tel_cmp", Tel.Text); cmd.Parameters.Add(p5); MySqlParameter p6 = new MySqlParameter("User_name", Username.Text); cmd.Parameters.Add(p6); MySqlParameter p7 = new MySqlParameter("Pwd", Pwd.Text); cmd.Parameters.Add(p7); MySqlParameter p4 = new MySqlParameter("type", rb.Text); cmd.Parameters.Add(p4); cmd.ExecuteNonQuery(); if (rb.Text == "Administrateur") { Administrateur.Administrateur a = new Administrateur.Administrateur(); this.Hide(); a.Show(); } else { Agent.Agent a = new Agent.Agent(); this.Hide(); a.Show(); } //MessageBox.Show(rb.Text); } catch (Exception r) { MessageBox.Show(r.Message); } finally { ManipulationBD.DecoonectionDataBase(); } }
private void button1_Click(object sender, EventArgs e) { try { ManipulationBD.ConnectionDataBase(); RadioButton rb = null; for (int i = 0; i < groupBox1.Controls.Count; i++) { rb = (RadioButton)groupBox1.Controls[i]; // On sort dès qu'on trouve le bouton sélectionné if (rb.Checked) { break; } } string Insertion = "insert into compte values ('" + Id.Text + "','" + Nom.Text + "','" + Prenom.Text + "','" + Tel.Text + "','" + UserName.Text + "','" + Pwd.Text + "','" + rb.Text + "')"; MySqlCommand cmd = new MySqlCommand(Insertion, ManipulationBD.Cnn); cmd.ExecuteNonQuery(); MessageBox.Show("Ajout effectuez"); } catch (Exception r) { MessageBox.Show(r.Message); } finally { ManipulationBD.DecoonectionDataBase(); } }
private void button1_Click(object sender, EventArgs e) { RadioButton rb = null; for (int i = 0; i < groupBox1.Controls.Count; i++) { rb = (RadioButton)groupBox1.Controls[i]; // On sort dès qu'on trouve le bouton sélectionné if (rb.Checked) { break; } } string Insertion = "update compte set id_cmp='" + ID.Text + "',nom_cmp='" + Nom.Text + "',prenom_cmp='" + Prenom.Text + "',tel_cmp='" + Tel.Text + "',User_name='" + Username.Text + "',Pwd='" + Pwd.Text + "',type_cmp='" + rb.Text + "' " + "where Pwd='" + Pwd_modif.Text + "'"; MySqlCommand cmd = new MySqlCommand(Insertion, ManipulationBD.Cnn); try { Administrateur admin = new Administrateur(); ManipulationBD.ConnectionDataBase(); cmd.ExecuteNonQuery(); admin.Show(); this.Hide(); MessageBox.Show("Modification effectuez"); } catch (Exception r) { MessageBox.Show(r.Message); } finally { ManipulationBD.DecoonectionDataBase(); } }
private void button1_Click(object sender, EventArgs e) { try { ManipulationBD.ConnectionDataBase(); RadioButton rb = null; for (int i = 0; i < groupBox1.Controls.Count; i++) { rb = (RadioButton)groupBox1.Controls[i]; // On sort dès qu'on trouve le bouton sélectionné if (rb.Checked) break; } string Insertion1 = "insert into contrat values (?,?,?,?,?,?,?,?,?,?)"; string strverif = "select count(*) from contrat where num_contrat=?"; MySqlCommand cmd1 = new MySqlCommand(Insertion1, ManipulationBD.Cnn); MySqlParameter p1 = new MySqlParameter("p1", textBox1.Text); cmd1.Parameters.Add(p1); MySqlParameter p2 = new MySqlParameter("p2", textBox3.Text); cmd1.Parameters.Add(p2); MySqlParameter p3 = new MySqlParameter("p3", textBox4.Text); cmd1.Parameters.Add(p3); MySqlParameter p4 = new MySqlParameter("p4", textBox2.Text); cmd1.Parameters.Add(p4); MySqlParameter p5 = new MySqlParameter("p5", textBox5.Text); cmd1.Parameters.Add(p5); MySqlParameter p6 = new MySqlParameter("p6", dateTimePicker1.Text); cmd1.Parameters.Add(p6); MySqlParameter p7 = new MySqlParameter("p7", dateTimePicker2.Text); cmd1.Parameters.Add(p7); MySqlParameter p8 = new MySqlParameter("p8", rb.Text); cmd1.Parameters.Add(p8); MySqlParameter p9 = new MySqlParameter("p9", textBox6.Text); cmd1.Parameters.Add(p9); MySqlParameter p10 = new MySqlParameter("p10", textBox7.Text); cmd1.Parameters.Add(p10); MySqlCommand verif = new MySqlCommand(strverif, ManipulationBD.Cnn); MySqlParameter p16 = new MySqlParameter("p16", textBox1.Text); verif.Parameters.Add(p16); long n = (long)verif.ExecuteScalar(); if (n == 0) { cmd1.ExecuteNonQuery(); MessageBox.Show("Ajout effectuez"); } else { MessageBox.Show("Ajout Impossible car Risque de Doublon"); } } }
private void button1_Click(object sender, EventArgs e) { try { ManipulationBD.ConnectionDataBase(); if (textBox1.Text == "") { MessageBox.Show(" Champ vide !!"); } else if (textBox2.Text == "") { MessageBox.Show(" Champ vide !! "); } else if (textBox3.Text == "") { MessageBox.Show(" Champ vide !! "); } else { string Insertion1 = "delete from contrat where Numero_Contrat=?"; string strverif = "select count(*) from contrat where Numero_Contrat=?"; MySqlCommand cmd1 = new MySqlCommand(Insertion1, ManipulationBD.Cnn); MySqlParameter p1 = new MySqlParameter("Contrat", textBox1.Text); cmd1.Parameters.Add(p1); MySqlCommand verif = new MySqlCommand(strverif, ManipulationBD.Cnn); MySqlParameter p16 = new MySqlParameter("p16", textBox1.Text); verif.Parameters.Add(p16); long n = (long)verif.ExecuteScalar(); if (n == 1) { cmd1.ExecuteNonQuery(); MessageBox.Show("Suppression effectuez"); } else { MessageBox.Show("Suppression Impossible Car le Contrat N'existe pas"); } } } catch (Exception r) { MessageBox.Show(r.Message); } finally { ManipulationBD.DecoonectionDataBase(); } }
private void button3_Click(object sender, EventArgs e) { try { ManipulationBD.ConnectionDataBase(); RadioButton rb1 = null; for (int i = 0; i < groupBox1.Controls.Count; i++) { rb1 = (RadioButton)groupBox1.Controls[i]; // On sort dès qu'on trouve le bouton sélectionné if (rb1.Checked) { break; } } string update = "select * from contrat where Numero_Contrat=?"; MySqlCommand cmd = new MySqlCommand(update, ManipulationBD.Cnn); MySqlParameter p = new MySqlParameter("p", textBox7.Text); cmd.Parameters.Add(p); MySqlDataReader dr = cmd.ExecuteReader(); if (dr != null) { while (dr.Read()) { rb1.Text = (string)dr[7]; dateTimePicker1.Text = ((DateTime)dr[6]).ToString(); dateTimePicker2.Text = ((DateTime)dr[5]).ToString(); textBox1.Text = ((int)dr[0]).ToString(); textBox5.Text = ((int)dr[3]).ToString(); textBox4.Text = ((int)dr[1]).ToString(); textBox2.Text = ((int)dr[2]).ToString(); textBox3.Text = ((int)dr[4]).ToString(); textBox6.Text = ((int)dr[8]).ToString(); textBox8.Text = ((int)dr[9]).ToString(); } } } catch (Exception r) { MessageBox.Show(r.Message); } finally { ManipulationBD.DecoonectionDataBase(); } }
private void button1_Click_1(object sender, EventArgs e) { try { ManipulationBD.ConnectionDataBase(); string UserName = user.Text; string Password = pwd.Text; User_name = user.Text; MySqlCommand cmd = new MySqlCommand(" Select * from compte where User_name = ? And Pwd = ? ", ManipulationBD.Cnn); MySqlParameter P1 = new MySqlParameter("P1", user.Text); cmd.Parameters.Add(P1); MySqlParameter P2 = new MySqlParameter("P2", pwd.Text); cmd.Parameters.Add(P2); MySqlDataReader dr = cmd.ExecuteReader(); if (dr != null) { while (dr.Read()) { if ((string)dr["type_cmp"] == "Administrateur") { Administrateur.Administrateur a = new Administrateur.Administrateur(); a.Show(); this.Hide(); } else { Agent.Agent a = new Agent.Agent(); this.Hide(); a.Show(); } } } } catch (Exception Ex) { MessageBox.Show(Ex.Message); } finally { ManipulationBD.DecoonectionDataBase(); } }
private void button1_Click(object sender, EventArgs e) { RadioButton rb1 = null; for (int i = 0; i < Cat.Controls.Count; i++) { rb1 = (RadioButton)Cat.Controls[i]; // On sort dès qu'on trouve le bouton sélectionné if (rb1.Checked) { break; } } RadioButton rb3 = null; for (int i = 0; i < Etat.Controls.Count; i++) { rb3 = (RadioButton)Etat.Controls[i]; // On sort dès qu'on trouve le bouton sélectionné if (rb3.Checked) { break; } } string Insertion1 = "update vehicule set num_ch = ' " + NumCh.Text + " ',categorie = ' " + rb1.Text + " ',marque = ' " + Marque.Text + " ',nbr_km = ' " + NbrKm.Text + " ',nbr_hr = ' " + NbrHr.Text + " ', etat = ' " + rb3.Text + " ' where num_ch ='" + NewNum.Text + " ' "; MySqlCommand cmd1 = new MySqlCommand(Insertion1, ManipulationBD.Cnn); try { ManipulationBD.ConnectionDataBase(); cmd1.ExecuteNonQuery(); MessageBox.Show("Modification effectuez"); } catch (Exception r) { MessageBox.Show(r.Message); } finally { ManipulationBD.DecoonectionDataBase(); } }
private void button1_Click(object sender, EventArgs e) { string Insertion1 = "delete from compte where Pwd=?"; MySqlCommand cmd1 = new MySqlCommand(Insertion1, ManipulationBD.Cnn); MySqlParameter p1 = new MySqlParameter("Pwd", Pwd.Text); cmd1.Parameters.Add(p1); try { Administrateur admin = new Administrateur(); ManipulationBD.ConnectionDataBase(); cmd1.ExecuteNonQuery(); MessageBox.Show("Suppression effectuez"); } catch (Exception r) { MessageBox.Show(r.Message); } finally { ManipulationBD.DecoonectionDataBase(); } }
private void button1_Click(object sender, EventArgs e) { string Insertion1 = "delete from tarification where Id_tarif =?"; MySqlCommand cmd1 = new MySqlCommand(Insertion1, ManipulationBD.Cnn); MySqlParameter p1 = new MySqlParameter("Id_tarif", textBox6.Text); cmd1.Parameters.Add(p1); try { ManipulationBD.ConnectionDataBase(); cmd1.ExecuteNonQuery(); cmd1.Parameters.Clear(); MessageBox.Show("Suppression effectuez"); } catch (Exception r) { MessageBox.Show(r.Message); } finally { ManipulationBD.DecoonectionDataBase(); } }
private void button1_Click_1(object sender, EventArgs e) { RadioButton rb1 = null; for (int i = 0; i < groupBox1.Controls.Count; i++) { rb1 = (RadioButton)groupBox1.Controls[i]; // On sort dès qu'on trouve le bouton sélectionné if (rb1.Checked) { break; } } string Insertion1 = "update tarification set Id_tarif = ' " + numtarif.Text + " ', categorie = ' " + rb1.Text + " ',tarif_chauff=' " + T_chauff.Text + "',tarif_loc_jr='" + T_Loc.Text + "',tarif_hr_trv='" + T_heure.Text + "',tarif_km_parc='" + T_km.Text + "',date_tarif='" + Date_T.Text + " ' " + "where Id_tarif='" + numTarif_modif.Text + "'"; MySqlCommand cmd1 = new MySqlCommand(Insertion1, ManipulationBD.Cnn); try { //Administrateur admin = new Administrateur(); ManipulationBD.ConnectionDataBase(); cmd1.ExecuteNonQuery(); cmd1.Parameters.Clear(); new Administrateur().Show(); this.Hide(); MessageBox.Show("Modification effectuez"); } catch (Exception r) { MessageBox.Show(r.Message); } finally { ManipulationBD.DecoonectionDataBase(); } }
private void button1_Click(object sender, EventArgs e) { try { ManipulationBD.ConnectionDataBase(); RadioButton rb = null; for (int i = 0; i < groupBox1.Controls.Count; i++) { rb = (RadioButton)groupBox1.Controls[i]; // On sort dès qu'on trouve le bouton sélectionné if (rb.Checked) { break; } } string Insertion1 = "update facturation set Numero_Fact=?,Numero_Contrat=?,Numero_Chassis=?,Categorie=?,Nbr_Km_Parc=?,Tarif_Km_Parc=?, Nombre_Jour_Loc=?,Tarif_Jour=?,Tarif_Jour_Chauff=?,Montant_Globale=?,Montant_TVA=?,Montant_Hors_Taxe=?,Montant_Net=?,Nombre_Heure_fct=?,Tarif_Heure=? where Numero_Fact=?"; string strverif = "select count(*) from facturation where Numero_Fact=?"; MySqlCommand cmd1 = new MySqlCommand(Insertion1, ManipulationBD.Cnn); MySqlParameter p1 = new MySqlParameter("p1", textBox5.Text); cmd1.Parameters.Add(p1); MySqlParameter p2 = new MySqlParameter("p2", textBox3.Text); cmd1.Parameters.Add(p2); MySqlParameter p3 = new MySqlParameter("p3", textBox4.Text); cmd1.Parameters.Add(p3); MySqlParameter p4 = new MySqlParameter("p4", rb.Text); cmd1.Parameters.Add(p4); MySqlParameter p5 = new MySqlParameter("p5", textBox6.Text); cmd1.Parameters.Add(p5); MySqlParameter p6 = new MySqlParameter("p6", textBox8.Text); cmd1.Parameters.Add(p6); MySqlParameter p7 = new MySqlParameter("p7", textBox1.Text); cmd1.Parameters.Add(p7); MySqlParameter p8 = new MySqlParameter("p8", textBox9.Text); cmd1.Parameters.Add(p8); MySqlParameter p9 = new MySqlParameter("p9", textBox10.Text); cmd1.Parameters.Add(p9); MySqlParameter p10 = new MySqlParameter("p10", textBox11.Text); cmd1.Parameters.Add(p10); MySqlParameter p11 = new MySqlParameter("p11", textBox12.Text); cmd1.Parameters.Add(p11); MySqlParameter p12 = new MySqlParameter("p12", textBox13.Text); cmd1.Parameters.Add(p12); MySqlParameter p13 = new MySqlParameter("p13", textBox14.Text); cmd1.Parameters.Add(p13); MySqlParameter p14 = new MySqlParameter("p14", textBox2.Text); cmd1.Parameters.Add(p14); MySqlParameter p15 = new MySqlParameter("p15", textBox7.Text); cmd1.Parameters.Add(p15); MySqlParameter par = new MySqlParameter("par", textBox15.Text); cmd1.Parameters.Add(par); MySqlCommand verif = new MySqlCommand(strverif, ManipulationBD.Cnn); MySqlParameter p16 = new MySqlParameter("p16", textBox5.Text); verif.Parameters.Add(p16); long n = (long)verif.ExecuteScalar(); if (n == 1) { cmd1.ExecuteNonQuery(); MessageBox.Show("Modidication effectuez"); } else { MessageBox.Show("Impossible car ce contrat n'existe pas"); } } catch (Exception r) { MessageBox.Show(r.Message); } finally { ManipulationBD.DecoonectionDataBase(); } }
private void Button1_Click(object sender, EventArgs e) { Agent.Acteur = Connection.Login.User_name; Agent.Operation = " a ajouter un nouveau client "; try { ManipulationBD.ConnectionDataBase(); RadioButton rb = null; for (int i = 0; i < groupBox1.Controls.Count; i++) { rb = (RadioButton)groupBox1.Controls[i]; if (rb.Checked) { break; } } string Tunisien = "insert into client values (@code_client,@adr_client,@tel_client,null,@cin,null,null,@nom,@prenom,null,null)"; string Etranger = "insert into client values (@code_client,@adr_client,@tel_client,@nationalite,null,@num_passport,@pays_org,@nom,@prenom,null,null)"; string Entreprise = "insert into client values (@code_client,@adr_client,@tel_client,null,null,null,null,null,null,@code_fisc,@rais_soc)"; string Historique = "insert into historique values(null, @Operation,@Acteur)"; string strverif = "select count(*) from client where Code_Client=?"; MySqlCommand cmd1 = new MySqlCommand(Tunisien, ManipulationBD.Cnn); cmd1.Parameters.AddWithValue("@code_client", Cd_client.Text); cmd1.Parameters.AddWithValue("@adr_client", Adr_client.Text); cmd1.Parameters.AddWithValue("@tel_client", Tel.Text); cmd1.Parameters.AddWithValue("@cin", Cin.Text); cmd1.Parameters.AddWithValue("@nom", Nom.Text); cmd1.Parameters.AddWithValue("@prenom", Prenom.Text); MySqlCommand cmd2 = new MySqlCommand(Etranger, ManipulationBD.Cnn); cmd2.Parameters.AddWithValue("@code_client", Cd_client.Text); cmd2.Parameters.AddWithValue("@adr_client", Adr_client.Text); cmd2.Parameters.AddWithValue("@tel_client", Tel.Text); cmd2.Parameters.AddWithValue("@nationalite", Nat.Text); cmd2.Parameters.AddWithValue("@num_passport", NumPass.Text); cmd2.Parameters.AddWithValue("@pays_org", P_Org.Text); cmd2.Parameters.AddWithValue("@nom", Nom.Text); cmd2.Parameters.AddWithValue("@prenom", Prenom.Text); MySqlCommand cmd3 = new MySqlCommand(Entreprise, ManipulationBD.Cnn); cmd3.Parameters.AddWithValue("@code_client", Cd_client.Text); cmd3.Parameters.AddWithValue("@adr_client", Adr_client.Text); cmd3.Parameters.AddWithValue("@tel_client", Tel.Text); cmd3.Parameters.AddWithValue("@code_fisc", Cd_fisc.Text); cmd3.Parameters.AddWithValue("@rais_soc", R_soc.Text); MySqlCommand Cmd = new MySqlCommand(Historique, ManipulationBD.Cnn); Cmd.Parameters.AddWithValue("@Operation", (string)Agent.Operation); Cmd.Parameters.AddWithValue("@Acteur", (string)Agent.Acteur); MySqlCommand verif = new MySqlCommand(strverif, ManipulationBD.Cnn); MySqlParameter p16 = new MySqlParameter("p16", Cd_client.Text); verif.Parameters.Add(p16); long n = (long)verif.ExecuteScalar(); if (n == 0) { if (rb.Text == "Tunisien") { cmd1.ExecuteNonQuery(); Cmd.ExecuteNonQuery(); agent.Show(); this.Hide(); MessageBox.Show("Ajout effectuez"); } else if (rb.Text == "Etranger") { cmd2.ExecuteNonQuery(); Cmd.ExecuteNonQuery(); agent.Show(); this.Hide(); MessageBox.Show("Ajout effectuez"); } else { cmd3.ExecuteNonQuery(); Cmd.ExecuteNonQuery(); new Agent().Show(); this.Hide(); MessageBox.Show("Ajout effectuez"); } } else { MessageBox.Show("Ajout Impossible car Risque de Doublon"); } } catch (Exception r) { MessageBox.Show(r.Message); } finally { ManipulationBD.DecoonectionDataBase(); } }
private void button3_Click(object sender, EventArgs e) { try { ManipulationBD.ConnectionDataBase(); RadioButton rb = null; for (int i = 0; i < groupBox1.Controls.Count; i++) { rb = (RadioButton)groupBox1.Controls[i]; // On sort dès qu'on trouve le bouton sélectionné if (rb.Checked) { break; } } string Client = "select * from client where code_client = ?"; string Tunisien = "select * from client where code_client=?"; string Etranger = "select * from client where code_client=?"; string Entreprise = "select * from client where code_client=?"; MySqlCommand client = new MySqlCommand(Client, ManipulationBD.Cnn); MySqlParameter par = new MySqlParameter("par", cd_client.Text); client.Parameters.Add(par); MySqlCommand tunisien = new MySqlCommand(Tunisien, ManipulationBD.Cnn); MySqlParameter pmt1 = new MySqlParameter("pmt1", cd_client.Text); tunisien.Parameters.Add(pmt1); MySqlCommand etranger = new MySqlCommand(Etranger, ManipulationBD.Cnn); MySqlParameter pmt2 = new MySqlParameter("pmt2", cd_client.Text); etranger.Parameters.Add(pmt2); MySqlCommand entreprise = new MySqlCommand(Entreprise, ManipulationBD.Cnn); MySqlParameter pmt3 = new MySqlParameter("pmt3", cd_client.Text); etranger.Parameters.Add(pmt3); MySqlDataReader dr = client.ExecuteReader(); if (dr != null) { /*while (dr.Read()) * { * // textBox1.Text = ((int)dr[0]).ToString(); * textBox1.Text = dr.GetInt32(0).ToString(); * textBox5.Text = (string)dr[1]; * textBox4.Text = dr.GetInt32(2).ToString(); * } * dr.Close();*/ if (rb.Text == "Tunisien") { while (dr.Read()) { cd_client.Text = dr.GetInt32(0).ToString(); adr_client.Text = (string)dr[1]; Tel.Text = dr.GetInt32(2).ToString(); } dr.Close(); MySqlDataReader dr1 = tunisien.ExecuteReader(); if (dr1 != null) { while (dr1.Read()) { cin.Text = ((int)dr[4]).ToString(); Nom.Text = (string)dr1[7]; Prenom.Text = (string)dr1[8]; } dr1.Close(); } } else if (rb.Text == "Etranger") { while (dr.Read()) { cd_client.Text = dr.GetInt32(0).ToString(); adr_client.Text = (string)dr[1]; Tel.Text = (string)dr[2]; } dr.Close(); MySqlDataReader dr1 = etranger.ExecuteReader(); if (dr1 != null) { while (dr1.Read()) { Nat.Text = (string)dr1[3]; numPass.Text = (string)dr[5]; P_org.Text = (string)dr1[6]; Nom.Text = (string)dr1[7]; Prenom.Text = (string)dr1[8]; } dr1.Close(); } } else { while (dr.Read()) { cd_client.Text = dr.GetInt32(0).ToString(); adr_client.Text = (string)dr[1]; Tel.Text = dr.GetInt32(2).ToString(); } dr.Close(); MySqlDataReader dr1 = entreprise.ExecuteReader(); if (dr1 != null) { while (dr1.Read()) { R_soc.Text = ((int)dr1[9]).ToString(); Cd_fisc.Text = (string)dr1[10]; } dr1.Close(); } } } else { MessageBox.Show("Modification Impossible car Il n'existe pas !"); } } catch (Exception r) { MessageBox.Show(r.Message); } finally { ManipulationBD.DecoonectionDataBase(); } }
private void button1_Click(object sender, EventArgs e) { try { ManipulationBD.ConnectionDataBase(); RadioButton rb = null; for (int i = 0; i < groupBox1.Controls.Count; i++) { rb = (RadioButton)groupBox1.Controls[i]; // On sort dès qu'on trouve le bouton sélectionné if (rb.Checked) { break; } } string Tunisien = "update client set code_client = ?, adr_client=?, tel_client=?, cin=?, nom=?, prenom=? where code_client=?"; string Etranger = "update client set code_client=?,adr_client=?,tel_client=?,nationalite=? , num_passport=?, pays_org=?, nom=?, prenom=? where Code_Client =?"; string Entreprise = "update client set code_client=?,adr_client=?,tel_client=?,code_fisc=?,rais_soc=? where code_client =?"; MySqlCommand cmd1 = new MySqlCommand(Tunisien, ManipulationBD.Cnn); MySqlParameter p1 = new MySqlParameter("p1", cd_client.Text); cmd1.Parameters.Add(p1); MySqlParameter p2 = new MySqlParameter("p2", adr_client.Text); cmd1.Parameters.Add(p2); MySqlParameter p3 = new MySqlParameter("p3", Tel.Text); cmd1.Parameters.Add(p3); MySqlParameter p4 = new MySqlParameter("p4", cin.Text); cmd1.Parameters.Add(p4); MySqlParameter p5 = new MySqlParameter("p5", Nom.Text); cmd1.Parameters.Add(p5); MySqlParameter p6 = new MySqlParameter("p6", Prenom.Text); cmd1.Parameters.Add(p6); MySqlParameter par1 = new MySqlParameter("par1", Cd_mod.Text); cmd1.Parameters.Add(par1); MySqlCommand cmd2 = new MySqlCommand(Etranger, ManipulationBD.Cnn); MySqlParameter e1 = new MySqlParameter("e1", cd_client.Text); cmd2.Parameters.Add(e1); MySqlParameter e2 = new MySqlParameter("e2", adr_client.Text); cmd2.Parameters.Add(e2); MySqlParameter e3 = new MySqlParameter("e3", Tel.Text); cmd2.Parameters.Add(e3); MySqlParameter e4 = new MySqlParameter("e4", Nat.Text); cmd2.Parameters.Add(e4); MySqlParameter e5 = new MySqlParameter("e5", numPass.Text); cmd2.Parameters.Add(e5); MySqlParameter e6 = new MySqlParameter("e6", P_org.Text); cmd2.Parameters.Add(e6); MySqlParameter e7 = new MySqlParameter("e7", Nom.Text); cmd2.Parameters.Add(e7); MySqlParameter e8 = new MySqlParameter("e8", Prenom.Text); cmd2.Parameters.Add(e8); MySqlParameter par2 = new MySqlParameter("par2", Cd_mod.Text); cmd2.Parameters.Add(par2); MySqlCommand cmd3 = new MySqlCommand(Entreprise, ManipulationBD.Cnn); MySqlParameter p8 = new MySqlParameter("p8", cd_client.Text); cmd3.Parameters.Add(p8); MySqlParameter p9 = new MySqlParameter("p9", adr_client.Text); cmd3.Parameters.Add(p9); MySqlParameter p10 = new MySqlParameter("p10", Tel.Text); cmd3.Parameters.Add(p10); MySqlParameter p11 = new MySqlParameter("p11", Cd_fisc.Text); cmd3.Parameters.Add(p11); MySqlParameter p12 = new MySqlParameter("p12", R_soc.Text); cmd3.Parameters.Add(p12); MySqlParameter par3 = new MySqlParameter("par3", Cd_mod.Text); cmd3.Parameters.Add(par3); //cmd1.ExecuteNonQuery(); //MessageBox.Show("Modification effectuez"); if (rb.Text == "Tunisien") { cmd1.ExecuteNonQuery(); MessageBox.Show("Modification effectuez"); } else if (rb.Text == "Etranger") { cmd2.ExecuteNonQuery(); agent.Show(); this.Hide(); MessageBox.Show("Modification effectuez"); } else { cmd3.ExecuteNonQuery(); agent.Show(); this.Hide(); MessageBox.Show("Modification effectuez"); } } catch (Exception r) { MessageBox.Show(r.Message); } finally { ManipulationBD.DecoonectionDataBase(); } }
private void button1_Click(object sender, EventArgs e) { try { ManipulationBD.ConnectionDataBase(); RadioButton rb = null; for (int i = 0; i < groupBox1.Controls.Count; i++) { rb = (RadioButton)groupBox1.Controls[i]; // On sort dès qu'on trouve le bouton sélectionné if (rb.Checked) { break; } } string Tunisien = "delete from client where code_client=?"; string Etranger = "delete from client where code_client=?"; string Entreprise = "delete from client where code_client=?"; string strverif = "select count(*) from client where code_client=?"; MySqlCommand cmd1 = new MySqlCommand(Tunisien, ManipulationBD.Cnn); MySqlParameter p1 = new MySqlParameter("code_client", cd_client.Text); cmd1.Parameters.Add(p1); MySqlCommand cmd2 = new MySqlCommand(Etranger, ManipulationBD.Cnn); MySqlParameter p2 = new MySqlParameter("code_client", cd_client.Text); cmd2.Parameters.Add(p2); MySqlCommand cmd3 = new MySqlCommand(Entreprise, ManipulationBD.Cnn); MySqlParameter p3 = new MySqlParameter("code_client", cd_client.Text); cmd3.Parameters.Add(p3); MySqlCommand verif = new MySqlCommand(strverif, ManipulationBD.Cnn); MySqlParameter par = new MySqlParameter("par", cd_client.Text); verif.Parameters.Add(par); long n = (long)verif.ExecuteScalar(); if (n > 0) { if (rb.Text == "Tunisien") { cmd1.ExecuteNonQuery(); MessageBox.Show("Suppression effectuez"); } else if (rb.Text == "Etranger") { cmd2.ExecuteNonQuery(); MessageBox.Show("Suppression effectuez"); } else { cmd3.ExecuteNonQuery(); MessageBox.Show("Suppression effectuez"); } } else { MessageBox.Show("Suppression Impossible car Il n'existe pas !"); } } catch (Exception r) { MessageBox.Show(r.Message); } finally { ManipulationBD.DecoonectionDataBase(); } }
private void button1_Click(object sender, EventArgs e) { try { ManipulationBD.ConnectionDataBase(); RadioButton rb = null; for (int i = 0; i < groupBox1.Controls.Count; i++) { rb = (RadioButton)groupBox1.Controls[i]; // On sort dès qu'on trouve le bouton sélectionné if (rb.Checked) { break; } } if (textBox1.Text == "") { MessageBox.Show(" Champ vide !!"); } else if (textBox2.Text == "") { MessageBox.Show(" Champ vide !! "); } else if (textBox3.Text == "") { MessageBox.Show(" Champ vide !! "); } else if (textBox4.Text == "") { MessageBox.Show(" Champ vide !! "); } else if (textBox5.Text == "") { MessageBox.Show(" Champ vide !! "); } else if (textBox6.Text == "") { MessageBox.Show(" Champ vide !! "); } else if (textBox7.Text == "") { MessageBox.Show(" Champ vide !! "); } else if (textBox8.Text == "") { MessageBox.Show(" Champ vide !! "); } else { string Insertion1 = "update contrat set Numero_Contrat=?,Numero_Chassis=?,Numero=?,Code_Client=?,Montant_Avance=?,Date_Debut_Loc=?,Date_Retour_prev=?,Chauffeur=?,Valeur_Compteur_Km=?,Valeur_Compteur_Heure=? where Numero_Contrat=?"; string strverif = "select count(*) from contrat where Numero_Contrat=?"; MySqlCommand cmd1 = new MySqlCommand(Insertion1, ManipulationBD.Cnn); MySqlParameter p1 = new MySqlParameter("p1", textBox1.Text); cmd1.Parameters.Add(p1); MySqlParameter p2 = new MySqlParameter("p2", textBox4.Text); cmd1.Parameters.Add(p2); MySqlParameter p3 = new MySqlParameter("p3", textBox2.Text); cmd1.Parameters.Add(p3); MySqlParameter p4 = new MySqlParameter("p4", textBox5.Text); cmd1.Parameters.Add(p4); MySqlParameter p5 = new MySqlParameter("p5", textBox3.Text); cmd1.Parameters.Add(p5); MySqlParameter p6 = new MySqlParameter("p6", dateTimePicker1.Text); cmd1.Parameters.Add(p6); MySqlParameter p7 = new MySqlParameter("p7", dateTimePicker2.Text); cmd1.Parameters.Add(p7); MySqlParameter p8 = new MySqlParameter("p8", rb.Text); cmd1.Parameters.Add(p8); MySqlParameter p9 = new MySqlParameter("p9", textBox6.Text); cmd1.Parameters.Add(p9); MySqlParameter p10 = new MySqlParameter("p10", textBox8.Text); cmd1.Parameters.Add(p10); MySqlParameter p11 = new MySqlParameter("p11", textBox7.Text); cmd1.Parameters.Add(p11); MySqlCommand verif = new MySqlCommand(strverif, ManipulationBD.Cnn); MySqlParameter p16 = new MySqlParameter("p16", textBox1.Text); verif.Parameters.Add(p16); long n = (long)verif.ExecuteScalar(); if (n == 1) { cmd1.ExecuteNonQuery(); MessageBox.Show("Modification effectuez"); } else { MessageBox.Show("Modification Impossible car cet Contrat n'existe pas"); } } } catch (Exception r) { MessageBox.Show(r.Message); } finally { ManipulationBD.DecoonectionDataBase(); } }