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