// 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 <CrudeReportingRoundupModel> FetchWithFilter(System.Guid reportingRoundupId, System.DateTime date, string reportingRoundupTypeRcd, string reportingReferenceCode, int countNumber, System.Guid userId, System.DateTime dateTime)
{
var list = new List <CrudeReportingRoundupModel>();
List <CrudeReportingRoundupData> dataList = CrudeReportingRoundupData.FetchWithFilter(reportingRoundupId, date, reportingRoundupTypeRcd, reportingReferenceCode, countNumber, userId, dateTime);
foreach (CrudeReportingRoundupData data in dataList)
{
var crudeReportingRoundupBusinessModel = new CrudeReportingRoundupModel();
DataToModel(data, crudeReportingRoundupBusinessModel);
list.Add(crudeReportingRoundupBusinessModel);
}
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 <CrudeReportingRoundupContract> FetchWithFilter(System.Guid reportingRoundupId, System.DateTime date, string reportingRoundupTypeRcd, string reportingReferenceCode, int countNumber, System.Guid userId, System.DateTime dateTime)
{
var list = new List <CrudeReportingRoundupContract>();
List <CrudeReportingRoundupData> dataList = CrudeReportingRoundupData.FetchWithFilter(
reportingRoundupId: reportingRoundupId,
date: date,
reportingRoundupTypeRcd: reportingRoundupTypeRcd,
reportingReferenceCode: reportingReferenceCode,
countNumber: countNumber,
userId: userId,
dateTime: dateTime
);
foreach (CrudeReportingRoundupData data in dataList)
{
var crudeReportingRoundupContract = new CrudeReportingRoundupContract();
DataToContract(data, crudeReportingRoundupContract);
list.Add(crudeReportingRoundupContract);
}
return(list);
}
