private void AddListingParameters(IListSetting setting)
{
Add("@SortColumnIndex", SqlDbType.TinyInt, (object)setting.SortColumnIndex);
Add("@SortDirection", SqlDbType.Bit, (object)(byte)setting.SortDirection);
Add("@CurrentPageNumber", SqlDbType.Int, (object)setting.CurrentPageNumber);
Add("@RecordsPerPage", SqlDbType.Int, (object)setting.RecordsPerPage);
Add("@TotalNumberOfRecords", SqlDbType.Int);
}
public IEnumerable <T> GetList <T>(IListSetting setting, Func <IDataRecord, T> current)
{
AddListingParameters(setting);
using (PrepareExecution(ExecuteString))
{
IList <T> list = new List <T>();
using (IDataReader reader = dbCommand.ExecuteReader())
{
CheckDBError();
while (reader.Read())
{
list.Add(current(reader));
}
}
setting.NumberOfRecords = TotalRecordCount;
return(list);
}
}
