コード例 #1
0
        public void Update(TablaturePlaylist playlist)
        {
            using (var cmd = new SQLiteCommand(_databaseHelper.GetConnection()))
            {
                cmd.CommandType = CommandType.Text;
                cmd.CommandText = string.Format(@"INSERT OR REPLACE INTO {0} (id, name, created) VALUES (@id, @name, @created)", TabsterDatabaseHelper.TablePlaylists);
                cmd.Parameters.Add(new SQLiteParameter("@id", playlist.Id));
                cmd.Parameters.Add(new SQLiteParameter("@name", playlist.Name));
                cmd.Parameters.Add(new SQLiteParameter("@created", TabsterDatabaseHelper.GetUnixTimestamp(playlist.Created.Value)));
                cmd.ExecuteNonQuery();
            }

            playlist.Id = _databaseHelper.GetConnection().LastInsertRowId;

            RemovePlaylistItems(playlist);

            foreach (var item in playlist)
            {
                using (var cmd = new SQLiteCommand(_databaseHelper.GetConnection()))
                {
                    cmd.CommandType = CommandType.Text;
                    cmd.CommandText = string.Format(@"INSERT INTO {0} (filename, playlist_id) VALUES (@filename, @playlist_id)", TabsterDatabaseHelper.TablePlaylistItems);
                    cmd.Parameters.Add(new SQLiteParameter("@filename", item.FileInfo.FullName));
                    cmd.Parameters.Add(new SQLiteParameter("@playlist_id", playlist.Id));
                    cmd.ExecuteNonQuery();
                }
            }

            _playlists.Add(playlist);
        }
コード例 #2
0
        private void AddPlaylistNode(TablaturePlaylist playlist, bool select = false)
        {
            var playlistRootNode = sidemenu.Nodes["node_playlists"];

            //check if tablaturePlaylist node already exists
            var node = playlistRootNode.Nodes.Cast <TreeNode>().FirstOrDefault(n => n.Tag.Equals(playlist));

            if (node == null)
            {
                node = new TreeNode(playlist.Name)
                {
                    NodeFont = sidemenu.FirstNode.FirstNode.NodeFont, Tag = playlist
                };
                playlistRootNode.Nodes.Add(node);

                if (!playlistRootNode.IsExpanded)
                {
                    playlistRootNode.ExpandAll();
                }
            }

            if (select)
            {
                sidemenu.SelectedNode = node;
            }
        }
コード例 #3
0
        public PlaylistDetailsDialog(TablaturePlaylist playlist)
        {
            InitializeComponent();

            _playlist = playlist;

            LoadData();
        }
コード例 #4
0
        public PlaylistDetailsDialog(TablaturePlaylist playlist)
        {
            InitializeComponent();

            _playlist = playlist;

            LoadData();
        }
コード例 #5
0
 private void RemovePlaylistItems(TablaturePlaylist playlist)
 {
     using (var cmd = new SQLiteCommand(_databaseHelper.GetConnection()))
     {
         cmd.CommandType = CommandType.Text;
         cmd.CommandText = string.Format(@"DELETE FROM {0} WHERE playlist_id=@playlist_id", TabsterDatabaseHelper.TablePlaylistItems);
         cmd.Parameters.Add(new SQLiteParameter("@playlist_id", playlist.Id));
         cmd.ExecuteNonQuery();
     }
 }
コード例 #6
0
        /// <summary>
        ///     Convert Xml-based files to binary.
        /// </summary>
        public static void ConvertXmlFiles(PlaylistManager playlistManager, LibraryManager libraryManager)
        {
            var playlistsDirectory = Path.Combine(TabsterEnvironment.GetEnvironmentDirectoryPath(TabsterEnvironmentDirectory.UserData), "Playlists");

            // playlists are no longer stored as files, but are now stored in database
            if (Directory.Exists(playlistsDirectory))
            {
#pragma warning disable 612
                var playlistProcessor = new TabsterFileProcessor <TablaturePlaylistDocument>(TablaturePlaylistDocument.FileVersion);
#pragma warning restore 612

                foreach (var file in Directory.GetFiles(playlistsDirectory, string.Format("*{0}", Constants.TablaturePlaylistFileExtension), SearchOption.AllDirectories))
                {
                    var playlistFile = playlistProcessor.Load(file);

                    if (playlistFile != null)
                    {
                        var playlist = new TablaturePlaylist(playlistFile.Name)
                        {
                            Created = playlistFile.FileAttributes.Created
                        };

                        foreach (var item in playlistFile)
                        {
                            playlist.Add(item);
                        }

                        playlistManager.Update(playlist);

                        try
                        {
                            File.Delete(file);
                        }

                        catch (Exception ex)
                        {
                            Logging.GetLogger().Error(string.Format("Error occured during playlist conversion: {0}", file), ex);
                        }
                    }
                }
            }

            if (Directory.Exists(libraryManager.TablatureDirectory))
            {
                foreach (var file in Directory.GetFiles(libraryManager.TablatureDirectory, string.Format("*{0}", Constants.TablatureFileExtension), SearchOption.AllDirectories))
                {
                    var tablatureFile = TabsterXmlFileConverter.ConvertTablatureDocument(file);

                    if (tablatureFile != null)
                    {
                        tablatureFile.Save(file);
                    }
                }
            }
        }
コード例 #7
0
 private void RemovePlaylistNode(TablaturePlaylist playlist)
 {
     foreach (TreeNode node in sidemenu.Nodes["node_playlists"].Nodes)
     {
         if (node.Tag.Equals(playlist))
         {
             sidemenu.Nodes.Remove(node);
             break;
         }
     }
 }
コード例 #8
0
        /// <summary>
        ///     Convert Xml-based files to binary.
        /// </summary>
        public static void ConvertXmlFiles(PlaylistManager playlistManager, LibraryManager libraryManager)
        {
            var playlistsDirectory = Path.Combine(TabsterEnvironment.GetEnvironmentDirectoryPath(TabsterEnvironmentDirectory.UserData), "Playlists");

            // playlists are no longer stored as files, but are now stored in database
            if (Directory.Exists(playlistsDirectory))
            {
            #pragma warning disable 612
                var playlistProcessor = new TabsterFileProcessor<TablaturePlaylistDocument>(TablaturePlaylistDocument.FileVersion);
            #pragma warning restore 612

                foreach (var file in Directory.GetFiles(playlistsDirectory, string.Format("*{0}", Constants.TablaturePlaylistFileExtension), SearchOption.AllDirectories))
                {
                    var playlistFile = playlistProcessor.Load(file);

                    if (playlistFile != null)
                    {
                        var playlist = new TablaturePlaylist(playlistFile.Name) {Created = playlistFile.FileAttributes.Created};

                        foreach (var item in playlistFile)
                        {
                            playlist.Add(item);
                        }

                        playlistManager.Update(playlist);

                        try
                        {
                            File.Delete(file);
                        }

                        catch(Exception ex)
                        {
                            Logging.GetLogger().Error(string.Format("Error occured during playlist conversion: {0}", file), ex);
                        }
                    }
                }
            }

            if (Directory.Exists(libraryManager.TablatureDirectory))
            {
                foreach (var file in Directory.GetFiles(libraryManager.TablatureDirectory, string.Format("*{0}", Constants.TablatureFileExtension), SearchOption.AllDirectories))
                {
                    var tablatureFile = TabsterXmlFileConverter.ConvertTablatureDocument(file);

                    if (tablatureFile != null)
                        tablatureFile.Save(file);
                }
            }
        }
コード例 #9
0
        public void Load()
        {
            _playlists.Clear();

            using (var cmd = new SQLiteCommand(string.Format("SELECT * FROM {0}", TabsterDatabaseHelper.TablePlaylists), _databaseHelper.GetConnection()))
            {
                using (var reader = cmd.ExecuteReader())
                {
                    while (reader.Read())
                    {
                        var id       = long.Parse(reader["id"].ToString());
                        var name     = reader["name"].ToString();
                        var created  = reader["created"].ToString();
                        var playlist = new TablaturePlaylist(name)
                        {
                            Id = id, Created = TabsterDatabaseHelper.UnixTimestampToDateTime(int.Parse(created))
                        };
                        _playlists.Add(playlist);
                    }
                }
            }

            foreach (var playlist in _playlists)
            {
                using (var cmd = new SQLiteCommand(string.Format("SELECT * FROM {0} WHERE playlist_id=@playlist_id", TabsterDatabaseHelper.TablePlaylistItems), _databaseHelper.GetConnection()))
                {
                    cmd.Parameters.Add(new SQLiteParameter("@playlist_id", playlist.Id));

                    using (var reader = cmd.ExecuteReader())
                    {
                        while (reader.Read())
                        {
                            var id       = long.Parse(reader["id"].ToString());
                            var filename = reader["filename"].ToString();

                            var file = _fileProcessor.Load(filename);

                            if (file != null)
                            {
                                var fileInfo = new FileInfo(filename);
                                var item     = new TablaturePlaylistItem(file, fileInfo);
                                playlist.Add(item);
                            }
                        }
                    }
                }
            }
        }
コード例 #10
0
ファイル: PlaylistManager.cs プロジェクト: GetTabster/Tabster
        public void Load()
        {
            _playlists.Clear();

            using (var cmd = new SQLiteCommand(string.Format("SELECT * FROM {0}", TabsterDatabaseHelper.TablePlaylists), _databaseHelper.GetConnection()))
            {
                using (var reader = cmd.ExecuteReader())
                {
                    while (reader.Read())
                    {
                        var id = long.Parse(reader["id"].ToString());
                        var name = reader["name"].ToString();
                        var created = reader["created"].ToString();
                        var playlist = new TablaturePlaylist(name) {Id = id, Created = TabsterDatabaseHelper.UnixTimestampToDateTime(int.Parse(created))};
                        _playlists.Add(playlist);
                    }
                }
            }

            foreach (var playlist in _playlists)
            {
                using (var cmd = new SQLiteCommand(string.Format("SELECT * FROM {0} WHERE playlist_id=@playlist_id", TabsterDatabaseHelper.TablePlaylistItems), _databaseHelper.GetConnection()))
                {
                    cmd.Parameters.Add(new SQLiteParameter("@playlist_id", playlist.Id));

                    using (var reader = cmd.ExecuteReader())
                    {
                        while (reader.Read())
                        {
                            var id = long.Parse(reader["id"].ToString());
                            var filename = reader["filename"].ToString();

                            var file = _fileProcessor.Load(filename);

                            if (file != null)
                            {
                                var fileInfo = new FileInfo(filename);
                                var item = new TablaturePlaylistItem(file, fileInfo);
                                playlist.Add(item);
                            }
                        }
                    }
                }
            }
        }
コード例 #11
0
        private void AddPlaylistNode(TablaturePlaylist playlist, bool select = false)
        {
            var playlistRootNode = sidemenu.Nodes["node_playlists"];

            //check if tablaturePlaylist node already exists
            var node = playlistRootNode.Nodes.Cast<TreeNode>().FirstOrDefault(n => n.Tag.Equals(playlist));

            if (node == null)
            {
                node = new TreeNode(playlist.Name) {NodeFont = sidemenu.FirstNode.FirstNode.NodeFont, Tag = playlist};
                playlistRootNode.Nodes.Add(node);

                if (!playlistRootNode.IsExpanded)
                    playlistRootNode.ExpandAll();
            }

            if (select)
                sidemenu.SelectedNode = node;
        }
コード例 #12
0
        private void NewPlaylist(object sender, EventArgs e)
        {
            using (var p = new NewPlaylistDialog())
            {
                if (p.ShowDialog() == DialogResult.OK)
                {
                    if (string.IsNullOrEmpty(p.PlaylistName))
                    {
                        MessageBox.Show(Resources.InvalidNameDialogText, Resources.InvalidNameDialogTitle, MessageBoxButtons.OK, MessageBoxIcon.Error);
                        return;
                    }

                    var playlist = new TablaturePlaylist(p.PlaylistName)
                    {
                        Created = DateTime.UtcNow
                    };

                    var item = GetSelectedLibraryItem();

                    // new playlist
                    if (sender == newPlaylistToolStripMenuItem)
                    {
                        // 'add to' new playlist
                        if (item != null)
                        {
                            playlist.Add(new TablaturePlaylistItem(item.File, item.FileInfo));
                        }
                    }

                    _playlistManager.Update(playlist);

                    AddPlaylistNode(playlist);
                    PopulatePlaylistMenu();
                    UpdateDetails();
                }
            }
        }
コード例 #13
0
 private void RemovePlaylistNode(TablaturePlaylist playlist)
 {
     foreach (TreeNode node in sidemenu.Nodes["node_playlists"].Nodes)
     {
         if (node.Tag.Equals(playlist))
         {
             sidemenu.Nodes.Remove(node);
             break;
         }
     }
 }
コード例 #14
0
        private void NewPlaylist(object sender, EventArgs e)
        {
            using (var p = new NewPlaylistDialog())
            {
                if (p.ShowDialog() == DialogResult.OK)
                {
                    if (string.IsNullOrEmpty(p.PlaylistName))
                    {
                        MessageBox.Show(Resources.InvalidNameDialogText, Resources.InvalidNameDialogTitle, MessageBoxButtons.OK, MessageBoxIcon.Error);
                        return;
                    }

                    var playlist = new TablaturePlaylist(p.PlaylistName) {Created = DateTime.UtcNow};

                    var item = GetSelectedLibraryItem();

                    // new playlist
                    if (sender == newPlaylistToolStripMenuItem)
                    {
                        // 'add to' new playlist
                        if (item != null)
                        {
                            playlist.Add(new TablaturePlaylistItem(item.File, item.FileInfo));
                        }
                    }

                    _playlistManager.Update(playlist);

                    AddPlaylistNode(playlist);
                    PopulatePlaylistMenu();
                    UpdateDetails();
                }
            }
        }
コード例 #15
0
ファイル: PlaylistManager.cs プロジェクト: GetTabster/Tabster
        public void Remove(TablaturePlaylist playlist)
        {
            using (var cmd = new SQLiteCommand(_databaseHelper.GetConnection()))
            {
                cmd.CommandType = CommandType.Text;
                cmd.CommandText = string.Format(@"DELETE FROM {0} WHERE id=@id", TabsterDatabaseHelper.TablePlaylists);
                cmd.Parameters.Add(new SQLiteParameter("@id", playlist.Id));
                cmd.ExecuteNonQuery();
            }

            RemovePlaylistItems(playlist);
        }
コード例 #16
0
ファイル: PlaylistManager.cs プロジェクト: GetTabster/Tabster
        public void Update(TablaturePlaylist playlist)
        {
            using (var cmd = new SQLiteCommand(_databaseHelper.GetConnection()))
            {
                cmd.CommandType = CommandType.Text;
                cmd.CommandText = string.Format(@"INSERT OR REPLACE INTO {0} (id, name, created) VALUES (@id, @name, @created)", TabsterDatabaseHelper.TablePlaylists);
                cmd.Parameters.Add(new SQLiteParameter("@id", playlist.Id));
                cmd.Parameters.Add(new SQLiteParameter("@name", playlist.Name));
                cmd.Parameters.Add(new SQLiteParameter("@created", TabsterDatabaseHelper.GetUnixTimestamp(playlist.Created.Value)));
                cmd.ExecuteNonQuery();
            }

            playlist.Id = _databaseHelper.GetConnection().LastInsertRowId;

            RemovePlaylistItems(playlist);

            foreach (var item in playlist)
            {
                using (var cmd = new SQLiteCommand(_databaseHelper.GetConnection()))
                {
                    cmd.CommandType = CommandType.Text;
                    cmd.CommandText = string.Format(@"INSERT INTO {0} (filename, playlist_id) VALUES (@filename, @playlist_id)", TabsterDatabaseHelper.TablePlaylistItems);
                    cmd.Parameters.Add(new SQLiteParameter("@filename", item.FileInfo.FullName));
                    cmd.Parameters.Add(new SQLiteParameter("@playlist_id", playlist.Id));
                    cmd.ExecuteNonQuery();
                }
            }

            _playlists.Add(playlist);
        }