private void getAllList(string pClientId)
        {
            try
            {
                dgvFamilyMembers.DataSource = loClientFamilyMember.getAllData(pClientId, "");
            }
            catch
            {
                dgvFamilyMembers.DataSource = null;
            }

            try
            {
                dgvPersonalReference.DataSource = loClientPersonalReference.getAllData(pClientId, "");
            }
            catch
            {
                dgvPersonalReference.DataSource = null;
            }

            try
            {
                dgvSourceOfIncome.DataSource = loClientSourceOfIncome.getAllData(pClientId, "");
            }
            catch
            {
                dgvSourceOfIncome.DataSource = null;
            }

            try
            {
                dgvOwnedProperties.DataSource = loClientOwnedProperty.getAllData(pClientId, "");
            }
            catch
            {
                dgvOwnedProperties.DataSource = null;
            }

            try
            {
                dgvCreditExperience.DataSource = loClientCreditExperience.getAllData(pClientId, "");
            }
            catch
            {
                dgvCreditExperience.DataSource = null;
            }

            try
            {
                dgvLoanHistory.DataSource = loLoanApplication.getLoanApplicationByClient(pClientId);
            }
            catch
            {
                dgvLoanHistory.DataSource = null;
            }
        }
        private void ClientFamilyMemberDetailUI_Load(object sender, EventArgs e)
        {
            try
            {
                lFromSave      = false;
                this.BackColor = Color.FromArgb(int.Parse(GlobalVariables.FormBackColor));

                if (lOperation == GlobalVariables.Operation.Edit)
                {
                    foreach (DataRow _dr in loClientFamilyMember.getAllData("0", lId).Rows)
                    {
                        lId                        = _dr["Id"].ToString();
                        txtName.Text               = _dr["Name"].ToString();
                        cboRelationship.Text       = _dr["Relationship"].ToString();
                        txtAge.Text                = _dr["Age"].ToString();
                        txtCellphoneNo.Text        = _dr["Cellphone No."].ToString();
                        txtBusinessWorkSchool.Text = _dr["Business/Work/School"].ToString();
                        txtIncome.Text             = string.Format("{0:n}", decimal.Parse(_dr["Income"].ToString()));
                        txtRemarks.Text            = _dr["Remarks"].ToString();
                    }
                }
            }
            catch (Exception ex)
            {
                ErrorMessageUI em = new ErrorMessageUI(ex.Message, this.Name, "ClientFamilyMemberDetailUI_Load");
                em.ShowDialog();
                return;
            }
        }