using Sony.Filtr.Playlists.Spotify.Model;
using Sony.Filtr.Utility.Extensions;
using System.Data.Common;

namespace Sony.Filtr.Playlists.Extensions
{
    public static class DbDataReaderExtensions
    {
        public static SpotifyTrackAnalyzeData ToSpotifyTrackAnalyzeData(this DbDataReader reader)
        {
            var track = new SpotifyTrackAnalyzeData
            { 
                AddedAt = reader.GetUtcDateTime("Added"),
                Album = new SpotifyAlbumAnalyzeData
                { 
                    ImageFileName = reader.GetString("SmallImageFilename"),
                    Upc = reader.GetString("Upc"),
                    Id = reader.GetString("AlbumId")
                },
                Isrc = reader.GetString("ISRC"),
                Popularity = reader.GetInt32("Popularity"),
                TrackId = reader.GetString("TrackId"),
                TrackName = reader.GetString("TrackName"),
                PlaylistIndex = reader.GetInt32("PlaylistIndex")
            };

            track.Artists.Add(new SpotifyArtistAnalyzeData 
            {
                Name = reader.GetString("ArtistName"),
                Id = reader.GetString("ArtistId")
            });

            return track;
        }
    }
}