Exemplo n.º 1
0
    public List <CityPopularityDBObject> LoadCityPopularities()
    {
        List <CityPopularityDBObject> result = new List <CityPopularityDBObject>();

        SqliteCommand    cmd    = sqlHelper.CreateTextCommand("SELECT * FROM city_popularity");
        SqliteDataReader reader = sqlHelper.ExecuteCommand(cmd);

        while (reader.Read())
        {
            CityPopularityDBObject row = new CityPopularityDBObject(reader);
            result.Add(row);
        }
        sqlHelper.CloseResultReader(reader);

        return(result);
    }
Exemplo n.º 2
0
    public void Initialzie(CityPopularityDBObject cityPopularity, Dictionary <string, TrackMetadataDBObject> trackMetadata)
    {
        latitude        = cityPopularity.latitude;
        longitude       = cityPopularity.longitude;
        coordinateFrame = GetComponentInChildren <GeographicTransform>();
        geoPos          = LatLong.FromDegrees(latitude, longitude);
        coordinateFrame.SetPosition(geoPos);

        trackPanels = new List <GameObject>();

        canvas = GetComponentInChildren <Canvas>();
        canvas.GetComponentInChildren <Text>().text = cityPopularity.cityName;

        if (!trackMetadata.ContainsKey(cityPopularity.trackList[0]))
        {
            return;
        }

        InitializeTrackPanelHeader(trackMetadata[cityPopularity.trackList[0]]);


        for (int i = 1; i < cityPopularity.trackList.Length; i++)
        {
            string trackAsin = cityPopularity.trackList[i];
            if (!trackMetadata.ContainsKey(trackAsin))
            {
                continue;
            }

            GameObject trackPanel = GameObject.Instantiate(trackPanelPrefab);
            trackPanel.transform.parent = canvas.transform;

            Vector3 pos = new Vector3(0.0f, initialYOffset + i * yOffsetPadding, 0.0f);
            trackPanel.transform.position = pos;

            InitializeTrackPanel(trackPanel, trackMetadata[trackAsin]);
            trackPanels.Add(trackPanel);
        }

        HideOrShowTrackPanels();

        Api.Instance.GeographicApi.RegisterGeographicTransform(coordinateFrame);
    }