public ActionResult UpdateReservation2(Excursion.Portail.Models.ReservationModel2 reservation)
        {
            //if (ModelState.IsValid)
            //{
            Reservation reserv = reservationRepository.FindOne(x => x.ReservationID == reservation.ReservationID);

            // recherche SortieID
            string[] tab        = reservation.Sortie.Split("-".ToCharArray());
            float    hdp        = Convert.ToSingle(tab[3]);
            string   nom        = tab[0].ToString();
            string   typeexc    = tab[1].ToString();
            DateTime datesortie = Convert.ToDateTime(tab[5]);

            if (MvcGlobalisationSupport.CultureManager.GetLanguage() == "fr")
            {
                SortieParSemaine sortie = sortieParSemaineRepository.FindOne(x => x.HeureDepart == hdp && x.Excursion.Nom_fr == nom && x.Jour.Date == datesortie && x.TypeExc.Type == typeexc && x.Excursion.CentreID == SessionData.CurrentUser.CentreID);
                reserv.SortieID = sortie.SortieID;
            }
            else if (MvcGlobalisationSupport.CultureManager.GetLanguage() == "de")
            {
                SortieParSemaine sortie = sortieParSemaineRepository.FindOne(x => x.HeureDepart == hdp && x.Excursion.Nom_de == nom && x.Jour.Date == datesortie && x.TypeExc.Type == typeexc && x.Excursion.CentreID == SessionData.CurrentUser.CentreID);
                reserv.SortieID = sortie.SortieID;
            }
            else if (MvcGlobalisationSupport.CultureManager.GetLanguage() == "en")
            {
                SortieParSemaine sortie = sortieParSemaineRepository.FindOne(x => x.HeureDepart == hdp && x.Excursion.Nom_en == nom && x.Jour.Date == datesortie && x.TypeExc.Type == typeexc && x.Excursion.CentreID == SessionData.CurrentUser.CentreID);
                reserv.SortieID = sortie.SortieID;
            }
            else if (MvcGlobalisationSupport.CultureManager.GetLanguage() == "it")
            {
                SortieParSemaine sortie = sortieParSemaineRepository.FindOne(x => x.HeureDepart == hdp && x.Excursion.Nom_it == nom && x.Jour.Date == datesortie && x.TypeExc.Type == typeexc && x.Excursion.CentreID == SessionData.CurrentUser.CentreID);
                reserv.SortieID = sortie.SortieID;
            }


            reserv.DateModification = DateTime.Now.Date;
            reserv.HotelID          = hotelRepository.FindOne(x => x.Nom == reservation.Hotel && x.Region.Zone.CentreID == SessionData.CurrentUser.CentreID).HotelID;

            reserv.Etat = "M";

            reserv.LangueID    = langueRepository.FindOne(x => x.NomLangue == reservation.Langue).LangueID;
            reserv.NumTicket   = reservation.NumTicket;
            reserv.PointDepart = reservation.PointDepart;
            reserv.NbreAdultes = reservation.NbreAdultes;
            reserv.NbreEnfants = reservation.NbreEnfants;
            reserv.NbreBebes   = reservation.NbreBebes;
            reserv.Observation = reservation.Observation;
            reserv.NumChamb    = reservation.NumChamb.ToString();
            if ((bool)reservation.Paye)
            {
                reserv.Paye         = reservation.Paye;
                reserv.DatePayement = DateTime.Now.Date;
            }
            reservationRepository.Update(reserv);
            reservationRepository.Save();
            //}
            return(RedirectToAction("Index"));
        }