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