Пример #1
0
        public Board GetBoard(int boardId)
        {
            TilesDAO til         = new TilesDAO();
            PortDAO  port        = new PortDAO();
            Board    returnBoard = new Board();

            con.Open();
            // where needs to be added
            string query = "SELECT * FROM Board WHERE Id= @Id";

            using (SqlCommand command = new SqlCommand(query, con))
            {
                command.Parameters.Add(new SqlParameter("@Id", boardId));
                //command.Parameters["Id"].Value = boardId;
                command.ExecuteNonQuery();
                SqlDataReader read = command.ExecuteReader();

                while (read.Read())
                {
                    read.GetInt32(0);
                    read.GetInt32(1);
                }

                con.Close();
                returnBoard.Tiles = til.GetAllTilesFromBoard(boardId);
                returnBoard.Ports = port.GetAllPortsFromBoard(boardId);
                return(returnBoard);

                //daarna ga naar tiles en port en haal alle gegevens op
            }
        }
Пример #2
0
 public BoardDAO()
 {
     port = new PortDAO();
     tile = new TilesDAO();
 }