private void PlList_Drop(object sender, DragEventArgs e) { Music music = (Music)e.Data.GetData(typeof(Music)); PlaylistElement element = (PlaylistElement)e.Data.GetData(typeof(PlaylistElement)); this.ListChange(music, element, sender); }
private void ListViewItem_Drop(object sender, DragEventArgs e) { dropOnElement = true; Music music = (Music)e.Data.GetData(typeof(Music)); PlaylistElement element = (PlaylistElement)e.Data.GetData(typeof(PlaylistElement)); this.ListChange(music, element, sender); }
private void ListChange(Music music, PlaylistElement element, object sender) { if (music != null) { if (!dropOnElement || sender.GetType() == typeof(ListViewItem)) { if (sender.GetType() == typeof(ListViewItem)) { int index = this.PlList.Items.IndexOf(((ListViewItem)sender)); ListViewItem viewItem = new ListViewItem(); viewItem.Content = new PlaylistElement(music); this.PlList.Items.Insert(index, viewItem); } else { ListViewItem viewItem = new ListViewItem(); viewItem.Content = new PlaylistElement(music); this.PlList.Items.Add(viewItem); } } else { dropOnElement = false; } } if (element != null) { if (!dropOnElement || sender.GetType() == typeof(ListViewItem)) { if (sender.GetType() == typeof(ListViewItem)) { int indexSource = this.PlList.Items.IndexOf(DragDropHelper.DragSource); int indexDest = this.PlList.Items.IndexOf(((ListViewItem)sender)); this.PlList.Items.RemoveAt(indexSource); ListViewItem viewItem = new ListViewItem(); viewItem.Content = element; this.PlList.Items.Insert(indexDest, viewItem); } else { int indexSource = this.PlList.Items.IndexOf(DragDropHelper.DragSource); this.PlList.Items.RemoveAt(indexSource); ListViewItem viewItem = new ListViewItem(); viewItem.Content = element; this.PlList.Items.Add(viewItem); } } else { dropOnElement = false; } } }
static public List<PlaylistElement> getPlaylist(int idPlaylist) { List<PlaylistElement> pElements = new List<PlaylistElement>(); try { if (idPlaylist > 0) { String query = "SELECT * FROM Content WHERE Playlist = " + idPlaylist + ";"; SqlDataReader myReader = null; SqlCommand myCommand = new SqlCommand(query, _db); myReader = myCommand.ExecuteReader(); while (myReader.Read()) { int id = Convert.ToInt32(myReader["Media"]); Music mus = singleMusic(id); mus.Stretch = Convert.ToDouble(myReader["Stretch"]); PlaylistElement tmp = new PlaylistElement(mus); pElements.Add(tmp); } myReader.Close(); myCommand.Dispose(); ShareVar.IdPlaylist = idPlaylist; } else { ShareVar.IdPlaylist = 0; } } catch (Exception e) { Console.WriteLine(e.Message); } return pElements; }