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); }