public IActionResult UsersAnswers() { var viewModel = new UsersAnswersViewModel(); viewModel = _usersAnswerService.GetAnswers(); return(View(viewModel)); }
public UsersAnswersViewModel GetAnswersWithDetails() { var result = new UsersAnswersViewModel(); using (var context = new InfolineContext()) { result.UsersAnswers = context.UserAnswers .Include(x => x.User) .Include(x => x.Question) .Select(item => new UsersAnswersDto { AnswerDate = item.AnswerDate, QuestionId = item.QuestionId, QuestionText = item.Question.Text, UserId = item.UserId, UserName = item.User.UserName, AnswerText = item.Answer }) .ToList(); } return(result); }