public static Reservation GetByUserIdAndSeanceId(int userId, int seanceId)
{
using var db = new DbCinema();
var queryable = from reservation in db.Reservations
join user in db.Users on reservation.UserId equals user.Id
join seance in db.Seances on reservation.SeanceId equals seance.Id
where reservation.UserId == userId && reservation.SeanceId == seanceId
select Reservation.Build(reservation, user, seance);
var singleReservation = queryable.ToList()[0];
singleReservation.Seance = SeanceController.Get(singleReservation.SeanceId);
singleReservation.User = UserController.Get(singleReservation.UserId);
return(singleReservation);
}
public static List <Reservation> All()
{
using var db = new DbCinema();
var query = from reservation in db.Reservations
join user in db.Users on reservation.UserId equals user.Id
join seance in db.Seances on reservation.SeanceId equals seance.Id
orderby reservation.Id descending
select Reservation.Build(reservation, user, seance);
var reservations = query.ToList();
foreach (var res in reservations)
{
res.Seance = SeanceController.Get(res.SeanceId);
res.User = UserController.Get(res.UserId);
}
return(reservations);
}