private void InitializeTrackPanelHeader(TrackMetadataDBObject metadata)
{
RectTransform trackHeaderPanel = canvas.GetComponentsInChildren <RectTransform>()[3];
initialYOffset = trackHeaderPanel.transform.position.y;
InitializeTrackPanel(trackHeaderPanel.gameObject, metadata);
}
private void InitializeTrackPanel(GameObject trackPanel, TrackMetadataDBObject metadata)
{
Text title = trackPanel.GetComponentsInChildren <Text>()[0];
Text artist = trackPanel.GetComponentsInChildren <Text>()[1];
Image album = trackPanel.GetComponentsInChildren <Image>()[1];
title.text = metadata.title;
artist.text = metadata.artist;
StartCoroutine(GetAlbumImage(album, metadata.imageUrl));
trackPanel.GetComponentInChildren <PlaySample>().Initialize(metadata.sampleUrl);
}
public List <TrackMetadataDBObject> LoadTrackMetadata()
{
List <TrackMetadataDBObject> result = new List <TrackMetadataDBObject>();
SqliteCommand cmd = sqlHelper.CreateTextCommand("SELECT * FROM track_metadata");
SqliteDataReader reader = sqlHelper.ExecuteCommand(cmd);
while (reader.Read())
{
TrackMetadataDBObject row = new TrackMetadataDBObject(reader);
result.Add(row);
}
sqlHelper.CloseResultReader(reader);
return(result);
}
