public async Task <IActionResult> MangaReviews(string username) { var user = await _context.User.FirstOrDefaultAsync(a => a.UserName == username); var reviewList = await _context.MangaReviews.Where(a => a.UserId == user.Id).OrderByDescending(a => a.Id).ToListAsync <MangaReviews>(); var users = new List <User>(); var mangas = new List <MangaItem>(); if (reviewList.Count < 1) { users.Add(user); } else { foreach (var review in reviewList) { var anime = await _context.MangaItem.FirstOrDefaultAsync(a => a.Id == review.MangaItemId); users.Add(user); mangas.Add(anime); } } var viewModel = new MangaReviewsViewModel { UserList = users, MangaInfoList = mangas, ReviewsList = reviewList }; return(View(viewModel)); }
public async Task <IActionResult> Reviews() { var reviewList = await _context.MangaReviews.OrderByDescending(a => a.Id).ToListAsync <MangaReviews>(); var usersList = new List <User>(); var mangasList = new List <MangaItem>(); foreach (var review in reviewList) { var user = await _context.User.FirstOrDefaultAsync(a => a.Id == review.UserId); var manga = await _context.MangaItem.FirstOrDefaultAsync(a => a.Id == review.MangaItemId); usersList.Add(user); mangasList.Add(manga); } var viewModel = new MangaReviewsViewModel { UserList = usersList, MangaInfoList = mangasList, ReviewsList = reviewList }; return(View(viewModel)); }