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

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

                if (String.IsNullOrEmpty(sortExpression))
                {
                    sortExpression = PRMPreBOQDetailHistoryEntity.FLD_NAME_PRMPreBOQDetailHistoryID + " " + SQLConstants.SORT_ORDER_DESCENDING;
                }

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

                pRMPreBOQDetailHistoryEntityList = FCCPRMPreBOQDetailHistory.GetFacadeCreate().GetIL(startRowIndex, pageSize, sortExpression, null, DatabaseOperationType.LoadPagedWithSortExpression);

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

            return(pRMPreBOQDetailHistoryEntityList ?? new List <PRMPreBOQDetailHistoryEntity>());
        }
        public IList <PRMPreBOQDetailHistoryEntity> GetData()
        {
            IList <PRMPreBOQDetailHistoryEntity> pRMPreBOQDetailHistoryEntityList = new List <PRMPreBOQDetailHistoryEntity>();

            try
            {
                pRMPreBOQDetailHistoryEntityList = FCCPRMPreBOQDetailHistory.GetFacadeCreate().GetIL(null, null, null, null, DatabaseOperationType.Load);

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

            return(pRMPreBOQDetailHistoryEntityList ?? new List <PRMPreBOQDetailHistoryEntity>());
        }