public static List <Devis> GetAllDevis()
{
NpgsqlConnection conn;
conn = new NpgsqlConnection(chaineConnection);
conn.Open();
List <Devis> listeDevis = new List <Devis>();
string query = @"SELECT id,status,date_creation,date_signature,date_facture,montant_facture,""id_Client"",""id_Salarie"" FROM ""devis""";
Debug.WriteLine(query);
NpgsqlCommand command = new NpgsqlCommand(query, conn);
NpgsqlDataReader dr = command.ExecuteReader();
while (dr.Read())
{
listeDevis.Add(new Devis(new Guid(dr[0].ToString()), Int32.Parse(dr[1].ToString()), DateTime.Parse(dr[2].ToString()), DateTime.Parse(dr[3].ToString()), DateTime.Parse(dr[4].ToString()), double.Parse(dr[5].ToString()), BDDExterne.GetClient(dr[6].ToString()), BDDExterne.GetSalarie(dr[7].ToString()), BDDExterne.GetModulesByDevis(dr[0].ToString())));
}
conn.Close();
return(listeDevis);
}
