public static void AddSongToPlaylist(int id, int playlistID)
{
var context = new MyJukeboxEntities();
var entry = new tPLentries()
{
PLID = playlistID,
SongID = id,
Pos = 1
};
context.tPLentries.Add(entry);
context.SaveChanges();
}
//public static List<string> GetQueryList()
//{
// List<string> queries = null;
// var context = new MyJukeboxEntities();
// queries = context.tQueries
// .Select(q => q.Query)
// .OrderBy(q => q).ToList();
// return queries;
//}
public static void AddSongToPlaylist(int id, string playlistName)
{
var context = new MyJukeboxEntities();
var playlist = context.tPlaylists
.Where(p => p.Name == playlistName)
.Select(p => p.ID).ToList();
if (playlist == null)
{
throw new Exception("Wrong playlist!");
}
var entry = new tPLentries()
{
PLID = playlist[0],
SongID = id,
Pos = 1
};
context.tPLentries.Add(entry);
context.SaveChanges();
}
