public async Task <IActionResult> GetVenuesByQuery([FromQuery] VenueQuery query)
{
var pagedResult = await venuesService.GetVenuesByStatusesAndQuery(query, VenueStatuses.Avaliable);
var result = mapper.Map <IEnumerable <VenueResource> >(pagedResult);
return(Ok(result));
}
public async Task <IActionResult> GetVenuesByCity([FromQuery] VenueQuery venueQuery)
{
var venues = await _venueService.GetVenuesByQuery(venueQuery);
var result = _mapper.Map <IEnumerable <VenueResource> >(venues);
return(Ok(result));
}
public async Task <IEnumerable <Venue> > GetVenuesQuery(VenueQuery query)
{
var queryable = context.Venues.AsQueryable();
if (query.Cities != null)
{
queryable = queryable.Where(v => query.Cities.Contains(v.CityId));
}
return(await queryable.ToListAsync());
}
public async Task <IEnumerable <Venue> > GetVenuesByStatusesAndQuery(VenueQuery query, params VenueStatuses[] statuses)
{
var queriable = context.Venues.Where(v => statuses.Contains(v.Status));
if (query.Cities != null)
{
queriable = queriable.Where(v => query.Cities.Contains(v.CityId));
}
return(await queriable.ToListAsync());
}
public async Task <IActionResult> CreateEvent([FromQuery] VenueQuery venueQuery)
{
ViewBag.Categories = new SelectList(await _categoryService.GetCategories(), "Id", "Name");
ViewBag.Venues = new SelectList(await _venueService.GetVenuesByQuery(venueQuery), "Id", "Name");
var eventsViewModel = new EventsViewModel
{
Cities = (await _cityService.GetCities()).ToArray()
};
return(View(eventsViewModel));
}
public async Task <IEnumerable <Venue> > GetVenuesByQuery(VenueQuery venueQuery)
{
var queryable = _context.Venues
.Include(c => c.City)
.AsQueryable();
if (venueQuery.Cities != null)
{
queryable = queryable.Where(v => venueQuery.Cities.Contains(v.CityId));
}
return(await queryable.ToListAsync());
}
public async Task <PagedResult <Venue> > GetVenuesByCities(VenueQuery query)
{
var queryable = context.Venues.AsQueryable();
if (query.cities != null)
{
queryable = queryable.Where(c => query.cities.Contains(c.CityId));
}
var items = await queryable.ToListAsync();
return(new PagedResult <Venue> {
Items = items
});
}
public async Task <IActionResult> Index([FromQuery] VenueQuery venueQuery)
{
return(View(await _venueService.GetVenuesByQuery(venueQuery)));
}
public async Task <IActionResult> GetVenuesByCity([FromQuery] VenueQuery query)
{
var pagedResult = await venueService.GetVenuesByCities(query);
return(Ok(mapper.Map <IEnumerable <VenueResource> >(pagedResult.Items)));
}
