How to view my content from my database to my home view in .Net core MVC

Question

Hi guys

SO I was learning to use .NET Core MVC through the tutorial, and I decided to take it up a notch. While the tutorial has been helpful, it did not really have what I was looking for, and surprisingly, neither do all the AI bots. So what's the issue? Well, I want to render all my movies that I have in my movie list on my home page from the database instead of generically adding them from a folder. The reason I am doing it like this is that if a movie is deleted from the database, it logically should not be available for watching. The main issue I am having is that instead of the thumbnails showing, it runs the else logic. It's as if it is not factoring in the entire condition.

Here's my code:

@model MvcMovie.Models.MovieGenreViewModel`
@{
    ViewData["Title"] = "Home Page";
}

    Relive your childhood with all the cool movies you missed
    Will you Checkout our library.


    
        @if (Model?.Movies != null && Model.Movies.Any())
        {
            foreach (var movie in Model.Movies)
            {
                
                    
                        @if (!string.IsNullOrEmpty(movie.Image))
                        {
                            
                        }
                        else
                        {
                            
                        }
                        
                            @movie.Title
                            
                                Genre: @movie.Genre 

                                Rating: @movie.Rating 

                                Release Date: @movie.ReleaseDate.ToShortDateString()
                            
                            View Details
                        
                    
                
            }
        }
        else
        {
            
                No movies available in the database.
            
        }

Please incase the error is not from my home/index, let me know where to look at.

Thanks.

Accepted Answer

Hi @Assadullah Sanusi

so here's the index of my movie page, as you can see there are movies displayed. These movies are fetched from the database, the way it is shown here is the same way I want it to display on my home page.

To display movies list in Home page, you can try the following steps:

1.In the HomeController, change the Index action as below: register the MvcMovieContext and query database to get the movie list, then return it to view page:

           public class HomeController : Controller
           {
               private readonly ILogger _logger;
               private readonly MvcMovieContext _context;
               public HomeController(ILogger logger, MvcMovieContext context)
               {
                   _logger = logger;
                   _context = context;
               }
               public async Task Index(string movieGenre, string searchString)
               {
                   if (_context.Movies == null)
                   {
                       return Problem("Entity set 'MvcMovieContext.Movie' is null.");
                   }
                   // Use LINQ to get the list of genres
                   IQueryable genreQuery = from m in _context.Movies
                                                   orderby m.Genre
                                                   select m.Genre;
                   // Query movies
                   var movies = from m in _context.Movies
                                select m;
                   if (!string.IsNullOrEmpty(searchString))
                   {
                       movies = movies.Where(s => s.Title != null && s.Title.ToUpper().Contains(searchString.ToUpper()));
                   }
                   if (!string.IsNullOrEmpty(movieGenre))
                   {
                       movies = movies.Where(x => x.Genre == movieGenre);
                   }
                   var movieGenreVM = new MovieGenreViewModel
                   {
                       Genres = new SelectList(await genreQuery.Distinct().ToListAsync()),
                       Movies = await movies.ToListAsync() // Ensures Movies is a List
                   };
                   return View(movieGenreVM);
               }

2.In the Home Index view page, refer to the following code (you can copy the code from your movie index page) to display the movie:

        @model MvcMovie.Models.MovieGenreViewModel

        @{
            ViewData["Title"] = "Index";
        }

        Index

        
            Create New
        
        
            

                

                Title: 
                
            
        

        
                @foreach (var item in Model.Movies!)
                {
                    
                }
            
            
                
                    
                        @Html.DisplayNameFor(model => model.Movies![0].Title)
                    
                    
                        Thumbnail
                    
                    
                        @Html.DisplayNameFor(model => model.Movies![0].ReleaseDate)
                    
                    
                        @Html.DisplayNameFor(model => model.Movies![0].Genre)
                    
                    
                        @Html.DisplayNameFor(model => model.Movies![0].Price)
                    
                    
                        @Html.DisplayNameFor(model => model.Movies![0].Rating)
                    
                    
                
            
            
                        
                            @Html.DisplayFor(modelItem => item.Title)
                        
                        
                            
                        
                        
                            @Html.DisplayFor(modelItem => item.ReleaseDate)
                        
                        
                            @Html.DisplayFor(modelItem => item.Genre)
                        
                        
                            @Html.DisplayFor(modelItem => item.Price)
                        
                        
                            @Html.DisplayFor(modelItem => item.Rating)
                        
                        
                            Edit |
                            Details |
                            Delete

Then, the movie should display in the home page.

Note:

From your database screenshot, it seems that you are stored the image using base64 string, so, in my sample, the Movie.cs class like this:

        public class Movie
        {
            public int Id { get; set; }
            [StringLength(60, MinimumLength = 3)]
            [Required]
            public string? Title { get; set; }
            [Required]
            public string? Image { get; set; }
            [Display(Name = "Release Date")]
            [DataType(DataType.Date)]
            public DateTime ReleaseDate { get; set; }
            [Range(1, 100)]
            [DataType(DataType.Currency)]
            [Column(TypeName = "decimal(18, 2)")]
            public decimal Price { get; set; }
            [RegularExpression(@"^[A-Z]+[a-zA-Z\s]*$")]
            [Required]
            [StringLength(30)]
            public string? Genre { get; set; }
            [RegularExpression(@"^[A-Z]+[a-zA-Z0-9""'\s-]*$")]
            [StringLength(5)]
            [Required]
            public string? Rating { get; set; }
        }

Finally, in the Home page, the result as below:

enter image description here

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Best regards,

Dillion

Answer

I guess that your post is based on the following Microsoft Movie tutorial:

Get started with ASP.NET Core MVC

If so, your requirement below;

I want to render all my movies that I have in my movie list on my home page from the database instead of generically adding them from a folder. The reason I am doing it like this is that if a movie is deleted from the database, it logically should not be available for watching.

will be realized if you proceed with the steps in tutorial up to "Part 5, work with a database in an ASP.NET Core MVC app."

However, your issue stated below does not make sense to me.

The main issue I am having is that instead of the thumbnails showing, it runs the else logic. It's as if it is not factoring in the entire condition.

Can you tell me some more details about what you want to do?

Share via

How to view my content from my database to my home view in .Net core MVC

2 additional answers

Your answer