public List <SP_GetSortedAllMaterialForCategoreyIIDnClientTypeResult> GetAllSortedMaterialForCategoryIDnClientType(Int64 categoryID, int clientType, int startRowIndex, int maxRowNumber) { try { OiiOHaatDCDataContext dbContext = DatabaseHelper.GetDataModelDataContext(); var listdata = dbContext.SP_GetSortedAllMaterialForCategoreyIIDnClientType(categoryID, clientType, startRowIndex, maxRowNumber).ToList(); return(listdata); } catch (Exception ex) { throw new Exception(ex.Message, ex); } }