namespace Sony.Filtr.AppleMusic.Data
{
    using System;
    using System.Data.Common;
    using MySqlConnector;
    using Sony.Filtr.Utility;
    using Sony.Filtr.Utility.Extensions;

    public class AppleMusicPlaylistTracklistHistory
    {
        public AppleMusicPlaylistTracklistHistory(MySqlDataReader sqlReader)
        {
            PlaylistId = sqlReader.GetStringNullCheck(0);
            Date = sqlReader.GetSafeDateTimeToString(1,"yyyy-MM-dd");
            PlaylistPosition = sqlReader.GetIntNullCheck(2);
            TrackId = sqlReader.GetLongNullCheck(3);
            TrackName = sqlReader.GetStringNullCheck(4);
            TrackArtistName = sqlReader.GetStringNullCheck(5);
            TrackISRC = sqlReader.GetStringNullCheck(6);
            PlaylistName = sqlReader.GetStringNullCheck(7);
        }

        public string PlaylistId { get; set; }

        public string Date { get; set; }

        public int? PlaylistPosition { get; set; }

        public long? TrackId { get; set; }

        public string TrackName { get; set; }

        public string TrackArtistName { get; set; }

        public string TrackISRC { get; set; }

        public string PlaylistName { get; set; }

        public string ParseDateFromString(string date)
        {
            DateTime temp;
            string result = string.Empty;
            if (!string.IsNullOrEmpty(date))
            { 
                DateTime.TryParse(date, out temp);
                if (temp != null)
                { 
                    result = temp.ToString("yyyy-MM-dd"); 
                }
            }
            return result;
        }
    }
}