static void Main(string[] args)
{
Game spiel = new Game(true);
Question q1 = new Question("Was ist 2+2");
Answer a1 = new Answer("4", true);
Answer a2 = new Answer("6");
q1.AddAnswer(a1);
q1.AddAnswer(a2);
spiel.AddQuestion(q1);
Question q2 = new Question("Wie geht es dir ...");
Answer a3 = new Answer("gut", true);
Answer a4 = new Answer("1111");
q2.AddAnswer(a3);
q2.AddAnswer(a4);
spiel.AddQuestion(q2);
Question q3 = new Question("´Welche Schleife gibt es in C#");
Answer a5 = new Answer("For-schleife", true);
Answer a6 = new Answer("Int-Schleife");
q3.AddAnswer(a5);
q3.AddAnswer(a6);
spiel.AddQuestion(q3);
while (spiel.Status == GameStatus.Active)
{
var frage = spiel.NextQuestion;
var antworten = frage.Answers;
Console.WriteLine(frage.Text);
int counter = 0;
foreach (Answer a in antworten)
{
Console.WriteLine("(" + counter + ") " + a.Text);
counter++;
}
Console.WriteLine("Geben Sie die richtig: ");
int eingabeindex = Convert.ToInt32(Console.ReadLine());
antworten[eingabeindex].IsChecked = true;
spiel.ValidateCurrentQuestion();
}
if (spiel.Status == GameStatus.HasFinished)
{
Console.WriteLine("Sie haben gewonnen, erreichtes Level: " + spiel.Level);
}
else
{
Console.WriteLine("Sie haben Verloren, Aktuelles Level:" + spiel.Level);
}
}
public static Question[] ReadQuestions(string table_name)
{
List <Question> questions = new List <Question>();
string sql = "select * from Questions order by Question";
IDbConnection _connection;
_connection = (IDbConnection) new SqliteConnection("URI=file:" + Application.dataPath + "/sampledb.sqlite");
_connection.Open();
IDbCommand IDbCommand = _connection.CreateCommand();
IDbCommand.CommandText = sql;
IDataReader _reader = IDbCommand.ExecuteReader();
_connection.Close();
while (_reader.Read())
{
//Debug.Log("Question: " + _reader["Question"] + "\t" + "Subject: " + _reader["Subject"]);
Question quest = new Question();
quest.Text = _reader["Question"] as string;
quest.AddSubject(_reader["Subject"] as string);
quest.AddHint(_reader["Hint"] as string);
quest.difficulty = (Difficulty)_reader["Difficulty"];
quest.AddAnswer(_reader["Answer 1"] as string);
quest.AddAnswer(_reader["Answer 2"] as string);
quest.AddAnswer(_reader["Answer 3"] as string);
quest.AddAnswer(_reader["Answer 4"] as string);
questions.Add(quest);
}
//
// if (_command != null){
// _command.Dispose();
// _command = null;
// }
// if (_connection != null){
// _connection .Close();
// _connection = null;
// }
Debug.Log(questions.Count);
return(questions.ToArray());
}