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