public void Save(Models.Playlist ply)
{
var dbply = PlaylistMapper.ToDatabase(ply);
_dbContext.Playlist.Add(dbply);
_dbContext.SaveChanges();
//Console.WriteLine("\nSAVED");
}
public Models.Playlist GetPlaylist(int songid)
{
DbModels.ListSong couple = null;
if (_dbContext.ListSong.Where(x => x.SongId == songid).FirstOrDefault() != null)
{
couple = _dbContext.ListSong.Where(x => x.SongId == songid).FirstOrDefault();
}
DbModels.Playlist playlist = null;
if (couple != null)
{
playlist = _dbContext.Playlist.Where(x => x.Id == couple.PlaylistId).FirstOrDefault();
}
if (playlist == null)
{
return(null);
}
else
{
return(PlaylistMapper.FromDatabase(playlist));
}
}
public IEnumerable <Models.Playlist> GetAll()
{
return(_dbContext.Playlist.Select(x => PlaylistMapper.FromDatabase(x)));
}
public IEnumerable <Models.Playlist> GetAllPlaylists(string user)
{
var userid = _dbContext.MscUser.Where(x => x.Username == user).FirstOrDefault();
Console.WriteLine("User -- " + userid.Username.ToString() + " " + user);
if (_dbContext.Playlist.Where(x => x.MscUserId.Equals(userid.Id)).FirstOrDefault() != null)
{
var data = _dbContext.Playlist.Where(x => x.MscUserId == userid.Id).Select(x => PlaylistMapper.FromDatabase(x));
return(data);
}
else
{
return(Enumerable.Empty <Models.Playlist>());
}
//var data = _dbContext.Playlist.Where(x => x.MscUserId == userid.Id).Select(x => PlaylistMapper.FromDatabase(x));
}
