public async Task SaveAnswer(CaseValidationQuestion caseValidationQuestion, string answer)
{
CaseValidationQuestionAnswer caseValidationQuestionAnswer = await GetCaseValidationQuestionAnswer(caseValidationQuestion);
if (caseValidationQuestionAnswer == null)
{
await _connection.InsertAsync(new CaseValidationQuestionAnswer { CaseValidationQuestionID = caseValidationQuestion.CaseValidationQuestionID, Answer = answer });
}
else
{
caseValidationQuestionAnswer.Answer = answer;
await _connection.UpdateAsync(new CaseValidationQuestionAnswer { CaseValidationQuestionID = caseValidationQuestion.CaseValidationQuestionID, Answer = answer });
}
}
public async Task WriteCaseValidationQuestions(int caseValidationID, List <NoteQuestion> noteQuestions)
{
int displayOrder = 0;
foreach (var noteQuestion in noteQuestions)
{
var caseValidationQuestion = new CaseValidationQuestion
{
CaseValidationID = caseValidationID,
DisplayOrder = displayOrder,
NoteQuestionID = noteQuestion.NoteQuestionID,
Question = noteQuestion.Question
};
await _connection.InsertAsync(caseValidationQuestion);
displayOrder++;
}
}
async Task <CaseValidationQuestionAnswer> GetCaseValidationQuestionAnswer(CaseValidationQuestion caseValidationQuestion)
{
return((await _connection.QueryAsync <CaseValidationQuestionAnswer>("select * from CaseValidationQuestionAnswers where CaseValidationQuestionID=?", caseValidationQuestion.CaseValidationQuestionID)).FirstOrDefault());
}
public async Task <string> GetCurrentAnswer(CaseValidationQuestion caseValidationQuestion)
{
CaseValidationQuestionAnswer caseValidationQuestionAnswer = await GetCaseValidationQuestionAnswer(caseValidationQuestion);
return(caseValidationQuestionAnswer?.Answer);
}
