private void UpdateLeaderBoardPersonalBest()
        {
            try
            {
                LearningGames lg = new LearningGames();
                RegisterLogin rl = new RegisterLogin();

                ModelLeaderBoard mlb = new ModelLeaderBoard
                {
                    USER_LIBRARY_CARD_ID = currentUser
                };

                List <ModelLeaderBoard> getPersonalBest = lg.GetPersonalBestIdentifyingAreas(mlb, connectionString);


                tbPBSCore.Text = getPersonalBest[0].IDENTIFYING_AREAS_PERSONAL_BEST.ToString();



                if (getPersonalBest.Count == 1)
                {
                    tbPBSCore.Text = getPersonalBest[0].IDENTIFYING_AREAS_PERSONAL_BEST.ToString();
                }



                getAllRecords = lg.GetIdentifyingAreasChampion(connectionString);

                if (getAllRecords[0].IDENTIFYING_AREAS_PERSONAL_BEST == 0)
                {
                    tbChampionName.Text = "No Champion Yet !";
                }
                else
                {
                    tbChampScore.Text = getAllRecords[0].IDENTIFYING_AREAS_PERSONAL_BEST.ToString();

                    List <ModelLeaderBoard> getBestUserId = lg.GetChampionNameIdentifyingAreas(getAllRecords[0].IDENTIFYING_AREAS_PERSONAL_BEST.ToString(), connectionString);

                    int id = getBestUserId[0].USER_LIBRARY_CARD_ID;

                    if (id == currentUser)
                    {
                        isChamp = true;
                    }

                    List <ModelRegisterLogin> getBestUser = rl.GetUser(id, connectionString);
                    tbChampionName.Text = getBestUser[0].USER_FNAME + " " + getBestUser[0].USER_LNAME;
                }
            }
            catch (Exception)
            {
                tbChampionName.Text = "No Champion Yet !";
            }
        }
        private void InsertUpdateRecords()
        {
            LearningGames    lg  = new LearningGames();
            ModelLeaderBoard mlb = new ModelLeaderBoard
            {
                USER_LIBRARY_CARD_ID            = currentUser,
                IDENTIFYING_AREAS_PERSONAL_BEST = userCurrentScore
            };


            List <ModelLeaderBoard> rec = lg.GetPersonalBestIdentifyingAreas(mlb, connectionString);

            if (rec.Count == 0)
            {
                lg.InsertNewPersonalBestIdentifyingAreas(mlb, connectionString);
            }
            else
            {
                lg.UpdateNewPersonalBestIdentifyingAreas(mlb, connectionString);
            }
        }