private IList <ReviewDesc> GetAllReviews(int?pageIndex) { ITaxonRepository Taxon = new TaxonRepository(); IReviewRepository reviews = new ReviewRepository(); // IList<ReviewDesc> review = Taxon.GetAllReviews(); int currentIndex = (int)(pageIndex ?? 1); //int count = review.Count; // int count = Taxon.getAllReviews().Count; SqlQuery query = Select.AllColumnsFrom <VwAllReview>(); int count = query.GetRecordCount(); ViewData["TotalItemCount"] = count; ViewData["PageNumber"] = currentIndex; ViewData["PageSize"] = UpdateUtils.DEFAULT_PAGE_SIZE; IList <ReviewDesc> review = Taxon.GetAllReviewsPaged(currentIndex, UpdateUtils.DEFAULT_PAGE_SIZE); var sortedReviews = from r in review orderby r.CtyShort select r; int pagedCount = review.Count; if (pagedCount > 0) { for (int i = 0; i < pagedCount; i++) { review[i].TaxonName = Taxon.getReviewTaxonName(review[i].ID, review[i].Taxontype, review[i].Kingdom); review[i].Paragraph = Taxon.getParagraphStagePerReview(review[i].ID); review[i].Concern = reviews.getConcernForReview(review[i].ID); review[i].DeadlineDate = Taxon.getDeadlineDatePerReview(review[i].ID); } } if (pagedCount <= 0) { review = null; } return(review); }