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