// 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 <CrudeCountryContract> FetchAllWithLimitAndOffset(int limit, int offset)
{
var list = new List <CrudeCountryContract>();
List <CrudeCountryData> dataList = CrudeCountryData.FetchAllWithLimitAndOffset(limit, offset);
foreach (CrudeCountryData crudeCountry in dataList)
{
var contract = new CrudeCountryContract();
DataToContract(crudeCountry, contract);
list.Add(contract);
}
return(list);
}
// 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 <CrudeCountryModel> FetchAllWithLimitAndOffset(string limit, string offset)
{
var list = new List <CrudeCountryModel>();
List <CrudeCountryData> dataList = CrudeCountryData.FetchAllWithLimitAndOffset(int.Parse(limit), int.Parse(offset));
foreach (CrudeCountryData crudeCountryBusiness in dataList)
{
var model = new CrudeCountryModel();
DataToModel(crudeCountryBusiness, model);
list.Add(model);
}
return(list);
}