private int?GetPlexPlaylistId(ItunesPlaylist playlist)
{
int? playlistId = null;
string sql = "SELECT id FROM metadata_items WHERE title = '{0}' AND metadata_type = 15"; //15=PLAYLIST_TYPE
sql = string.Format(sql, playlist.FullPlaylistName);
playlistId = (int?)m_PlexDb.ReadPlexValue(sql);
return(playlistId);
}
private string FullPlaylistName(ItunesPlaylist playlist)
{
string name = playlist.Name;
if (!string.IsNullOrWhiteSpace(playlist.ParentPersistentID))
{
ItunesPlaylist parent = m_AllItunesPlaylists.FirstOrDefault(p => p.PlaylistPersistentID == playlist.ParentPersistentID);
if (parent != null)
{
name = string.Format("{0} - {1}", FullPlaylistName(parent), name);
}
}
return(name);
}
public void GetItunesPlayLists(string itunesLibrary, bool includeTracks)
{
m_ItunesTracks = new List <ItunesTrack>();
m_AllItunesPlaylists = new List <ItunesPlaylist>();
m_ItunesPlaylists = new List <ItunesPlaylist>();
if (string.IsNullOrWhiteSpace(itunesLibrary))
{
return;
}
if (!File.Exists(itunesLibrary))
{
return;
}
Cursor.Current = Cursors.WaitCursor;
XmlReaderSettings docSettings = new XmlReaderSettings();
docSettings.XmlResolver = null;
docSettings.DtdProcessing = DtdProcessing.Ignore;
var xmlReader = XmlTextReader.Create(itunesLibrary, docSettings);
XPathDocument docNav = new XPathDocument(xmlReader);
// Get Itunes Tracks
if (includeTracks)
{
string trackXpath = "/plist/dict/dict/dict";
XPathNavigator trackNav = docNav.CreateNavigator();
XPathExpression trackExpr = trackNav.Compile(trackXpath);
XPathNodeIterator trackNodes = trackNav.Select(trackExpr);
XmlReaderSettings trackSet2 = new XmlReaderSettings();
trackSet2.ConformanceLevel = ConformanceLevel.Fragment;
m_ItunesTracks.Clear();
foreach (XPathNavigator node in trackNodes)
{
XPathDocument doc2 = new XPathDocument(
XmlReader.Create(new StringReader(node.InnerXml), trackSet2));
XPathNavigator nav2 = doc2.CreateNavigator();
ItunesTrack track = new ItunesTrack();
track.Id = nav2.SelectSingleNode("key[.='Track ID']/following-sibling::*").ValueAsInt;
track.Name = nav2.SelectSingleNode("key[.='Name']/following-sibling::*").ToString();
track.Location = nav2.SelectSingleNode("key[.='Location']/following-sibling::*").ToString();
m_ItunesTracks.Add(track);
}
}
// Get Itunes playlists
string playlistXpath = "/plist/dict/array/dict";
XPathNavigator playlistNav = docNav.CreateNavigator();
XPathExpression playlistExpr = playlistNav.Compile(playlistXpath);
XPathNodeIterator playlistNodes = playlistNav.Select(playlistExpr);
XmlReaderSettings playlistSet2 = new XmlReaderSettings();
playlistSet2.ConformanceLevel = ConformanceLevel.Fragment;
m_ItunesPlaylists.Clear();
foreach (XPathNavigator node in playlistNodes)
{
if (!node.InnerXml.Contains("<key>Master</key>") &&
!node.InnerXml.Contains("<key>Distinguished Kind</key>"))
{
XPathDocument doc2 = new XPathDocument(
XmlReader.Create(new StringReader(node.InnerXml), playlistSet2));
XPathNavigator nav2 = doc2.CreateNavigator();
// TODO Need to build a path reading "Playlist Persistent ID" and "Parent Persistent ID"
ItunesPlaylist playlist = new ItunesPlaylist();
playlist.PlaylistPersistentID = nav2.SelectSingleNode("key[.='Playlist Persistent ID']/following-sibling::*")?.ToString();
playlist.ParentPersistentID = nav2.SelectSingleNode("key[.='Parent Persistent ID']/following-sibling::*")?.ToString();
playlist.Name = nav2.SelectSingleNode("key[.='Name']/following-sibling::*").ToString();
playlist.FullPlaylistName = FullPlaylistName(playlist);
m_AllItunesPlaylists.Add(playlist);
if (!node.InnerXml.Contains("<key>Folder</key>"))
{
if (includeTracks)
{
var trackListXml = nav2.Select("key[.='Playlist Items']/following-sibling::*");
trackListXml.MoveNext();
string tracksXml = trackListXml.Current.InnerXml;
doc2 = new XPathDocument(XmlReader.Create(new StringReader(tracksXml), playlistSet2));
nav2 = doc2.CreateNavigator();
var trackIdList = nav2.Select("dict/key[.='Track ID']/following-sibling::*");
while (trackIdList.MoveNext())
{
int trackId = trackIdList.Current.ValueAsInt;
ItunesTrack track = m_ItunesTracks.FirstOrDefault(t => t.Id == trackId);
if (track != null)
{
playlist.Tracks.Add(track);
}
}
}
m_ItunesPlaylists.Add(playlist);
}
}
}
Cursor.Current = Cursors.Default;
}