public IList <APApprovalProcessPanelMapEntity> GetPagedData(Int32 startRowIndex, Int32 pageSize, String sortExpression)
        {
            IList <APApprovalProcessPanelMapEntity> aPApprovalProcessPanelMapEntityList = new List <APApprovalProcessPanelMapEntity>();

            try
            {
                if (pageSize == -1)
                {
                    pageSize = 1000000000;
                }

                if (String.IsNullOrEmpty(sortExpression))
                {
                    sortExpression = APApprovalProcessPanelMapEntity.FLD_NAME_ApprovalProcessPanelMapID + " " + SQLConstants.SORT_ORDER_DESCENDING;
                }

                startRowIndex = Convert.ToInt32(startRowIndex / pageSize) + 1;

                aPApprovalProcessPanelMapEntityList = FCCAPApprovalProcessPanelMap.GetFacadeCreate().GetIL(startRowIndex, pageSize, sortExpression, null, DatabaseOperationType.LoadPagedWithSortExpression);

                if (aPApprovalProcessPanelMapEntityList != null && aPApprovalProcessPanelMapEntityList.Count > 0)
                {
                    totalRowCount = aPApprovalProcessPanelMapEntityList[0].TotalRowCount;
                }
            }
            catch (Exception ex)
            {
            }

            return(aPApprovalProcessPanelMapEntityList ?? new List <APApprovalProcessPanelMapEntity>());
        }
        public IList <APApprovalProcessPanelMapEntity> GetData()
        {
            IList <APApprovalProcessPanelMapEntity> aPApprovalProcessPanelMapEntityList = new List <APApprovalProcessPanelMapEntity>();

            try
            {
                aPApprovalProcessPanelMapEntityList = FCCAPApprovalProcessPanelMap.GetFacadeCreate().GetIL(null, null, null, null, DatabaseOperationType.Load);

                if (aPApprovalProcessPanelMapEntityList != null && aPApprovalProcessPanelMapEntityList.Count > 0)
                {
                    totalRowCount = aPApprovalProcessPanelMapEntityList[0].TotalRowCount;
                }
            }
            catch (Exception ex)
            {
            }

            return(aPApprovalProcessPanelMapEntityList ?? new List <APApprovalProcessPanelMapEntity>());
        }