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 + "'"));
}
