private void updateInfoToolStripMenuItem_Click(object sender, EventArgs e) { if (lv.SelectedItems.Count > 0) { Member mem, sel = new Member(); //MessageBox.Show(lv.SelectedItems[0].SubItems[1].Text); sel.memid = lv.SelectedItems[0].SubItems[1].Text; mem= sel.SELECT_BY_ID(); mem.GET_IMAGE_BY_ID(); if (mem != null) { pnlops.Controls.Clear(); mem_update c = new mem_update(); c.mem = mem; c.Width = pnlops.Width; pnlops.Height = c.Height; pnlops.Controls.Add(c); } } }
private void cboMem_SelectedIndexChanged(object sender, EventArgs e) { txtinterest.Text = ""; txtinterest_amort.Text = ""; txtprincipal.Text = ""; txtprincipal_amort.Text = ""; txttotal_amort.Text = ""; cbocollection_day.Text = ""; cbopayment_mode.Text = ""; txtinterest.Text = ""; cboamortization_period.Text = ""; MAXIMUM_ALLOWED_LOAN = 0; lbmembersdata.Items.Clear(); lblatestloan.Items.Clear(); cboComaker.Text = ""; pbcomaker.Image = null; lblcomaker.Text = ""; lblcomaker.BackColor = Color.Transparent; lbcomakersdata.Items.Clear(); lbcomakerslatestloan.Items.Clear(); if (cboMem.Text != "") { String[] c = cboMem.Text.ToString().Split('-'); String id = c[c.Length-2] + "-" + c[c.Length-1]; Member m2 = new Member(); //MessageBox.Show(id); m2.memid = id; applicant = m2.SELECT_BY_ID(); m2.GET_IMAGE_BY_ID(); lblmem.Text = applicant.fullname.ToString().ToUpper() + " - " + applicant.occupation.ToString(); Member_Capital mc = new Member_Capital(); mc.memid = applicant.memid; decimal cbu = mc.GET_CURRENT_PAID_UP_CAPITAL(); lbmembersdata.Items.Add("MEMBER'S VERIFICATION DATA"); lbmembersdata.Items.Add("MEMBER SINCE : " + applicant.acceptance_date.ToShortDateString()); lbmembersdata.Items.Add("MEMBER STANDING : " + applicant.standing); lbmembersdata.Items.Add("CBU AS OF " + DateTime.Now.ToShortDateString() + " : PhP " + cbu.ToString("#,##0.00")); l.empid = applicant.memid; Loan applicant_latest_loan = l.GET_LATEST_LOAN("MICRO"); PREV_LOAN = applicant_latest_loan; // GET THE LATEST MICRO LOAN OF A MEMBER lblatestloan.Items.Add("LATEST MICRO LOAN"); LATEST_MICRO_LOAN = (applicant_latest_loan != null) ? applicant_latest_loan.principal : 0; if (LATEST_MICRO_LOAN != 0) { lblatestloan.Items.Add("APPLICATION NO : " + applicant_latest_loan.application_no); lblatestloan.Items.Add("PRINCIPAL : PhP " + applicant_latest_loan.principal.ToString("#,##0.00")); lblatestloan.Items.Add("INTEREST : PhP " + applicant_latest_loan.interest.ToString("#,##0.00")); lblatestloan.Items.Add("MONTHLY AMORTIZATION: PhP " + (applicant_latest_loan.amortization_on_interest + applicant_latest_loan.amortization_on_principal).ToString("#,##0.00")); lblatestloan.Items.Add("BALANCE: ---(under development)---"); } else { lblatestloan.Items.Add("Nothing found..."); } //lblmemdata2.Text = "CAPITAL BUILD-UP :" +cbu.ToString("#,##0.00"); if (cbu >= MINIMUM_SHARED_CAPITAL_TO_AVAIL_LOAN) { lbmembersdata.Items.Add("PASSED THE MINIMUM : " + MINIMUM_SHARED_CAPITAL_TO_AVAIL_LOAN.ToString("#,##0.00") + " SHARE TO AVAIL LOAN"); lblmem.BackColor = Color.Green; //subtract minimum shared capital from the CBU //then get the 60% -- because 60% of (CBU-MINIMUM_SHARED_CAPITAL) is the //LOANABLE_AMOUNT MAXIMUM_ALLOWED_LOAN = (cbu - MINIMUM_SHARED_CAPITAL) * PERCENTAGE_TOGET_LOANABLE_AMOUNT; lbmembersdata.Items.Add("MAX LOANABLE AMOUNT : PhP " + MAXIMUM_ALLOWED_LOAN.ToString("#,##0.00")); } else { lbmembersdata.Items.Add("DID NOT PASSED THE MINIMUM : " + MINIMUM_SHARED_CAPITAL_TO_AVAIL_LOAN.ToString("#,##0.00") + " SHARE TO AVAIL LOAN"); lblmem.BackColor = Color.Red; } if (m2.pic != null) { MemoryStream ms = new MemoryStream(m2.pic); pb.Image = Image.FromStream(ms); pb.SizeMode = PictureBoxSizeMode.Zoom; } else { pb.Image = Properties.Resources.noimagefound; pb.SizeMode = PictureBoxSizeMode.Zoom; } } }