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