/// <summary> /// Hasan Add 2015.03.16 For Getting AllAds 10 rows data into listview in Everytime /// </summary> /// <param name="categoryIID"></param> /// <param name="startRow"></param> /// <returns></returns> public List <SP_GetSortedMaterialAccordingToCategoreyIIDResult> GetSortedMaterialAccordingToCategoreyIIDnRowNumber(Int64 categoryID, int startRowIndex, int maxRowNumber) { try { OiiOHaatDCDataContext dbContext = DatabaseHelper.GetDataModelDataContext(); var listdata = dbContext.SP_GetSortedMaterialAccordingToCategoreyIID(categoryID, startRowIndex, maxRowNumber).ToList(); return(listdata); } catch (Exception ex) { throw new Exception(ex.Message, ex); } }