public async Task <IActionResult> Edit(long id, [Bind("Id,CinemaId,MovieId,ShowingDate,ShowTime,DateCreated,DateUpdated")] MovieShowings movieShowings)
{
if (id != movieShowings.Id)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
_context.Update(movieShowings);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!MovieShowingsExists(movieShowings.Id))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction(nameof(Index)));
}
ViewData["CinemaId"] = new SelectList(_context.Cinemas, "Id", "Id", movieShowings.CinemaId);
ViewData["MovieId"] = new SelectList(_context.Movies, "Id", "Id", movieShowings.MovieId);
return(View(movieShowings));
}
public async Task <IActionResult> Showings(int?id)
{
if (id == null)
{
return(NotFound());
}
var movie = await _context.Movies.SingleOrDefaultAsync(m => m.Id == id);
if (movie == null)
{
return(NotFound());
}
ViewData["MovieShowings"] = new MovieShowings()
{
MovieId = movie.Id
};
ViewData["CinemaId"] = new SelectList(_context.Cinemas, "Id", "Name");
ViewData["MovieId"] = new SelectList(_context.Movies, "Id", "Title");
var showing = await _context.MovieShowings.Where(m => m.MovieId == movie.Id).OrderByDescending(m => m.ShowingDate).ToListAsync();
ListShowTimeViewModel listShowTime = new ListShowTimeViewModel()
{
Movie = movie,
MovieShowings = showing
};
return(View(listShowTime));
}
public MovieShowings AddNewMovieShowing(DateTime showingDate, int?loungeId, int?movieId) // add new showing to DB
{
MovieShowings showing = new MovieShowings();
showing.movieShowingTime = showingDate;
showing.loungeId = loungeId;
showing.movieId = movieId;
return(showing);
}
public async Task <IActionResult> Create([Bind("Id,CinemaId,MovieId,ShowingDate,ShowTime,DateCreated,DateUpdated")] MovieShowings movieShowings)
{
if (ModelState.IsValid)
{
_context.Add(movieShowings);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
ViewData["CinemaId"] = new SelectList(_context.Cinemas, "Id", "Id", movieShowings.CinemaId);
ViewData["MovieId"] = new SelectList(_context.Movies, "Id", "Id", movieShowings.MovieId);
return(View(movieShowings));
}
public MovieShowings GetMovieShowingEntity(int movieIdInput)
{
var movieShowing = new MovieShowings();
try
{
using (var db = new BookingDBEntities())
{
movieShowing = (from s in db.MovieShowings
where s.movieId == movieIdInput
select s).FirstOrDefault <MovieShowings>();
}
return(movieShowing);
}
catch
{
movieShowing = null;
return(movieShowing);
}
}
public async Task <IActionResult> AddShowTimes(AddShowTimeViewModel movieShowings)
{
List <MovieShowings> showingsList = new List <MovieShowings>();
if (ModelState.IsValid)
{
char dateDelimiter = '-';
string[] dates = movieShowings.ShowingDates.Split(dateDelimiter);
var allDates = GetDatesBetween(Convert.ToDateTime(dates[0]), Convert.ToDateTime(dates[1]));
char timeDelimeter = ',';
string[] showTimes = movieShowings.ShowingTimes.Split(timeDelimeter);
try
{
foreach (var date in allDates)
{
foreach (var showTime in showTimes)
{
TimeSpan timeSpan = TimeSpan.FromHours(Convert.ToInt32(showTime));
//string fromTimeSpan = timeSpan.ToString("hh':'mm':'ss");
//DateTime dateTime = DateTime.ParseExact(showTime, "HH:mm:ss",
// CultureInfo.InvariantCulture);
var showing = new MovieShowings()
{
CinemaId = movieShowings.CinemaId,
MovieId = movieShowings.MovieId,
DateCreated = DateTime.Now,
DateUpdated = DateTime.Now,
ShowingDate = date.Date,
ShowTime = date.Date + timeSpan
};
//string dateconcat = date.Date + timeSpan;
//showing.ShowTime = Convert.ToDateTime(dateconcat);
showingsList.Add(showing);
_context.Entry(showing).State = EntityState.Added;
}
}
//_context.Entry(showingsList);
}
catch (Exception ex)
{
throw ex;
}
//foreach (var showing in showingsList)
//{
// char delimiter = '-';
// string[] dates = movieShowings.ShowingDates.Split(delimiter);
//}
// _context.Add(showingsList);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
ViewData["CinemaId"] = new SelectList(_context.Cinemas, "Id", "Name", movieShowings.CinemaId);
ViewData["MovieId"] = new SelectList(_context.Movies, "Id", "Title", movieShowings.MovieId);
return(View(movieShowings));
}
