public async Task <AnswerSurveyResponseDto> AnswerAsync([FromBody] AnswerSurveyDto answer) { Survey tempSurvey = new Survey(null, answer); User tempUser = new User { Id = answer.UserId }; AnswerSurveyResponseDto response = await _repository.AnswerSurveyAsync(tempSurvey, tempUser); return(response); }
public async Task <AnswerSurveyResponseDto> AnswerSurveyAsync(Survey survey, User user) { AnswerSurveyResponseDto response = new AnswerSurveyResponseDto(); using (SqlConnection connection = await _dbContext.OpenConnectionAsync()) { using (SqlCommand command = new SqlCommand(AnswerSurveyStatement, connection)) { command.Parameters.AddWithValue("@SurveyID", survey.Id); command.Parameters.AddWithValue("@UserID", user.Id); command.Parameters.AddWithValue("@Answers", JsonConvert.SerializeObject(survey.Questions)); int rowsAffected = await command.ExecuteNonQueryAsync(); if (rowsAffected == 1) { response.ResponseMessage = $"Your answer has been registered for the survey titled: {survey.Title}"; } } } return(response); }