public async Task <IActionResult> RemoveReservation([FromBody] int reservationId)
{
var reservation = await _context.TblReservations.Where(r => r.ReservationId == reservationId).FirstOrDefaultAsync();
if (reservation != null)
{
reservation.IsDeleted = true;
_context.TblReservations.Update(reservation);
_context.Entry(reservation).State = EntityState.Modified;
if (_context.SaveChanges() > 0)
{
return(Ok());
}
else
{
return(BadRequest("Could not delete reservation"));
}
}
else
{
return(BadRequest("Could not find reservation"));
}
}
public async Task <IActionResult> SubmitReservation([FromBody] BookTicketReservationViewModel model)
{
try
{
var user = await GetCurrentUserAsync();
var userId = user?.Id;
string mail = user?.Email;
var myMovie = await _movieService.GetMovieById(model.movieId ?? 1);
if (user != null)
{
foreach (var item in model.selectedSeats)
{
TblReservations reservation = new TblReservations();
reservation.ReservedByCustomerId = userId;
reservation.ReservedForMovieId = model.movieId ?? 0;
reservation.ReservedInCinemaId = myMovie.Cinema.CinemaId;
reservation.ReservationTime = DateTime.Now.ToString("dd/MM/yyyy h:mm tt");
reservation.IsPaid = false;
reservation.ReservationStatusId = 2;
reservation.Seat = item.Id;
reservation.CreatedByUserId = userId;
reservation.LastModifiedByUserId = userId;
reservation.CreatedOnDate = DateTime.Now.ToString("dd/MM/yyyy");
reservation.LastModifiedOnDate = DateTime.Now.ToString();
await _context.TblReservations.AddAsync(reservation);
}
if (_context.SaveChanges() > 0)
{
return(Ok());
}
}
return(BadRequest());
}
catch (Exception ex)
{
throw ex;
}
}
public bool AddMovie(MovieViewModel movie)
{
Images image = new Images()
{
ImagePath = movie.ImagePath
};
_context.Images.Add(image);
if (_context.SaveChanges() > 0)
{
TblMovie tblMovie = new TblMovie()
{
CinemaId = movie.CinemaId,
MovieGenreId = movie.MovieGenreId,
IsBookable = movie.IsBookable,
MovieName = movie.MovieName,
MovieDescription = movie.MovieDescription,
ReleaseDate = movie.ReleaseDate,
MovieLength = movie.MovieLength,
PriceForAdults = movie.PriceForAdults,
PriceForChildrens = movie.PriceForChildrens,
//ShowTimeIds = movie.ShowTimeIds,
Rating = movie.Rating,
LanguageId = movie.LanguageId,
Image = image.ImageId,
CreatedByUserId = movie.CreatedByUserId,
LastModifiedByUserId = movie.LastModifiedByUserId,
CreatedOnDate = movie.CreatedOnDate,
LastModifiedOnDate = movie.LastModifiedOnDate,
IsDeleted = movie.IsDeleted
};
var cinemaAdded = _movieRepository.AddMovie(tblMovie);
if (cinemaAdded)
{
TblShowTime showTime = new TblShowTime()
{
CinemaId = movie.CinemaId,
MovieId = tblMovie.MovieId,
Time = movie.ShowTime,
CreatedByUserId = movie.CreatedByUserId,
LastModifiedByUserId = movie.LastModifiedByUserId,
CreatedOnDate = DateTime.Now.ToShortDateString(),
LastModifiedOnDate = DateTime.Now.ToShortDateString(),
};
_context.TblShowTime.Add(showTime);
if (_context.SaveChanges() > 0)
{
var myMovie = _context.TblMovie.Where(r => r.MovieId == tblMovie.MovieId).SingleOrDefault();
myMovie.ShowTimeIds = showTime.ShowTimeId.ToString();
_movieRepository.EditMovie(myMovie);
}
return(true);
}
}
return(false);
}
public bool AddAddress(TblAddress address)
{
_context.TblAddress.Add(address);
return(_context.SaveChanges() > 0);
}
public bool AddCinema(TblCinema cinema)
{
_context.TblCinema.Add(cinema);
return(_context.SaveChanges() > 0);
}
public bool AddMovie(TblMovie movie)
{
_context.TblMovie.Add(movie);
return(_context.SaveChanges() > 0);
}
