// fetch all from table into new List of class instances, filtered by any column
// links:
// docLink: http://sql2x.org/documentationLink/db27658d-4d23-46d7-9970-7bbaef8634b0
public List <CrudeFinancialSpecialServiceModel> FetchWithFilter(System.Guid financialSpecialServiceId, System.Guid serviceSpecialServiceRequestId, int quantity, decimal amount, System.Guid financialCurrencyId, System.Guid userId, System.DateTime dateTime)
{
var list = new List <CrudeFinancialSpecialServiceModel>();
List <CrudeFinancialSpecialServiceData> dataList = CrudeFinancialSpecialServiceData.FetchWithFilter(financialSpecialServiceId, serviceSpecialServiceRequestId, quantity, amount, financialCurrencyId, userId, dateTime);
foreach (CrudeFinancialSpecialServiceData data in dataList)
{
var crudeFinancialSpecialServiceBusinessModel = new CrudeFinancialSpecialServiceModel();
DataToModel(data, crudeFinancialSpecialServiceBusinessModel);
list.Add(crudeFinancialSpecialServiceBusinessModel);
}
return(list);
}
// 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 <CrudeFinancialSpecialServiceContract> FetchWithFilter(System.Guid financialSpecialServiceId, System.Guid serviceSpecialServiceRequestId, int quantity, decimal amount, System.Guid financialCurrencyId, System.Guid userId, System.DateTime dateTime)
{
var list = new List <CrudeFinancialSpecialServiceContract>();
List <CrudeFinancialSpecialServiceData> dataList = CrudeFinancialSpecialServiceData.FetchWithFilter(
financialSpecialServiceId: financialSpecialServiceId,
serviceSpecialServiceRequestId: serviceSpecialServiceRequestId,
quantity: quantity,
amount: amount,
financialCurrencyId: financialCurrencyId,
userId: userId,
dateTime: dateTime
);
foreach (CrudeFinancialSpecialServiceData data in dataList)
{
var crudeFinancialSpecialServiceContract = new CrudeFinancialSpecialServiceContract();
DataToContract(data, crudeFinancialSpecialServiceContract);
list.Add(crudeFinancialSpecialServiceContract);
}
return(list);
}