private void PlaylistView_Drop(object sender, System.Windows.DragEventArgs e) { if (e.Data.GetDataPresent("mediaFile")) { string sourcePath = e.Data.GetData("mediaFile") as string; int index = playlistController.GetCurrentIndex(PlaylistView, e.GetPosition); PlaylistSet playlist = PlaylistView.Items[index] as PlaylistSet; string playlistName = playlist.Name; MediaSet mediaToAdd = new MediaSet(); string result = ""; using (var db = new MeLoDBModels()) { mediaToAdd.FullName = e.Data.GetData("mediaFile") as string; Regex r = new Regex(@"([^\\]+$)", RegexOptions.IgnoreCase | RegexOptions.Singleline); MatchCollection m = r.Matches(mediaToAdd.FullName); foreach (Match item in m) { result += item.Groups[1].ToString(); } mediaToAdd.Name = result; mediaToAdd.TypeId = 3; mediaToAdd.PlaylistSetId = db.PlaylistSet.Where(p => p.Name == playlistName).Single().Id; db.MediaSet.Add(mediaToAdd); db.SaveChanges(); } } }
public void SavePlaylistToDatabase(PlaylistSet pl) { using (var db = new MeLoDBModels()) { db.PlaylistSet.Add(pl); db.SaveChanges(); } }
public List <PlaylistSet> GetPlaylists() { List <PlaylistSet> playlists; using (var db = new MeLoDBModels()) { playlists = db.PlaylistSet.ToList(); } return(playlists); }
private void PlaylistView_SelectionChanged(object sender, SelectionChangedEventArgs e) { try { PlaylistSet newItem = (PlaylistSet)e.AddedItems[0]; ContentView.Items.Clear(); using (var db = new MeLoDBModels()) { var playlistId = db.PlaylistSet.Where(p => p.Name == newItem.Name).Single().Id; var content = db.MediaSet.Where(m => m.PlaylistSetId == playlistId).ToArray(); foreach (var item in content) { ContentView.Items.Add(item); } } } catch { } }