// 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 <CrudeBookingContract> FetchWithFilter(System.Guid bookingId, string receivedFrom, System.Guid addressId, string bookingSourceRcd, System.Guid externalSystemId, System.Guid agencyId, System.Guid financialCurrencyId, System.Guid financialCostcentreId, string comment, System.Guid userId, System.DateTime dateTime) { var list = new List <CrudeBookingContract>(); List <CrudeBookingData> dataList = CrudeBookingData.FetchWithFilter( bookingId: bookingId, receivedFrom: receivedFrom, addressId: addressId, bookingSourceRcd: bookingSourceRcd, externalSystemId: externalSystemId, agencyId: agencyId, financialCurrencyId: financialCurrencyId, financialCostcentreId: financialCostcentreId, comment: comment, userId: userId, dateTime: dateTime ); foreach (CrudeBookingData data in dataList) { var crudeBookingContract = new CrudeBookingContract(); DataToContract(data, crudeBookingContract); list.Add(crudeBookingContract); } return(list); }