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 })); }