private void Dg_Prod_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
int index = e.RowIndex;
int refe = int.Parse(Dg_Prod.Rows[index].Cells[0].Value.ToString());
String desig = Dg_Prod.Rows[index].Cells[1].Value.ToString();
int prix = int.Parse(Dg_Prod.Rows[index].Cells[2].Value.ToString());
int qte = int.Parse(Dg_Prod.Rows[index].Cells[3].Value.ToString());
int total = int.Parse(Dg_Prod.Rows[index].Cells[4].Value.ToString());
LigneCommande lc = LigneCommandeADO.LigneCommande(refe);
if (lc != null)
{
lcSelected = lc;
Txt_Qte.Text = lc.Qte.ToString();
Commande cmd = CommandeADO.Recherche_Commande_Num_Cde(lc.NumCde);
if (cmd != null)
{
cmdSelected = cmd;
Txt_NumCde.Text = cmd.Num_Cde.ToString();
Date_Cde.Text = cmd.Date_Cde.ToString();
Client client = ClientADO.Recherche_cin(cmd.CIN_Cl);
if (client != null)
{
setClientFields(client);
clSelected = client;
}
}
Produit pr = ProduitADO.Recherche_Ref(lc.RefProd);
if (pr != null)
{
prSelected = pr;
}
}
}
private void Txt_NumCde_KeyPress(object sender, KeyPressEventArgs e)
{
if (Convert.ToInt32(e.KeyChar) == 13)
{
if (!string.IsNullOrEmpty(Txt_NumCde.Text))
{
int numCmd = int.Parse(Txt_NumCde.Text);
Commande cmd = CommandeADO.Recherche_Commande_Num_Cde(numCmd);
if (cmd != null)
{
cmdSelected = cmd;
Client cl = ClientADO.Recherche_cin(cmd.CIN_Cl);
if (cl != null)
{
clSelected = cl;
setClientFields(cl);
}
else
{
MessageBox.Show("Client introuvable");
}
}
else
{
Nouv_Cde_Click(sender, e);
}
}
else
{
MessageBox.Show("Entrer numero de commande");
}
}
}
private void Nouv_Lig_Click(object sender, EventArgs e)
{
if (!string.IsNullOrEmpty(Txt_NumCde.Text))
{
Commande cmd = CommandeADO.Recherche_Commande_Num_Cde(int.Parse(Txt_NumCde.Text));
if (cmd != null)
{
if (!string.IsNullOrEmpty(Txt_Qte.Text))
{
FListe_Prod fc = new FListe_Prod();
fc.ShowDialog();
if (FListe_Prod.produit != null)
{
prSelected = FListe_Prod.produit;
if (prSelected != null)
{
LigneCommande lc = new LigneCommande
{
NumCde = cmd.Num_Cde,
RefProd = prSelected.Ref_Prod,
Qte = int.Parse(Txt_Qte.Text)
};
LigneCommandeADO.Inserer(lc);
Affiche_Ligne_Commande();
Vider_Clt_Click(sender, e);
Vider_Cde_Click(sender, e);
lcSelected = null;
prSelected = null;
cmdSelected = null;
clSelected = null;
MessageBox.Show("Ligne Commande inserer");
}
else
{
MessageBox.Show("Sélectionner un produit");
}
}
else
{
MessageBox.Show("Sélectionner un produit");
}
}
else
{
MessageBox.Show("Inserer une qunatité");
}
}
else
{
MessageBox.Show("Inserer une commande");
}
}
else
{
MessageBox.Show("Inserer une commande");
}
}
private void Affiche_Ligne_Commande()
{
Txt_TotCde.Clear();
Dg_Prod.Rows.Clear();
List <LigneCommande> ligneCmd = LigneCommandeADO.Liste_LigneCommande();
if (ligneCmd != null)
{
long totalCmds = 0;
foreach (LigneCommande lc in ligneCmd)
{
Produit pd = ProduitADO.Recherche_Ref(lc.RefProd);
Commande cmd = CommandeADO.Recherche_Commande_Num_Cde(lc.NumCde);
// Ref ligcmd | design | prix | quantité | total
long totalCmd = pd.PrixV_Prod * lc.Qte;
totalCmds += totalCmd;
Dg_Prod.Rows.Add(cmd.Num_Cde, pd.Desig_Prod, pd.PrixV_Prod, lc.Qte, totalCmd);
}
Txt_TotCde.Text = totalCmds.ToString();
}
}
private void Nouv_Cde_Click(object sender, EventArgs e)
{
if (string.IsNullOrEmpty(Txt_NumCde.Text))
{
MessageBox.Show("Numero commande invalid");
}
else if (string.IsNullOrEmpty(Date_Cde.Value.Date.ToString()))
{
MessageBox.Show("Date commande invalid");
}
else
{
int numCmd = int.Parse(Txt_NumCde.Text);
DateTime dteCmd = Date_Cde.Value.Date;
Commande commande = CommandeADO.Recherche_Commande_Num_Cde(numCmd);
if (commande != null)
{
cmdSelected = commande;
Pan_LigC.Visible = true;
Txt_NumCde.Text = commande.Num_Cde.ToString();
Date_Cde.Value = commande.Date_Cde;
Client client = ClientADO.Recherche_cin(commande.CIN_Cl);
if (client != null)
{
setClientFields(client);
clSelected = client;
}
}
else
{
if (string.IsNullOrEmpty(Txt_Cin.Text))
{
MessageBox.Show("CIN client invalid");
}
else
{
int cin = int.Parse(Txt_Cin.Text);
Client cl = ClientADO.Recherche_cin(cin);
if (cl != null)
{
setClientFields(cl);
clSelected = cl;
Commande cmd = new Commande
{
Num_Cde = numCmd,
Date_Cde = dteCmd,
CIN_Cl = cin,
};
CommandeADO.Inserer(cmd);
Pan_LigC.Visible = true;
cmdSelected = cmd;
MessageBox.Show("Commande inserer");
}
else
{
MessageBox.Show("Client introuvable");
}
}
}
}
}