public void SupprimerLigneFacture()
{
if (dataGridView1.Rows.Count == 0)
{
MessageBox.Show("Liste vide!", "Erreur", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else
{
DialogResult rsl = MessageBox.Show("Voulez-vous vraiment éliminer ce produit de la facture?", "Supprimer Produit", MessageBoxButtons.YesNo);
if (rsl == DialogResult.Yes)
{
int numero_ligneFacture = Convert.ToInt16(dataGridView1.CurrentRow.Cells[0].Value.ToString());
LigneFacture L = new LigneFacture(numero_ligneFacture);
L.SupprimerLigneFacture();
this.lignefactureTableAdapter.Fill(this.gestioncommercialeDataSet1.lignefacture);
Selection();
}
}
}
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);
label1.ForeColor = Color.Black;
label2.ForeColor = Color.Black;
if (textBox2.Text == "")
{
label7.ForeColor = Color.Red;
}
if (textBox7.Text == "")
{
label8.ForeColor = Color.Red;
}
}
else
{
Produit_codeProduit = textBox2.Text;
// string libelle_produit;
//double TVA_produit;
//double remise_produit;
quantite = Convert.ToInt16(textBox7.Text);
montant_Produit = quantite * prix_vente_produit;
LigneFacture L = new LigneFacture(numero_ligneFacture);
L.ModifierLigneFacture(Produit_codeProduit, quantite, montant_Produit, Facture_numeroFacture);
this.lignefactureTableAdapter.Fill(this.gestioncommercialeDataSet1.lignefacture);
textBox2.Text = "";
textBox7.Text = "";
panel1.Visible = false;
Selection();
}
}
private void pictureBox1_Click(object sender, EventArgs e)
{
if (textBox1.Text == "" || textBox8.Text == "")
{
MessageBox.Show("Vous devez remplir les champs vides!", "Champs vides", MessageBoxButtons.OK);
label1.ForeColor = Color.Black;
label2.ForeColor = Color.Black;
label9.ForeColor = Color.Black;
label4.ForeColor = Color.Black;
label5.ForeColor = Color.Black;
label6.ForeColor = Color.Black;
label8.ForeColor = Color.Black;
label9.ForeColor = Color.Black;
if (textBox1.Text == "")
{
label1.ForeColor = Color.Red;
}
if (textBox8.Text == "")
{
label9.ForeColor = Color.Red;
}
}
else
{
if (textBox5.Text == "")
{
textBox5.Text = "0";
}
if (textBox6.Text == "")
{
textBox6.Text = "0";
}
int numero_Facture = Convert.ToInt16(textBox1.Text);
string date_Facture = dateTimePicker1.Value.ToString("dd / MM / yyyy");
double timbre_Facture = Convert.ToDouble(textBox5.Text);
double remise_Facture = Convert.ToDouble(textBox6.Text);
double montantHT_Facture = Convert.ToDouble(textBox3.Text);
double montantTTC_Facture = Convert.ToDouble(textBox4.Text);
int Client_codeClient = Convert.ToInt16(textBox8.Text);
string statut_Facture;
if (radioButton1.Checked == true)
{
statut_Facture = radioButton1.Text;
}
else
{
statut_Facture = radioButton2.Text;
}
Facture F = new Facture(numero_Facture, date_Facture, timbre_Facture, remise_Facture, montantHT_Facture, montantTTC_Facture, statut_Facture, Client_codeClient);
F.creerFacture();
f.factureTableAdapter.Fill(f.gestioncommercialeDataSet1.facture);
for (int i = 0; i < dataGridView1.Rows.Count; i++)
{
//numero_ligneFacture : numero de la ligne_factue dans la base
string MyConString = "SERVER=localhost;" + "DATABASE=gestioncommerciale;" + "UID=root;" + "PASSWORD=freedomity;";
MySqlConnection connection = new MySqlConnection(MyConString);
MySqlCommand cmd = connection.CreateCommand();
cmd.CommandText = "select count(*) from lignefacture"; //where Facture_numeroFacture = " + Facture_numeroFacture;
connection.Open();
int num = Convert.ToInt32(cmd.ExecuteScalar());
connection.Close();
if (num != 0)
{
cmd.CommandText = "select max(numero_ligneFacture) from lignefacture;"; //where Facture_numeroFacture = " + Facture_numeroFacture;
connection.Open();
numero_ligneFacture = Convert.ToInt32(cmd.ExecuteScalar()) + 1;
connection.Close();
}
else
{
numero_ligneFacture = 1;
}
dataGridView1.Rows[i].Cells[8].Value = numero_ligneFacture;
numero_ligneFacture = Convert.ToInt16(dataGridView1.Rows[i].Cells[8].Value);
Produit_codeProduit = dataGridView1.Rows[i].Cells[1].Value.ToString();
quantite = Convert.ToInt16(dataGridView1.Rows[i].Cells[6].Value);
montant_Produit = Convert.ToDouble(dataGridView1.Rows[i].Cells[7].Value);
Facture_numeroFacture = numero_Facture;
LigneFacture L = new LigneFacture(numero_ligneFacture, Produit_codeProduit, quantite, montant_Produit, Facture_numeroFacture);
L.AjouterLigneFacture();
}
//this.lignefactureTableAdapter.Fill(this.gestioncommercialeDataSet1.lignefacture);
Hide();
ac.Enabled = true;
}
}
private void pictureBox6_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
{
//numero_ligneFacture
int numero_ligneFacture;
if (dataGridView1.Rows.Count == 0)
{
numero_ligneFacture = 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(numero_ligneFacture) from lignefacture";
connection.Open();
numero_ligneFacture = Convert.ToInt32(cmd.ExecuteScalar()) + 1;
connection.Close();
}
string Produit_codeProduit = textBox2.Text;
//selectionner le prix produit
string MyConString2 = "SERVER=localhost;" + "DATABASE=gestioncommerciale;" + "UID=root;" + "PASSWORD=freedomity;";
MySqlConnection connection2 = new MySqlConnection(MyConString2);
MySqlCommand cmd2 = connection2.CreateCommand();
cmd2.CommandText = "select prix_vente_produit from produit where code_produit ='" + Produit_codeProduit + "';";
connection2.Open();
prix_vente_produit = Convert.ToInt32(cmd2.ExecuteScalar());
connection2.Close();
//selectionner le TVA produit
cmd2.CommandText = "select TVA_produit from produit where code_produit ='" + Produit_codeProduit + "';";
connection2.Open();
TVA_produit = Convert.ToInt32(cmd2.ExecuteScalar());
connection2.Close();
//selectionner le remise produit
cmd2.CommandText = "select remise_produit from produit where code_produit ='" + Produit_codeProduit + "';";
connection2.Open();
remise_produit = Convert.ToInt32(cmd2.ExecuteScalar());
connection2.Close();
int quantite = Convert.ToInt16(textBox7.Text);
double montant_Produit = quantite * prix_vente_produit;
int Facture_numeroFacture = Convert.ToInt16(textBox1.Text);
//recuperer le montant HT de la facture
montantHT_Facture += montant_Produit;
textBox3.Text = montantHT_Facture.ToString();
//recuperer le montant TTC
montantTTC_Facture = montantHT_Facture + ((TVA_produit * montantHT_Facture) / 100);
textBox4.Text = montantTTC_Facture.ToString();
LigneFacture L = new LigneFacture(numero_ligneFacture, Produit_codeProduit, quantite, montant_Produit, Facture_numeroFacture);
L.AjouterLigneFacture();
this.lignefactureTableAdapter.Fill(this.gestioncommercialeDataSet1.lignefacture);
textBox2.Text = "";
textBox7.Text = "";
panel1.Visible = false;
Selection();
}
}