public async Task <IActionResult> GetGetInsByDay(int dayId) { var getIns = await _repo.GetGetIns(); var artists = await _repo.GetArtists(); var venues = await _repo.GetVenues(); var getInsForDayId = (from g in getIns where g.DayId == dayId join artist in artists on g.ArtistId equals artist.Id select new { Id = g.Id, Start = g.Start, End = g.End, ArtistId = g.ArtistId, Artist = artist.Name, VenueId = g.VenueId }).ToList(); var getInsForDayIdByVenue = (from g in getInsForDayId join venue in venues on g.VenueId equals venue.Id orderby g.VenueId select new { Id = g.Id, Start = g.Start, End = g.End, ArtistId = g.ArtistId, Artist = g.Artist, VenueId = g.VenueId, Venue = venue.Name }).ToList(); //var getInsByArtist = (from g in getIns // join a in artists // on g.ArtistId equals a.Id // select new // { // Id = g.Id, // Start = g.Start, // End = g.End, // Artist = a.Name // }).ToList(); return(Ok(getInsForDayIdByVenue)); }
public async Task <IActionResult> GetArtistsNames() { var artistsList = await _repo.GetArtists(); var artistsToReturn = _mapper.Map <IEnumerable <ArtistsNamesDto> >(artistsList); //var artists = await _repo.GetArtists(); //var artistsToReturn = _mapper.Map<IEnumerable<ArtistForListDto>>(artists); return(Ok(artistsToReturn)); }