private void button7_Click(object sender, EventArgs e) { #region Ajout try { string code_bordureauprixappro = textBox11.Text; double quantite = double.Parse(textBox2.Text); int n_attache = int.Parse(comboBox3.SelectedValue.ToString()); int n_prixappro = int.Parse(comboBox4.SelectedValue.ToString()); Bordereauprixappro p = new Bordereauprixappro(code_bordureauprixappro, n_attache, n_prixappro, quantite); p.Ajouter(); MessageBox.Show("Opération effectué", "Information", MessageBoxButtons.OK, MessageBoxIcon.Information); } catch (Exception ex) { MessageBox.Show("Erreur : " + ex.Message, "Exception", MessageBoxButtons.OK, MessageBoxIcon.Error); } #endregion }
private void button1_Click(object sender, EventArgs e) { #region Ajout try { string code_bordureauprixappro = textBoxA2.Text; double quantite = double.Parse(textBoxA4.Text); int n_attache = int.Parse(comboBoxA1.SelectedValue.ToString()); int n_prixappro = int.Parse(comboBoxA3.SelectedValue.ToString()); Bordereauprixappro p = new Bordereauprixappro(code_bordureauprixappro, n_attache, n_prixappro, quantite); p.Ajouter(); MessageBox.Show("Opération effectué", "Information", MessageBoxButtons.OK, MessageBoxIcon.Information); string r1 = "select PRIXAPPRO.[PX_N],PRIXAPPRO.[DESIG],PRIXAPPRO.UNITE_MESURE,BORDUREAUPRIXAPPRO.QUANTITE "; string r2 = "from PRIXAPPRO, BORDUREAUPRIXAPPRO "; string r3 = "where PRIXAPPRO.N_PRIXAPPRO = BORDUREAUPRIXAPPRO.N_PRIXAPPRO and BORDUREAUPRIXAPPRO.N_ATTACHE = " + comboBoxA1.SelectedValue.ToString(); string req = r1 + r2 + r3; Services.listViewremplissage(ref listView2, Services.executeQuery(req)); } catch (Exception ex) { MessageBox.Show("Erreur : " + ex.Message, "Exception", MessageBoxButtons.OK, MessageBoxIcon.Error); } #endregion }