public static string GetPlaylists()
{
using (var context = new mf_surfplEntities())
{
return JsonConvert.SerializeObject(context.Playlists.ToList());
}
}
public static string GetTracksInPlaylist(int playlistId)
{
using (var context = new mf_surfplEntities())
{
return JsonConvert.SerializeObject(
context.Tracks.Where(t =>
t.Playlists.Any(p =>
p.PlaylistID == playlistId)).ToList());
}
}
public static string GetTracksByGenre(int genreId)
{
using (var context = new mf_surfplEntities())
{
return JsonConvert.SerializeObject(
context.Tracks.Where(t =>
t.GenreID == genreId).ToList());
}
}
