public IList <UserList_DetailedEntity> GetPagedData(Int32 startRowIndex, Int32 pageSize, String sortExpression, String filterExpression) { IList <UserList_DetailedEntity> userList_DetailedEntityList = new List <UserList_DetailedEntity>(); try { if (String.IsNullOrEmpty(sortExpression)) { sortExpression = "MemberID"; } Int32 currentPage = Convert.ToInt32(startRowIndex / pageSize) + 1; //startRowIndex = Convert.ToInt32( startRowIndex / pageSize) + 1; if (pageSize == -1) { pageSize = 1000000000; } userList_DetailedEntityList = FCCUserList_Detailed.GetFacadeCreate().GetIL(pageSize, currentPage, sortExpression, filterExpression); if (userList_DetailedEntityList != null && userList_DetailedEntityList.Count > 0) { totalRowCount = userList_DetailedEntityList[0].TotalRowCount; } } catch (Exception ex) { } return(userList_DetailedEntityList ?? new List <UserList_DetailedEntity>()); }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { try { lblTotalUser.Text = "0"; String sortExpression = SqlExpressionBuilder.PrepareSortExpression(UserList_DetailedEntity.FLD_NAME_UserName, SQLSortOrderType.Assending); lblTotalUser.Text = FCCUserList_Detailed.GetFacadeCreate().GetIL(1000000, 1, sortExpression, String.Empty).Count.ToString(); } catch (Exception ex) { } } }