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 { }
 }