Example #1
0
        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));
        }
Example #2
0
        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));
        }
Example #3
0
        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));
        }