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