private MetaData CreateMetaDataFromWebDetails(WebTrack webTrack)
{
var metaData = new MetaData
{
AlbumArtist = this.WebAlbum.Artist,
AlbumName = this.WebAlbum.Title,
ContributingArtists = webTrack.ContributingArtists,
DiscNumber = webTrack.DiscNumber,
Genre = webTrack.Genre,
Title = webTrack.Title,
TrackNumber = webTrack.TrackNumber,
Year = this.WebAlbum.ReleaseYear
};
//use album artist as song artist if there are no contributing artists
if (metaData.ContributingArtists.Count() == 0)
{
metaData.ContributingArtists.Add(metaData.AlbumArtist);
}
return(metaData);
}
public List <WebTrack> GetWebTracksByPlaylistId(string pid)
{
var webPlaylistTracks = new List <WebTrack>();
if (String.IsNullOrEmpty(pid))
{
return(webPlaylistTracks);
}
SQLiteConnection db = null;
try
{
db = ConnectDb();
string sql = "select web_track.tid, web_track.track from web_playlist_track, web_track where web_playlist_track.pid='{0}' and web_playlist_track.tid=web_track.tid order by web_playlist_track.'order' ASC";
SQLiteCommand command = new SQLiteCommand(String.Format(sql, pid), db);
SQLiteDataReader reader = command.ExecuteReader();
while (reader.Read())
{
var webTrack = new WebTrack(reader["tid"].ToString(), reader["track"].ToString());
webPlaylistTracks.Add(webTrack);
}
}
catch (Exception e)
{
throw e;
}
finally
{
if (db != null)
{
db.Close();
}
}
return(webPlaylistTracks);
}
