private void txtAnnuler_Click(object sender, EventArgs e) { Ajout f1 = new Ajout(reef, idClient); this.Dispose(); f1.ShowDialog(); }
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 btnValider_Click(object sender, EventArgs e) { bl = new BALLigCmd(); dl = new LigCmd(); /* dl.NumCmd = Int32.Parse(reef); * dl.CodeProduit = txtProduit.Text; * dl.Qte = Int32.Parse(txtQte.Text); * dl.Prix = Int32.Parse(txtPrix.Text);*/ OleDbConnection ccn = new OleDbConnection(); ccn = Global.seConnecter(Global.cs); string codeprd = "'" + txtProduit.Text + "'"; Global.ExecuterOleDbAction(@"update LigCmd set LigCmd.Qte = " + Int32.Parse(txtQte.Text) + ", LigCmd.Prix = " + Int32.Parse(txtPrix.Text) + " where LigCmd.CodeProduit = " + codeprd + " and LigCmd.NumCmd = " + Int32.Parse(reef), ccn); Global.seDeconnecter(ccn); Ajout f1 = new Ajout(reef, idClient); OleDbConnection cn = new OleDbConnection(); OleDbDataReader lect; cn = Global.seConnecter(Global.cs); lect = Global.ExecuterOleDBSelect(@"select * from Client where NumClient =" + idClient, 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(); this.Dispose(); f1.ShowDialog(); }
private void btnValider_Click(object sender, EventArgs e) { int res; bl = new BALLigCmd(); dl = new LigCmd(); dl.NumCmd = Int32.Parse(reef); dl.CodeProduit = txtProduit.Text; dl.Qte = Int32.Parse(txtQte.Text); dl.Prix = Int32.Parse(txtPrix.Text); res = bl.AjouterLigCmd(dl); if (res == 1) { Ajout f1 = new Ajout(reef, idClient); OleDbConnection cn = new OleDbConnection(); OleDbDataReader lect; cn = Global.seConnecter(Global.cs); lect = Global.ExecuterOleDBSelect(@"select * from Client where NumClient =" + idClient, 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(); this.Dispose(); f1.ShowDialog(); } else { MessageBox.Show("Echec Ajout de Ligne Comm."); } }
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 btnValider_Click(object sender, EventArgs e) { if (gridClient.SelectedRows.Count == 1) { string IdClient = gridClient.SelectedRows[0].Cells[0].Value.ToString(); Ajout f1 = new Ajout(ch1, IdClient); f1.txtClient.Text = gridClient.SelectedRows[0].Cells[1].Value.ToString(); f1.txtRue.Text = gridClient.SelectedRows[0].Cells[2].Value.ToString(); f1.txtVille.Text = gridClient.SelectedRows[0].Cells[3].Value.ToString(); f1.txtCodePostal.Text = gridClient.SelectedRows[0].Cells[4].Value.ToString(); f1.txtTel.Text = gridClient.SelectedRows[0].Cells[5].Value.ToString(); this.Dispose(); f1.ShowDialog(); } else { MessageBox.Show("Selectionner le client souhaiter" + "\n" + "Selectionner la ligne entiere.", "Erreur de selection", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } }