public async Task <bool> UpdateUserStatusAtQuizEnd(PokemonDALModel dalModel) { var sql = $@" UPDATE UserScoreData SET TotalAccumlatiedPoints = @{nameof(dalModel.TotalAccumlatiedPoints)}, TotalPossiblePoints = @{nameof(dalModel.TotalPossiblePoints)}, QuizLength25Attempts = @{nameof(dalModel.QuizLength25Attempts)}, QuizLength50Attempts = @{nameof(dalModel.QuizLength50Attempts)}, QuizLength100Attempts = @{nameof(dalModel.QuizLength100Attempts)}, OverallPercent = @{nameof(dalModel.OverallPercent)}, RecentAmountOfQuestions = @{nameof(dalModel.RecentAmountOfQuestions)}, RecentTotalCorrect = @{nameof(dalModel.RecentTotalCorrect)}, AttemptsPerQuiz = @{nameof(dalModel.AttemptsPerQuiz)} WHERE FK_UsernameID = @{nameof(dalModel.FK_UsernameID)}"; using (var connection = new SqlConnection(_config.ConnectionString)) { var result = connection.Execute(sql, dalModel); return(true); } }
public async Task <bool> InsertUserStatusAtQuizEnd(PokemonDALModel dalModel) { var sql = $@"Insert INTO UserScoreData( Username, FK_UsernameID, TotalAccumlatiedPoints, TotalPossiblePoints, QuizLength25Attempts, QuizLength50Attempts, QuizLength100Attempts, AverageScore, OverallPercent, RecentAmountOfQuestions, RecentTotalCorrect, WhichQuizTaken, AttemptsPerQuiz) Values (@{nameof(dalModel.Username)}, @{nameof(dalModel.FK_UsernameID)}, @{nameof(dalModel.TotalAccumlatiedPoints)}, @{nameof(dalModel.TotalPossiblePoints)}, @{nameof(dalModel.QuizLength25Attempts)}, @{nameof(dalModel.QuizLength50Attempts)}, @{nameof(dalModel.QuizLength100Attempts)}, @{nameof(dalModel.AverageScore)}, @{nameof(dalModel.OverallPercent)}, @{nameof(dalModel.RecentAmountOfQuestions)}, @{nameof(dalModel.RecentTotalCorrect)}, @{nameof(dalModel.WhichQuizTaken)}, @{nameof(dalModel.AttemptsPerQuiz)})"; using (var connection = new SqlConnection(_config.ConnectionString)) { var result = connection.Execute(sql, dalModel); return(true); } }