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