示例#1
0
        private void EmployeeListGet()
        {
            try
            {
                Employee_Controller empGet = new Employee_Controller();

                dgvEmployeeList.DataSource = empGet.EmployeeSelectAll();
                this.dgvEmployeeList.Columns[0].Visible = false;

                // this.dgvEmployeeList.Columns[1].Visible = false;


                //foreach (DataRow row in empGet.EmployeeSelectAll().Rows)
                //{
                //txtIDS.Text = row["IDS"].ToString();
                //txtLastName.Text = row["lname"].ToString();
                //txtFirstName.Text = row["fname"].ToString();
                //txtMiddleName.Text = row["mname"].ToString();
                //txtAddress.Text = row["AddressHome"].ToString();
                //txtContactNumber.Text = row["ContactNo"].ToString();
                //dtpDateOfBirth.Value = Convert.ToDateTime(row["DateOfBirth"].ToString());
                //dtpDateOfEmployment.Value = Convert.ToDateTime(row["DateOfEmployment"].ToString());
                //cboGender.SelectedIndex = Convert.ToInt32(row["CivilStatus"].ToString());
                //cboCivilStatus.SelectedIndex = Convert.ToInt32(row["CivilStatus"].ToString());
                //cboPosition.SelectedIndex = Convert.ToInt32(row["Position"].ToString());
                //cboUnit.SelectedIndex = Convert.ToInt32(row["Unit"].ToString());
                //txtSalary.Text = row["Salary"].ToString();
                //chkStatus.Checked = Convert.ToBoolean(row["Stat"].ToString());
                //}
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message.ToString());
            }
        }
示例#2
0
        // private void ChangeThemeName(Control control, string themeName)

        #endregion

        #region Employee

        private void EmployeeListGet()
        {
            try
            {
                DataGridViewRow row = this.dgvEmployeeList.RowTemplate;
                row.DefaultCellStyle.BackColor = Color.Aqua;
                row.Height        = 100;
                row.MinimumHeight = 20;

                Employee_Controller empGet = new Employee_Controller();


                dgvEmployeeList.DataSource = empGet.EmployeeSelectAll();
                //   this.dgvEmployeeList1.Columns[0].Visible = false;
                dgvEmployeeList.Columns[12].DefaultCellStyle.Format = "###,##0.00##";
                dgvEmployeeList.Columns[14].DefaultCellStyle.Format = "###,##0.00##";
                dgvEmployeeList.Columns[15].DefaultCellStyle.Format = "###,##0.00##";
                dgvEmployeeList.Columns[16].DefaultCellStyle.Format = "###,##0.00##";
                dgvEmployeeList.Columns[17].DefaultCellStyle.Format = "###,##0.00##";
                dgvEmployeeList.Columns[18].DefaultCellStyle.Format = "###,##0.00##";
                dgvEmployeeList.Columns[19].DefaultCellStyle.Format = "###,##0.00##";
                dgvEmployeeList.Columns[20].DefaultCellStyle.Format = "###,##0.00##";
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message.ToString());
            }
        }
示例#3
0
        private void builEmployeeCbo()
        {
            Employee_Controller AttendanceGet = new Employee_Controller();
            DataTable           dt            = AttendanceGet.EmployeeSelectAllCbo();

            cboEmployeesName.DataSource    = dt;
            cboEmployeesName.DisplayMember = "FullName";
            cboEmployeesName.ValueMember   = "IDS";
        }
示例#4
0
        private void EmployeeUpdates()
        {
            byte[] pic;
            try
            {
                if (picImage.Image != null)
                {
                    MemoryStream stream = new MemoryStream();
                    picImage.Image.Save(stream, System.Drawing.Imaging.ImageFormat.Bmp);
                    pic = stream.ToArray();
                }
                else
                {
                    pic = null;
                }

                Employee_Controller empNew = new Employee_Controller();
                empNew.EmployeeUpdate(Convert.ToDouble(txtIDS.Text),
                                      Convert.ToString(txtLastName.Text),
                                      Convert.ToString(txtFirstName.Text),
                                      Convert.ToString(txtMiddleName.Text),
                                      Convert.ToString(txtAddress.Text),
                                      Convert.ToString(txtContactNumber.Text),
                                      Convert.ToDateTime(dtpDateOfBirth.Value),
                                      Convert.ToDateTime(dtpDateOfEmployment.Value),
                                      Convert.ToInt32(cboGender.SelectedIndex),
                                      Convert.ToInt32(cboCivilStatus.SelectedIndex),
                                      Convert.ToString(cboPosition.Text),
                                      Convert.ToInt32(cboDepartment.SelectedValue),
                                      Convert.ToInt32(cboUnit.SelectedIndex),
                                      Convert.ToDecimal(txtSalary.Text),
                                      pic,
                                      Convert.ToInt32(chkStatus.CheckState),
                                      Convert.ToDecimal(txtSSSPrem.Text),
                                      Convert.ToDecimal(txtPHICPrem.Text),
                                      Convert.ToDecimal(txtPagIbigPrem.Text),
                                      Convert.ToDecimal(txtSSSLoan.Text),
                                      Convert.ToDecimal(txtPagIbigLoan.Text),
                                      Convert.ToDecimal(txtSavings.Text),
                                      Convert.ToDecimal(txtOTRate.Text)
                                      // Convert.ToString(cboShiftName.Text )
                                      );

                MessageBox.Show("Update Successfull");
                // EmployeeGet(IDS);
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message.ToString());
            }
        }
示例#5
0
        public void EmployeeGet(double ids)
        {
            try
            {
                Employee_Controller empGet = new Employee_Controller();

                foreach (DataRow row in empGet.EmployeeSelect(ids).Rows)
                {
                    txtIDS.Text                  = row["IDS"].ToString();
                    txtLastName.Text             = row["lname"].ToString();
                    txtFirstName.Text            = row["fname"].ToString();
                    txtMiddleName.Text           = row["mname"].ToString();
                    txtAddress.Text              = row["AddressHome"].ToString();
                    txtContactNumber.Text        = row["ContactNo"].ToString();
                    dtpDateOfBirth.Value         = Convert.ToDateTime(row["DateOfBirth"].ToString());
                    dtpDateOfEmployment.Value    = Convert.ToDateTime(row["DateOfEmployment"].ToString());
                    cboGender.SelectedIndex      = Convert.ToInt32(row["CivilStatus"].ToString());
                    cboCivilStatus.SelectedIndex = Convert.ToInt32(row["CivilStatus"].ToString());
                    cboPosition.Text             = row["Position"].ToString();
                    //  cboShiftName.Text = row["ShiftName"].ToString();

                    byte[] MyData = new byte[0];
                    if (row["PersonImage"] != null)
                    {
                        ////if (IsValidImage((byte[])row["PersonImage"]) == true)
                        ////{
                        MyData = (byte[])row["PersonImage"];
                        MemoryStream stream = new MemoryStream(MyData);
                        picImage.Image = Image.FromStream(stream);
                        // }
                    }

                    cboDepartment.SelectedValue = Convert.ToInt32(row["Department"].ToString());
                    cboUnit.SelectedIndex       = Convert.ToInt32(row["Unit"].ToString());
                    chkStatus.Checked           = Convert.ToBoolean(row["Stat"]);

                    txtSalary.Text      = row["Salary"].ToString();
                    txtSSSPrem.Text     = row["SSSPrem"].ToString();
                    txtPHICPrem.Text    = row["PHICPrem"].ToString();
                    txtPagIbigPrem.Text = row["PagIbigPrem"].ToString();
                    txtSSSLoan.Text     = row["SSSLoan"].ToString();
                    txtPagIbigLoan.Text = row["PagIbigLoan"].ToString();
                    txtSavings.Text     = row["Savings"].ToString();
                    txtOTRate.Text      = row["OTRate"].ToString();
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message.ToString());
            }
        }
示例#6
0
        public void EmployeeGetPic(double ids)
        {
            try
            {
                Employee_Controller empGet = new Employee_Controller();

                foreach (DataRow row in empGet.EmployeeSelect(ids).Rows)
                {
                    byte[] MyData = new byte[0];
                    if (row["PersonImage"] != null)
                    {
                        ////if (IsValidImage((byte[])row["PersonImage"]) == true)
                        ////{
                        MyData = (byte[])row["PersonImage"];
                        MemoryStream stream = new MemoryStream(MyData);
                        picImage.Image = Image.FromStream(stream);
                        // }
                    }
                }
            }
            catch { }
        }
示例#7
0
        private void DownloadTemplate()
        {
            if (bIsConnected == false)
            {
                MessageBox.Show("Please connect the device first!", "Error");
                return;
            }

            if (iCanSaveTmp == 0)//You haven't enrolled the templates.
            {
                MessageBox.Show("Please enroll the fingerprint templates first!", "Error");
                return;
            }

            //String connString = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=..\..\data\Templates.mdb";
            //Variables var = new Variables();
            //conn = new SqlConnection(var.ConStringOleDB());
            //OleDbConnection conn = new OleDbConnection(ConStringOleDB);

            int    idwFingerIndex  = 0; // Convert.ToInt32(cbFingerIndex.Text.Trim());
            int    iTmpLength      = 0;
            string sdwEnrollNumber = dgvEmployeeList.SelectedRows[0].Cells["IDS"].Value.ToString();
            int    iFlag           = 0;

            byte[] byTmpData  = new byte[2000];//modify by darcy on Dec.9 2009
            string sName      = "";
            string sPassword  = "";
            int    iPrivilege = 0;
            bool   bEnabled   = false;



            axCZKEM1.EnableDevice(iMachineNumber, false);
            Cursor = Cursors.WaitCursor;
            axCZKEM1.ReadAllTemplate(iMachineNumber);


            while (axCZKEM1.SSR_GetUserInfo(iMachineNumber, sdwEnrollNumber, out sName, out sPassword, out iPrivilege, out bEnabled))
            {
                if (axCZKEM1.GetUserTmpEx(iMachineNumber, sdwEnrollNumber, idwFingerIndex, out iFlag, out byTmpData[0], out iTmpLength))
                {
                    //If you need to select or delete the data in the database ,you can just define the sql sentences by youself
                    //string sql = "insert into Template(UserID,FingerID,Template,TmpLen,Flag) values('" + sdwEnrollNumber + "','" + idwFingerIndex + "','" + byTmpData + "','" + iTmpLength + "','" + iFlag + "')";//modify by darcy on Dec.9 2009
                    //OleDbCommand cmd = new OleDbCommand(sql, conn);
                    //conn.Open();
                    //cmd.ExecuteNonQuery();

                    Employee_Controller emp = new Employee_Controller();
                    //  emp.EmployeeTemplateInsert(0, Convert.ToInt32(sdwEnrollNumber), Convert.ToInt32(idwFingerIndex), byTmpData[0], iTmpLength, iFlag);
                    double ids = emp.EmployeeTemplateInsert(0, 1, 1, 0, 1, 1);

                    MessageBox.Show("Successfully save templates to database ! ", "Success");
                }
                else
                {
                    MessageBox.Show("Saving templates to database failed !", "Error");
                }
            }
            axCZKEM1.RefreshData(iMachineNumber);//the data in the device should be refreshed
            axCZKEM1.EnableDevice(iMachineNumber, true);
            Cursor = Cursors.Default;
        }