public IActionResult Status(int id) { var borrowedMovies = this._context.MovieBorrowerses .Include(e => e.Movie) .Include(e => e.Borrower) .Where(e => e.MovieId == id) .ToList(); var movieTitle = this._context.Movies.Find(id).Title; var result = new List <StatusViewModel>(); foreach (var movieBorrowerse in borrowedMovies) { var period = movieBorrowerse.BorrowDate.ToString("yyyy-MM-dd") + " : " + movieBorrowerse.ReturnDate.ToString("yyyy-MM-dd"); result.Add(new StatusViewModel { BorrowerName = movieBorrowerse.Borrower.Name, Period = period, }); } var model = new MovieStatusViewModel { Title = movieTitle, Statuses = result }; return(this.View(model)); }
public IActionResult Status(int id) { var movie = this.context .Movies .FirstOrDefault(m => m.Id == id); if (movie == null) { return(this.RedirectToAction("All")); } this.MovieStatus = new MovieStatusViewModel { Title = movie.Title }; var currentMovieRecords = this.context .MovieRecords .Where(mr => mr.MovieId == id) .Select(mr => mr.RecordId) .ToList(); this.MovieStatus.MovieRecords = this.context .Records .Where(r => currentMovieRecords.Contains(r.Id)) .Select(r => new MovieRecordsViewModel { StartDate = r.StartDate, EndDate = r.EndDate }) .ToList(); return(this.View(this.MovieStatus)); }
public IActionResult Status(int id) { var movie = this.Context.Movies.FirstOrDefault(x => x.Id == id); if (movie == default(Movie)) { return(RedirectToPage(IndexPage)); } var movieName = movie.Title; MovieStatusViewModel movieHistory = new MovieStatusViewModel() { MovieTitle = movie.Title }; movieHistory.DateHistory = this.Context .MovieBorrows .Include(x => x.Borrower) .Where(x => x.MovieId == id) .Select(x => new StartEndDateModel() { StartDate = x.StartDate.ToString("yyyy-MM-dd HH:mm", CultureInfo.InvariantCulture), EndDate = x.EndDate != null ? ((DateTime)x.EndDate).ToString("yyyy-MM-dd HH:mm", CultureInfo.InvariantCulture) : "none", BorrowerName = x.Borrower.Name }) .ToList(); return(this.View(movieHistory)); }