public UnscResultDTO GetUnscListWithPaging(string PipelineDuns, string keyword, DateTime?postStartDate, DateTime?effectiveStartDate, DateTime?effectiveEndDate, SortingPagingInfo sortingPagingInfo) { UnscResultDTO unscResult = new UnscResultDTO(); //Get unsc list using above parameters IQueryable <UnscPerTransaction> result; IQueryable <UnscPerTransactionDTO> UnscDTO = null; try { result = GetAllUNSCOnPipelineId(PipelineDuns, keyword, postStartDate, effectiveStartDate, effectiveEndDate); if (result.Count() > 0) { UnscDTO = GetUnscData(result).AsQueryable(); } var dataQueryWithOrder = SortByColumnWithOrder(UnscDTO, sortingPagingInfo); unscResult.RecordCount = dataQueryWithOrder.Count(); var resultData = dataQueryWithOrder.Skip((sortingPagingInfo.CurrentPageIndex - 1) * sortingPagingInfo.PageSize).Take(sortingPagingInfo.PageSize).ToList(); if (resultData.Count() > 0) { unscResult.unscPerTransactionDTO = resultData.Select(a => modalFactory.ParseDTO(a)).ToList(); return(unscResult); } return(new UnscResultDTO()); } catch (Exception ex) { return(null); } }