public bool DeletePurchasedSong(PurchasedSong purchasedSong)
        {
            try
            {
                PurchasedSongTable.DeleteOnSubmit(purchasedSong);
                PurchasedSongTable.Context.SubmitChanges();

                return true;
            }
            catch (Exception)
            {
                return false;
            }
        }
        public bool SavePurchasedSong(PurchasedSong purchasedSong)
        {
            try
            {
                if (purchasedSong.PurchasedSongId == 0)
                {
                    PurchasedSongTable.InsertOnSubmit(purchasedSong);
                }
                else
                {
                    PurchasedSongTable.Context.Refresh(RefreshMode.KeepCurrentValues, purchasedSong);
                }

                PurchasedSongTable.Context.SubmitChanges();

                return true;
            }
            catch (Exception)
            {
                return false;
            }
        }
        public bool RecordSongPlayByUser(int songId, int playlistId, int userId)
        {
            var playlistSongId = GetPlaylistSongCollection(playlistId).Where(s => s.SongId == songId).Select(p => p.PlaylistSongId).FirstOrDefault();
            var purchasedSong = new PurchasedSong()
            {
                UserId = userId,
                Cost = 0,
                DatePurchased = DateTime.Now,
                PlaylistSongId = playlistSongId
            };

            try
            {
                var success = SqlPurchasedSongRepository.SavePurchasedSong(purchasedSong);

                return success;
            }
            catch
            {
                return false;
            }
        }