private void recupererPrix(string monID)
        {
            var filteredData = Modele.MaConnexion.FraisForfait.ToList()
                               .Where(x => x.id == monID);

            bsFrais.DataSource = filteredData;
            bsFrais.MoveFirst();
            FraisForfait fraisForfait = (FraisForfait)bsFrais.Current;

            if (monID == "NUI")
            {
                prixNUI = fraisForfait.montant.ToString();
                tbMontantNuitée.Text = prixNUI;
            }
            else if (monID == "REP")
            {
                prixREP = fraisForfait.montant.ToString();
                tbMontantRepasMidi.Text = prixREP;
            }
        }
 private void cbTypeVehicule_SelectedIndexChanged(object sender, EventArgs e)
 {
     if (cbTypeVehicule.Text == "4CV DIESEL")
     {
         var filteredData = Modele.MaConnexion.FraisForfait.ToList()
                            .Where(x => x.id == "4cD");
         bsKm.DataSource = filteredData;
         bsKm.MoveFirst();
         FraisForfait fraisForfait2 = (FraisForfait)bsKm.Current;
         tbMontantKilométrage.Text = fraisForfait2.montant.ToString();
     }
     if (cbTypeVehicule.Text == "5/6CV DIESEL")
     {
         var filteredData = Modele.MaConnexion.FraisForfait.ToList()
                            .Where(x => x.id == "5cD");
         bsKm.DataSource = filteredData;
         bsKm.MoveFirst();
         FraisForfait fraisForfait2 = (FraisForfait)bsKm.Current;
         tbMontantKilométrage.Text = fraisForfait2.montant.ToString();
     }
     if (cbTypeVehicule.Text == "4CV ESSENCE")
     {
         var filteredData = Modele.MaConnexion.FraisForfait.ToList()
                            .Where(x => x.id == "4cE");
         bsKm.DataSource = filteredData;
         bsKm.MoveFirst();
         FraisForfait fraisForfait2 = (FraisForfait)bsKm.Current;
         tbMontantKilométrage.Text = fraisForfait2.montant.ToString();
     }
     if (cbTypeVehicule.Text == "5/6CV ESSENCE")
     {
         var filteredData = Modele.MaConnexion.FraisForfait.ToList()
                            .Where(x => x.id == "5cE");
         bsKm.DataSource = filteredData;
         bsKm.MoveFirst();
         FraisForfait fraisForfait2 = (FraisForfait)bsKm.Current;
         tbMontantKilométrage.Text = fraisForfait2.montant.ToString();
     }
     textbox_Kilo_TextChanged(sender, e);
 }