private void StartProcessing() { lblStatus.Text = "Connecting to database..."; lblStatus.Refresh(); lblProgress.Text = $"Updated: 0 | New: 0"; lblProgress.Refresh(); if (string.IsNullOrWhiteSpace(Settings.PlexDatabase)) { string dbPath = @"%LOCALAPPDATA%\Plex Media Server\Plug-in Support\Databases\com.plexapp.plugins.library.db"; Settings.PlexDatabase = Environment.ExpandEnvironmentVariables(dbPath); if (!File.Exists(Settings.PlexDatabase)) { Settings.PlexDatabase = string.Empty; } } m_PlexDb = new PlexDatabaseControlller(Settings.PlexDatabase); m_Itunes = new ItunesManager(); progressBar1.Value = 0; m_UpdateCount = 0; m_AddCount = 0; bwProcess.RunWorkerAsync(); }
private List <PlexTableAccounts> GetPlexAccounts() { PlexDatabaseControlller plex = new PlexDatabaseControlller(GetProperty("Plex Database").Value.ToString()); if (plex.IsDbConnected) { string sql = @"SELECT id, 'Master' AS name FROM accounts WHERE id = 0 UNION ALL SELECT id, name FROM accounts WHERE id > 0;"; return(plex.ReadPlexAndMap <PlexTableAccounts>(sql)); } return(new List <PlexTableAccounts>()); }