ComboBoxDevis.Items.Clear();
            PanelDevis.Children.Clear();
            var price = 0;
            var nbEstimate = 1;
            try
            {
                var oCommand = ConnectionOracle.OracleCommand(database, "SELECT DISTINCT NUMERODEVIS FROM DEVIS WHERE ID_CLIENT = :1");
                var paramIdClient = new OracleParameter(":1", OracleDbType.Int32) { Value = ((ComboboxItemClient)ComboBoxClient.SelectedItem).Value.id };

                oCommand.Parameters.Add(paramIdClient);
                database.Open();

                var resultat = oCommand.ExecuteReader();
                while(resultat.Read())
                {
                    var oCommand2 = ConnectionOracle.OracleCommand(database, "SELECT ID_MARCHANDISE, PRIXMARCHANDISE, QUANTITE, JOUR FROM DEVIS WHERE NUMERODEVIS = :1");
                    var paramNumeroDevis = new OracleParameter(":1", OracleDbType.Int32) { Value = resultat[0] };
                    oCommand2.Parameters.Add(paramNumeroDevis);
                    var resultat2 = oCommand2.ExecuteReader();
                    var listMarchandise = new List<Merchandise>();
                    var estimateClient = new Estimate(listMarchandise);
                    var merchandise = new Merchandise(0, null, 0, 0);
                    while(resultat2.Read())
                    {
                        var idMerchandise = Convert.ToInt32(resultat2[0]);
                        var priceMerchandise = Convert.ToInt32(resultat2[1]);
                        var quantity = Convert.ToInt32(resultat2[2]);
                        var day = Convert.ToDateTime(resultat2[3]);
                        merchandise.id = idMerchandise;
                        merchandise.prix = priceMerchandise;
                        merchandise.quantite = quantity;
                        estimate.date = day;
                        var oCommand3 = ConnectionOracle.OracleCommand(database, "SELECT NOM FROM MARCHANDISE WHERE ID_MARCHANDISE = :1");
                        var paramIdMarchandise = new OracleParameter(":1", OracleDbType.Int32) { Value = resultat2[0] };
                        oCommand3.Parameters.Add(paramIdMarchandise);
                        var resultat3 = oCommand3.ExecuteReader();
                        while (resultat3.Read())
                        {
                            merchandise.nom = resultat3[0].ToString();
                        }
                        listMarchandise.Add(merchandise);
                        price += priceMerchandise * quantity;
                    }
                    ComboBoxDevis.Items.Add(new ComboboxItemEstimate { Text = "Devis n°" + nbEstimate + " - " + price + "€", Value = estimateClient });
                    ((ComboboxItemClient)ComboBoxClient.SelectedItem).Value.listEstimate.Add(estimateClient);

                    nbEstimate++;
                    price = 0;
                }
                resultat.Close();
            }
            catch(Exception ex)
            {
                MessageBox.Show(ex.Message);
                return;
            }
            finally
            {
                database.Close();
            }

            BTN_Supprimer.Visibility = Visibility.Visible;
            PanelDevis.Children.Clear();