//return a game out the database
public Game getGame(string game)
{
string name = "";
int metascore = 0;
int userscore = 0;
string resume = "";
string genre = "";
string console = "";
DateTime date = DateTime.Today;
int rating = 0;
foreach (Dictionary<string, object> D in db.getGame(game))
{
name = (string)D["naam"];
metascore = Convert.ToInt32(D["metascore"]);
userscore = Convert.ToInt32(D["userscore"]);
resume = (string)D["samenvatting"];
genre = (string)D["genre"];
console = (string)D["spelcomputer"];
date = (DateTime)D["datum"];
rating = Convert.ToInt32(D["rating"]);
}
Game newGame = new Game(metascore, userscore, name, genre, resume, console, date, rating);
return newGame;
}
public void TestGetGame()
{
Game game = new Game(1, 10, "game", "genre", "some text", "xbox", DateTime.Now, 10);
game = game.getGame("Fallout4"); //get the game fallout4
Assert.AreEqual("Fallout4", game.Name, "Check if name is equal");
}
public void getInfo()
{
//check session to see what image is clicked then fill the page with the information
//uses InnerHtml tag to write data to the asp page.
switch ((string) Session["imageClicked"])
{
case "Fallout4":
game = game.getGame("Fallout4");
info.InnerHtml += "Naam:" + game.Name + ", Userscore: <font color=\"" +getColor(getAverage(3)) + "\">" + getAverage(3) + "</font>" + ", Metascore: <font color=\"" + getColor(game.Metascore) + "\">" + game.Metascore + "</font>";
samenvatting.InnerHtml += game.Resume;
reviews.InnerHtml += getReviews(3);
Session["categorienr"] = 3;
break;
case "Sinister":
movie = movie.getMovie("Sinister");
info.InnerHtml += "Naam:" + movie.Name + ", Userscore: <font color=\"" + getColor(getAverage(1)) + "\">" + getAverage(1) + "</font>" + ", Metascore: <font color=\"" + getColor(movie.Metascore) + "\">" + movie.Metascore + "</font>";
samenvatting.InnerHtml += movie.Resume;
reviews.InnerHtml += getReviews(1);
Session["categorienr"] = 1;
break;
case "Thedrop":
movie = movie.getMovie("TheDrop");
info.InnerHtml += "Naam:" + movie.Name + ", Userscore: <font color=\"" + getColor(getAverage(2)) + "\">" + getAverage(2) + "</font>" + ", Metascore: <font color=\"" + getColor(movie.Metascore) + "\">" + movie.Metascore + "</font>";
samenvatting.InnerHtml += movie.Resume;
reviews.InnerHtml += getReviews(2);
Session["categorienr"] = 2;
break;
case "Dishonored":
game = game.getGame("Dishonored");
info.InnerHtml += "Naam:" + game.Name + ", Userscore: <font color=\"" + getColor(getAverage(4)) + "\">" + getAverage(4) + "</font>" + ", Metascore: <font color=\"" + getColor(game.Metascore) + "\">" + game.Metascore + "</font>";
samenvatting.InnerHtml += game.Resume;
reviews.InnerHtml += getReviews(4);
Session["categorienr"] = 4;
break;
case "Power":
show = show.getShow("Power");
info.InnerHtml += "Naam:" + show.Name + ", Userscore: <font color=\"" + getColor(getAverage(5)) + "\">" + getAverage(5) + "</font>" + ", Metascore:<font color=\"" + getColor(show.Metascore) + "\">" + show.Metascore + "</font>";
samenvatting.InnerHtml += show.Resume;
reviews.InnerHtml += getReviews(5);
Session["categorienr"] = 5;
break;
case "Scandal":
show = show.getShow("Scandal");
info.InnerHtml += "Naam:" + show.Name + ", Userscore: <font color=\"" + getColor(getAverage(6)) + "\">" + getAverage(6) + "</font>" + ", Metascore: <font color=\"" + getColor(show.Metascore) + "\">" + show.Metascore + "</font>";
samenvatting.InnerHtml += show.Resume;
reviews.InnerHtml += getReviews(6);
Session["categorienr"] = 6;
break;
case "Blackmill":
music = music.getMusic("Blackmill");
info.InnerHtml += "Naam:" + music.Name + ", Userscore:<font color=\"" + getColor(getAverage(7)) + "\">" + getAverage(7) + "</font>" + ", Metascore: <font color=\"" + getColor(music.Metascore) + "\">" + music.Metascore + "</font>";
samenvatting.InnerHtml += music.Resume;
reviews.InnerHtml += getReviews(7);
Session["categorienr"] = 7;
break;
case "Eminem":
music = music.getMusic("Eminem");
info.InnerHtml += "Naam:" + music.Name + ", Userscore: <font color=\"" + getColor(getAverage(8)) + "\">" + getAverage(8) + "</font>" + ", Metascore: <font color=\"" + getColor(music.Metascore) + "\">" + music.Metascore + "</font>";
samenvatting.InnerHtml += music.Resume;
reviews.InnerHtml += getReviews(8);
Session["categorienr"] = 8;
break;
}
}
