public static List <Reservation> GetBySeanceId(int seanceId)
{
using var db = new DbCinema();
var queryable = from reservation in db.Reservations
join seance in db.Seances on reservation.SeanceId equals seance.Id
where reservation.SeanceId == seanceId
select Reservation.Build(reservation, seance);
var reservations = queryable.ToList();
return(reservations);
}
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);
}
protected override void OnModelCreating(ModelBuilder modelBuilder)
{
LandingRequest.Build(modelBuilder);
Notice.Build(modelBuilder);
Broadcast.Build(modelBuilder);
IdelStar.Build(modelBuilder);
PressCoverage.Build(modelBuilder);
IdelTV.Build(modelBuilder);
IdelEvent.Build(modelBuilder);
User.Build(modelBuilder);
Counseling.Build(modelBuilder);
Reservation.Build(modelBuilder);
BeforeAfter.Build(modelBuilder);
Manager.Build(modelBuilder);
MainSlide.Build(modelBuilder);
base.OnModelCreating(modelBuilder);
}
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);
}