public async Task <MusicModel> GetSingleRecommendation(Data.MusicRecommendationsContext context, int id)
{
var song = from s in context.MusicModel
where s.Id == id
select s;
return(await song.SingleAsync());
}
public async Task <IList <MusicModel> > DeleteRecommendation(Data.MusicRecommendationsContext context, int id)
{
var song = from s in context.MusicModel
where s.Id == id
select s;
context.Remove(id);
// context.SaveChanges();
await context.SaveChangesAsync();
// return new list without the deleted song
return(await context.MusicModel.ToListAsync());
}
public async Task <IList <MusicModel> > CreateRecommendation(Data.MusicRecommendationsContext context, MusicModel newRecommendation)
{
// want to check if it already exists by song name
bool recommendationExists = context.MusicModel.Any(x => x.SongName == newRecommendation.SongName);
if (!recommendationExists)
{
context.Add(newRecommendation);
await context.SaveChangesAsync();
}
return(await context.MusicModel.ToListAsync());
}
public async Task <MusicModel> UpdateRecommendation(Data.MusicRecommendationsContext context, int id, MusicModel updatedRecommendation)
{
var songQuery = from s in context.MusicModel
where s.Id == id
select s;
var song = await songQuery.SingleAsync();
// look at each field from this id and update any field that is being edited by user
song.SongName = updatedRecommendation.SongName;
song.AlbumName = updatedRecommendation.AlbumName;
song.ArtistName = updatedRecommendation.ArtistName;
song.Genre = updatedRecommendation.Genre;
song.Price = updatedRecommendation.Price;
song.isRecommended = updatedRecommendation.isRecommended;
await context.SaveChangesAsync();
return(song);
}
public async Task <IList <MusicModel> > GetRecommendations(Data.MusicRecommendationsContext context, string searchString, string musicGenre)
{
var musicRecs = from m in context.MusicModel
select m;
if (!string.IsNullOrEmpty(searchString))
{
musicRecs = musicRecs.Where(s => s.SongName.Contains(searchString));
}
//if (!string.IsNullOrEmpty(ArtistName))
//{
// musicRecs = musicRecs.Where(x => x.ArtistName == ArtistName);
//}
if (!string.IsNullOrEmpty(musicGenre))
{
musicRecs = musicRecs.Where(x => x.Genre == musicGenre);
}
//Artists = new SelectList(await artistQuery.Distinct().ToListAsync());
return(await musicRecs.ToListAsync());
}
