This Script Only Getting 7 Records. But I Have 15 In Database. How Can I Achevie It. if set a pagesize to >7 it shows only 7 records.

public List<Model.ReportsDashboard> GetList(string whereCriteria, string orderBy, string direction, int pageSize, int pageNumber)
        {
            switch (orderBy)
            {

                case "ReportsDashboardID":
                    orderBy = "dbo.Reports_Dashboard.id";
                    break;
                case "ReportUrl":
                    orderBy = "dbo.Reports_Dashboard.ReportUrl";
                    break;
                case "ReportName":
                    orderBy = "dbo.Reports_Dashboard.ReportName";
                    break;
                default:
                    orderBy = "dbo.Reports_Dashboard.ReportName";
                    break;
            }

            if (String.IsNullOrEmpty(direction))
                direction = "ASC";

            if (String.IsNullOrEmpty(whereCriteria))
                whereCriteria = "dbo.Reports_Dashboard.Active = 1";

            string sql = @"
                Declare @RowStart int 
                Declare @RowEnd int 
                
                SET @RowStart = @PageSize * @PageNumber + 1; 
                SET @RowEnd = @RowStart + @PageSize - 1 ; 

                With Report_Dashboard AS 
                     ( SELECT ROW_NUMBER() over (order by " + orderBy + " " + direction + @") as RowNumber,
			               dbo.Reports_Dashboard.id, 
		                   dbo.Reports_Dashboard.ReportName, 
		                   dbo.Reports_Dashboard.ReportUrl
		               FROM  dbo.Reports_Dashboard
                       where " + whereCriteria + @") ,
               counts as (select count(*) as TotalRecordCount from Report_Dashboard)

               select Report_Dashboard.*,counts.TotalRecordCount
               from Report_Dashboard
                    cross apply counts 
                Where RowNumber >= @RowStart and RowNumber <= @RowEnd 
            ";

            List<SqlParameter> sqlParameters = new List<SqlParameter>();

            sqlParameters.Add(new SqlParameter("@PageNumber", pageNumber));
            sqlParameters.Add(new SqlParameter("@PageSize", pageSize));

            LoadRecordMethod LoadReport = (SqlDataReader dr) =>
            {
                Model.ReportsDashboard loadreportdashboard = new Model.ReportsDashboard();
                LoadField(loadreportdashboard, dr, GetName(() => loadreportdashboard.id));
                LoadField(loadreportdashboard, dr, GetName(() => loadreportdashboard.ReportName));
                LoadField(loadreportdashboard, dr, GetName(() => loadreportdashboard.ReportUrl));
                LoadField(loadreportdashboard, dr, GetName(() => loadreportdashboard.TotalRecordCount));
                return loadreportdashboard;
            };

            List<Model.ReportsDashboard> list = this.ReturnList(new LoadRecordMethod(LoadRecord), sql, sqlParameters);

            return list;
        }