private DataItemPageRequest BuildUserPageRequest(int pageNum, int sortBy, int pageSize)
{
var itemPageReq = new DataItemPageRequest();
itemPageReq.PageNumber = (pageNum <= 0) ? 1 : pageNum;
itemPageReq.PageSize = pageSize;
itemPageReq.SortBy = (sortBy == 0) ? 3 : sortBy;
return(itemPageReq);
}
PagedList <UserStub> IUserRepository.GetUsersPage(DataItemPageRequest dataItemPageRequest)
{
var retPagedList = new PagedList <UserStub>();
using (var cn = new SqlConnection(_connStr))
{
using (var cmd = new SqlCommand("uspGetAspNetIdentityUsersPaged", cn))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@PageNum", dataItemPageRequest.PageNumber);
cmd.Parameters.AddWithValue("@PageSize", dataItemPageRequest.PageSize);
cmd.Parameters.AddWithValue("@SortOrder", dataItemPageRequest.SortBy);
cn.Open();
using (var reader = cmd.ExecuteReader())
{
while (reader.Read())
{
var usrStub = new UserStub()
{
Id = reader.GetInt64(0),
FirstName = reader.GetString(2),
LastName = reader.GetString(3),
CompanyName = reader.GetString(5),
IsaActive = reader.GetBoolean(6)
};
retPagedList.ItemList.Add(usrStub);
}
reader.NextResult();
if (reader.Read())
{
var pagedInfo = new PagedInfo()
{
TotalPages = reader.GetInt32(0),
CurrentPage = reader.GetInt32(1),
TotalItems = reader.GetInt32(2),
PageSize = reader.GetInt32(3)
};
retPagedList.PagedListInfo = pagedInfo;
}
}
}
}
return(retPagedList);
}
public PagedList <UserStub> GetUsersPage(DataItemPageRequest usrPageReq)
{
var pagedListUsr = _userRepo.GetUsersPage(usrPageReq);
return(pagedListUsr);
}
