public ActionResult Create(int SortieID, string HotelName, string LanguageName, string Etat, Reservation model)
        {
            //Reserv.Data.Excursion excr = ExcursionRepository
            try
            {
                Excursion.Data.Reservation reserv = new Reservation();

                reserv.SortieID   = SortieID;
                reserv.DateReserv = DateTime.Now.Date;
                reserv.NumChamb   = model.NumChamb;

                Excursion.Data.Hotel hotel = hotelRepository.FindOne(x => x.Nom == HotelName);
                reserv.HotelID = hotel.HotelID;

                if (SessionData.CurrentUser.TypeUser == "Client")
                {
                    reserv.TypeClient = SessionData.CurrentUser.TypeUser;
                }
                else if (SessionData.CurrentUser.TypeUser == "Client Indirect")
                {
                    reserv.TypeClient = SessionData.CurrentUser.TypeCIndirect;
                }

                reserv.UserID = SessionData.CurrentUser.UserID;

                if (LanguageName == "Eng")
                {
                    reserv.LangueID = 1;
                }
                else if (LanguageName == "Fr")
                {
                    reserv.LangueID = 2;
                }
                else if (LanguageName == "Deu")
                {
                    reserv.LangueID = 3;
                }
                else if (LanguageName == "Ara")
                {
                    reserv.LangueID = 4;
                }

                if (reserv.Etat == "No Modification No Cancellation")
                {
                    reserv.Etat = "N";
                }
                else if (reserv.Etat == "Canceled")
                {
                    reserv.Etat = "C";
                }
                else if (reserv.Etat == "Modified")
                {
                    reserv.Etat = "M";
                }

                reserv.Observation    = model.Observation;
                reserv.DateAnnulation = model.DateAnnulation;

                reserv.NumTicket = model.NumTicket;

                reserv.PointDepart      = model.PointDepart;
                reserv.DateModification = model.DateModification;
                reserv.NbreAdultes      = model.NbreAdultes;
                reserv.NbreBebes        = model.NbreBebes;
                reserv.NbreEnfants      = model.NbreEnfants;

                reserv.Reduction    = model.Reduction;
                reserv.Paye         = model.Paye;
                reserv.DatePayement = model.DatePayement;

                reservationRepository.Add(reserv);
                reservationRepository.Save();
                ViewBag.AjoutSuccess = "Reservation added successfully";
            }
            catch (DbEntityValidationException ex)
            {
            }

            #region SelectList
            var SysLst = new List <string>();
            var SysQry = from d in hotelRepository.FindMany(x => x.Region.Zone.CentreID == SessionData.CurrentUser.CentreID)
                         select d.Nom;
            SysLst.AddRange(SysQry.Distinct());
            ViewBag.Hotel = new SelectList(SysLst);


            var SysLst1 = new List <string>();
            var SysQry1 = from b in langueRepository.GetAll()
                          select b.NomLangue;
            SysLst1.AddRange(SysQry1.Distinct());
            ViewBag.Lang = new SelectList(SysLst1);

            var SysLst2 = new List <string>();
            SysLst2.Add("Canceled");
            SysLst2.Add("No Modification No Cancellation");
            SysLst2.Add("Modified");
            ViewBag.Etatres = new SelectList(SysLst2);

            var SysLst3 = new List <int>();
            SysLst3.Add(SortieID);
            ViewBag.Sortie = new SelectList(SysLst3);
            #endregion
            return(View());
        }