private void AttendanceUpdates() { try { AttendanceLog_Controller AttUpdate = new AttendanceLog_Controller(); AttUpdate.AttendanceShiftUpdate(Convert.ToDouble(txtIDS.Text), Convert.ToDateTime(dtpDate.Value), Convert.ToDateTime(dtpDate.Value.Date + dtpPunchIn.Value.TimeOfDay), Convert.ToDateTime(dtpDate.Value.Date + dtpBreakOut.Value.TimeOfDay), Convert.ToDateTime(dtpDate.Value.Date + dtpBreakIn.Value.TimeOfDay), Convert.ToDateTime(dtpDate.Value.Date + dtpPunchOut.Value.TimeOfDay), Convert.ToDateTime(dtpDate.Value.Date + dtpOvertimeIn.Value.TimeOfDay), Convert.ToDateTime(dtpDate.Value.Date + dtpOvertimeOut.Value.TimeOfDay), Convert.ToInt32(chkPI.CheckState), Convert.ToInt32(chkBO.CheckState), Convert.ToInt32(chkBI.CheckState), Convert.ToInt32(chkPO.CheckState), Convert.ToInt32(chkOI.CheckState), Convert.ToInt32(chkOO.CheckState)); MessageBox.Show("Update Successfull"); } catch (Exception ex) { MessageBox.Show(ex.Message.ToString()); } }
private void AttendanceInserts() { try { AttendanceLog_Controller AttNew = new AttendanceLog_Controller(); Double IDS = AttNew.AttendanceInsert(Convert.ToDouble(txtEmployeeIDS.Text), Convert.ToDateTime(dtpDate.Value), Convert.ToDateTime(dtpDate.Value.Date + dtpPunchIn.Value.TimeOfDay), Convert.ToDateTime(dtpDate.Value.Date + dtpBreakOut.Value.TimeOfDay), Convert.ToDateTime(dtpDate.Value.Date + dtpBreakIn.Value.TimeOfDay), Convert.ToDateTime(dtpDate.Value.Date + dtpPunchOut.Value.TimeOfDay), Convert.ToDateTime(dtpDate.Value.Date + dtpOvertimeIn.Value.TimeOfDay), Convert.ToDateTime(dtpDate.Value.Date + dtpOvertimeOut.Value.TimeOfDay), Convert.ToInt32(chkPI.CheckState), Convert.ToInt32(chkBO.CheckState), Convert.ToInt32(chkBI.CheckState), Convert.ToInt32(chkPO.CheckState), Convert.ToInt32(chkOI.CheckState), Convert.ToInt32(chkOO.CheckState)); MessageBox.Show("Save Successfull"); AttendanceGet(IDS); } catch (Exception ex) { MessageBox.Show(ex.Message.ToString()); } }
public DataTable EmployeeGetWorkedDays(double employeeIDS, DateTime DateFrom, DateTime DateTo) { try { AttendanceLog_Controller WorkedDays = new AttendanceLog_Controller(); return(WorkedDays.EmployeeGetWorkedDays(employeeIDS, DateFrom, DateTo)); } catch (Exception ex) { MessageBox.Show(ex.Message.ToString()); return(null); } }
public void MyAttendanceRuleChange(double EmployeeIDS, DateTime DateFrom, DateTime DateTo) { try { AttendanceLog_Controller AttendanceGet = new AttendanceLog_Controller(); dgvChangesInShift.DataSource = AttendanceGet.MyAttendanceRuleChange(EmployeeIDS, DateFrom, DateTo); //this.dgvAttendance.Columns[0].Visible = false; //this.dgvChangesInShift.Columns[1].Visible = false; //this.dgvAttendance.Columns[2].Visible = false; //this.dgvAttendance.Columns[3].Width = 300; //this.dgvAttendance.Columns[0].Width = 40; //this.dgvAttendance.Columns[4].Width = 180; } catch { } }
public void MyAttendanceRuleShow(double EmployeeIDS) { try { AttendanceLog_Controller AttendanceGetAll = new AttendanceLog_Controller(); dgvMyAttendanceRule.DataSource = AttendanceGetAll.MyAttendanceRuleSelect(EmployeeIDS); //this.dgvAttendance.Columns[0].Visible = false; //this.dgvAttendanceRule.Columns[1].Visible = false; //this.dgvAttendanceRule.Columns[2].Visible = false; //this.dgvAttendanceRule.Columns[3].Width = 300; //this.dgvAttendanceRule.Columns[0].Width = 40; //this.dgvAttendanceRule.Columns[4].Width = 180; } catch { } }
public void AttendanceLogShowAll() { try { AttendanceLog_Controller AttendanceGetAll = new AttendanceLog_Controller(); dgvAttendance.DataSource = AttendanceGetAll.AttendanceSelectAll(); //this.dgvAttendance.Columns[0].Visible = false; this.dgvAttendance.Columns[1].Visible = false; this.dgvAttendance.Columns[2].Visible = false; this.dgvAttendance.Columns[3].Width = 300; this.dgvAttendance.Columns[0].Width = 40; this.dgvAttendance.Columns[4].Width = 180; } catch { } }
private void axCZKEM1_OnAttTransactionEx(string sEnrollNumber, int iIsInValid, int iAttState, int iVerifyMethod, int iYear, int iMonth, int iDay, int iHour, int iMinute, int iSecond, int iWorkCode) { AttendanceLog_Controller Attendance = new AttendanceLog_Controller(); DateTime cDate = Convert.ToDateTime(iYear.ToString() + "-" + iMonth.ToString() + "-" + iDay.ToString() + " " + iHour.ToString() + ":" + iMinute.ToString() + ":" + iSecond.ToString()); Attendance.AttendanceInsertUpdate(0, Convert.ToDouble(sEnrollNumber), Convert.ToString(iMachineNumber), cDate, iAttState); AttendanceLogShow(Convert.ToDouble(sEnrollNumber), dtpFromAtt.Value, dtpToAtt.Value); EmployeeGetPic(Convert.ToDouble(sEnrollNumber)); MyAttendanceRuleShow(Convert.ToDouble(sEnrollNumber)); MyAttendanceRuleChange(Convert.ToDouble(sEnrollNumber), dtpFromAtt.Value, dtpToAtt.Value); foreach (DataRow row in Attendance.EmployeeGetWorkedDays(Convert.ToDouble(sEnrollNumber), dtpFromAtt.Value, dtpToAtt.Value).Rows) { lblCredit.Text = "Credit(Days): " + row["Credit"].ToString(); lblLate.Text = "Late|Early Out: " + row["LateEO"].ToString(); } }
public void AttendanceLogShow(double EmployeeIDS, DateTime DateFrom, DateTime DateTo) { try { AttendanceLog_Controller AttendanceGet = new AttendanceLog_Controller(); dgvAttendance.DataSource = AttendanceGet.AttendanceSelect(EmployeeIDS, DateFrom, DateTo); foreach (DataRow row in AttendanceGet.EmployeeGetWorkedDays(Convert.ToDouble(EmployeeIDS), DateFrom, DateTo).Rows) { lblCredit.Text = "Credit(Days): " + row["Credit"].ToString(); lblLate.Text = "Late|Early Out: " + row["LateEO"].ToString(); } //this.dgvAttendance.Columns[0].Visible = false; this.dgvAttendance.Columns[1].Visible = false; this.dgvAttendance.Columns[2].Visible = false; this.dgvAttendance.Columns[3].Width = 300; this.dgvAttendance.Columns[0].Width = 40; this.dgvAttendance.Columns[4].Width = 180; } catch { } }
private void AttendanceLogInsertUpdate() { if (bIsConnected == false) { MessageBox.Show("Please connect the device first", "Error"); return; } string sdwEnrollNumber = ""; //int idwTMachineNumber = 0; //int idwEMachineNumber = 0; int idwVerifyMode = 0; int idwInOutMode = 0; int idwYear = 0; int idwMonth = 0; int idwDay = 0; int idwHour = 0; int idwMinute = 0; int idwSecond = 0; int idwWorkcode = 0; int idwErrorCode = 0; //int iGLCount = 0; //int iIndex = 0; Cursor = Cursors.WaitCursor; //lvLogs.Items.Clear(); AttendanceLog_Controller Attendance = new AttendanceLog_Controller(); axCZKEM1.EnableDevice(axCZKEM1.MachineNumber, false); //disable the device // if (axCZKEM1.ReadSuperLogData(iMachineNumber))//read all the attendance records to the memory if (axCZKEM1.ReadGeneralLogData(axCZKEM1.MachineNumber)) //read all the attendance records to the memory { while (axCZKEM1.SSR_GetGeneralLogData(iMachineNumber, out sdwEnrollNumber, out idwVerifyMode, out idwInOutMode, out idwYear, out idwMonth, out idwDay, out idwHour, out idwMinute, out idwSecond, ref idwWorkcode))//get records from the memory { DateTime cDate = Convert.ToDateTime(idwYear.ToString() + "-" + idwMonth.ToString() + "-" + idwDay.ToString() + " " + idwHour.ToString() + ":" + idwMinute.ToString() + ":" + idwSecond.ToString()); // DateTime cDate1 = Convert.ToDateTime(String.Format("{0:MM/dd/yyyy}", cDate)); //DateTime cDateFrom = Convert.ToDateTime(String.Format("{0:MM/dd/yyyy}", dtpFromAtt.Value)); // DateTime cDateTo = Convert.ToDateTime(String.Format("{0:MM/dd/yyyy}", dtpToAtt.Value)); // if (cDate1 >= cDateFrom && cDate1 <= cDateTo) // { Attendance.AttendanceInsertUpdate(0, Convert.ToDouble(sdwEnrollNumber), Convert.ToString(iMachineNumber), cDate, idwInOutMode); // } } } else { Cursor = Cursors.Default; axCZKEM1.GetLastError(ref idwErrorCode); if (idwErrorCode != 0) { MessageBox.Show("Reading data from terminal failed,ErrorCode: " + idwErrorCode.ToString(), "Error"); } else { MessageBox.Show("No data from terminal returns!", "Error"); } } axCZKEM1.EnableDevice(iMachineNumber, true); //enable the device Cursor = Cursors.Default; }
public void AttendanceGet(double ids) { try { AttendanceLog_Controller Att = new AttendanceLog_Controller(); foreach (DataRow row in Att.AttendanceShiftEditSelect(ids).Rows) { txtIDS.Text = row["IDS"].ToString(); dtpDate.Value = Convert.ToDateTime(row["AttendanceDate"].ToString()); if (row["PunchIn"].ToString() != "") { dtpPunchIn.Format = DateTimePickerFormat.Custom; dtpPunchIn.CustomFormat = "hh:mm tt"; chkPI.Checked = true; dtpPunchIn.Value = Convert.ToDateTime(row["PunchIn"].ToString()); } if (row["BreakOut"].ToString() != "") { dtpBreakOut.Format = DateTimePickerFormat.Custom; dtpBreakOut.CustomFormat = "hh:mm tt"; chkBO.Checked = true; dtpBreakOut.Value = Convert.ToDateTime(row["BreakOut"].ToString()); } if (row["BreakIn"].ToString() != "") { dtpBreakIn.Format = DateTimePickerFormat.Custom; dtpBreakIn.CustomFormat = "hh:mm tt"; chkBI.Checked = true; dtpBreakIn.Value = Convert.ToDateTime(row["BreakIn"].ToString()); } if (row["PunchOut"].ToString() != "") { dtpPunchOut.Format = DateTimePickerFormat.Custom; dtpPunchOut.CustomFormat = "hh:mm tt"; chkPO.Checked = true; dtpPunchOut.Value = Convert.ToDateTime(row["PunchOut"].ToString()); } if (row["OTIn"].ToString() != "") { dtpOvertimeIn.Format = DateTimePickerFormat.Custom; dtpOvertimeIn.CustomFormat = "hh:mm tt"; chkOI.Checked = true; dtpOvertimeIn.Value = Convert.ToDateTime(row["OTIn"].ToString()); } if (row["OTOut"].ToString() != "") { dtpOvertimeOut.Format = DateTimePickerFormat.Custom; dtpOvertimeOut.CustomFormat = "hh:mm tt"; chkOO.Checked = true; dtpOvertimeOut.Value = Convert.ToDateTime(row["OTOut"].ToString()); } } } catch (Exception ex) { MessageBox.Show(ex.Message.ToString()); } }