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