private void pictureBox9_Click_1(object sender, EventArgs e) { if (textBox2.Text == "" || textBox7.Text == "") { MessageBox.Show("Vous devez remplir les champs vides!", "Champs vides", MessageBoxButtons.OK); label7.ForeColor = Color.Black; label8.ForeColor = Color.Black; if (textBox2.Text == "") { label7.ForeColor = Color.Red; } if (textBox7.Text == "") { label8.ForeColor = Color.Red; } } else { pr_code = textBox2.Text; pr_quantite = Convert.ToInt16(textBox7.Text); double prix_vente_produit = 0; pr_montant = pr_quantite * prix_vente_produit; LigneDevis L = new LigneDevis(num_ligne_devis); L.ld_modifier(dv_code, pr_code, pr_quantite, pr_montant); this.lignedevisTableAdapter.Fill(this.gestioncommercialeDataSet1.lignedevis); textBox2.Text = ""; textBox7.Text = ""; panel2.Visible = false; } }
private void pictureBox9_Click(object sender, EventArgs e) { if (textBox2.Text == "" || textBox7.Text == "") { MessageBox.Show("Vous devez remplir les champs vides!", "Champs vides", MessageBoxButtons.OK); label7.ForeColor = Color.Black; label8.ForeColor = Color.Black; if (textBox2.Text == "") { label7.ForeColor = Color.Red; } if (textBox7.Text == "") { label8.ForeColor = Color.Red; } } else { //numero_ligneDevis int num_ligne_devis; if (dataGridView1.Rows.Count == 0) { num_ligne_devis = 1; } else { string MyConString = "SERVER=localhost;" + "DATABASE=gestioncommerciale;" + "UID=root;" + "PASSWORD=freedomity;"; MySqlConnection connection = new MySqlConnection(MyConString); MySqlCommand cmd = connection.CreateCommand(); cmd.CommandText = "select max(num_ligne_devis) from lignedevis"; connection.Open(); num_ligne_devis = Convert.ToInt32(cmd.ExecuteScalar()) + 1; connection.Close(); } int dv_code = Convert.ToInt16(tbCodeDevis.Text); string pr_code = textBox2.Text; int pr_quantite = Convert.ToInt16(textBox7.Text); double prix_vente_produit = 0; double pr_montant = pr_quantite * prix_vente_produit; LigneDevis L = new LigneDevis(num_ligne_devis); L.ld_modifier(dv_code, pr_code, pr_quantite, pr_montant); this.lignedevisTableAdapter.Fill(this.gestioncommercialeDataSet1.lignedevis); textBox2.Text = ""; textBox7.Text = ""; panel2.Visible = false; } }