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();
}