public async Task <IActionResult> NovelReviews(string username)
{
var user = await _context.User.FirstOrDefaultAsync(a => a.UserName == username);
var reviewList = await _context.NovelReviews.Where(a => a.UserId == user.Id).OrderByDescending(a => a.Id).ToListAsync <NovelReviews>();
var users = new List <User>();
var novels = new List <NovelItem>();
if (reviewList.Count < 1)
{
users.Add(user);
}
else
{
foreach (var review in reviewList)
{
var novel = await _context.NovelItem.FirstOrDefaultAsync(a => a.Id == review.NovelItemId);
users.Add(user);
novels.Add(novel);
}
}
var viewModel = new NovelReviewsViewModel
{
UserList = users,
NovelInfoList = novels,
ReviewsList = reviewList
};
return(View(viewModel));
}
public async Task <IActionResult> Reviews()
{
var reviewList = await _context.NovelReviews.OrderByDescending(a => a.Id).ToListAsync <NovelReviews>();
var usersList = new List <User>();
var novelsList = new List <NovelItem>();
foreach (var review in reviewList)
{
var user = await _context.User.FirstOrDefaultAsync(a => a.Id == review.UserId);
var novel = await _context.NovelItem.FirstOrDefaultAsync(a => a.Id == review.NovelItemId);
usersList.Add(user);
novelsList.Add(novel);
}
var viewModel = new NovelReviewsViewModel
{
UserList = usersList,
NovelInfoList = novelsList,
ReviewsList = reviewList
};
return(View(viewModel));
}
