//Helper
public VenueDetail GetVenueByID(int id)
{
var venuesCommunity = new List <ArtistListItem>();
var showService = new ShowService();
using (var ctx = new ApplicationDbContext())
{
var entity = ctx.Venues.Single(e => e.VenueID == id);
var listOfShowDetailModels = new List <ShowDetail>(); // something weird here with using Shows rather than showDetail
foreach (var show in entity.Shows)
{
var showToAdd = showService.GetShowByID(show.ShowID);
foreach (var artist in showToAdd.ListOfArtist)
{
var artistToAdd = new ArtistListItem()
{
ArtistID = artist.ArtistID,
ArtistName = artist.ArtistName,
Location = artist.Location
};
venuesCommunity.Add(artistToAdd);
}
listOfShowDetailModels.Add(showToAdd);
}
return(new VenueDetail
{
VenueID = entity.VenueID,
VenueName = entity.VenueName,
VenueType = entity.VenueType,
Location = entity.Location,
ListOfShows = listOfShowDetailModels,
ArtistCommunity = venuesCommunity
});
}
}
public List <ArtistListItem> GetArtistCommunity(ArtistDetail baseArtist) //int id
{
var artistCommunity = new List <ArtistListItem>();
// get artistShowData where artistShowData.ShowID == show.ShowID in artist.ListOfShows
foreach (var show in baseArtist.ListOfShows)
{
foreach (var artist in show.ListOfArtist)
{
if (artist.ArtistID != baseArtist.ArtistID)
{
var artistListItem = new ArtistListItem()
{
ArtistID = artist.ArtistID,
ArtistName = artist.ArtistName,
Location = artist.Location
};
artistCommunity.Add(artistListItem);
}
}
}
return(artistCommunity);
}
