Esempio n. 1
0
        public void TestInsertContestant()
        {
            Contestant contestant = new Contestant("Ole", 1);
            var        DB         = new DBContestant();

            DB.InsertContestant(contestant, 1017);
        }
Esempio n. 2
0
        /// <summary>
        /// Takes a contestantName and Guid, creates a new contestant. call db insert, to save the new contestant to database.
        /// </summary>
        /// <param name="contestanName"></param>
        public List <string> GetScoreTable(Guid contestantId)
        {
            List <string> results        = new List <string>();
            int           quizInstanceId = new DBContestant().GetQuizInstanceIdByContestantId(contestantId);
            QuizInstance  quizInstance   = new DBQuizInstance().GetQuizInstanceById(quizInstanceId, true);

            return(ContestantHighscore(quizInstance));
        }
Esempio n. 3
0
        /// <summary>
        /// Takes a contestantName and Guid, creates a new contestant. call db insert, to save the new contestant to database.
        /// </summary>
        /// <param name="contestanName"></param>
        public Contestant InsertContestant(string name, int quizInstanceId)
        {
            Contestant contestant = new Contestant(name, quizInstanceId);

            DBContestant dbContestant = new DBContestant();

            try
            {
                dbContestant.InsertContestant(contestant, quizInstanceId);
                return(contestant);
            }
            catch (Exception ex)
            {
                Console.WriteLine(ex.StackTrace);
                throw ex;
            }
        }