private void CheckTimeToSetVideo(DateTime now) { foreach (var clientReservation in _reservation.GetAll()) { foreach (var setVideo in clientReservation.Reservations.Where(r => r.StartTime >= now)) { // 新增影片 SetVideos(setVideo.Codes, clientReservation.ClientId, setVideo.StartTime, setVideo.EndTime); } } }
public void Get_All_Returns_All_Reservations() { // Arrange LibraryContextMock mockContext = new LibraryContextMock(); ReservationRepository repo = new ReservationRepository(mockContext); BookRepository bookRepo = new BookRepository(mockContext); Book newBook = new Book() { title = "New title", author = "New author", isbn = "22222", publishDate = "2001" }; Reservation newReservation1 = new Reservation() { book = newBook }; Reservation newReservation2 = new Reservation() { book = newBook }; bookRepo.Add(newBook); repo.Add(newReservation1); repo.Add(newReservation2); // Act IEnumerable <Reservation> Reservations = repo.GetAll(); // Asert Assert.Equal(new Reservation[] { newReservation1, newReservation2 }, Reservations.ToArray()); }
public void Put_Doesnt_Update_If_Times_Clash() { // Arrange LibraryContextMock mockContext = new LibraryContextMock(); ReservationRepository repo = new ReservationRepository(mockContext); BookRepository bookRepo = new BookRepository(mockContext); Book newBook = new Book() { title = "New title", author = "New author", isbn = "22222", publishDate = "2001" }; Reservation Reservation1 = new Reservation() { book = newBook, startDate = new System.DateTime(2016, 1, 1, 1, 0, 0), endDate = new System.DateTime(2016, 1, 1, 2, 0, 0), }; Reservation Reservation2 = new Reservation() { book = newBook, startDate = new System.DateTime(2016, 1, 1, 1, 30, 0), endDate = new System.DateTime(2016, 1, 1, 2, 30, 0), }; bookRepo.Add(newBook); repo.Add(Reservation1); Assert.Throws <InvalidOperationException>(() => repo.Update(Reservation2, 0)); IEnumerable <Reservation> Reservations = repo.GetAll(); Assert.Equal(new Reservation[] { Reservation1 }, Reservations.ToArray()); }
public List <Reservation> GetReservations() { List <Reservation> reservations = new List <Reservation>(); reservations = reservationRepository.GetAll().OrderByDescending(x => x.DateReserv).ToList(); return(reservations); }
public ActionResult GetReservations() { var reservations = repo.GetAll(); if (reservations != null) { return(Ok(reservations)); } return(NotFound()); }
public ActionResult Index() { ReservationRepository repository = new ReservationRepository(); List <Reservation> reservations = repository.GetAll(); ReservationsListViewModel model = new ReservationsListViewModel(); model.Reservations = reservations; return(View(model)); }
public void New_Reservation_Repository_Is_Empty() { // Arrange ReservationRepository repo = new ReservationRepository(); // Act IEnumerable <Reservation> reservations = repo.GetAll(); // Asert Assert.Empty(reservations); }
public void New_Reservation_Repository_Is_Empty() { // Arrange LibraryContextMock mockContext = new LibraryContextMock(); ReservationRepository repo = new ReservationRepository(mockContext); // Act IEnumerable <Reservation> Reservations = repo.GetAll(); // Asert Assert.Empty(Reservations); }
public void GetSingleReservation() { using (var repository = new ReservationRepository()) { var query = from r in repository.GetAll() where r.ConfirmationCode == "1234" select r; var reservation = query.FirstOrDefault(); Assert.IsNotNull(reservation); } }
public void GetReservationWithFlightsLazyLoad() { Reservation reservation; using (var repository = new ReservationRepository()) { var query = from r in repository.GetAll() where r.ConfirmationCode == "1234" select r; reservation = query.FirstOrDefault(); Assert.IsNotNull(reservation); //TODO: Lab 02 Exercise 2, Task 2.2 : Complete the Lazy Load test implementation } }
public void Return_Borrowed_Edits_Reservation() { // Arrange ReservationRepository repo = new ReservationRepository(); Book newBook = new Book() { Id = 0 }; // Act repo.Borrow(newBook); repo.Return(newBook); IEnumerable <Reservation> reservations = repo.GetAll(); // Asert Assert.NotEqual(null, reservations.ToArray()[0].EndDate); }
public void Borrow_Inserts_New_Reservation() { // Arrange ReservationRepository repo = new ReservationRepository(); Book newBook = new Book() { Id = 0 }; // Act repo.Borrow(newBook); IEnumerable <Reservation> reservations = repo.GetAll(); // Asert Assert.Equal(0, reservations.ToArray()[0].BookId); Assert.NotEqual(null, reservations.ToArray()[0].StartDate); Assert.Equal(null, reservations.ToArray()[0].EndDate); }
public void GetReservationWithFlightsEagerLoad() { Reservation reservation; using (var repository = new ReservationRepository()) { var query = from r in repository.GetAll() where r.ConfirmationCode == "1234" select r; query = query.Include(r => r.DepartureFlight).Include(r => r.ReturnFlight); reservation = query.FirstOrDefault(); } Assert.IsNotNull(reservation); Assert.IsNotNull(reservation.DepartureFlight); Assert.IsNotNull(reservation.ReturnFlight); }
public void GetReservationsWithSingleFlightWithoutLazyLoad() { Reservation reservation; TravelCompanionContext context = new TravelCompanionContext(); //TODO: Lab 02 Exercise 2, Task 2.3 : Turn Lazy Loading Off using (var repository = new ReservationRepository(context)) { var query = from r in repository.GetAll() where r.ConfirmationCode == "1234" select r; reservation = query.FirstOrDefault(); Assert.IsNotNull(reservation); Assert.IsNull(reservation.DepartureFlight); Assert.IsNull(reservation.ReturnFlight); } }
public void Get_All_Returns_All_Reservations() { // Arrange ReservationRepository repo = new ReservationRepository(); Book newBook1 = new Book() { Id = 1 }; Book newBook2 = new Book() { Id = 2 }; repo.Borrow(newBook1); repo.Borrow(newBook2); // Act IEnumerable <Reservation> reservations = repo.GetAll(); // Asert Assert.Equal(2, reservations.ToArray().Length); }
public void Delete_Removes_Correct_Reservation() { // Arrange LibraryContextMock mockContext = new LibraryContextMock(); ReservationRepository repo = new ReservationRepository(mockContext); BookRepository bookRepo = new BookRepository(mockContext); Book newBook = new Book() { title = "New title", author = "New author", isbn = "22222", publishDate = "2001" }; Reservation newReservation1 = new Reservation() { id = 0, book = newBook }; Reservation newReservation2 = new Reservation() { id = 1, book = newBook }; Reservation newReservation3 = new Reservation() { id = 2, book = newBook }; bookRepo.Add(newBook); repo.Add(newReservation1); repo.Add(newReservation2); repo.Add(newReservation3); // Act repo.Remove(1); IEnumerable <Reservation> Reservations = repo.GetAll(); // Asert Assert.Equal(new Reservation[] { newReservation1, newReservation3 }, Reservations.ToArray()); }
public void Update_updates_Correct_Reservation() { // Arrange LibraryContextMock mockContext = new LibraryContextMock(); ReservationRepository repo = new ReservationRepository(mockContext); BookRepository bookRepo = new BookRepository(mockContext); Book newBook = new Book() { title = "New title", author = "New author", isbn = "22222", publishDate = "2001" }; Reservation oldReservation = new Reservation() { book = newBook, startDate = new System.DateTime(2016, 1, 1, 1, 0, 0), endDate = new System.DateTime(2016, 1, 1, 2, 0, 0), }; Reservation newReservation = new Reservation() { book = newBook, startDate = new System.DateTime(2016, 1, 1, 3, 0, 0), endDate = new System.DateTime(2016, 1, 1, 4, 0, 0), }; bookRepo.Add(newBook); repo.Add(oldReservation); // Act repo.Update(newReservation, 0); IEnumerable <Reservation> Reservations = repo.GetAll(); // Asert Assert.Equal(new Reservation[] { newReservation }, Reservations.ToArray()); }
public IEnumerable <Reservation> GetAllReservations() { return(repo.GetAll()); }
public IEnumerable <Reservation> GetAllReservations() { return(_reservationRepository.GetAll()); }
// GET: Web public IEnumerable <Reservation> GetAllReservations() { //matches routing api/ return(repo.GetAll()); }
// GET: Home public ActionResult Index() { return(View(_repo.GetAll())); }
// public ActionResult Update(Excursion.Portail.Models.ReservationViewModel viewModel, FormCollection formCollection) // { // var operation = formCollection["oper"]; // var Id = formCollection["id"]; // if (operation.Equals("add")) // { // Reservation reserv = new Reservation(); // reserv.SortieID = 1; // reserv.DateReserv = DateTime.Now.Date; // // reserv.NumChamb = viewModel.; // reserv.HotelID = 1; // reserv.TypeClient = SessionData.CurrentUser.TypeUser; // reserv.UserID = SessionData.CurrentUser.UserID; // reserv.LangueID = 4; // reserv.Etat = "N"; // reserv.NumTicket = viewModel.NumTicket; // reserv.PointDepart = viewModel.PointDepart; // reserv.NbreAdultes = viewModel.NbreAdultes; // reserv.NbreEnfants = viewModel.NbreEnfants; // reserv.NbreBebes = viewModel.NbreBebes; // reserv.Observation = viewModel.Observation; // reserv.NumChamb = viewModel.NumChamb.ToString(); // reserv.Paye = viewModel.Paye; // reserv.DatePayement = viewModel.DatePayement; // reservationRepository.Add(reserv); // reservationRepository.Save(); // //int ContactId = viewModel.ReservationID; // } // else if (operation.Equals("edit")) // { // Reservation reserv = reservationRepository.FindOne(x => x.ReservationID == viewModel.ReservationID); // reserv.DateModification = DateTime.Now.Date; // // reserv.NumChamb = viewModel.; // reserv.HotelID = 1; // reserv.LangueID = 4; // reserv.Etat = "M"; // reserv.LangueID = langueRepository.FindOne(x => x.NomLangue == viewModel.LangueID).LangueID; // reserv.NumTicket = viewModel.NumTicket; // reserv.PointDepart = viewModel.PointDepart; // reserv.NbreAdultes = viewModel.NbreAdultes; // reserv.NbreEnfants = viewModel.NbreEnfants; // reserv.NbreBebes = viewModel.NbreBebes; // reserv.Observation = viewModel.Observation; // reserv.NumChamb = viewModel.NumChamb.ToString(); // reserv.Paye = viewModel.Paye; // reserv.DatePayement = viewModel.DatePayement; // reservationRepository.Update(reserv); // reservationRepository.Save(); // } // else if (operation.Equals("del")) // { // Reservation reserv = reservationRepository.FindOne(x => x.ReservationID == viewModel.ReservationID); // reserv.Etat = "C"; // reserv.DateAnnulation = DateTime.Now.Date; // reservationRepository.Update(reserv); // reservationRepository.Save(); // } // return Content("false"); // //return RedirectToAction("JsonSalesCollection", new RouteValueDictionary( // // new { controller = "Home", action = "JsonSalesCollection" })); // } // public virtual ActionResult JsonSalesCollection(DateTime? startDate, DateTime? endDate, string typeclient, //string sidx, string sord, int page, int rows) // { // SalesLogic logicLayer = new SalesLogic(); // List<Reservation> context; // ////Filter using client type // //if (typeclient != null) // //{ // // context = logicLayer.GetReservationsByFilterTypeC(typeclient); // //} // // If we aren't filtering by date, return this month's contributions // if (startDate == DateTime.MinValue || endDate == DateTime.MinValue) // { // context = logicLayer.GetReservations(); // } // else // Filter by specified date range // { // context = logicLayer.GetReservationsByDateRange((System.DateTime)startDate, (System.DateTime)endDate, typeclient); // } // // Calculate page index, total pages, etc. for jqGrid to us for paging // int pageIndex = Convert.ToInt32(page) - 1; // int pageSize = rows; // int totalRecords = context.Count(); // int totalPages = (int)Math.Ceiling((float)totalRecords / (float)pageSize); // // Order the results based on the order passed into the method // string orderBy = string.Format("{0} {1}", sidx, sord); // var Reservations = context.AsQueryable() // .OrderBy(orderBy) // Uses System.Linq.Dynamic library for sorting // .Skip(pageIndex * pageSize) // .Take(pageSize); // // Format the data for the jqGrid // var jsonData = new // { // total = totalPages, // page = page, // records = totalRecords, // rows = ( // from s in Reservations // select new // { // i = s.ReservationID, // cell = new string[] { // s.ReservationID.ToString(), // s.PointDepart.ToString(), // s.DateReserv.ToShortDateString(), // s.NumTicket.ToString(), // //s.SortieID.ToString(), // //s.HotelID.ToString(), // //s.LangueID.ToString(), // s.SortieParSemaine.Excursion.Nom.ToString(), // s.Hotel.Nom.ToString(), // s.NumChamb.ToString(), // s.Langue.NomLangue.ToString(), // s.Observation.ToString(), // s.NbreAdultes.ToString(), // s.NbreEnfants.ToString(), // s.NbreBebes.ToString(), // s.Paye.ToString(), // s.DatePayement.ToString() // } // }).ToArray() // }; // // Return the result in json // return Json(jsonData, JsonRequestBehavior.AllowGet); // } // public JsonResult GetExcursionsList() // { // var allExcursions = new List<string>(); // var SysQry1 = from b in sortieParSemaineRepository.GetAll() // select b.Excursion.Nom; // allExcursions.AddRange(SysQry1.Distinct()); // //allExcursions.Add("Excursion1"); // //allExcursions.Add("Excursion2"); // //allExcursions.Add("Excursion3"); // //allExcursions.Add("Excursion4"); // //allExcursions.Add("Excursion5"); // return Json(allExcursions, JsonRequestBehavior.AllowGet); // } // public JsonResult GetHotelsList() // { // //List<string> allHotels = new List<string>(); // var allHotels = new List<string>(); // var SysQry = from d in hotelRepository.FindMany(x => x.RegionID == SessionData.CurrentUser.RegionID) // select d.Nom; // allHotels.AddRange(SysQry.Distinct()); // //allHotels.Add("Hotel1"); // //allHotels.Add("Hotel2"); // //allHotels.Add("Hotel3"); // //allHotels.Add("Hotel4"); // //allHotels.Add("Hotel5"); // return Json(allHotels, JsonRequestBehavior.AllowGet); // } // public JsonResult GetLanguesList() // { // //List<string> allLangues = new List<string>(); // var allLangues = new List<string>(); // var SysQry1 = from b in langueRepository.GetAll() // select b.NomLangue; // allLangues.AddRange(SysQry1.Distinct()); // //allLangues.Add("Deutsh"); // //allLangues.Add("English"); // //allLangues.Add("Français"); // //allLangues.Add("Arab"); // //allLangues.Add("Italien"); // return Json(allLangues, JsonRequestBehavior.AllowGet); // } // public JsonResult GetEtatsList() // { // List<string> allEtats = new List<string>(); // allEtats.Add("No Modif No Cancel"); // allEtats.Add("Cancel"); // allEtats.Add("Modif"); // return Json(allEtats, JsonRequestBehavior.AllowGet); // } #endregion #region IgGrid public virtual ActionResult GetAllRespExc() { List <Excursion.Portail.Models.ReservationModel> Liste2 = new List <ReservationModel>(); var reservations = reservationRepository.GetAll().ToList(); foreach (Reservation Res in reservations) { ReservationModel res2 = new ReservationModel(); res2.AddRow = null; res2.UpdateRow = null; res2.DeleteRow = null; res2.DateAnnulation = Res.DateAnnulation; res2.DateModification = Res.DateModification; res2.DatePayement = Res.DatePayement; res2.DateReserv = (DateTime)Res.DateReserv; res2.Etat = Res.Etat; res2.Hotel = Res.Hotel.Nom; res2.Langue = Res.Langue.NomLangue; if (MvcGlobalisationSupport.CultureManager.GetLanguage() == "fr") { res2.Sortie = Res.SortieParSemaine.Excursion.Nom_fr; } else if (MvcGlobalisationSupport.CultureManager.GetLanguage() == "de") { res2.Sortie = Res.SortieParSemaine.Excursion.Nom_de; } else if (MvcGlobalisationSupport.CultureManager.GetLanguage() == "en") { res2.Sortie = Res.SortieParSemaine.Excursion.Nom_en; } else if (MvcGlobalisationSupport.CultureManager.GetLanguage() == "it") { res2.Sortie = Res.SortieParSemaine.Excursion.Nom_it; } res2.NbreAdultes = Res.NbreAdultes; res2.NbreBebes = Res.NbreBebes; res2.NbreEnfants = Res.NbreEnfants; res2.NumChamb = Res.NumChamb; res2.NumLigneAs400 = Res.NumLigneAs400; res2.NumTicket = Res.NumTicket; res2.Observation = Res.Observation; res2.Paye = (bool)Res.Paye; res2.PointDepart = Res.PointDepart; res2.Reduction = Res.Reduction; res2.ReservationID = Res.ReservationID; res2.TypeClient = Res.TypeClient; res2.UserID = Res.UserID; User us = userRepository.FindOne(x => x.UserID == Res.UserID); if (us.TypeUser == "Client") { res2.ClientD = us.Nom.ToString() + " " + us.Prenom.ToString(); } else { if (us.TypeCIndirect == "Guide") { res2.Guide = us.Nom.ToString() + " " + us.Prenom.ToString(); } else if (us.TypeCIndirect == "Fournisseur") { res2.Fournisseur = us.Nom.ToString() + " " + us.Prenom.ToString(); } } Liste2.Add(res2); } return(Json(Liste2, JsonRequestBehavior.AllowGet)); }
public async Task <List <ReservationModel> > List() { return(await _reservationRepository.GetAll <ReservationModel>()); }
public IEnumerable <Reservation> GetAll() => _repo.GetAll();
public ViewResult Index() { return(View(repo.GetAll())); }
public static List <Reservation> GetAll() => ReservationRepository.GetAll();
public List <Reservation> GetAll() { return(_reserveRepository.GetAll()); }
private void RefreshControls() { bindingSourceReserve.Clear(); bindingSourceReserve.DataSource = repository.GetAll(); dataGridViewReserve.DataSource = bindingSourceReserve; }
public async Task <IEnumerable <Reservation> > List() { return(await _reservationRepository.GetAll()); }
public ActionResult Index() => View(repo.GetAll());