public GetAirportResponse GetAirport(GetAirportRequest request)
{
var response = new GetAirportResponse
{
IsSuccessful = false,
Message = ""
};
try
{
// Query this airport where the AirportId matches in the database. Essentially this is a SQL WHERE clause.
var airport = _context.Airports.FirstOrDefault(Airport => Airport.Id == request.AirportId);
if (airport != null)
{
response.Airport = airport;
response.IsSuccessful = true;
response.Message = "Airport was found.";
}
else
{
response.IsSuccessful = false;
response.Message = "Aircrat was not found.";
}
}
catch (Exception ex)
{
response.IsSuccessful = false;
response.Message = ex.Message;
}
return(response);
}
public async Task <IActionResult> GetAirports([FromBody] GetAirportRequest request)
{
APIByIdObjectResponse ard = new APIByIdObjectResponse();
try
{
var data = await db.Airports
.Where((x) => request.Keywords.Length > 0?x.Name.Contains(request.Keywords) : true)
.Where((x) => request.Id != null ? x.Id == request.Id : true)
.Skip((request.PageSize ?? 20) * ((request.PageNumber ?? 0) - 1))
.Take(request.PageSize ?? 20).ToListAsync();
List <AirportDTO> dto = new List <AirportDTO>();
data.ForEach((x) =>
{
dto.Add(new AirportDTO()
{
Id = x.Id,
Name = x.Name,
Code = x.Code,
CountryCode = x.CountryCode,
CountryName = x.CountryName,
StateCode = x.StateCode
});
});
ard.ObjectsArray = data.ToDictionary(x => x.Id, x => x);
ard.Message = "Success";
}
catch (Exception ex)
{
ard.Message = ex.Message.ToString();
}
return(response.JsonReturn(ard, 200));
}
