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(); }
private void BindBorrowers() { BorrowerManager oManager = new BorrowerManager(); oManager.ConnectionString = this.ConnectionString; oManager.Open(); grdCtlBorrowerInfo.DataSource = oManager.GetBorrowersRecord(); grdCtlBorrowerInfo.Refresh(); oManager.Close(); }