public Player PickPlayer() { Console.WriteLine("Welcome to this quiz. Please enter your name"); string alias = Console.ReadLine(); //Query to look if player exist var query = from player in connection.Players where player.Name == alias select player; if (query.Count() >= 1) { Console.WriteLine("Welcome back"); Thread.Sleep(2000); return(query.First()); } else { Player player = new Player() { Id = Guid.NewGuid().ToString(), Name = alias, Score = 0 }; connection.Players.Add(player); connection.SaveChanges(); return(player); } }
public void PlayTheGame() { //Query to make a loop through all questions int questionId = 1; var questionCount = from question in connection.Questions select question; //Fetch the current question from the db var getQuestion = from question in connection.Questions where question.Id == questionId select question; while (questionId <= questionCount.Count()) { Console.Clear(); Console.WriteLine($"Your score is {currentPlayer.Score}\n"); Console.WriteLine(getQuestion.First().QuestionText); Console.WriteLine("\n1. " + getQuestion.First().AnswerOne); Console.WriteLine("2. " + getQuestion.First().AnswerTwo); Console.WriteLine("3. " + getQuestion.First().AnswerThree); Console.WriteLine("4. " + getQuestion.First().AnswerFour); var input = Console.ReadKey(true); int guessOption = 0; switch (input.Key) { case ConsoleKey.D1: guessOption = 1; break; case ConsoleKey.D2: guessOption = 2; break; case ConsoleKey.D3: guessOption = 3; break; case ConsoleKey.D4: guessOption = 4; break; } if (guessOption == getQuestion.First().CorrectAnswer) { currentPlayer.Score++; connection.SaveChanges(); } questionId++; } }
public void CreateQuestion() { var query = from question in connection.Questions select question; var quest = new Question { Id = query.Count() + 1, QuestionText = NewQuestion(), AnswerOne = NewAnswer(1), AnswerTwo = NewAnswer(2), AnswerThree = NewAnswer(3), AnswerFour = NewAnswer(4), CorrectAnswer = CorrectAnswer() }; connection.Questions.Add(quest); connection.SaveChanges(); }