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()); }