public void UpdateSeats(int id, int numberOfSelectedSeats)
{
CinemaBroadcast broadcast = _cinemaDbContext.CinemaBroadcasts.FirstOrDefault(x => x.BroadcastId == id);
broadcast.NumberOfSeats = broadcast.NumberOfSeats - numberOfSelectedSeats;
_cinemaDbContext.SaveChanges();
}
public void DeleteBroadcast(int id)
{
CinemaBroadcast broadcastFromDb = _cinemaDbContext.CinemaBroadcasts.FirstOrDefault(x => x.BroadcastId == id);
if (broadcastFromDb != null)
{
_cinemaDbContext.CinemaBroadcasts.Remove(broadcastFromDb);
_cinemaDbContext.SaveChanges();
}
}
public void AddBroadcast(CinemaBroadcastDTO cinemaBroadcastDTO)
{
CinemaBroadcast insertBroadcast = new CinemaBroadcast {
MovieId = cinemaBroadcastDTO.MovieId,
CinemaLocationId = cinemaBroadcastDTO.CinemaLocationId,
PriceId = cinemaBroadcastDTO.PriceId,
NumberOfSeats = cinemaBroadcastDTO.NumberOfSeats,
BroadcastTime = cinemaBroadcastDTO.Time,
BroadcastTimeHour = cinemaBroadcastDTO.BroadcastTime
};
_cinemaDbContext.CinemaBroadcasts.Add(insertBroadcast);
_cinemaDbContext.SaveChanges();
}
public void DeleteBooking(int id)
{
CinemaBooking bookingFromDb = _cinemaDbContext.CinemaBookings.FirstOrDefault(x => x.BookingId == id);
if (bookingFromDb != null)
{
int seats = bookingFromDb.Seat;
int broadcastId = bookingFromDb.BroadcastId;
_cinemaDbContext.CinemaBookings.Remove(bookingFromDb);
CinemaBroadcast broadcastFromDb = _cinemaDbContext.CinemaBroadcasts.FirstOrDefault(x => x.BroadcastId == broadcastId);
broadcastFromDb.NumberOfSeats += seats;
_cinemaDbContext.SaveChanges();
}
}
public CinemaBroadcastDTO GetBroadcastByIdAndLocationName(int broadcastId, string locationName)
{
CinemaBroadcast broadcastFromDb = _cinemaDbContext.CinemaBroadcasts
.Include(x => x.CinemaLocation)
.FirstOrDefault(x => x.BroadcastId == broadcastId && x.CinemaLocation.NameLocation == locationName);
return(new CinemaBroadcastDTO {
BroadcastId = broadcastFromDb.BroadcastId,
MovieId = broadcastFromDb.MovieId,
PriceId = broadcastFromDb.PriceId,
CinemaLocationId = broadcastFromDb.CinemaLocationId,
NumberOfSeats = broadcastFromDb.NumberOfSeats,
Time = broadcastFromDb.BroadcastTime,
BroadcastTime = broadcastFromDb.BroadcastTimeHour
});
}
