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