public IActionResult GetTransportation() { APIByIdObjectResponse ard = new APIByIdObjectResponse(); try { var data = db.Transportations.ToList().ToDictionary(x => x.Id, x => x); ard.ObjectsArray = data; ard.Message = "Success"; } catch (Exception ex) { ard.Message = ex.Message.ToString(); } return(response.JsonReturn(ard, 200)); }
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)); }
public async Task <IActionResult> GetQuotes([FromBody] GetQuoteRequest request) { APIByIdObjectResponse ard = new APIByIdObjectResponse(); try { int total = db.Quotes.Where((x) => request.Deleted == false ? x.QuoteStatus == (int)QuoteStatus.SUCCEEDED : x.QuoteStatus == (int)QuoteStatus.DELETED).Count(); var data = await db.Quotes .Include((x) => x.Customer).Include((x) => x.Departure).Include((x) => x.Destination).Include((x) => x.Transportation) .Where((x) => request.Id != null ? x.Id == request.Id : true) .Where((x) => request.Deleted == false ? x.QuoteStatus == (int)QuoteStatus.SUCCEEDED : x.QuoteStatus == (int)QuoteStatus.DELETED) .Where((x) => request.Keywords.Length > 0 ? x.Customer.FirstName.Contains(request.Keywords) : true) .Skip((request.PageSize ?? 20) * ((request.PageNumber ?? 0) - 1)) .Take(request.PageSize ?? 20) .ToListAsync(); List <QuoteDTO> qut = new List <QuoteDTO>(); data.ForEach((x) => { qut.Add(new QuoteDTO() { Id = x.Id, DepatureId = x.DepartureId, DestinationId = x.DestinationId, TransportationId = x.TransportationId, NumberOfTravellers = x.NumberOfTravellers, DepatureDate = x.DepatureDate, ReturnDate = x.ReturnDate, DateAdded = x.DateAdded, DateModified = x.DateModified, Customer = new CustomerDTO() { Id = x.Customer.Id, FirstName = x.Customer.FirstName, LastName = x.Customer.LastName, PhoneNumber = x.Customer.PhoneNumber, Email = x.Customer.Email, Address = x.Customer.Address, }, Depature = new AirportDTO() { Id = x.Departure.Id, Name = x.Departure.Name, Code = x.Departure.Code, CountryCode = x.Departure.CountryCode, CountryName = x.Departure.CountryName, StateCode = x.Departure.StateCode }, Destination = new AirportDTO() { Id = x.Destination.Id, Name = x.Destination.Name, Code = x.Destination.Code, CountryCode = x.Destination.CountryCode, CountryName = x.Destination.CountryName, StateCode = x.Destination.StateCode }, }); }); ard.ObjectsArray = qut.ToDictionary(x => x.Id, x => x); ard.TotalRecords = total; ard.Message = "Success"; } catch (Exception ex) { ard.Message = ex.Message.ToString(); } return(response.JsonReturn(ard, 200)); }