public IActionResult OnPost(AnswerIn answerIn) { if (ModelState.IsValid) { try { var container = new ProblemContainer(); answerIn.IsCorrect = container.IsProblemSolved(answerIn.ProblemId, answerIn.Answer); _databaseRepository.SaveAnswer(answerIn); if (answerIn.IsCorrect) { return(RedirectToPage(@"Correct")); } else { return(RedirectToPage(@"Incorrect")); } } catch (Exception ex) { ModelState.AddModelError("error", ex.Message); } } return(Page()); }
public void SaveAnswer(AnswerIn answer) { string sql = $@"INSERT INTO dbo.CodeJam VALUES (1, @nickname, @taskId, @isCorrect, @answer, GETDATE())"; using (IDbConnection db = new SqlConnection(_connectionString)) { db.Execute(sql, answer); } }