public ArtistInfoRespond getArtistInfo(int id)
{
if (!(_context.Artists.Any(x => x.idArtist == id)))
{
return(null);
}
string qnickname = _context.Artists.Where(x => x.idArtist == id).Select(x => x.nickname).FirstOrDefault();
var qevents = (from zmienna1 in _context.Events
join zmienna2 in _context.ArtistEvents on zmienna1.idEvent equals zmienna2.idEvent
where zmienna2.idArtist == id
orderby zmienna2.performanceDate.Year descending
select new Event
{
idEvent = zmienna1.idEvent,
name = zmienna1.name,
startDate = zmienna1.startDate,
endDate = zmienna1.endDate
}).ToList();
ArtistInfoRespond artResp = new ArtistInfoRespond
{
nickname = qnickname,
events = qevents
};
return(artResp);
}
public IActionResult getArtistInfo(int id)
{
id = 1;
ArtistInfoRespond air = _context.getArtistInfo(id);
if (air == null)
{
return(NotFound("Artist not found"));
}
return(Ok(new { air.nickname, air.events }));
}
