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)); }