public async Task <IActionResult> OnGet() { if (!User.Identity.IsAuthenticated) { return(RedirectToPage("/Account/Login", new { area = "Identity" })); } try { int?UserGroupID = HttpContext.Session.GetInt32("UserGroupID"); var user = await _userManager.GetUserAsync(User); PotAccess = await _siteData.GetPotAccess(user.Id.ToString(), UserGroupID); int index = PotAccess.FindIndex(item => item.PotID == 1); if (index == -1) { return(RedirectToPage("/Account/AccessDenied", new { area = "Identity" })); } string cs = _config.GetConnectionString("Default"); FilmDetails = _filmData.GetFilmDetails(Id).Result.FirstOrDefault(); if (FilmDetails.UserGroupID != UserGroupID) { return(RedirectToPage("/Account/AccessDenied", new { area = "Identity" })); } if (FilmDetails != null) { if (FilmDetails != null) { var genres = _filmData.GetGenreList(); var directors = _filmData.GetDirectorsList(); var platforms = _filmData.GetPlatformsList(); var users = _siteData.GetUserList(UserGroupID, 1); //Genre = genres.Where(x => x.GenreID == FilmDetails.GenreID).FirstOrDefault()?.GenreText; Genres = new List <SelectListItem>(); Directors = new List <SelectListItem>(); Platforms = new List <SelectListItem>(); Users = new List <SelectListItem>(); FilmGenres = new List <FilmGenres>(); FilmDirectors = new List <FilmDirectors>(); FilmPlatforms = new List <FilmPlatforms>(); FilmGenres = _filmData.GetFilmGenres(Id).Result; FilmDirectors = _filmData.GetFilmDirectors(Id).Result; FilmPlatforms = _filmData.GetFilmPlatforms(Id).Result; genres.Result.ForEach(x => { Genres.Add(new SelectListItem { Value = x.GenreID.ToString(), Text = x.GenreText }); }); directors.Result.ForEach(x => { Directors.Add(new SelectListItem { Value = x.DirectorID.ToString(), Text = x.DirectorName }); }); platforms.Result.ForEach(x => { Platforms.Add(new SelectListItem { Value = x.PlatformID.ToString(), Text = x.PlatformText }); }); users.Result.ForEach(x => { if (FilmDetails.AddedByID == x.UserID) { Users.Add(new SelectListItem { Value = x.UserID.ToString(), Text = x.UserName, Selected = true }); } else { Users.Add(new SelectListItem { Value = x.UserID.ToString(), Text = x.UserName }); } }); } } return(Page()); } catch (Exception ex) { Log.Error(ex.ToString()); throw new Exception(ex.ToString()); } }