public async Task <ItemsPageEntity <AirplaneEntity> > SearchAirplanesAsync(AirplaneFilterEntity filter)
{
using SqlConnection db = new SqlConnection(_dalSettings.ConnectionString);
IEnumerable <PaginationAirplaneEntity> queryResult = await db.QueryAsync <PaginationAirplaneEntity>(
"SearchAirplanes",
filter,
commandType : CommandType.StoredProcedure);
if (!queryResult.Any())
{
return(new ItemsPageEntity <AirplaneEntity>(
new List <AirplaneEntity>(),
0
));
}
int totalCount = queryResult.First().TotalCount;
List <AirplaneEntity> airplanes = queryResult.Select(_mapper.Map <AirplaneEntity>).ToList();
return(new ItemsPageEntity <AirplaneEntity>(
airplanes,
totalCount
));
}
public async Task <ItemsPage <Airplane> > SearchAirplanesAsync(AirplaneFilter filter)
{
AirplaneFilterEntity filterDal = _mapper.Map <AirplaneFilterEntity>(filter);
ItemsPageEntity <AirplaneEntity> airplanesDal =
await _airplaneRepository.SearchAirplanesAsync(filterDal);
ItemsPage <Airplane> airplanes = _mapper.Map <ItemsPage <Airplane> >(airplanesDal);
return(airplanes);
}
public async Task <ItemsPageEntity <AirplaneEntity> > SearchAirplanesAsync(AirplaneFilterEntity filter)
{
return(new ItemsPageEntity <AirplaneEntity>(_airplaneData, _airplaneData.Count));
}
