private void btnDelete_Click(object sender, EventArgs e) { cl_Penalty p = new cl_Penalty(); MYFUNCTIONS f = new MYFUNCTIONS(); int pubIDel = Convert.ToInt32(listView1.SelectedItems[0].Text); p.propPenalty_Id = pubIDel; p.delete_penalty(); f.PopulateListView(listView1, "Select * from tpenalty"); }
private void frmListofBorrower_Load(object sender, EventArgs e) { MYFUNCTIONS f = new MYFUNCTIONS(); string sql=""; //tmoneylender //moneylender_id, fname, lname, mi, address, age, date_lender, credit_limit, contact_no, lenderID //schedule_of_payment_id, schedule_date, cust_id, remarks, amount_lend //tmoneylender_loan //moneylender_loan_ID, loan_id, moneylender_id, status, mnt_amount, principal //tschedule_of_payment sql = "select b.lenderID,CONCAT(b.fname, ' ', b.mi, ' ' , b.lname) as NAME,b.address,b.contact_no," + "(sum(sp.mnt_amount)+ sum(sp.penalty_amount)) as spcollection from tmoneylender b " + "inner join tschedule_of_payment sp on b.moneylender_id = sp.moneylender_id "+ "where sp.status = 'paid'"; f.PopulateListView(lsvBCollection,sql); }
private void btnSave_Click(object sender, EventArgs e) { MYFUNCTIONS f = new MYFUNCTIONS(); cl_Penalty p = new cl_Penalty(); p.propPenalty_amount =Convert.ToDouble(txtpenalty.Text); if ((cboRemarks.Text == "Active") || (cboRemarks.Text == "Pending")) { } else { MessageBox.Show("Please select the remarks."); return; } if (PUBLIC_VARS.EDITMODE == true) { if (p.countActive(cboRemarks.Text) == true ) { MessageBox.Show("Please set only 1 active penalty"); return; } p.propPenalty_Id = pubID; p.propPenalty_remarks = cboRemarks.Text; p.update_penalty(); MessageBox.Show(PUBLIC_VARS.updateData); f.PopulateListView(listView1, "Select * from tpenalty"); } else { if (p.countActive(cboRemarks.Text) == true ) { MessageBox.Show("Please set only 1 active penalty"); return; } p.propPenalty_remarks = cboRemarks.Text; p.INSERT_PENALTY(); MessageBox.Show( PUBLIC_VARS.saveData); f.PopulateListView(listView1, "Select * from tpenalty"); } }
private void frmAccountPayable_Load(object sender, EventArgs e) { int dt; int yr; MYFUNCTIONS f = new MYFUNCTIONS(); double mntDue = 0d; dt = 0; yr = 0; f.acctPayable(lsvBCollection, dt, yr); label3.Text ="Total no. of barrowers :" + lsvBCollection.Items.Count.ToString(); if(lsvBCollection.SelectedItems.Count > -1){ for (int c = 0; c <= lsvBCollection.Items.Count -1; c++) //MessageBox.Show(lsvBCollection.Items[c].SubItems[4].ToString()); { double ham = 0d; ham = Convert.ToDouble(lsvBCollection.Items[c].SubItems[4].Text); mntDue = mntDue + ham; } } label4.Text = "Total Account's Payable : " + String.Format("{0:#,##0.00}", mntDue); }
private void button1_Click(object sender, EventArgs e) { int dt; int yr; double mntDue = 0d; MYFUNCTIONS f = new MYFUNCTIONS(); dt = dateTimePicker1.Value.Month; yr = dateTimePicker1.Value.Year; f.acctPayable(lsvBCollection, dt,yr); if (lsvBCollection.SelectedItems.Count > -1) { for (int c = 0; c <= lsvBCollection.Items.Count - 1; c++) //MessageBox.Show(lsvBCollection.Items[c].SubItems[4].ToString()); { double ham = 0d; ham = Convert.ToDouble(lsvBCollection.Items[c].SubItems[4].Text); mntDue = mntDue + ham; } label4.Text = "Total Account's Payable : " + String.Format("{0:#,##0.00}", mntDue); } }
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 frmPenalty_Load(object sender, EventArgs e) { MYFUNCTIONS f = new MYFUNCTIONS(); f.PopulateListView(listView1, "select * from tpenalty"); }