public void modifier()
{
if (dgvCommVente.Rows.Count == 0)
{
MessageBox.Show("Liste vide!", "Erreur", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else
{
int v_code = Convert.ToInt16(dgvCommVente.CurrentRow.Cells[0].Value.ToString());
int v_cl_code = Convert.ToInt16(dgvCommVente.CurrentRow.Cells[1].Value.ToString());
string v_statut = Convert.ToString(dgvCommVente.CurrentRow.Cells[2].Value.ToString());
String v_date = Convert.ToString(dgvCommVente.CurrentRow.Cells[3].Value.ToString());
String v_date_liv = Convert.ToString(dgvCommVente.CurrentRow.Cells[4].Value.ToString());
string v_adresse = Convert.ToString(dgvCommVente.CurrentRow.Cells[5].Value.ToString());
string v_ville = Convert.ToString(dgvCommVente.CurrentRow.Cells[6].Value.ToString());
int v_cp = Convert.ToInt32(dgvCommVente.CurrentRow.Cells[7].Value.ToString());
string v_pays = Convert.ToString(dgvCommVente.CurrentRow.Cells[8].Value.ToString());
int v_fixe = Convert.ToInt32(dgvCommVente.CurrentRow.Cells[9].Value.ToString());
int v_mobile = Convert.ToInt32(dgvCommVente.CurrentRow.Cells[10].Value.ToString());
int v_fax = Convert.ToInt32(dgvCommVente.CurrentRow.Cells[11].Value.ToString());
string v_email = Convert.ToString(dgvCommVente.CurrentRow.Cells[12].Value.ToString());
string v_sitew = Convert.ToString(dgvCommVente.CurrentRow.Cells[13].Value.ToString());
string v_note = Convert.ToString(dgvCommVente.CurrentRow.Cells[14].Value.ToString());
double v_frais = Convert.ToDouble(dgvCommVente.CurrentRow.Cells[15].Value.ToString());
CommandeVente cmv = new CommandeVente(v_code, v_cl_code, v_statut, v_date, v_date_liv, v_adresse, v_ville, v_cp, v_pays, v_fixe, v_mobile, v_fax, v_email, v_sitew, v_note, v_frais);
ModifierCommandeVente mcv = new ModifierCommandeVente(this, cmv, ac);
mcv.Show();
ac.Enabled = false;
}
}
public void supprimer()
{
if (dgvCommVente.Rows.Count == 0)
{
MessageBox.Show("Liste vide!", "Erreur", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else
{
DialogResult result = MessageBox.Show("Voulez-vous vraiment supprimer cette commande?", "Suppression!", MessageBoxButtons.YesNo);
if (result == DialogResult.Yes)
{
int v_code = Convert.ToInt32(dgvCommVente.CurrentRow.Cells[0].Value.ToString());
CommandeVente cmv = new CommandeVente(v_code);
cmv.cmv_supprimer();
this.commandeventeTableAdapter.Fill(this.gestioncommercialeDataSet1.commandevente);
MessageBox.Show("Commande supprimée!", "Suppression", MessageBoxButtons.OK);
}
}
}
public ModifierCommandeVente(CommandesVente cv, CommandeVente cv1,Accueil ac)
{
InitializeComponent();
this.cv = cv;
this.cv1 = cv1;
this.ac = ac;
ToolTip t = new ToolTip();
t.ShowAlways = true;
t.SetToolTip(tbCP, "Insertion des numéros uniquement.");
t.ShowAlways = true;
t.SetToolTip(tbFixe, "Insertion des numéros uniquement.");
t.ShowAlways = true;
t.SetToolTip(tbMobile, "Insertion des numéros uniquement.");
t.ShowAlways = true;
t.SetToolTip(tbFax, "Insertion des numéros uniquement.");
t.ShowAlways = true;
t.SetToolTip(textBox7, "Insertion des numéros uniquement.");
t.ShowAlways = true;
t.SetToolTip(tbFrais, "Insertion des numéros uniquement (Ex : 1,01).");
t.ShowAlways = true;
t.SetToolTip(pictureBox4, "Ajouter");
t.ShowAlways = true;
t.SetToolTip(pictureBox5, "Modifier");
t.ShowAlways = true;
t.SetToolTip(pictureBox8, "Supprimer");
}
public ModifierCommandeVente(CommandesVente cv, CommandeVente cv1, Accueil ac)
{
InitializeComponent();
this.cv = cv;
this.cv1 = cv1;
this.ac = ac;
ToolTip t = new ToolTip();
t.ShowAlways = true;
t.SetToolTip(tbCP, "Insertion des numéros uniquement.");
t.ShowAlways = true;
t.SetToolTip(tbFixe, "Insertion des numéros uniquement.");
t.ShowAlways = true;
t.SetToolTip(tbMobile, "Insertion des numéros uniquement.");
t.ShowAlways = true;
t.SetToolTip(tbFax, "Insertion des numéros uniquement.");
t.ShowAlways = true;
t.SetToolTip(textBox7, "Insertion des numéros uniquement.");
t.ShowAlways = true;
t.SetToolTip(tbFrais, "Insertion des numéros uniquement (Ex : 1,01).");
t.ShowAlways = true;
t.SetToolTip(pictureBox4, "Ajouter");
t.ShowAlways = true;
t.SetToolTip(pictureBox5, "Modifier");
t.ShowAlways = true;
t.SetToolTip(pictureBox8, "Supprimer");
}
public void modifier()
{
if (dgvCommVente.Rows.Count == 0)
MessageBox.Show("Liste vide!", "Erreur", MessageBoxButtons.OK, MessageBoxIcon.Error);
else
{
int v_code = Convert.ToInt16(dgvCommVente.CurrentRow.Cells[0].Value.ToString());
int v_cl_code = Convert.ToInt16(dgvCommVente.CurrentRow.Cells[1].Value.ToString());
string v_statut = Convert.ToString(dgvCommVente.CurrentRow.Cells[2].Value.ToString());
String v_date = Convert.ToString(dgvCommVente.CurrentRow.Cells[3].Value.ToString());
String v_date_liv = Convert.ToString(dgvCommVente.CurrentRow.Cells[4].Value.ToString());
string v_adresse = Convert.ToString(dgvCommVente.CurrentRow.Cells[5].Value.ToString());
string v_ville = Convert.ToString(dgvCommVente.CurrentRow.Cells[6].Value.ToString());
int v_cp = Convert.ToInt32(dgvCommVente.CurrentRow.Cells[7].Value.ToString());
string v_pays = Convert.ToString(dgvCommVente.CurrentRow.Cells[8].Value.ToString());
int v_fixe = Convert.ToInt32(dgvCommVente.CurrentRow.Cells[9].Value.ToString());
int v_mobile = Convert.ToInt32(dgvCommVente.CurrentRow.Cells[10].Value.ToString());
int v_fax = Convert.ToInt32(dgvCommVente.CurrentRow.Cells[11].Value.ToString());
string v_email = Convert.ToString(dgvCommVente.CurrentRow.Cells[12].Value.ToString());
string v_sitew = Convert.ToString(dgvCommVente.CurrentRow.Cells[13].Value.ToString());
string v_note = Convert.ToString(dgvCommVente.CurrentRow.Cells[14].Value.ToString());
double v_frais = Convert.ToDouble(dgvCommVente.CurrentRow.Cells[15].Value.ToString());
CommandeVente cmv = new CommandeVente(v_code, v_cl_code, v_statut, v_date, v_date_liv, v_adresse, v_ville, v_cp, v_pays, v_fixe, v_mobile, v_fax, v_email, v_sitew, v_note, v_frais);
ModifierCommandeVente mcv = new ModifierCommandeVente(this, cmv,ac);
mcv.Show();
ac.Enabled = false;
}
}
public void supprimer()
{
if (dgvCommVente.Rows.Count == 0)
MessageBox.Show("Liste vide!", "Erreur", MessageBoxButtons.OK, MessageBoxIcon.Error);
else
{
DialogResult result = MessageBox.Show("Voulez-vous vraiment supprimer cette commande?", "Suppression!", MessageBoxButtons.YesNo);
if (result == DialogResult.Yes)
{
int v_code = Convert.ToInt32(dgvCommVente.CurrentRow.Cells[0].Value.ToString());
CommandeVente cmv = new CommandeVente(v_code);
cmv.cmv_supprimer();
this.commandeventeTableAdapter.Fill(this.gestioncommercialeDataSet1.commandevente);
MessageBox.Show("Commande supprimée!", "Suppression", MessageBoxButtons.OK);
}
}
}
private void pictureBox1_Click(object sender, EventArgs e)
{
try
{
string cmv_adresse, cmv_ville, cmv_pays, cmv_email, cmv_sitew, cmv_note, cmv_date, cmv_statut, cmv_date_liv;
int cmv_code, cl_code, cmv_cp, cmv_fixe, cmv_mobile, cmv_fax;
double cmv_frais;
if (tbCodeCommV.Text == "" || tbCodeClient.Text == "")
{
MessageBox.Show("Veuillez remplir tous les champs nécessaires .", "Erreur", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
lComm.ForeColor = Color.Black;
lClient.ForeColor = Color.Black;
if (tbCodeCommV.Text == "")
{
lComm.ForeColor = Color.Red;
}
if (tbCodeClient.Text == "")
{
lClient.ForeColor = Color.Red;
}
}
else
{
if (tbCP.Text == "")
{
cmv_cp = 0;
}
else
{
cmv_cp = Convert.ToInt32(tbCP.Text);
}
if (tbFixe.Text == "")
{
cmv_fixe = 0;
}
else
{
cmv_fixe = Convert.ToInt32(tbFixe.Text);
}
if (tbMobile.Text == "")
{
cmv_mobile = 0;
}
else
{
cmv_mobile = Convert.ToInt32(tbMobile.Text);
}
if (tbFax.Text == "")
{
cmv_fax = 0;
}
else
{
cmv_fax = Convert.ToInt32(tbFax.Text);
}
if (tbFrais.Text == "")
{
cmv_frais = 0;
}
else
{
cmv_frais = Convert.ToDouble(tbFrais.Text);
}
cmv_code = Convert.ToInt32(tbCodeCommV.Text);
cl_code = Convert.ToInt32(tbCodeClient.Text);
cmv_adresse = rtbAdresse.Text;
cmv_ville = tbVille.Text;
cmv_pays = tbPays.Text;
cmv_email = tbEmail.Text;
cmv_sitew = tbSitew.Text;
cmv_note = rtbNote.Text;
cmv_date = dtpCommV.Value.ToString("dd / MM / yyyy");
cmv_date_liv = dtpLiv.Value.ToString("dd / MM / yyyy");
cmv_statut = "Active";
CommandeVente cmv = new CommandeVente(cmv_code, cl_code, cmv_statut, cmv_date, cmv_date_liv, cmv_adresse, cmv_ville, cmv_cp, cmv_pays, cmv_fixe, cmv_mobile, cmv_fax, cmv_email, cmv_sitew, cmv_note, cmv_frais);
cmv.cmv_ajouter();
cv.commandeventeTableAdapter.Fill(cv.gestioncommercialeDataSet1.commandevente);
for (int i = 0; i < dataGridView1.Rows.Count; i++)
{
string MyConString = "SERVER=localhost;" + "DATABASE=gestioncommerciale;" + "UID=root;" + "PASSWORD=freedomity;";
MySqlConnection connection = new MySqlConnection(MyConString);
MySqlCommand cmd = connection.CreateCommand();
cmd.CommandText = "select count(*) from lignecommandevente";
connection.Open();
int num = Convert.ToInt32(cmd.ExecuteScalar());
connection.Close();
if (num != 0)
{
cmd.CommandText = "select max(num_ligne_commande) from lignecommandevente;";
connection.Open();
num_ligne_commande = Convert.ToInt32(cmd.ExecuteScalar()) + 1;
connection.Close();
}
else
{
num_ligne_commande = 1;
}
dataGridView1.Rows[i].Cells[8].Value = num_ligne_commande;
num_ligne_commande = Convert.ToInt16(dataGridView1.Rows[i].Cells[8].Value);
pr_code = dataGridView1.Rows[i].Cells[1].Value.ToString();
pr_quantite = Convert.ToInt16(dataGridView1.Rows[i].Cells[6].Value);
pr_montant = Convert.ToDouble(dataGridView1.Rows[i].Cells[7].Value);
LigneCommandeVente L = new LigneCommandeVente(num_ligne_commande, cmv_code, pr_code, pr_quantite, pr_montant);
L.lcmv_ajouter();
}
Hide();
cv.Enabled = true;
}
}
catch (FormatException)
{
MessageBox.Show("Erreur!", "Erreur", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
}
}
private void pictureBox1_Click(object sender, EventArgs e)
{
try
{
string cmv_adresse, cmv_ville, cmv_pays, cmv_email, cmv_sitew, cmv_note, cmv_date, cmv_statut, cmv_date_liv;
int cmv_code, cl_code, cmv_cp, cmv_fixe, cmv_mobile, cmv_fax;
double cmv_frais;
if(tbCodeCommV.Text == "" || tbCodeClient.Text == "")
{
MessageBox.Show("Veuillez remplir tous les champs nécessaires .", "Erreur", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
lComm.ForeColor = Color.Black;
lClient.ForeColor = Color.Black;
if (tbCodeCommV.Text == "")
{
lComm.ForeColor = Color.Red;
}
if (tbCodeClient.Text == "")
{
lClient.ForeColor = Color.Red;
}
}
else
{
if (tbCP.Text == "")
cmv_cp = 0;
else
cmv_cp = Convert.ToInt32(tbCP.Text);
if (tbFixe.Text == "")
cmv_fixe = 0;
else
cmv_fixe = Convert.ToInt32(tbFixe.Text);
if (tbMobile.Text == "")
cmv_mobile = 0;
else
cmv_mobile = Convert.ToInt32(tbMobile.Text);
if (tbFax.Text == "")
cmv_fax = 0;
else
cmv_fax = Convert.ToInt32(tbFax.Text);
if (tbFrais.Text == "")
cmv_frais = 0;
else
cmv_frais = Convert.ToDouble(tbFrais.Text);
cmv_code = Convert.ToInt32(tbCodeCommV.Text);
cl_code = Convert.ToInt32(tbCodeClient.Text);
cmv_adresse = rtbAdresse.Text;
cmv_ville = tbVille.Text;
cmv_pays = tbPays.Text;
cmv_email = tbEmail.Text;
cmv_sitew = tbSitew.Text;
cmv_note = rtbNote.Text;
cmv_date = dtpCommV.Value.ToString("dd / MM / yyyy");
cmv_date_liv = dtpLiv.Value.ToString("dd / MM / yyyy");
cmv_statut = "Active";
CommandeVente cmv = new CommandeVente(cmv_code, cl_code, cmv_statut, cmv_date, cmv_date_liv, cmv_adresse, cmv_ville, cmv_cp, cmv_pays, cmv_fixe, cmv_mobile, cmv_fax, cmv_email, cmv_sitew, cmv_note, cmv_frais);
cmv.cmv_ajouter();
cv.commandeventeTableAdapter.Fill(cv.gestioncommercialeDataSet1.commandevente);
for (int i = 0; i < dataGridView1.Rows.Count; i++)
{
string MyConString = "SERVER=localhost;" + "DATABASE=gestioncommerciale;" + "UID=root;" + "PASSWORD=freedomity;";
MySqlConnection connection = new MySqlConnection(MyConString);
MySqlCommand cmd = connection.CreateCommand();
cmd.CommandText = "select count(*) from lignecommandevente";
connection.Open();
int num = Convert.ToInt32(cmd.ExecuteScalar());
connection.Close();
if (num != 0)
{
cmd.CommandText = "select max(num_ligne_commande) from lignecommandevente;";
connection.Open();
num_ligne_commande = Convert.ToInt32(cmd.ExecuteScalar()) + 1;
connection.Close();
}
else
{
num_ligne_commande = 1;
}
dataGridView1.Rows[i].Cells[8].Value = num_ligne_commande;
num_ligne_commande = Convert.ToInt16(dataGridView1.Rows[i].Cells[8].Value);
pr_code = dataGridView1.Rows[i].Cells[1].Value.ToString();
pr_quantite = Convert.ToInt16(dataGridView1.Rows[i].Cells[6].Value);
pr_montant = Convert.ToDouble(dataGridView1.Rows[i].Cells[7].Value);
LigneCommandeVente L = new LigneCommandeVente(num_ligne_commande, cmv_code, pr_code, pr_quantite, pr_montant);
L.lcmv_ajouter();
}
Hide();
cv.Enabled = true;
}
}
catch (FormatException)
{
MessageBox.Show("Erreur!", "Erreur", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
}
}