public async Task <FeedQuizResult> CreateQuizResult(FeedQuizResult result, int QuizId) { using (var conn = new MySqlConnection(connString)) //New temporary connection { await conn.OpenAsync(); //Opens connection using (var cmd = new MySqlCommand($"INSERT INTO feed_quiz_result VALUES({0}, {QuizId}, {result.UserId}, {result.OverallScore}, '{result.DatePosted.ToString("yyyy-MM-dd hh:mm:ss")}');", conn)) { //^ inserts values into feed_quiz_result row await cmd.ExecuteNonQueryAsync(); //Executes command return(await GetQuizResultById((int)cmd.LastInsertedId)); //Get returned reuslt row } } }
public async Task <IActionResult> CreateQuizResult(int PostId, [FromBody] FeedQuizResult result) { return(Ok(await new FeedTasks().CreateQuizResult(result, PostId))); }