// fetch all rows from table into new List of Contracts, filtered by any column
// links:
// docLink: http://sql2x.org/documentationLink/ce01ef4a-5cd0-4e51-b211-9c0a15b791a0
public List <CrudeAircraftContract> FetchWithFilter(System.Guid aircraftId, string aircraftName, string aircraftTypeRcd, string aircraftConfigurationRcd, string aircraftBodyRcd, System.Guid aircraftMeasurementId, System.Guid productId, System.DateTime operationalDateTime, System.DateTime firstFlightDateTime, string engineType, int passengerCapacity, System.Guid userId, System.DateTime dateTime)
{
var list = new List <CrudeAircraftContract>();
List <CrudeAircraftData> dataList = CrudeAircraftData.FetchWithFilter(
aircraftId: aircraftId,
aircraftName: aircraftName,
aircraftTypeRcd: aircraftTypeRcd,
aircraftConfigurationRcd: aircraftConfigurationRcd,
aircraftBodyRcd: aircraftBodyRcd,
aircraftMeasurementId: aircraftMeasurementId,
productId: productId,
operationalDateTime: operationalDateTime,
firstFlightDateTime: firstFlightDateTime,
engineType: engineType,
passengerCapacity: passengerCapacity,
userId: userId,
dateTime: dateTime
);
foreach (CrudeAircraftData data in dataList)
{
var crudeAircraftContract = new CrudeAircraftContract();
DataToContract(data, crudeAircraftContract);
list.Add(crudeAircraftContract);
}
return(list);
}
