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();
}
public void AddBorrower(BorrowerUnit oUnit)
{
SqlCommand oCommand = new SqlCommand();
oCommand.Connection = this.Connection;
oCommand.CommandType = CommandType.StoredProcedure;
oCommand.CommandText = "SP_TRANS_INSERT_BORROWER";
oCommand.Parameters.Add(new SqlParameter("@CardType", oUnit.CardType));
oCommand.Parameters.Add(new SqlParameter("@BorrowerCode", oUnit.BorrowerCode));
oCommand.Parameters.Add(new SqlParameter("@LastName", oUnit.LastName));
oCommand.Parameters.Add(new SqlParameter("@FirstName", oUnit.FirstName));
oCommand.Parameters.Add(new SqlParameter("@MiddleName", oUnit.MiddleName));
oCommand.Parameters.Add(new SqlParameter("@Address", oUnit.Address));
oCommand.Parameters.Add(new SqlParameter("@ContactNumber", oUnit.ContactNumber));
oCommand.Parameters.Add(new SqlParameter("@Employer", oUnit.Employer));
oCommand.Parameters.Add(new SqlParameter("@GuarantorID", oUnit.GuarantorID));
oCommand.Parameters.Add(new SqlParameter("@GuarantorName", oUnit.GuarantorName));
oCommand.Parameters.Add(new SqlParameter("@ATMNo", oUnit.ATMNo));
oCommand.Parameters.Add(new SqlParameter("@EmploymentStatus", oUnit.EmploymentStatus));
oCommand.Parameters.Add(new SqlParameter("@EffectiveDate", oUnit.EffectiveDate));
oCommand.Parameters.Add(new SqlParameter("@FrequencyOfPayment", oUnit.FrequencyOfPayment));
oCommand.Parameters.Add(new SqlParameter("@InterestRate", oUnit.InterestRate));
oCommand.Parameters.Add(new SqlParameter("@PayDayCode", oUnit.PayDayCode));
oCommand.Parameters.Add(new SqlParameter("@MortgageInfo", oUnit.MortgageInfo));
oCommand.Parameters.Add(new SqlParameter("@CreditLimit", oUnit.CreditLimit));
oCommand.ExecuteNonQuery();
}
private void btnAdd_Click(object sender, EventArgs e)
{
BorrowerManager oManager = new BorrowerManager();
BorrowerUnit oUnit = new BorrowerUnit();
oManager.ConnectionString = this.ConnectionString;
oManager.Open();
// Details
oUnit.CardType = cboType.Text;
oUnit.BorrowerCode = txtBorrowerCode.Text;
oUnit.LastName = txtLastName.Text;
oUnit.FirstName = txtFirstName.Text;
oUnit.MiddleName = txtMiddleName.Text;
oUnit.Address = txtAddress.Text;
oUnit.ContactNumber = txtContactNumber.Text;
oUnit.Employer = cboEmployer.EditValue.ToString();
oUnit.GuarantorID = cboGuarantorFinancer.EditValue.ToString();
oUnit.GuarantorName = cboGuarantorFinancer.Text;
oUnit.ATMNo = txtATMNo.Text;
oUnit.EmploymentStatus = cboEmploymentStatus.Text;
oUnit.EffectiveDate = Convert.ToDateTime(dtEffectiveDate.EditValue);
oUnit.InterestRate = txtInterestRate.Text;
oUnit.PayDayCode = cboPayDayCode.EditValue.ToString();
oUnit.MortgageInfo = txtMortgageInfo.Text;
oUnit.CreditLimit = Convert.ToDouble(txtCreditLimit.Text);
oManager.UpdateBorrower(oUnit);
oManager.Close();
txtBorrowerCode.Enabled = false;
}
private void barSaveAndNew_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
if (txtBorrowerCode.Enabled == true)
{
if (txtBorrowerCode.Text == "")
{
MessageBox.Show("Blank code is not permitted!!!", "Code", MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
BorrowerManager oManager = new BorrowerManager();
BorrowerUnit oUnit = new BorrowerUnit();
oManager.ConnectionString = this.ConnectionString;
oManager.Open();
if (oManager.isBorrowerCodeExists(txtBorrowerCode.Text))
{
oManager.Close();
MessageBox.Show("Code already exists!!! Please try another code", "Code", MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
oUnit.CardType = cboType.Text;
oUnit.BorrowerCode = txtBorrowerCode.Text;
oUnit.LastName = txtLastName.Text;
oUnit.FirstName = txtFirstName.Text;
oUnit.MiddleName = txtMiddleName.Text;
oUnit.Address = txtAddress.Text;
oUnit.ContactNumber = txtContactNumber.Text;
oUnit.Employer = cboEmployer.EditValue.ToString();
oUnit.GuarantorID = cboGuarantorFinancer.EditValue.ToString();
oUnit.GuarantorName = cboGuarantorFinancer.Text;
oUnit.ATMNo = txtATMNo.Text;
oUnit.EmploymentStatus = cboEmploymentStatus.Text;
oUnit.EffectiveDate = Convert.ToDateTime(dtEffectiveDate.EditValue);
oUnit.InterestRate = txtInterestRate.Text;
oUnit.FrequencyOfPayment = cboFrequencyOfPayment.Text;
if (cboPayDayCode.EditValue == null)
{
oUnit.PayDayCode = "";
}
else
{
oUnit.PayDayCode = cboPayDayCode.EditValue.ToString();
}
oUnit.MortgageInfo = txtMortgageInfo.Text;
oUnit.CreditLimit = Convert.ToDouble(txtCreditLimit.Text);
// Details
oManager.AddBorrower(oUnit);
oManager.Close();
txtBorrowerCode.Enabled = false;
MessageBox.Show("Adding successfull!!!", "Add", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
BorrowerManager oManager = new BorrowerManager();
BorrowerUnit oUnit = new BorrowerUnit();
oManager.ConnectionString = this.ConnectionString;
oManager.Open();
oUnit.CardType = cboType.Text;
oUnit.BorrowerCode = txtBorrowerCode.Text;
oUnit.LastName = txtLastName.Text;
oUnit.FirstName = txtFirstName.Text;
oUnit.MiddleName = txtMiddleName.Text;
oUnit.Address = txtAddress.Text;
oUnit.ContactNumber = txtContactNumber.Text;
oUnit.Employer = cboEmployer.Text;
oUnit.GuarantorID = cboGuarantorFinancer.EditValue.ToString();
oUnit.GuarantorName = cboGuarantorFinancer.Text;
oUnit.ATMNo = txtATMNo.Text;
oUnit.EmploymentStatus = cboEmploymentStatus.Text;
oUnit.EffectiveDate = Convert.ToDateTime(dtEffectiveDate.EditValue);
oUnit.InterestRate = txtInterestRate.Text;
oUnit.FrequencyOfPayment = cboFrequencyOfPayment.Text;
if (cboPayDayCode.EditValue == null)
{
oUnit.PayDayCode = "";
}
else
{
oUnit.PayDayCode = cboPayDayCode.EditValue.ToString();
}
oUnit.MortgageInfo = txtMortgageInfo.Text;
oUnit.CreditLimit = Convert.ToDouble(txtCreditLimit.Text);
// Details
oManager.UpdateBorrower(oUnit);
oManager.Close();
txtBorrowerCode.Enabled = false;
MessageBox.Show("Updating successfull!!!", "Update", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
