Example #1
0
        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);
                }

            }
        }
Example #2
0
        private void btnsave_Click(object sender, EventArgs e)
        {
            Member m = new Member();
            m.memid = txtid.Text;
            m.fullname = txtlname.Text + ", " + txtfname.Text + " " + txtmname.Text;

            m.gender = cbogender.Text;
            m.birthdate = dtBday.Value;
            m.contactno = txtcontactno.Text;
            m.address = txtaddress.Text;
            m.occupation = txtoccupation.Text;
            m.status = "ACTIVE"; //STATUS = ACTIVE, STAFF, WITHDRAWN

            m.typeofmembership = cbomembershiptype.Text; // REGULAR, ASSOCIATE
            m.email = txtemail.Text;
            m.tinno = txttinno.Text;

            if (pbEmpPic.Image != null)
            {
                long filesize;
                MemoryStream mstream = new MemoryStream();
                pbEmpPic.Image.Save(mstream, System.Drawing.Imaging.ImageFormat.Jpeg);
                Byte[] arrImage = mstream.GetBuffer();
                filesize = mstream.Length;
                m.pic = arrImage;
            }

            if(m.save()){
                    MessageBox.Show("Successful", "Saving...", MessageBoxButtons.OK,MessageBoxIcon.Exclamation, MessageBoxDefaultButton.Button1);
                    this.Parent.Height = 0;
                    this.Parent.Controls.Clear();
                    this.Dispose();
            }
            else{
                Logger.WriteErrorLog(db.err.ToString());
                MessageBox.Show("Error : " + db.err.ToString() , "Saving...", MessageBoxButtons.OK, MessageBoxIcon.Error, MessageBoxDefaultButton.Button1);
            }
        }
Example #3
0
 private void btnFilter_Click(object sender, EventArgs e)
 {
     Member mem = new Member();
     m.Load_Searched_MembersInListView(lv, txtname.Text);
 }
Example #4
0
        private void btnMigrate_Click(object sender, EventArgs e)
        {
            DataTable dt = dTable;
            dtmigrated = dt.Clone();
            dtmigrated.Rows.Clear();

            foreach (DataRow row in dt.Rows)
            {
                Member m = new Member();
                m.memid = row["Membership_Registry_Number"].ToString();
                m.fullname = row["Name of Member"].ToString();
                m.address = row["Address"].ToString();
                m.email = row["Email"].ToString();
                m.acceptance_date = Convert.ToDateTime(row["Acceptance_Date"].ToString());
                m.contactno = row["Contact_No"].ToString();
                m.occupation = row["Occupation"].ToString();
                m.status = "ACTIVE"; //STATUS = ACTIVE, STAFF, WITHDRAWN

                m.typeofmembership = "REGULAR"; // REGULAR, ASSOCIATE

                if (m.save())
                {
                    System.Diagnostics.Debug.WriteLine(m.memid + "-" + m.fullname + " -->Record Saved");
                }
                else {
                    System.Diagnostics.Debug.WriteLine("Error :" + db.err.Message);
                }
            }
            bs = new BindingSource();

            bs.DataSource = dtmigrated;
        }
Example #5
0
        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;
                }
            }
        }
Example #6
0
        public Member SELECT_BY_ID()
        {
            DataTable dt = new DataTable();
            MySqlCommand cmd = new MySqlCommand();
            db.SET_COMMAND_PARAMS(cmd, "MEMBER_SELECT_BY_ID");
            cmd.Parameters.AddWithValue("_memid", memid);
            MySqlDataAdapter da = new MySqlDataAdapter(cmd);
            da.Fill(dt);

            try
            {

                if (dt != null)
                {
                    if (dt.Rows.Count > 0)
                    {
                        Member e = new Member();

                        foreach (DataRow r in dt.Rows)
                        {
                            e.memid = r["memid"].ToString();
                            e.fullname = r["fullname"].ToString();
                            e.address = r["address"].ToString();
                            e.contactno = r["contactno"].ToString();
                            e.status = r["status_"].ToString();
                            e.typeofmembership = r["typeofmembership"].ToString();
                            e.occupation = r["occupation"].ToString();
                            e.email = r["email"].ToString();
                            e.acceptance_date = Convert.ToDateTime(r["acceptance_date"].ToString());
                            e.address = r["address"].ToString();
                            e.tinno = r["tinno"].ToString();

                        }
                        return e;

                    }
                    else
                    {

                        return null;
                    }
                }
                else
                {
                    return null;
                }
            }
            catch (Exception err) {
                Logger.WriteErrorLog("ERROR ON MEMBERS_SELECT_BY_ID MODULE :" + err.Message);
                return null;
            }
        }
Example #7
0
        public void Load_Searched_MembersInListView(ListView lv, String input)
        {
            Member e = new Member();
                DataTable dt = new DataTable();

                dt = e.SELECT_BY_NAME(input);

                lv.Items.Clear();

                if (dt != null)
                {
                    int ctr = 1;
                    foreach (DataRow r in dt.Rows)
                    {
                        ListViewItem li = new ListViewItem();
                        li.Text = ctr.ToString();
                        li.SubItems.Add(r["memid"].ToString());
                        li.SubItems.Add(r["fullname"].ToString());
                        li.SubItems.Add(r["address"].ToString());
                        li.SubItems.Add(r["contactno"].ToString());
                        Member_Standing ms = new Member_Standing();
                        ms.memid = r["memid"].ToString();
                        li.SubItems.Add(ms.STANDING);

                        li.BackColor = (ms.STANDING == "MIGS") ? Color.GreenYellow : Color.Red;

                        lv.Items.Add(li);
                        ctr++;

                    }
                }
        }
Example #8
0
        public void LoadRegularMembers(ComboBox cbo)
        {
            Member e = new Member();
                DataTable dt = new DataTable();

                dt = e.SELECT_REGULAR();
                if (dt != null)
                {
                    foreach (DataRow r in dt.Rows)
                    {
                        cbo.Items.Add(r["fullname"] + "-" + r["memid"]);
                    }
                }
        }