private void LoadDetails(int id) { MovieWithFestivalDetails movieDetails = movieHandler.GetMovieDetailsById(id); if (movieDetails != null) { ltrlAbout.Text = movieDetails.About; ltrlActors.Text = movieDetails.Actors; ltrlAward.Text = movieDetails.Award; ltrlDate.Text = movieDetails.ReleasingDate; ltrlDirector.Text = movieDetails.Director; ltrlFestival.Text = movieDetails.Festival; ltrlLocation.Text = movieDetails.Location; ltrlRuntime.Text = movieDetails.RunningTime; ltrlTitle.Text = movieDetails.Name; movieposter.Src = movieDetails.PosterUrl; youtube.Text = movieDetails.YoutubeEmbeddedLink; imgfestphotourl.Src = movieDetails.FestivalBannerUrl; if (!string.IsNullOrEmpty(movieDetails.MovieLink)) { ancrwatchfilm.HRef = "../Views/WatchMovie"; } else if (!string.IsNullOrEmpty(movieDetails.AmazonLinkRent)) { ancrwatchfilm.Target = "_blank"; ancrwatchfilm.HRef = movieDetails.AmazonLinkRent; } else { ancrwatchfilm.HRef = "#"; } } }
/// <summary> /// Get the details of the movie by id /// </summary> /// <param name="id"></param> /// <returns></returns> public MovieWithFestivalDetails GetMovieDetailsById(int id) { MovieWithFestivalDetails completeMovieDetails = null; using (var repo = new filmfestivaldbEntities()) { var movie = repo.moviesdetails.Join(repo.festivaldetails, m => m.festival_id, f => f.Id, (m, f) => new { m, f }) .Where(x => x.m.Id == id) .Select(y => new { About = y.m.Description, Actors = y.m.Actors, Award = y.m.Award, Director = y.m.Director, Festival = y.m.FestivalFullName, FestivalBannerUrl = y.f.FestivalArtUrl, Id = y.m.Id, Location = y.m.Country, MovieLink = y.m.MovieLink, Name = y.m.Title, PosterUrl = y.m.PosterLink, ReleasingDate = y.m.Released, RunningTime = y.m.Runtime, YoutubeLink = y.m.YoutubeEmbeddedCode, AmazonLinkRent = y.m.AmazonLinkRent }).FirstOrDefault(); if (movie != null) { completeMovieDetails = new MovieWithFestivalDetails(); // Convert the bytes array into string and store into about completeMovieDetails.About = System.Text.Encoding.Default.GetString(movie.About); completeMovieDetails.Actors = movie.Actors; completeMovieDetails.Award = movie.Award; completeMovieDetails.Director = movie.Director; completeMovieDetails.Festival = movie.Festival; completeMovieDetails.Id = movie.Id; completeMovieDetails.Location = movie.Location; completeMovieDetails.Name = movie.Name; completeMovieDetails.PosterUrl = movie.PosterUrl; completeMovieDetails.ReleasingDate = movie.ReleasingDate; completeMovieDetails.RunningTime = movie.RunningTime; completeMovieDetails.MovieLink = movie.MovieLink; completeMovieDetails.FestivalBannerUrl = movie.FestivalBannerUrl; completeMovieDetails.AmazonLinkRent = movie.AmazonLinkRent; // Convert the bytes array into string and store into YoutubeEmbedded Link url completeMovieDetails.YoutubeEmbeddedLink = System.Text.Encoding.Default.GetString(movie.YoutubeLink); } return(completeMovieDetails); } }