// 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 <CrudeFinancialBookingTransactionContract> FetchWithFilter(System.Guid financialBookingTransactionId, System.Guid bookingId, int transactionNumber, string financialBookingTransactionTypeRcd, decimal amount, System.Guid financialFeeId, System.Guid financialTaxId, System.Guid financialFareId, System.Guid financialPaymentId, System.Guid financialCurrencyId, System.Guid financialCostcentreId, System.Guid financialAdjustmentId, System.Guid financialServiceId, System.Guid userId, System.DateTime dateTime)
{
var list = new List <CrudeFinancialBookingTransactionContract>();
List <CrudeFinancialBookingTransactionData> dataList = CrudeFinancialBookingTransactionData.FetchWithFilter(
financialBookingTransactionId: financialBookingTransactionId,
bookingId: bookingId,
transactionNumber: transactionNumber,
financialBookingTransactionTypeRcd: financialBookingTransactionTypeRcd,
amount: amount,
financialFeeId: financialFeeId,
financialTaxId: financialTaxId,
financialFareId: financialFareId,
financialPaymentId: financialPaymentId,
financialCurrencyId: financialCurrencyId,
financialCostcentreId: financialCostcentreId,
financialAdjustmentId: financialAdjustmentId,
financialServiceId: financialServiceId,
userId: userId,
dateTime: dateTime
);
foreach (CrudeFinancialBookingTransactionData data in dataList)
{
var crudeFinancialBookingTransactionContract = new CrudeFinancialBookingTransactionContract();
DataToContract(data, crudeFinancialBookingTransactionContract);
list.Add(crudeFinancialBookingTransactionContract);
}
return(list);
}