private void frmListMoneyLender_Load(object sender, EventArgs e)
{
cl_moneylender cMoneyLender = new cl_moneylender();
cMoneyLender.LOAD_MONEYLENDER(lsvMoneyLender);
//MYFUNCTIONS m = new MYFUNCTIONS();
//string sql = "select * from tmoneylender";
//m.PopulateListView(lsvMoneyLender, sql);
}
private void frmDetailsBorrower_Load(object sender, EventArgs e)
{
cl_moneylender lender = new cl_moneylender();
cl_lender_inform li = new cl_lender_inform();
lender.LOADTOFIELDSLenderID(bid);
lblAddress.Text = lender.propAddress;
lblContact.Text = lender.propContact_no;
lblName.Text = lender.propfname.ToString() + " " + lender.propMI.ToString() + " " + lender.proplname.ToString();
li.loadDetailsBorrowers(lsvPaymentSched, lender.propMoneyLender_id);
}
private void btnDelete_Click(object sender, EventArgs e)
{
if (lsvMoneyLender.SelectedItems.Count > 0)
{
PUBLIC_VARS.activeID = Convert.ToInt32(lsvMoneyLender.SelectedItems[0].Text.ToString());
cl_moneylender cMoneyLender = new cl_moneylender();
DialogResult result1 = MessageBox.Show("Are you sure you want to delete entry?", "delete", MessageBoxButtons.YesNo);
if (result1 == DialogResult.Yes)
{
cMoneyLender.DELETE_DATA(PUBLIC_VARS.activeID);
MessageBox.Show(PUBLIC_VARS.deleteData);
}
cMoneyLender.LOAD_MONEYLENDER(lsvMoneyLender);
}
else {
MessageBox.Show("No records to be deleted.");
}
}
private void cboBtype_SelectedIndexChanged(object sender, EventArgs e)
{
cl_moneylender l = new cl_moneylender();
l.LOAD_MONEYLENDER_Actvie(lsvMoneyLender, cboBtype.Text);
}
private void btnView_Click(object sender, EventArgs e)
{
cl_moneylender l = new cl_moneylender();
l.Search_MONEYLENDER(lsvMoneyLender, "view");
}
private void btnSearch_Click(object sender, EventArgs e)
{
cl_moneylender l = new cl_moneylender();
l.Search_MONEYLENDER(lsvMoneyLender,textBox1.Text);
}
private void textBox1_TextChanged(object sender, EventArgs e)
{
cl_moneylender l = new cl_moneylender();
l.Search_MONEYLENDER(lsvMoneyLender, textBox1.Text);
}
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 frmCustomer_Load(object sender, EventArgs e)
{
if (PUBLIC_VARS.EDITMODE == true)
{
cl_moneylender cm = new cl_moneylender();
cl_LenderInformation c_info = new cl_LenderInformation();
cm.LOADTOFIELDS(mlt);
txtAddress.Text = cm.propAddress;
txtFname.Text = cm.propfname;
txtLname.Text = cm.proplname;
txtMI.Text = cm.propMI;
txtAge.Text = cm.propAge.ToString();
txtTin_no.Text = cm.propCreditLimit.ToString();
txtContactNo.Text = cm.propContact_no;
txtMoneyLenderID.Text = cm.propLenderID;
cboLenderType.Text = cm.propIs_inactive;
c_info.LOAD_TOFIELDSinfo(mlt);
txtbirthplace.Text = c_info.propbirthplace;
dob.Value = c_info.propDOB;
cboCivilStatus.Text = c_info.propCivilStatus;
cboGender.Text = c_info.propGender;
cbohousetype.Text = c_info.propHouseType;
txtemail.Text = c_info.propEmail;
txtoccupation.Text = c_info.propOccupation;
txtposition.Text = c_info.propPosition;
txtlengthservice.Text = Convert.ToInt32(c_info.propLengthofService).ToString();
txtcompanyaddress.Text = c_info.propCompanyAdd;
txtcompanyname.Text = c_info.propCompanyName;
cm.loadPictureBarrower(mlt);
tempPictures = cm.propPicBarrower;
//pictureBarrowerImages = cm.propPicBarrower;
picBorrower.Image = Image.FromFile(@"D:\MY PROJECTS\LoanTrackingSystem\loantracking\loantracking\bimages\" + cm.propPicBarrower);
picBorrower.SizeMode = PictureBoxSizeMode.StretchImage;
// picBorrower.Image = Image.FromFile(@"D:\MY PROJECTS\LoanTrackingSystem\loantracking\loantracking\bimages\default_avatar.jpg");
// picBorrower.SizeMode = PictureBoxSizeMode.StretchImage;
if (c_info.propCivilStatus != "Single")
{
cl_spouse sp = new cl_spouse();
sp.LOAD_TOFIELDSPOUSE(mlt);
txtspousename.Text = sp.propspousename;
txtSpouseAge.Text = Convert.ToInt32(sp.props_age).ToString();
txtspouseP.Text = sp.propsPosition;
txtsCompany.Text = sp.propsCompany;
txtSoCCu.Text = sp.propspouseOcc;
}
}
else
{
MYFUNCTIONS f = new MYFUNCTIONS();
DateTime dt = DateTime.Today;
Int64 dx =f.autoUserID()+1;
txtMoneyLenderID.Text =dt.Year.ToString("X2") + String.Format("{0:D5}", dx);
picBorrower.Image = Image.FromFile(@"D:\MY PROJECTS\LoanTrackingSystem\loantracking\loantracking\bimages\default_avatar.jpg");
picBorrower.SizeMode = PictureBoxSizeMode.StretchImage;
}
}
private void btnGenerate_Click(object sender, EventArgs e)
{
cl_moneylender m = new cl_moneylender();
cl_lender_inform lend = new cl_lender_inform();
//less 1 mo. interest = 1.5%
//charges = 5%
double amt_applied = 0d;
int no_ofDays = 0;
if (textBox1.Text == "") {
MessageBox.Show("Please supply the borrowers name.");
return;
}
if(Convert.ToDouble(txtAmountApplied.Text)<=0){
MessageBox.Show("Please supply the correct amount.");
return;
}
if (Convert.ToDouble(txtMonthlyDue.Text)< 0 || Convert.ToDouble(txtMonthlyDue.Text)< 5 ) {
MessageBox.Show("Please supply the correct amount.");
return;
}
if (m.isBarrowerActive(mYLenderIDs) == true)
{
MessageBox.Show("Cannot generate loan borrower is Inactive");
return;
}
amt_applied = Convert.ToDouble(txtAmountApplied.Text);
double charges = (amt_applied * 5) / 100;
double rest1 = (amt_applied * 1.5) / 100;
double net_proceeds = amt_applied - (rest1+charges);
int termsNo;
int monthstoPay;
txtNetAmount.Text = net_proceeds.ToString("#,###0.00");
DateTime timenow = DateTime.Today;
try
{
termsNo = Convert.ToInt32(txtMonthsNo.Text);
if (txtMonthsNo.Text == "")
{
termsNo = 36;
}
}
catch (Exception xx) {
termsNo = 36;
}
lsvPaymentSched.Items.Clear();
DateTime today = DateTime.Today;
List<DateTime> lstq = new List<DateTime>();
if (termsNo > 36) {
MessageBox.Show("Invalid amount.");
return;
}
else if(termsNo < 0){
termsNo = 36;
}
int ctr;
for (ctr = 1; ctr <= termsNo; ctr++)
{
// lstq.Add(timenow.AddMonths(ctr).AddDays(-1));
// MessageBox.Show(timenow.AddMonths(ctr).AddDays(-1).ToString());
lstq.Add(timenow.AddMonths(ctr).AddDays(-1));
}
//for (int i = 1; i < lstq.Count; i++)
//{
// MessageBox.Show(lstq[i].ToString());
//}
double getamnt = Convert.ToDouble(txtAmountApplied.Text);
double pmt = 0d;
double pmt1 = 0d;
double restDue = 0d;
double re = 0d;
double getamnt1 = 0d;
double mntDue = Convert.ToDouble(txtMonthlyDue.Text);
restDue = getamnt;
double tmp = 0d;
monthstoPay = 1;
//================
for (int i = 0; i < lstq.Count;i++ )
{
ListViewItem lvi1 = new ListViewItem();
DateTime lastDayOfThisMonth = new DateTime(lstq[i].Year,lstq[i].Month, 1).AddMonths(1).AddDays(-1);
//DateTime dt = DateTime.Today;
lvi1.Text = lstq[i+1].ToString(); //lastDayOfThisMonth.AddMonths(1).ToString("d");
//lstdatesched.Add(lastDayOfThisMonth.ToString());
lstdatesched.Add(lvi1.Text.ToString());
no_ofDays = Convert.ToInt32(lastDayOfThisMonth.Day.ToString());
// no_ofDays = Convert.ToInt32(lastDayOfThisMonth.AddMonths(Convert.ToInt16(lvi1.Text.Substring(1).ToString())).Day.ToString());
pmt = 0.0005; //0.015 / 30; //
pmt1 = pmt * no_ofDays;
getamnt1 = getamnt * pmt1;
re = (mntDue) - getamnt1;
tmp = getamnt;
getamnt = getamnt - re;
if (getamnt >= 0)
{
lvi1.SubItems.Add(mntDue.ToString("#,###0.00"));
lvi1.SubItems.Add(getamnt1.ToString("#,###0.00"));
}
monthstoPay = monthstoPay + 1;
lstamt.Add(getamnt);
if (getamnt <= 0)
{
double tmp_mnt = tmp + getamnt1;
lvi1.SubItems.Add(tmp_mnt.ToString("#,###0.00"));
lvi1.SubItems.Add("0.00".ToString());
lvi1.SubItems.Add("0.00".ToString());
txtmonthstopay.Text = monthstoPay - 1 + " " + "Months to pay";
lvi1.SubItems.Add("Pending");
lsvPaymentSched.Items.Add(lvi1);
return;
}
else
{
lvi1.SubItems.Add(getamnt.ToString("#,###0.00"));
}
lvi1.SubItems.Add("Pending");
lsvPaymentSched.Items.Add(lvi1);
//schedule_of_payment_id, schedule_date, cust_id, remarks
}
//=================
//foreach (DateTime eel in lstq)
//{
// ListViewItem lvi1 = new ListViewItem();
// DateTime lastDayOfThisMonth = new DateTime(eel.Year, eel.Month, 1).AddMonths(1).AddDays(-1);
// //DateTime dt = DateTime.Today;
// lvi1.Text = lastDayOfThisMonth.AddMonths(1).ToString("d");
// //lstdatesched.Add(lastDayOfThisMonth.ToString());
// lstdatesched.Add(lvi1.Text.ToString());
// no_ofDays = Convert.ToInt32(lastDayOfThisMonth.Day.ToString());
// // no_ofDays = Convert.ToInt32(lastDayOfThisMonth.AddMonths(Convert.ToInt16(lvi1.Text.Substring(1).ToString())).Day.ToString());
// pmt = 0.0005; //0.015 / 30; //
// pmt1 = pmt * no_ofDays;
// getamnt1 = getamnt * pmt1;
// re = (mntDue) - getamnt1;
// tmp = getamnt;
// getamnt = getamnt - re;
// if (getamnt >= 0)
// {
// lvi1.SubItems.Add(mntDue.ToString("#,###0.00"));
// lvi1.SubItems.Add(getamnt1.ToString("#,###0.00"));
// }
// monthstoPay = monthstoPay + 1;
// lstamt.Add(getamnt);
// if (getamnt <= 0)
// {
// double tmp_mnt = tmp + getamnt1;
// lvi1.SubItems.Add(tmp_mnt.ToString("#,###0.00"));
// lvi1.SubItems.Add("0.00".ToString());
// lvi1.SubItems.Add("0.00".ToString());
// txtmonthstopay.Text = monthstoPay - 1 + " " + "Months to pay";
// lvi1.SubItems.Add("Pending");
// lsvPaymentSched.Items.Add(lvi1);
// return;
// }
// else
// {
// lvi1.SubItems.Add(getamnt.ToString("#,###0.00"));
// }
// lvi1.SubItems.Add("Pending");
// lsvPaymentSched.Items.Add(lvi1);
// //schedule_of_payment_id, schedule_date, cust_id, remarks
//}
}
private void textBox1_TextChanged(object sender, EventArgs e)
{
cl_moneylender cl = new cl_moneylender();
cl.SearchLenderByName(textBox1.Text, lsvLender);
if (!string.IsNullOrEmpty(textBox1.Text))
{
this.lsvLender.BringToFront();
this.lsvLender.Location = new Point(282, 79);
this.lsvLender.Visible = true;
}
else if(textBox1.Text == "")
{
this.lsvLender.Visible = false;
}
}
private void lsvLender_DoubleClick(object sender, EventArgs e)
{
cl_moneylender ml = new cl_moneylender();
int ml_ID = Convert.ToInt32(lsvLender.SelectedItems[0].Text);
mYLenderIDs = ml_ID;
ml.LOADTOFIELDS(ml_ID);
textBox1.Text = ml.propfname + " " + ml.propMI + " " + ml.proplname;
txtlenderID.Text = ml.propLenderID;
this.lsvLender.Visible = false;
}
private void lsvLender_DoubleClick(object sender, EventArgs e)
{
cl_moneylender ml = new cl_moneylender();
cl_lender_inform lendIn = new cl_lender_inform();
int ml_ID = Convert.ToInt32(lsvLender.SelectedItems[0].Text);
mYLenderIDs = ml_ID;
ml.LOADTOFIELDS(ml_ID);
txtborrwersName.Text = ml.propfname + " " + ml.propMI + " " + ml.proplname;
txtlenderID.Text = ml.propLenderID;
txtAddress.Text = ml.propAddress;
lendIn.PaySched(ml_ID);
txtPenalty.Text = lendIn.propHpenalty.ToString("#,##0.00");
this.lsvLender.Visible = false;
cl_lender_inform le = new cl_lender_inform();
le.hasBorrowerPenalty(ml_ID);
txtAmountApplied.Text = lendIn.propPrinc.ToString("#,##0.00");
double xd = lendIn.propMnt_amount + lendIn.propHpenalty;
txtMonthlyDues.Text = xd.ToString("#,##0.00");
}
