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); }