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); }