50 lines
2.0 KiB
C#
50 lines
2.0 KiB
C#
|
using System;
|
|||
|
|
using System.Collections.Generic;
|
|||
|
|
using System.ComponentModel.DataAnnotations;
|
|||
|
|
using System.Linq;
|
|||
|
|
using System.Threading.Tasks;
|
|||
|
|
using Microsoft.AspNetCore.Http;
|
|||
|
|
using Microsoft.AspNetCore.Mvc;
|
|||
|
|
using Microsoft.EntityFrameworkCore;
|
|||
|
|
using ThAmCo.Venues.Data;
|
|||
|
|
|
|||
|
|
namespace ThAmCo.Venues.Controllers
|
|||
|
|
{
|
|||
|
|
[Route("api/[controller]")]
|
|||
|
|
[ApiController]
|
|||
|
|
public class AvailabilityController : ControllerBase
|
|||
|
|
{
|
|||
|
|
private readonly VenuesDbContext _context;
|
|||
|
|
|
|||
|
|
public AvailabilityController(VenuesDbContext context)
|
|||
|
|
{
|
|||
|
|
_context = context;
|
|||
|
|
}
|
|||
|
|
|
|||
|
|
// GET: api/Availability?eventType=X?beginDate=X&endDate=X
|
|||
|
|
[HttpGet]
|
|||
|
|
public async Task<IActionResult> Get([FromQuery, MinLength(3), MaxLength(3), Required] string eventType,
|
|||
|
|
[FromQuery, Required] DateTime beginDate,
|
|||
|
|
[FromQuery, Required] DateTime endDate)
|
|||
|
|
{
|
|||
|
|
var avails = _context.Availabilities
|
|||
|
|
.Where(a => a.Reservation == null
|
|||
|
|
&& a.Date >= beginDate.Date
|
|||
|
|
&& a.Date <= endDate.Date)
|
|||
|
|
.Join(_context.Suitabilities.Where(s => s.EventTypeId == eventType),
|
|||
|
|
a => a.VenueCode,
|
|||
|
|
s => s.VenueCode,
|
|||
|
|
(a, s) => new
|
|||
|
|
{
|
|||
|
|
a.Venue.Code,
|
|||
|
|
a.Venue.Name,
|
|||
|
|
a.Venue.Description,
|
|||
|
|
a.Venue.Capacity,
|
|||
|
|
a.Date,
|
|||
|
|
a.CostPerHour
|
|||
|
|
});
|
|||
|
|
|
|||
|
|
return Ok(await avails.ToListAsync());
|
|||
|
|
}
|
|||
|
|
}
|
|||
|
|
}
|