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); }
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); }