0

I'm busy with a new language : C#. I can't figure out how to return a object in this method.... It's in a Database. I put in a gameID and then i want to return the Game of that GameID

Can someone help me?

Method in GameController:

public Game getGame(int gameID)
    {
        Game game = new Game();

        try
        {
            conn.Open();


            string selectQuery = "select * from game where game_id=@gameID";
            MySqlCommand cmd = new MySqlCommand(selectQuery, conn);
            cmd.Parameters.AddWithValue("@gameID", gameID);
            MySqlDataReader dataReader = cmd.ExecuteReader();

            while (dataReader.Read())
            {

                game.ID = dataReader.GetInt32("game_id");
                game.Naam = dataReader.GetString("gamenaam");
                //game.Genre.ID = dataReader.GetInt32("genre_id");

            }
        }
        catch (Exception e)
        {
            Console.Write("Ophalen van genres mislukt " + e);
        }
        finally
        {
            conn.Close();
        }

        return game;


    }

Model Game:

public class Game
{
    public String Naam { get; set; }

    public Genre Genre { get; set; }

    public int ID { get; set; }

    public override string ToString()
    {
        return String.Format("{0} (id = {1}) {2}", Naam, ID, Genre);
    }
}
Tony
  • 58
  • 9

0 Answers0