// fetch all rows from table with an offset, and limit of rows // links: // docLink: http://sql2x.org/documentationLink/a87e5c54-b47e-4031-bc3b-837b4cf9f692 public List <CrudeServiceSpecialServiceRequestOperationRuleRefModel> FetchAllWithLimitAndOffset(string limit, string offset) { var list = new List <CrudeServiceSpecialServiceRequestOperationRuleRefModel>(); List <CrudeServiceSpecialServiceRequestOperationRuleRefData> dataList = CrudeServiceSpecialServiceRequestOperationRuleRefData.FetchAllWithLimitAndOffset(int.Parse(limit), int.Parse(offset)); foreach (CrudeServiceSpecialServiceRequestOperationRuleRefData crudeServiceSpecialServiceRequestOperationRuleRefBusiness in dataList) { var model = new CrudeServiceSpecialServiceRequestOperationRuleRefModel(); DataToModel(crudeServiceSpecialServiceRequestOperationRuleRefBusiness, model); list.Add(model); } return(list); }
// copy all rows from a List of serialized data objects to a List of SOAP Contracts, // with a limit on number of returned rows and order by columns, starting at a specific row // links: // docLink: http://sql2x.org/documentationLink/3fe9f1b3-97b6-4f58-a0f2-adfcbd973bfc public List <CrudeServiceSpecialServiceRequestOperationRuleRefContract> FetchAllWithLimitAndOffset(int limit, int offset) { var list = new List <CrudeServiceSpecialServiceRequestOperationRuleRefContract>(); List <CrudeServiceSpecialServiceRequestOperationRuleRefData> dataList = CrudeServiceSpecialServiceRequestOperationRuleRefData.FetchAllWithLimitAndOffset(limit, offset); foreach (CrudeServiceSpecialServiceRequestOperationRuleRefData crudeServiceSpecialServiceRequestOperationRuleRef in dataList) { var contract = new CrudeServiceSpecialServiceRequestOperationRuleRefContract(); DataToContract(crudeServiceSpecialServiceRequestOperationRuleRef, contract); list.Add(contract); } return(list); }