SP Get List in api without jquery datatable

USE [Nobolo]

GO

/****** Object:  StoredProcedure [dbo].[spGetListOfPrivatePhotos]    Script Date: 7/8/2020 1:20:40 PM ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

--[dbo].[spGetListOfPrivatePhotos] 2035,1,10

ALTER  PROCEDURE [dbo].[spGetListOfPrivatePhotos] 

@UserID as bigint = 0,

@PageIndex as int = 1,

@PageSize as int = 1000,

@ReturnMessage varchar(200) = null output ,

@ReturnValue bigint = 0

AS

BEGIN

Declare @StartPage as int = 0;

Declare @EndPage as int = 0;

set @StartPage = (@PageIndex - 1) * @PageSize + 1

set @EndPage = @PageIndex * @PageSize;

Select 

A.PageNo,

A.T_Rec,

A.T_Pages,

A.UploadedPhotosID,

A.MediumImageURL,

A.ThumbnailImageURL,

A.OriginalImageURL

,A.[isPublic] as IsSocial

from (Select 

ROW_NUMBER() OVER (order by A.UploadedPhotosID desc) AS RowIndex,

CAST(@PageIndex AS VARCHAR)   as PageNo,

COUNT(A.UploadedPhotosID) OVER (PARTITION BY -1) AS T_Rec,

CEILING(CAST(COUNT(A.UploadedPhotosID) OVER (PARTITION BY -1) AS DECIMAL) /  CAST(CAST(@PageSize  AS VARCHAR) AS DECIMAL) ) AS T_Pages,

* from (

Select

B.UploadedPhotosID,

ISNULL(B.MediumImageURL,'') as MediumImageURL,

ISNULL(B.[ThumbnailImageURL],'') as ThumbnailImageURL,

ISNULL(B.[OriginalImageURL],'') as OriginalImageURL

,B.[isPublic]

from [dbo].[tblUploadedPhotos] B

--Left join tblUsers C on B.UserId = C.UsersId

Where B.[UserID] =@UserID 

and B.RecordStatus= 'Active' 

and

(B.isPurchase=1)

and B.isPublic = 0

) A 

) A where A.RowIndex >= @StartPage And A.RowIndex <= @EndPage

END