public void Quiz_Click(object sender, RoutedEventArgs e)
{
//Als er op een Chapter word geklikt
Button btn = sender as Button;
string v = Convert.ToString(btn.Content);
ChapterInformation playableChapters = connection.GameInfo($"SELECT * FROM `chapter` WHERE `category` = " + catInfo.CategoryID + " AND `name` = '" + v + "'");
playableChapters.ChapterCat = catInfo.CategoryID;
this.Frame.Navigate(typeof(Game.PlayGame), playableChapters);
}
public ChapterInformation GameInfo(string sqli)
{
ChapterInformation gameInfo = new ChapterInformation();
MySqlCommand cmd = new MySqlCommand(sqli, con);
con.Open();
MySqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
gameInfo.ChapterName = reader.GetString("name");
gameInfo.ChapterID = reader.GetString("id");
gameInfo.ChapterDesc = reader.GetString("description");
gameInfo.ChapterCat = reader.GetString("category");
}
con.Close();
return(gameInfo);
}
