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;
}
}
