// 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 <CrudeFlightScheduleSegmentContract> FetchWithFilter(System.Guid flightScheduleSegmentId, System.Guid flightScheduleId, System.Guid departureAirportId, System.Guid arrivalAirportId, int physicalSegmentNumber, int logicalSegmentNumber, System.TimeSpan departureTime, System.TimeSpan arrivalTime, string departureGate, string arrivalGate, System.Guid userId, System.DateTime dateTime)
{
var list = new List <CrudeFlightScheduleSegmentContract>();
List <CrudeFlightScheduleSegmentData> dataList = CrudeFlightScheduleSegmentData.FetchWithFilter(
flightScheduleSegmentId: flightScheduleSegmentId,
flightScheduleId: flightScheduleId,
departureAirportId: departureAirportId,
arrivalAirportId: arrivalAirportId,
physicalSegmentNumber: physicalSegmentNumber,
logicalSegmentNumber: logicalSegmentNumber,
departureTime: departureTime,
arrivalTime: arrivalTime,
departureGate: departureGate,
arrivalGate: arrivalGate,
userId: userId,
dateTime: dateTime
);
foreach (CrudeFlightScheduleSegmentData data in dataList)
{
var crudeFlightScheduleSegmentContract = new CrudeFlightScheduleSegmentContract();
DataToContract(data, crudeFlightScheduleSegmentContract);
list.Add(crudeFlightScheduleSegmentContract);
}
return(list);
}
