예제 #1
0
        private void attendanceToolStripMenuItem_Click(object sender, EventArgs e)
        {
            if (lv.SelectedItems.Count > 0)
            {
                String id = lv.SelectedItems[0].SubItems[1].Text;

                Employee emp, emp1 = new Employee();
                emp1.empid = id;

                emp = emp1.SELECT_BY_ID();

                emp.GET_BASIC_PAY();
                emp.GET_BRANCH_ASSIGNMENT();
                emp.GET_EMPLOYMENT_STATUS();
                emp.GET_IMAGE_BY_ID();
                emp.GET_CURRENT_POSITION();

                pnlops.Controls.Clear();

                attendance_entry c = new attendance_entry();
                c.emp = emp;
                c.Width = pnlops.Width;
                pnlops.Height = c.Height;

                pnlops.Controls.Add(c);
            }
        }
예제 #2
0
        private void cboEmp_SelectedIndexChanged(object sender, EventArgs e)
        {
            if (cboEmp.Text != "")
            {
                String[] c = cboEmp.Text.ToString().Split('-');
                String id = c[1];
                Employee emp1, emp2 = new Employee();
                emp2.empid = id;

                emp1 = emp2.SELECT_BY_ID();
                emp = emp1;
                //emp1.SELECT_BY_ID();
                emp1.GET_IMAGE_BY_ID();

                String pos = (emp1.GET_CURRENT_POSITION() != "") ? emp1.position.ToString() : "NO_POSITION_INDICATED";
                lblemp.Text = emp1.lname.ToUpper() + ", " + emp1.fname.ToUpper() + " " + emp1.mname.ToUpper() + " - " + pos;

                if (emp1.pic != null)
                {
                    MemoryStream ms = new MemoryStream(emp1.pic);
                    pb.Image = Image.FromStream(ms);
                    pb.SizeMode = PictureBoxSizeMode.Zoom;
                }
                else
                {
                    pb.Image = Properties.Resources.noimagefound;
                    pb.SizeMode = PictureBoxSizeMode.Zoom;
                }
            }
        }
예제 #3
0
        private void btnStart_Click(object sender, EventArgs e)
        {
            if (btnStart.Text == "Start")
            {

                pnlops.Controls.Clear();
                Employee emp = new Employee();
                //1-Tabaco Lab
                //2-Central Office
                //3-Legazpi
                //4-Ligao
                //5-Polangui
                emp.branch = "2";// LOAD CENTRAL EMPLOYEES
                //DataTable empdt = emp.SELECT_ALL();
                DataTable empdt = emp.SELECT_BY_BRANCH();

                if (empdt != null)
                {
                    label1.Text = "Payroll Generator : FROM :" + cutoff.from_date.ToShortDateString() + " - " + cutoff.to_date.ToShortDateString() + " Total Employee [" + empdt.Rows.Count.ToString() + "]";

                    foreach (DataRow dr in empdt.Rows)
                    {

                        String empid = dr["empid"].ToString();

                        emp_payroll_new ep = new emp_payroll_new();
                        ep.cutoff = cutoff;
                        ep.cutoffdetailsdt = cutoffdetailsdt;
                        ep.empid = empid; ;
                        ep.Dock = DockStyle.Top;
                        ep.Width = pnlops.Width - 40;

                        pnlops.Controls.Add(ep);

                    }
                }
                else
                {
                    MessageBox.Show("EMPLOYEE BY BRANCH NOT WORKING...");
                }

                btnStart.Text = "Print";
            }
            else {

                frmCutoffAttendanceReport frm = new frmCutoffAttendanceReport();

                frm.cutoff_date_from = cutoff.from_date;
                frm.cutoff_date_to = cutoff.to_date;
                frm.cutoffdetailsdt = cutoffdetailsdt;

                frm.ShowDialog();

                btnStart.Text = "Start";
            }
        }
예제 #4
0
        private void tztpassword_KeyDown(object sender, KeyEventArgs e)
        {
            if (e.KeyCode.ToString().Equals("Return"))
            {

                Employee emp, emp1 = new Employee();
                emp1.empid = txtid.Text;
                String hash;
                using (MD5 md5Hash = MD5.Create())
                {
                    hash = Global.GetMd5Hash(md5Hash, txtpassword.Text);
                }

                emp1.password = hash;
                emp = emp1.SELECT_BY_IDPASS();

                //MessageBox.Show(hash);

                if (emp != null)
                {

                    Global.CURRENT_USER.empid = emp.empid;
                    Global.CURRENT_USER = emp;
                    Global.CURRENT_USER.pic = emp.GET_IMAGE_BY_ID();
                    Global.CURRENT_USER.basic_pay = emp.GET_BASIC_PAY();
                    Global.CURRENT_USER.emp_status = emp.GET_EMPLOYMENT_STATUS();
                    Global.CURRENT_USER.position = emp.GET_CURRENT_POSITION();
                    Global.CURRENT_USER.branch = emp.GET_BRANCH_ASSIGNMENT();

                    //CREATE A RESTRICTION OBJECT
                    Emp_Restriction r = new Emp_Restriction();
                    //SET CURRENT USER RESTRICTION
                    r.empid = Global.CURRENT_USER.empid;
                    Global.CURRENT_USER.restriction = r.SELECT_BY_ID();
                    Global.CURRENT_USER.LIST_BENEFITS();

                    //GET CURRENT USER LATEST SCHEDULE
                    Emp_Sched es = new Emp_Sched();
                    es.empid = Global.CURRENT_USER.empid;
                    Global.CURRENT_USER.schedule = es.SELECT_BY_EMPID();

                    Global.CURRENT_USER.ISLOGGEDIN = true;

                    frmMain f = new frmMain();
                    f.Show();

                    this.Hide();

                }
                else {
                    MessageBox.Show("Nothing found");
                }

            }
        }
예제 #5
0
        //private decimal MINUTELY_RATE = 0;//AKA RATE_PER_MINUTE
        public Payroll_Generator(Employee empparam, List<Attendance> attendanceparam, List<Cutoff_Details> cutoffparam)
        {
            this.emp = empparam;
            this.attendance = attendanceparam;
            this.cutoff = cutoffparam;

            MONTHLY_RATE = emp.GET_BASIC_PAY();
            DAILY_RATE = MONTHLY_RATE / 26;

            string EMP_STATUS = emp.GET_EMPLOYMENT_STATUS();

            HOURLY_RATE = (EMP_STATUS == "Regular") ? DAILY_RATE / 7 : DAILY_RATE / 8;
        }
예제 #6
0
        private void bgw_DoWork(object sender, DoWorkEventArgs e)
        {
            Employee emp = new Employee();
            DataTable dt = emp.SELECT_IDS();

            if (dt != null)
            {
                int ctr = dt.Rows.Count;
                for (int x = 0; x < ctr - 1; x++)
                {
                    bgw.ReportProgress(x);
                }
            }
            else{

            }
        }
예제 #7
0
        private void cboEmp_SelectedIndexChanged(object sender, EventArgs e)
        {
            pnlrestrictions.Controls.Clear();

            if (cboEmp.Text != "")
            {
                String[] c = cboEmp.Text.ToString().Split('-');
                String id = c[1];
                Employee emp1, emp2 = new Employee();
                emp2.empid = id;

                emp1 = emp2.SELECT_BY_ID();
                emp = emp1;

                //emp1.SELECT_BY_ID();
                emp1.GET_IMAGE_BY_ID();

                String pos = (emp1.GET_CURRENT_POSITION() != "") ? emp1.position.ToString() : "NO_POSITION_INDICATED";
                lblemp.Text = emp1.lname.ToUpper() + ", " + emp1.fname.ToUpper() + " " + emp1.mname.ToUpper() + " - " + pos;

                if (emp1.pic != null)
                {
                    MemoryStream ms = new MemoryStream(emp1.pic);
                    pb.Image = Image.FromStream(ms);
                    pb.SizeMode = PictureBoxSizeMode.Zoom;
                }
                else
                {
                    pb.Image = Properties.Resources.noimagefound;
                    pb.SizeMode = PictureBoxSizeMode.Zoom;
                }

                //GET THE RESTRICTIONS
                Emp_Restriction er, er2 = new Emp_Restriction();
                er2.empid = emp.empid;
                er = er2.SELECT_BY_ID();

                //LOOP THROUGH ALL RESTRICTIONS THEN ADD A CHECKBOX FOR EACH RESTRICTION

                GenereateCheckBoxes(er);

            }
        }
예제 #8
0
파일: Global.cs 프로젝트: zerojec/MMG-PIAPS
        public static void CREATE_JECBASCO()
        {
            Employee emps = new Employee();

               emps.empid = "0039";
               emps.fname = "Jose Jericho";
               emps.lname = "Basco";
               emps.mname = "Astillero";
               emps.gender = "Male";
               emps.birthdate = DateTime.Now;

               emps.contactno = "09064418634";
               emps.address = "Basud, Tabaco City";
               emps.position = "IT-Programmer";
               emps.basic_pay = Convert.ToDecimal("10826.00");
               emps.date_hired = DateTime.Now;
               emps.emp_status = "Regular";
               emps.branch = "1";
               emps.tinno = "";

               //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;
               //    emps.pic = arrImage;
               //}

               emps.password = "******";

               if (emps.save())
               {
               MessageBox.Show("Okey");
               }
               else
               {
               MessageBox.Show("Error :" + db.err.Message);
               }
        }
예제 #9
0
        private void btnsave_Click(object sender, EventArgs e)
        {
            Employee emp = new Employee();
                emp.empid = txtid.Text;
                emp.fname= txtfname.Text;
                emp.lname = txtlname.Text;
                emp.mname = txtmname.Text;
                emp.gender = cbogender.Text;
                emp.birthdate = dtBday.Value;
                emp.contactno = txtcontactno.Text;
                emp.address = txtaddress.Text;
                emp.position = cbopositions.Text;
                emp.basic_pay = Convert.ToDecimal(txtbasicpay.Text);
                emp.date_hired = dtemploymentdate.Value;
                emp.emp_status = cboemploymentstatus.Text;
                string[] branchid = cbobranch.Text.Split('-');
                emp.branch = branchid[0];
                emp.tinno = txttinno.Text;
                emp.position = cbopositions.Text;
                emp.password = "******";

                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;
                    emp.pic = arrImage;
                }

                if (emp.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);
                }
        }
예제 #10
0
 public void LoadAllEployees()
 {
     Employee emp= new Employee();
     DataTable dt = new DataTable();
     dt = emp.SELECT_ALL();
     if (dt != null) {
         int num=1;
         foreach(DataRow r in dt.Rows){
             ListViewItem li = new ListViewItem();
             li.Text = num.ToString();
             li.SubItems.Add(r["empid"].ToString());
             li.SubItems.Add(r["lname"].ToString() + ", " + r["fname"].ToString() + " " + r["mname"].ToString());
             li.SubItems.Add(r["position_"].ToString());//r["position"].ToString());
             li.SubItems.Add(r["contactno"].ToString());
             //li.SubItems.Add(r["gender"].ToString());
             li.SubItems.Add(r["address"].ToString());
             lv.Items.Add(li);
             num++;
         }
     }
 }
예제 #11
0
        //BGW asynchronously GET EMPLOYEE DETAILS
        //ASYNC GET IMAGE FROM DATABASE
        //ASYNC GET LASTEST POSITION
        private void bgw_DoWork(object sender, DoWorkEventArgs e)
        {
            Employee getter = new Employee();
            getter.empid = empid;

            if (dbcon.CONNECT()) {
                emp=getter.SELECT_BY_ID(dbcon);
                emp.GET_IMAGE_BY_ID(dbcon);
                emp.GET_CURRENT_POSITION(dbcon);

                Emp_Sched es = new Emp_Sched();
                es.empid = emp.empid;
                empsched = es.SELECT_BY_EMPID(dbcon);
            }
        }
예제 #12
0
        public void LoadRegularEmployee(ComboBox cbo)
        {
            Employee e = new Employee();
                DataTable dt = new DataTable();

                dt = e.SELECT_REGULAR();
                if (dt != null)
                {
                    foreach (DataRow r in dt.Rows)
                    {
                        cbo.Items.Add(r["lname"] + ", " + r["fname"] + " " + r["mname"] + "-" + r["empid"]);
                    }
                }
        }
예제 #13
0
 public void employeeadded(Employee e)
 {
 }
예제 #14
0
        private void viewScheduleToolStripMenuItem_Click(object sender, EventArgs e)
        {
            String id = lv.SelectedItems[0].SubItems[1].Text;
            //MessageBox.Show(id);

            Employee emp, emp1 = new Employee();
            emp1.empid = id;
            emp = emp1.SELECT_BY_ID();
            emp.GET_BASIC_PAY();
            emp.GET_BRANCH_ASSIGNMENT();
            emp.GET_EMPLOYMENT_STATUS();
            emp.GET_IMAGE_BY_ID();
            emp.GET_CURRENT_POSITION();
            emp.LIST_BENEFITS();
            pnlops.Controls.Clear();

            Emp_Sched es = new Emp_Sched();
            es.empid = emp.empid;
            emp.schedule= es.SELECT_BY_EMPID();

            emp_view_sched c = new emp_view_sched();
            c.emp = emp;
            c.Width = pnlops.Width;
            pnlops.Height = c.Height;

            pnlops.Controls.Add(c);
        }
예제 #15
0
        private void frmCutoffAttendanceReport_Load(object sender, EventArgs e)
        {
            this.rptViewer.ProcessingMode = Microsoft.Reporting.WinForms.ProcessingMode.Local;
            this.rptViewer.LocalReport.DataSources.Clear();

            string path = System.Reflection.Assembly.GetExecutingAssembly().Location.ToString();
            var directory = System.IO.Path.GetDirectoryName(path);
            directory += "\\reports\\atttendance_cutoff.rdlc";

            //C:\projects\MMG-PIAPS\MMG-PIAPS\bin\Debug\reports\cutoff_attendance.rdlc
            //C:\projects\MMG-PIAPS\MMG-PIAPS\bin\Debug\reports\atttendance_cutoff.rdlc
            this.rptViewer.LocalReport.ReportPath = directory;

            //MessageBox.Show(directory);

            Employee emp = new Employee();
            emp.branch = "2";

            DataTable dt = emp.SELECT_BY_BRANCH();

            DataSet1 ds = new DataSet1();
            cutoffdt = ds.Tables["cutoffattendance"];

            //CREATE AN IMAGE COLUMN
            //SET THE IMAGE VALUE
            //THEN ADD TO DATASET FOR REPORT REFERENCE
            DataColumn colByteArray = new DataColumn("emp_img");
            colByteArray.DataType = System.Type.GetType("System.Byte[]");
            dt.Columns.Add(colByteArray);

            foreach (DataRow item in dt.Rows) {

                Employee e1 = new Employee();
                e1.empid = item["empid"].ToString();
                item["emp_img"] = e1.GET_IMAGE_BY_ID();

                //=====================================

                //FOR SUBREPORT DATASOURCE
                //POPULATE THE DATASET, FOR SUBREPORT USAGE
                //WITH THE EMPLOYEE'S ATTENDANCE FROM BIOMETRICS
                //THEN CHECKS THE ATTENDANCE WHETHER GOOD (IN,OUT,IN,OUT)
                //OR INAPPROPRIATE (IN ONLY, OR (IN, OUT, IN), OR (IN,OUT,OUT,IN,OUT)
                //AND OTHER IMPROPER ATTENDANCE LOGS
                int x = 1;
                foreach (DataRow cutoffitem in cutoffdetailsdt.Rows)
                {

                    DataRow c = cutoffdt.NewRow();

                    DateTime d = Convert.ToDateTime(cutoffitem["date_"].ToString());
                    c.BeginEdit();
                    c["empid"] = e1.empid;
                    c["no"] = x;
                    c["date_"] = d.ToString("MM/dd/yyyy");

                    //CRREATE A DYNAMIC CONNECTION TO DB
                    non_static_dbcon cn = new non_static_dbcon();

                    //COMPARE CUTOFF DATE WITH ATTENDANCE HERE
                    //==============================================
                    String attendance;

                    String status;

                    if (cn.CONNECT())
                    {
                        Attendance att = new Attendance();
                        att.empid = e1.empid;

                        attendance = att.SELECT_STR_BY_EMPID_BY_DATE(d, cn);

                        String[] attarr= attendance.Split(',');

                        if (attendance != "")
                        {
                            if ((attarr.Length == 3) || (attarr.Length > 4))
                            {
                                status = "INAPPROPRIATE";
                            }
                            else if ((attarr.Length == 2) || attarr.Length == 4)
                            {
                                status = "GOOD";
                            }
                            else {
                                status = "INAPPROPRIATE";
                            }
                        }
                        else {
                            status = "";
                        }

                    }
                    else {
                        attendance = "";
                        status = "";
                    }

                    cn.DISCONNECT();

                    c["attendance_"] = attendance;
                    //===============================================
                    c["day_type"] = cutoffitem["day_type"].ToString();

                    c["status_"] = status;
                    cutoffdt.Rows.Add(c);

                    x++;
                }

                //=====================================
            }//end foreach item in dt.rows
            ReportDataSource r = new ReportDataSource("DataSet1", dt);

            this.rptViewer.LocalReport.SubreportProcessing += new SubreportProcessingEventHandler(localReport_SubreportProcessing);

            //SET REPORT PARAMETER
            ReportParameter from_date = new ReportParameter("cutoff_date_from", cutoff_date_from.ToString("MM/dd/yyyy"));
            ReportParameter to_date = new ReportParameter("cutoff_date_to", cutoff_date_to.ToString("MM/dd/yyyy"));

            rptViewer.LocalReport.SetParameters(from_date);
            rptViewer.LocalReport.SetParameters(to_date);

            this.rptViewer.LocalReport.DataSources.Add(r);

               // this.rptViewer.SetDisplayMode(DisplayMode.PrintLayout);
            this.rptViewer.RefreshReport();
        }
예제 #16
0
        private void cboemp_SelectedIndexChanged(object sender, EventArgs e)
        {
            txtinterest.Text = "";
            txtinterest_amort.Text = "";
            cboprincipal.Text = "";
            txtprincipal_amort.Text = "";
            txttotal_amort.Text = "";
            MAXIMUM_ALLOWED_AMORT_PERIOD = 0;
            MAXIMUM_ALLOWED_LOAN = 0;
            txtbalance.Text = "";
            cbopayment_mode.Text = "";
            cbocollection_day.Text = "";
            cboamortization_period.Text = "";
            txtnetproceeds.Text = "";
            lbapplicantsdata.Items.Clear();
            lblatestloan.Items.Clear();
            lbcomakersdata.Items.Clear();
            lbcomakerslatestloan.Items.Clear();

            if (cboemp.Text != "")
            {
                String[] c = cboemp.Text.ToString().Split('-');
                String id = c[1];
                Employee emp2 = new Employee();
                emp2.empid = id;

               applicant = emp2.SELECT_BY_ID();

                //GET LATEST BASIC SAL
                decimal BASIC_PAY = applicant.GET_BASIC_PAY();

                //emp1.SELECT_BY_ID();
                applicant.GET_IMAGE_BY_ID();

                String pos = (applicant.GET_CURRENT_POSITION() != "") ? applicant.position.ToString() : "NO_POSITION_INDICATED";
                lblemp.Text = applicant.lname.ToUpper() + ", " + applicant.fname.ToUpper() + " " + applicant.mname.ToUpper() + " - " + pos;

                //WHEN WAS THE EMPLOYEE BECAME REGULAR?
                DateTime regularization_date = applicant.GET_REGULAR_STATUS_DATE();
                int months_as_regular = Global.GetMonths(regularization_date, DateTime.Now);

                //DISPLAY REGULARIZATION DATE
                lbapplicantsdata.Items.Add("EMPLOYEE INFORMATION");
                lbapplicantsdata.Items.Add("BECAME REGULAR SINCE :" + regularization_date.ToShortDateString());
                lbapplicantsdata.Items.Add("TOTAL MONTHS_IN_SEVICE AS REGULAR : " + months_as_regular.ToString());
                lbapplicantsdata.Items.Add("BASIC SALARY : " + BASIC_PAY.ToString("#,##0.00"));

                //DETERMINE HOW MUCH LOAN IS ALLOWED FOR THIS CERTAIN EMPLOYEE
                //ACCORDING TO HIS/HER BASIC PAY
                //MessageBox.Show(months_as_regular + " - " + BASIC_PAY.ToString());
                if ((months_as_regular >= 6) && (months_as_regular <= 12))
                {
                    MAXIMUM_ALLOWED_LOAN = 2 * BASIC_PAY;
                    MAXIMUM_ALLOWED_AMORT_PERIOD = 6;

                    iteratesalary(BASIC_PAY, cboprincipal, 2);

                }
                else if ((months_as_regular > 12) && (months_as_regular <= 24))
                {
                    MAXIMUM_ALLOWED_LOAN = 4 * BASIC_PAY;
                    MAXIMUM_ALLOWED_AMORT_PERIOD = 24;
                    iteratesalary(BASIC_PAY, cboprincipal, 4);
                }
                else if (months_as_regular > 24)
                {
                    MAXIMUM_ALLOWED_LOAN = 6 * BASIC_PAY;
                    MAXIMUM_ALLOWED_AMORT_PERIOD = 24;
                    iteratesalary(BASIC_PAY, cboprincipal, 6);

                }

                //display latest loan

                l.empid = applicant.empid;

                Loan applicant_latest_loan = l.GET_LATEST_LOAN("SALARY");
                PREV_LOAN = applicant_latest_loan;
                // GET THE LATEST MICRO LOAN OF A MEMBER
                lblatestloan.Items.Add("LATEST MICRO LOAN");
                LATEST_SALARY_LOAN = (applicant_latest_loan != null) ? applicant_latest_loan.principal : 0;

                if (LATEST_SALARY_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...");
                    lblatestloan.Items.Add("MAXIMUM ALLOWED LOAN :" + MAXIMUM_ALLOWED_LOAN.ToString("#,##0.00"));
                    lblatestloan.Items.Add("MAXIMUM AMORTIZATION PERIOD :" + MAXIMUM_ALLOWED_AMORT_PERIOD.ToString());
                }

                cboprincipal.Text = MAXIMUM_ALLOWED_LOAN.ToString("0.00");
               // lblloancategory.Text = "MAXIMUM_ALLOWED_AMOUNT : " + MAXIMUM_ALLOWED_LOAN.ToString("#,##0.00") + " MAXIMUM_AMORTIZATION_PERIOD : " + MAXIMUM_ALLOWED_AMORT_PERIOD.ToString();
                //nmamortperiod.Maximum = MAXIMUM_ALLOWED_AMORT_PERIOD;
                //nmamortperiod.Value = nmamortperiod.Maximum;

                if (applicant.pic != null)
                {
                    MemoryStream ms = new MemoryStream(applicant.pic);
                    pb.Image = Image.FromStream(ms);
                    pb.SizeMode = PictureBoxSizeMode.Zoom;
                }
                else
                {
                    pb.Image = Properties.Resources.noimagefound;
                    pb.SizeMode = PictureBoxSizeMode.Zoom;
                }
            }
        }
예제 #17
0
        private void cboComaker_SelectedIndexChanged(object sender, EventArgs e)
        {
            lbcomakersdata.Items.Clear();
            lbcomakerslatestloan.Items.Clear();

            if (cboComaker.Text != "")
            {
                String[] c = cboComaker.Text.ToString().Split('-');
                String id = c[1];
                Employee emp2 = new Employee();
                emp2.empid = id;

                comaker = emp2.SELECT_BY_ID();

                //GET LATEST BASIC SAL
                decimal BASIC_PAY = comaker.GET_BASIC_PAY();

                //emp1.SELECT_BY_ID();
                comaker.GET_IMAGE_BY_ID();

                String pos = (comaker.GET_CURRENT_POSITION() != "") ? comaker.position.ToString() : "NO_POSITION_INDICATED";
                lblcomaker.Text = comaker.lname.ToUpper() + ", " + comaker.fname.ToUpper() + " " + comaker.mname.ToUpper() + " - " + pos;

                //WHEN WAS THE EMPLOYEE BECAME REGULAR?
                DateTime regularization_date = comaker.GET_REGULAR_STATUS_DATE();
                int months_as_regular = Global.GetMonths(regularization_date, DateTime.Now);

                //DISPLAY REGULARIZATION DATE
                lbcomakersdata.Items.Add("EMPLOYEE INFORMATION");
                lbcomakersdata.Items.Add("BECAME REGULAR SINCE :" + regularization_date.ToShortDateString());
                lbcomakersdata.Items.Add("TOTAL MONTHS_IN_SEVICE AS REGULAR : " + months_as_regular.ToString());
                lbcomakersdata.Items.Add("BASIC SALARY : " + BASIC_PAY.ToString("#,##0.00"));

                //display latest loan

                l.empid = comaker.empid;

                Loan comakers_latest_loan = l.GET_LATEST_LOAN("SALARY");

                // GET THE LATEST MICRO LOAN OF A MEMBER
                lbcomakerslatestloan.Items.Add("LATEST MICRO LOAN");
                COMAKERS_LATEST_SALARY_LOAN = (comakers_latest_loan != null) ? comakers_latest_loan.principal : 0;

                if (COMAKERS_LATEST_SALARY_LOAN != 0)
                {
                    lbcomakerslatestloan.Items.Add("APPLICATION NO : " + comakers_latest_loan.application_no);
                    lbcomakerslatestloan.Items.Add("PRINCIPAL : PhP " + comakers_latest_loan.principal.ToString("#,##0.00"));
                    lbcomakerslatestloan.Items.Add("INTEREST : PhP " + comakers_latest_loan.interest.ToString("#,##0.00"));
                    lbcomakerslatestloan.Items.Add("MONTHLY AMORTIZATION: PhP " + (comakers_latest_loan.amortization_on_interest + comakers_latest_loan.amortization_on_principal).ToString("#,##0.00"));
                    lbcomakerslatestloan.Items.Add("BALANCE: ---(under development)---");
                }
                else
                {

                    lbcomakerslatestloan.Items.Add("Nothing found...");

                }

                //CHECK IF THIS COMAKER HAS BEEN A COMAKER FOR MORE THAN ONE(1) MEMBER_EMPLOYEE
                 //==========================================================================
                //-------> INSERT CODE HERE

                lbcomakerslatestloan.Items.Add("CURRENTLY COMAKER TO : ...{under development}...");
                //===========================================================================

                // LOAD EMPLOYEE PICTURE
                if (comaker.pic != null)
                {
                    MemoryStream ms = new MemoryStream(comaker.pic);
                    pbcomaker.Image = Image.FromStream(ms);
                    pbcomaker.SizeMode = PictureBoxSizeMode.Zoom;
                }
                else
                {
                    pbcomaker.Image = Properties.Resources.noimagefound;
                    pbcomaker.SizeMode = PictureBoxSizeMode.Zoom;
                }
            }
        }
예제 #18
0
        public Employee SELECT_BY_IDPASS()
        {
            DataTable dt = new DataTable();
            MySqlCommand cmd = new MySqlCommand();
            db.SET_COMMAND_PARAMS(cmd, "EMP_SELECT_BY_IDPASS");
            cmd.Parameters.AddWithValue("_empid", empid);
            cmd.Parameters.AddWithValue("_pword", password);
            MySqlDataAdapter da = new MySqlDataAdapter(cmd);
            da.Fill(dt);

            if (dt != null)
            {
                if (dt.Rows.Count > 0)
                {
                    Employee e = new Employee();
                    foreach (DataRow r in dt.Rows)
                    {
                        e.empid = r["empid"].ToString();
                        e.fname = r["fname"].ToString();
                        e.lname = r["lname"].ToString();
                        e.mname = r["mname"].ToString();
                        e.address = r["address"].ToString();
                        e.birthdate = Convert.ToDateTime(r["birthday"].ToString());
                        e.contactno = r["contactno"].ToString();
                        e.gender = r["gender"].ToString();
                        e.COOP_MEMBERSHIP_ID = r["COOP_MEMBERSHIP_ID"].ToString();
                        e.tinno = r["tinno"].ToString();
                        e.password = r["pword"].ToString();

                    }
                    return e;
                }
                else { return null; }

            }
            else
            {
                return null;
            }
        }
예제 #19
0
        private void attendanceToolStripMenuItem_Click(object sender, EventArgs e)
        {
            if (lv.SelectedItems.Count > 0)
            {
                String id = lv.SelectedItems[0].Tag.ToString();

                DateTime dtime = Convert.ToDateTime(lv.SelectedItems[0].SubItems[3].Text);

                Employee emp, emp1 = new Employee();
                emp1.empid = id;

                emp = emp1.SELECT_BY_ID();

                emp.GET_CURRENT_POSITION();
                emp.GET_IMAGE_BY_ID();

                pnlops.Controls.Clear();

                frmAttendance_Fixer c = new frmAttendance_Fixer();
                c.emp = emp;
                c.thisdate = dtime;
                c.ShowDialog();

            }
        }
예제 #20
0
        private void attendance_ctrl_Load(object sender, EventArgs e)
        {
            Employee emp = new Employee();
            emp.LoadEmployee(cboEmp);

            Attendance a = new Attendance();
            a.LoadInListView(lv);

            chkDate.Checked = true;
            chkEmp.Checked = true;
        }
예제 #21
0
        private void updateBasicSalaryToolStripMenuItem_Click(object sender, EventArgs e)
        {
            String id = lv.SelectedItems[0].SubItems[1].Text;

            Employee emp, emp1 = new Employee();
            emp1.empid = id;
            emp = emp1.SELECT_BY_ID();
            emp.GET_BASIC_PAY();
            //emp.GET_BRANCH_ASSIGNMENT();
            //emp.GET_EMPLOYMENT_STATUS();
            emp.GET_IMAGE_BY_ID();
            emp.GET_CURRENT_POSITION();

            pnlops.Controls.Clear();
        }