private void btnValider_Click(object sender, EventArgs e)
{
string idClient1 = idClient;
int res;
bl = new BALCommande();
dl = new Commande();
bl.deleteCommande(ch1);
dl.NumCmd = Int32.Parse(ch1);
dl.DateCmd = dateCom.Text;
dl.NumClient = Int32.Parse(idClient1);
res = bl.AjouterCommande(dl);
if (res == 1)
{
MessageBox.Show("Succès Ajout de nouveau commande.");
Form1 f1 = new Form1();
this.Dispose();
f1.ShowDialog();
}
else
{
MessageBox.Show("Echec Ajout de nouveau client.");
}
}
private void ValiderLigneCmd_Click(object sender, EventArgs e)
{
DAL.Commande cmd = new DAL.Commande(RefCmdTextBoxAjoutCmd.Text, Int32.Parse(idclient.Text), DateAjoutCmd.Value.ToString());
if (BALCommande.checkCmd(cmd.NumCmd))
{
for (int i = 0; i < nbrLigCmd; i++)
{
BALLignecmd.deleteLigCmd(cmd.NumCmd);
}
BALCommande.deleteCmd(cmd.NumCmd);
}
BALCommande.addCommande(cmd);
if (LignesCmdGrid.Rows.Count > 0)
{
for (int i = 0; i < LignesCmdGrid.Rows.Count; i++)
{
DAL.Lignecmd l = new DAL.Lignecmd(
LignesCmdGrid.Rows[i].Cells[0].Value.ToString(),
RefCmdTextBoxAjoutCmd.Text,
Int32.Parse(LignesCmdGrid.Rows[i].Cells[2].Value.ToString()),
float.Parse(LignesCmdGrid.Rows[i].Cells[3].Value.ToString())
);
BALLignecmd.addLigneCmd(l);
}
BALCommande.remplirListeCommande(cmddgv);
this.Close();
}
}
private void btnAjouter_Click(object sender, EventArgs e)
{
string referance;
BAL.BALCommande bl;
bl = new BALCommande();
referance = (bl.getMaxRef() + 1).ToString();
Ajout f1 = new Ajout(referance, "");
f1.ShowDialog();
}
private void Supprimerbtn_Click(object sender, EventArgs e)
{
if (ListeCommandedgv.Rows.Count > 0)
{
for (int i = 0; i < ListeCommandedgv.Rows.Count; i++)
{
BALLignecmd.deleteLigCmd(ListeCommandedgv.SelectedRows[0].Cells[0].Value.ToString());
}
BALCommande.deleteCmd(ListeCommandedgv.SelectedRows[0].Cells[0].Value.ToString());
BALCommande.remplirListeCommande(ListeCommandedgv);
ListeLigneCmddgv.Rows.Clear();
}
}
private void find()
{
TextBox[] info =
{
RechercheRef,
RechercheClientinput
};
DateTimePicker[] dates =
{
deb,
fin
};
BALCommande.rechercheCmd(ListeCommandedgv, info, dates);
}
private void gridList_CellClick(object sender, DataGridViewCellEventArgs e)
{
if (gridList.SelectedRows.Count == 1)
{
string IdCom = gridList.SelectedRows[0].Cells[0].Value.ToString();
OleDbConnection cn = new OleDbConnection();
cn = BAL.Global.seConnecter(BAL.Global.cs);
DAL.Commande Cd;
BAL.BALCommande Cb;
Cd = new Commande();
Cb = new BALCommande();
int id = Cb.getCommandbyId(Cd, IdCom);
string idclt = id.ToString();
BAL.BALClient bl;
OleDbDataReader lect;
lect = BAL.Global.ExecuterOleDBSelect(@"select * from Client where NumClient=" + idclt, cn);
while (lect.Read())
{
txtClient.Text = lect.GetValue(1).ToString();
txtAdresse.Text = lect.GetValue(2).ToString();
txtVille.Text = lect.GetValue(3).ToString();
txtCP.Text = lect.GetValue(4).ToString();
txtTel.Text = lect.GetValue(5).ToString();
}
BAL.Global.seDeconnecter(cn);
lect.Close();
}
else
{
txtClient.Text = "";
txtAdresse.Text = "";
txtVille.Text = "";
txtCP.Text = "";
txtTel.Text = "";
}
}
private void btnModifier_Click(object sender, EventArgs e)
{
if (gridList.SelectedRows.Count == 1)
{
string Idcmd = gridList.SelectedRows[0].Cells[0].Value.ToString();
bl = new BALCommande();
dl = new Commande();
Ajout f1 = new Ajout(gridList.SelectedRows[0].Cells[0].Value.ToString(), bl.getCltbyIdcmd(Idcmd).ToString());
OleDbConnection cn = new OleDbConnection();
OleDbDataReader lect;
cn = Global.seConnecter(Global.cs);
lect = Global.ExecuterOleDBSelect(@"select * from Client where NumClient =" + Int32.Parse(bl.getCltbyIdcmd(Idcmd).ToString()), cn);
while (lect.Read())
{
f1.txtClient.Text = lect.GetValue(1).ToString();
f1.txtRue.Text = lect.GetValue(2).ToString();
f1.txtVille.Text = lect.GetValue(3).ToString();
f1.txtCodePostal.Text = lect.GetValue(4).ToString();
f1.txtTel.Text = lect.GetValue(5).ToString();
}
Global.seDeconnecter(cn);
lect.Close();
f1.ShowDialog();
}
else
{
MessageBox.Show("Selectionner le commande souhaiter" + "\n" + "Selectionner la ligne entiere.", "Erreur de selection", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
}
private void remplirListeCommandedgv()
{
BALCommande.remplirListeCommande(ListeCommandedgv);
}
