public Int32 DeleteData() { DB_PostgreSQL dataBase = new DB_PostgreSQL(); dataBase.ExecuteNonQuery("DELETE FROM \"Ar_Fac\" WHERE \"Code_Article\"='" + this.Code + "'"); return(dataBase.ExecuteNonQuery("DELETE FROM \"Articles\" WHERE \"Code\"='" + this.Code + "'")); }
private void Supprimer_Click(object sender, EventArgs e) { if (MessageBox.Show("Vous ete sure de vouloire Supprimer cette article de la Facture ?", "Attention", MessageBoxButtons.YesNo) == DialogResult.Yes) { int index = c1TrueDBGrid1.Row; string Code = c1TrueDBGrid1.Columns["Code_Article"].CellText(index); if (Code == null) { MessageBox.Show("Aucun Article selectionee"); return; } DB_PostgreSQL dataBase = new DB_PostgreSQL(); dataBase.ExecuteNonQuery("DELETE FROM \"Ar_Fac\" WHERE \"Code_Article\"='" + Code + "' AND \"Code_Facture\"='" + currentFacture.Code + "'"); DataSet ARFAC = dataBase.returnDataSet("SELECT \"Code_Article\",\"Libelle\",\"Quantite\",\"Operation\",\"Prix\" FROM \"Articles\",\"Ar_Fac\" WHERE \"Ar_Fac\".\"Code_Facture\"='" + currentFacture.Code + "' AND" + "\"Articles\".\"Code\"=\"Ar_Fac\".\"Code_Article\""); c1TrueDBGrid1.DataSource = ARFAC.Tables[0]; } }
private void Supprimer_Click(object sender, EventArgs e) { if (MessageBox.Show("Vous ete sure de vouloire Supprimer ceux Client ?", "Attention", MessageBoxButtons.YesNo) == DialogResult.Yes) { int index = c1TrueDBGrid1.Row; string Code = c1TrueDBGrid1.Columns["Code"].CellText(index); if (Code == null) { MessageBox.Show("Code Vide"); return; } DB_PostgreSQL dataBase = new DB_PostgreSQL(); dataBase.ExecuteNonQuery("DELETE FROM \"Facture\" Where \"Code_Client\"='" + Code + "'"); TB_Client Ar = new TB_Client(); Ar.FindByKey(Code); Ar.DeleteData(); GestionClient_Load(sender, e); } }
public void deleteData(string CodeFacture) { DB_PostgreSQL dataBase = new DB_PostgreSQL(); dataBase.ExecuteNonQuery("DELETE FROM \"Ar_Fac\" Where \"Code_Facture\"='" + CodeFacture + "'"); }
public Int32 DeleteData() { DB_PostgreSQL dataBase = new DB_PostgreSQL(); return(dataBase.ExecuteNonQuery("DELETE FROM \"User\" WHERE \"Login\"='" + this.Login + "'")); }