public ActionResult Ajouter(Excursion.Data.Hotel hotel, string NomRegion, string NbreEtoiles)
        {
            Excursion.Data.Hotel htl = new Data.Hotel();
            htl.CodeHotel  = hotel.CodeHotel;
            htl.Nom        = hotel.Nom;
            htl.NbrEtoiles = NbreEtoiles;

            //
            try
            {
                HttpPostedFileBase file      = Request.Files[0];
                byte[]             imageSize = new byte[file.ContentLength];
                file.InputStream.Read(imageSize, 0, (int)file.ContentLength);
                //
                string path = System.IO.Path.Combine(Server.MapPath("~/Images/Img/Hotel"), System.IO.Path.GetFileName(file.FileName));
                file.SaveAs(path);
                //
                htl.Photo = file.FileName.Split('\\').Last();
            }
            catch (Exception e)
            {
                ModelState.AddModelError("uploadError", e);
            }
            //

            htl.RegionID = regionRepository.FindOne(x => x.Nom == NomRegion).RegionID;
            hotelRepository.Add(htl);
            hotelRepository.Save();

            #region dropdownlist
            var SysLst = new List <string>();
            var SysQry = from b in regionRepository.FindMany(x => x.Zone.CentreID == SessionData.CurrentUser.CentreID)
                         select b.Nom;
            SysLst.AddRange(SysQry.Distinct());
            ViewBag.regionList = new SelectList(SysLst);

            var SysLst1 = new List <string>();
            SysLst1.Add("1 étoile"); SysLst1.Add("2 étoiles"); SysLst1.Add("3 étoiles"); SysLst1.Add("4 étoiles"); SysLst1.Add("5 étoiles");
            ViewBag.NbreEtoileList = new SelectList(SysLst1);

            #endregion

            return(RedirectToAction("Index", new RouteValueDictionary(
                                        new { controller = "Reservation", action = "Index" })));
        }
        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());
        }