private void btnSave_Click_1(object sender, EventArgs e)
{
if(txtAge.Text == "" || txtContactNo.Text == "" || txtFname.Text == "" || txtLname.Text =="" || txtAddress.Text == "" || txtContactNo.Text == ""){
MessageBox.Show("Please supply the required fields.");
return;
}
if(txtlengthservice.Text == ""){
txtlengthservice.Text = "0";
}
cl_moneylender cMoneyLender = new cl_moneylender();
cl_LenderInformation l_Info = new cl_LenderInformation();
cMoneyLender.propfname = txtFname.Text;
cMoneyLender.proplname = txtLname.Text;
cMoneyLender.propMI = txtMI.Text;
cMoneyLender.propAddress = txtAddress.Text;
cMoneyLender.propAge = Convert.ToInt32(txtAge.Text);
cMoneyLender.propCreditLimit = Convert.ToDouble(222);
cMoneyLender.propLenderID = txtMoneyLenderID.Text;
cMoneyLender.propContact_no = txtContactNo.Text;
cMoneyLender.propIs_inactive = cboLenderType.Text;
l_Info.propLengthofService = Convert.ToInt32(txtlengthservice.Text.ToString());
l_Info.propHouseType = cbohousetype.Text;
l_Info.propGender = cboGender.Text;
l_Info.propEmail = txtemail.Text;
l_Info.propOccupation = txtoccupation.Text;
l_Info.propPosition = txtposition.Text;
l_Info.propTIN_no = txtTin_no.Text;
l_Info.propCompanyName = txtcompanyname.Text;
l_Info.propCompanyAdd = txtcompanyaddress.Text;
l_Info.propCivilStatus = cboCivilStatus.Text;
l_Info.propbirthplace = txtbirthplace.Text;
l_Info.propDOB = dob.Value;
cl_spouse sp = new cl_spouse();
sp.propspousename = txtspousename.Text;
sp.propspouseOcc = txtSoCCu.Text;
sp.propsCompany =txtsCompany.Text;
sp.propsPosition=txtspouseP.Text;
//check if is active or not
cl_borrower_loan bl = new cl_borrower_loan();
if (cboCivilStatus.Text != "Single")
{
sp.props_age = Convert.ToInt32(txtSpouseAge.Text);
}
if (cMoneyLender.propAge < 18 )
{
MessageBox.Show("Age should not lesser than 18");
return;
}
if (PUBLIC_VARS.EDITMODE == true){
cMoneyLender.UPDATE_DATA(mlt);
int l_sid = Convert.ToInt32(PUBLIC_VARS.d.getlastid().ToString());
l_Info.propmonenylenderInfoID = l_sid;
l_Info.INSERT_DATATOLENDER();
if (cboCivilStatus.Text != "Single")
{
sp.propMoneyLender_id = l_sid;
sp.UPDATE_SPOUSE(mlt);
}
cMoneyLender.propMoneyLender_id = mlt;
if (InsertPictureBarrowerImages == "")
{
cMoneyLender.propPicBarrower = tempPictures;
}
else
{
cMoneyLender.propPicBarrower = InsertPictureBarrowerImages;
}
cMoneyLender.UpdatePicBarrower();
MessageBox.Show( PUBLIC_VARS.updateData);
}
else{
MYFUNCTIONS f = new MYFUNCTIONS();
if (cMoneyLender.isBarrowerExist() == true) {
MessageBox.Show("Record already exist.");
return;
}
cMoneyLender.INSERT_DATA();
int iiiD = PUBLIC_VARS.d.getlastid();
int l_sid = Convert.ToInt32(PUBLIC_VARS.d.getlastid().ToString());
l_Info.propmonenylenderInfoID = l_sid;
l_Info.INSERT_DATATOLENDER();
if(cboCivilStatus.Text != "Single"){
sp.propMoneyLender_id = l_sid;
sp.INSERT_SPOUSE();
}
Int64 dx = f.autoUserID() + 1;
f.InsertCounterNo(dx);
if (InsertPictureBarrowerImages == ""){
InsertPictureBarrowerImages = "default_avatar.jpg";
}
cMoneyLender.propPicBarrower = InsertPictureBarrowerImages;
cMoneyLender.propMoneyLender_id = iiiD;
cMoneyLender.InserPictureBarrower();
MessageBox.Show(PUBLIC_VARS.saveData);
}
//cMoneyLender.LOAD_MONEYLENDER(lst.lsvMoneyLender);
//MYFUNCTIONS m = new MYFUNCTIONS();
//string sql = "SELECT * FROM tmoneylender";
//m.PopulateListView(lsvevent,sql);
cMoneyLender.LOAD_MONEYLENDER(lsvevent);
this.Close();
}
private void btnProcess_Click(object sender, EventArgs e)
{
cl_lender_inform lenderIn = new cl_lender_inform();
try
{
if (lenderIn.PEND_ACTIVELOAN(mYLenderIDs) == true)
{
MessageBox.Show("Please settle your loan first. " );
}
else
{
cl_lender_inform lend = new cl_lender_inform();
cl_borrower_loan bl = new cl_borrower_loan();
// int ml_ID = Convert.ToInt32(lsvLender.SelectedItems[0].Text);
List<DateTime> lstq = new List<DateTime>();
for (int i = 0; i < lstamt.Count; i++)
{
lend.propDbalance = lstamt[i];
//lend.propiTerest = ;
// lend.propPrinc = ;
lend.propMnt_amount = Convert.ToDouble(txtMonthlyDue.Text);
lend.propLoan_id = 2;
lend.propStatus = "Pending";
lend.propMoneyLender_id = mYLenderIDs;
lend.propPrinc = Convert.ToDouble(lsvPaymentSched.Items[i].SubItems[2].Text);
lend.propSchedate = Convert.ToDateTime(lsvPaymentSched.Items[i].Text.ToString());
lend.propHpenalty = 0.0;
lend.propBalanceAmount = Convert.ToDouble(lsvPaymentSched.Items[i].SubItems[3].Text);
lend.INSERT_LENDER_INFORM(); // tschedule_of_payment
//bl.propRemarks = "Pending";
//bl.propBorrowerID = mYLenderIDs;
//bl.propSchedate =Convert.ToDateTime(lsvPaymentSched.Items[i].Text.ToString());
//bl.propAmountLend = Convert.ToDouble(txtAmountApplied.Text);
//bl.InsertCustLoan(); // tmoneylender_loan
}
bl.propRemarks = "Pending";
bl.propBorrowerID = mYLenderIDs;
bl.propSchedate = DateTime.Today; //Convert.ToDateTime(lsvPaymentSched.Items[i].Text.ToString());
bl.propAmountLend = Convert.ToDouble(txtAmountApplied.Text);
bl.InsertCustLoan(); // tmoneylender_loan
MessageBox.Show("Loan has been approve.");
this.Hide();
}
}
catch(Exception ex){
MessageBox.Show(ex.Message);
}
}