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