public static Boolean SupprimerDevis(string id)
{
foreach (Devis item in BDDExterne.GetAllDevis())
{
if (item.devId.ToString() == id)
{
NpgsqlConnection conn;
conn = new NpgsqlConnection(chaineConnection);
conn.Open();
NpgsqlCommand MyCmd = null;
// id, nom ,tel,numrue,codepostal,ville,pays,mail,nom rue
string query = @"DELETE FROM devis CASCADE WHERE id = '" + id + "'";
Debug.WriteLine(query);
MyCmd = new NpgsqlCommand(query, conn);
MyCmd.ExecuteNonQuery(); //Exécution
conn.Close();
return(true);
}
}
return(false);
}
