public IList <HREmployeeFamilyInfo_DetailedEntity> GetPagedData(Int32 startRowIndex, Int32 pageSize, String sortExpression, String filterExpression)
        {
            IList <HREmployeeFamilyInfo_DetailedEntity> hREmployeeFamilyInfo_DetailedEntityList = new List <HREmployeeFamilyInfo_DetailedEntity>();

            try
            {
                if (String.IsNullOrEmpty(sortExpression))
                {
                    sortExpression = "HREmployeeFamilyInfoID";
                }

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

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

                hREmployeeFamilyInfo_DetailedEntityList = FCCHREmployeeFamilyInfo_Detailed.GetFacadeCreate().GetIL(pageSize, currentPage, sortExpression, filterExpression);

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

            return(hREmployeeFamilyInfo_DetailedEntityList ?? new List <HREmployeeFamilyInfo_DetailedEntity>());
        }
        private void GetSelectedContactPersonInfo()
        {
            String fe = SqlExpressionBuilder.PrepareFilterExpression("HREmployeeFamilyInfo." + HREmployeeFamilyInfo_DetailedEntity.FLD_NAME_HREmployeeFamilyInfoID, ddlEmergencyContactPersonID.SelectedValue.ToString(), SQLMatchType.Equal);

            IList <HREmployeeFamilyInfo_DetailedEntity> lst = FCCHREmployeeFamilyInfo_Detailed.GetFacadeCreate().GetIL(1000, 1, String.Empty, fe);

            if (lst != null && lst.Count > 0)
            {
                txtFirstName.Text    = lst[0].FirstName;
                txtMiddleName.Text   = lst[0].MiddleName;
                txtLastName.Text     = lst[0].LastName;
                txtRelationShip.Text = lst[0].FamilyRelationTypeName;
                txtMobilePhone.Text  = lst[0].Phone;
            }
            else
            {
                txtFirstName.Text    = String.Empty;
                txtMiddleName.Text   = String.Empty;
                txtLastName.Text     = String.Empty;
                txtRelationShip.Text = String.Empty;
                txtMobilePhone.Text  = String.Empty;
            }
        }