Пример #1
0
        public void OpenDocument(string BorrowerCode)
        {
            BorrowerManager oManager = new BorrowerManager();
            BorrowerUnit oUnit = new BorrowerUnit();

            oManager.ConnectionString = this.ConnectionString;
            oManager.Open();

            DataTable dtBorrowerInfo = oManager.GetBorrowersRecord(BorrowerCode);
            DataRow oRow = dtBorrowerInfo.Rows[0];

            cboType.Text = oRow["CardType"].ToString();
            txtBorrowerCode.Text = oRow["BorrowerCode"].ToString();
            txtLastName.Text = oRow["LastName"].ToString();
            txtFirstName.Text = oRow["FirstName"].ToString();
            txtMiddleName.Text = oRow["MiddleName"].ToString();
            txtAddress.Text = oRow["Address"].ToString();
            txtContactNumber.Text = oRow["ContactNumber"].ToString();
            cboEmployer.EditValue = oRow["Employer"].ToString();
            cboGuarantorFinancer.EditValue = oRow["GuarantorID"].ToString();
            txtATMNo.Text = oRow["ATMNo"].ToString();
            cboEmploymentStatus.Text = oRow["EmploymentStatus"].ToString();
            dtEffectiveDate.EditValue = Convert.ToDateTime(oRow["EffectiveDate"].ToString());
            cboFrequencyOfPayment.Text = oRow["FrequencyOfPayment"].ToString();
            txtInterestRate.Text = oRow["InterestRate"].ToString();
            cboPayDayCode.EditValue = oRow["PayDayCode"].ToString();
            txtMortgageInfo.Text = oRow["MortgageInfo"].ToString();
            txtCreditLimit.Text = oRow["CreditLimit"].ToString();

            txtBorrowerCode.Enabled = false;

            oManager.Close();
        }
Пример #2
0
        private void BindBorrowers()
        {
            BorrowerManager oManager = new BorrowerManager();

            oManager.ConnectionString = this.ConnectionString;
            oManager.Open();

            grdCtlBorrowerInfo.DataSource = oManager.GetBorrowersRecord();
            grdCtlBorrowerInfo.Refresh();

            oManager.Close();
        }