public bool AddSongInPartyPlaylist(SongsForPartyTable playlist)
{
using (var db = new EntitiesChooseEm())
{
db.SongsForPartyTables.Add(playlist);
db.SaveChanges();
}
return(true);
}
public SongsForPartyTable UpdateSongRating(SongsForPartyTable songWithUpdatedRating)
{
using (var context = new EntitiesChooseEm())
{
SongsForPartyTable song = context.SongsForPartyTables.FirstOrDefault(p => p.songURL == songWithUpdatedRating.songURL && p.partyID == songWithUpdatedRating.partyID);
song.rating = songWithUpdatedRating.rating;
context.SaveChanges();
}
return(songWithUpdatedRating);
}
public SongsForPartyTable GetSongFromPartyPlaylist(long partyID, string songURL)
{
SongsForPartyTable song = null;
using (var db = new EntitiesChooseEm())
{
song = db.SongsForPartyTables.FirstOrDefault(p => p.partyID == partyID && p.songURL == songURL);
}
return(song);
}
public List <SongsForPartyTable> GetAllSongs(long partyID)
{
List <SongsForPartyTable> songs = new List <SongsForPartyTable>();
using (var db = new EntitiesChooseEm())
{
var sfp = db.SongsForPartyTables.Where(sP => sP.partyID == partyID);
foreach (var item in sfp)
{
SongsForPartyTable sp = new SongsForPartyTable
{
partyID = item.partyID,
songURL = item.songURL,
rating = item.rating,
RowVersion = item.RowVersion
};
songs.Add(sp);
}
}
return(songs);
}