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());
}
}
