public ICollection <MachineInfo> GetLogData(ZkemClient objZkeeper, int machineNumber)
{
string dwEnrollNumber1 = "";
int dwVerifyMode = 0;
int dwInOutMode = 0;
int dwYear = 0;
int dwMonth = 0;
int dwDay = 0;
int dwHour = 0;
int dwMinute = 0;
int dwSecond = 0;
int dwWorkCode = 0;
ICollection <MachineInfo> lstEnrollData = new List <MachineInfo>();
objZkeeper.ReadAllGLogData(machineNumber);
while (objZkeeper.SSR_GetGeneralLogData(machineNumber, out dwEnrollNumber1, out dwVerifyMode, out dwInOutMode, out dwYear, out dwMonth, out dwDay, out dwHour, out dwMinute, out dwSecond, ref dwWorkCode))
{
string inputDate = new DateTime(dwYear, dwMonth, dwDay, dwHour, dwMinute, dwSecond).ToString();
MachineInfo objInfo = new MachineInfo();
objInfo.MachineNumber = machineNumber;
objInfo.IndRegID = int.Parse(dwEnrollNumber1);
objInfo.DateTimeRecord = inputDate;
lstEnrollData.Add(objInfo);
}
return(lstEnrollData);
}
//Getting Today's Log Data
public ICollection <MachineInfo> GetTodayLogData(ZkemClient objZkeeper, int machineNumber)
{
string dwEnrollNumber1 = "";
int dwVerifyMode = 0;
int dwInOutMode = 0;
int dwYear = 0;
int dwMonth = 0;
int dwDay = 0;
int dwHour = 0;
int dwMinute = 0;
int dwSecond = 0;
int dwWorkCode = 0;
ICollection <MachineInfo> lstEnrollData = new List <MachineInfo>();
objZkeeper.ReadAllGLogData(machineNumber);
while (objZkeeper.SSR_GetGeneralLogData(machineNumber, out dwEnrollNumber1, out dwVerifyMode, out dwInOutMode, out dwYear, out dwMonth, out dwDay, out dwHour, out dwMinute, out dwSecond, ref dwWorkCode))
{
string inputDate = new DateTime(dwYear, dwMonth, dwDay, dwHour, dwMinute, dwSecond).ToString();
DateTime dt = DateTime.Now;
dt = DateTime.Parse(dt.ToString("yyyy-MM-dd"));
MachineInfo objInfo = new MachineInfo();
//objInfo.MachineNumber = machineNumber;
objInfo.EmployeeID = int.Parse(dwEnrollNumber1);
objInfo.DateTimeRecord = inputDate;
objInfo.InOut = dwInOutMode + "";
DateTime dt_compare = DateTime.Parse(DateTime.Parse(inputDate).ToString("yyyy-MM-dd"));
if (dt == dt_compare)
{
lstEnrollData.Add(objInfo);
}
}
return(lstEnrollData);
}
// Filtering Data from Synced Table
public ICollection <MachineInfo> GetFilteredData(ZkemClient objZkeeper, int machineNumber, DateTime dt)
{
string dwEnrollNumber1 = "";
int dwVerifyMode = 0;
int dwInOutMode = 0;
int dwYear = 0;
int dwMonth = 0;
int dwDay = 0;
int dwHour = 0;
int dwMinute = 0;
int dwSecond = 0;
int dwWorkCode = 0;
ICollection <MachineInfo> lstEnrollData = new List <MachineInfo>();
objZkeeper.ReadAllGLogData(machineNumber);
while (objZkeeper.SSR_GetGeneralLogData(machineNumber, out dwEnrollNumber1, out dwVerifyMode, out dwInOutMode, out dwYear, out dwMonth, out dwDay, out dwHour, out dwMinute, out dwSecond, ref dwWorkCode))
{
string inputDate = new DateTime(dwYear, dwMonth, dwDay, dwHour, dwMinute, dwSecond).ToString();
// String.Format("{0:MM/dd/yyyy}", dt);
DateTime date = new DateTime(dwYear, dwMonth, dwDay, dwHour, dwMinute, dwSecond);
DateTime dateCompare = new DateTime(dt.Year, dt.Month, dt.Day, dt.Hour, dt.Minute, dt.Second);
MachineInfo objInfo = new MachineInfo();
//objInfo.MachineNumber = machineNumber;
objInfo.EmployeeID = int.Parse(dwEnrollNumber1);
objInfo.DateTimeRecord = inputDate;
objInfo.InOut = dwInOutMode + "";
if ((dateCompare <= date))
{
lstEnrollData.Add(objInfo);
}
}
return(lstEnrollData);
}
public ICollection <MachineInfo> GetLogData(ZkemClient objZkeeper, int machineNumber)
{
string dwEnrollNumber1 = "";
int dwVerifyMode = 0;
int dwInOutMode = 0;
int dwYear = 0;
int dwMonth = 0;
int dwDay = 0;
int dwHour = 0;
int dwMinute = 0;
int dwSecond = 0;
int dwWorkCode = 0;
ICollection <MachineInfo> lstEnrollData = new List <MachineInfo>();
objZkeeper.ReadAllGLogData(machineNumber);
cnx.Open();
SqlCommand cmd2 = new SqlCommand("select * from atdrecord", cnx);
SqlDataReader dr = cmd2.ExecuteReader();
DataTable tb = new DataTable();
tb.Load(dr);
while (objZkeeper.SSR_GetGeneralLogData(machineNumber, out dwEnrollNumber1, out dwVerifyMode, out dwInOutMode, out dwYear, out dwMonth, out dwDay, out dwHour, out dwMinute, out dwSecond, ref dwWorkCode))
{
string inputDate = new DateTime(dwYear, dwMonth, dwDay, dwHour, dwMinute, dwSecond).ToString();
string recDate = dwYear + "-" + dwMonth + "-" + dwDay, recTime = dwHour + ":" + dwMinute + ":" + dwSecond;
string RecDate2 = dwYear + "-" + dwMonth + "-" + dwDay + ' ' + dwHour + ":" + dwMinute + ":" + dwSecond;
DateTime dateP = new DateTime(dwYear, dwMonth, dwDay, dwHour, dwMinute, dwSecond);
// DateTime d = new DateTime(0,0,0,dwHour, dwMinute, dwSecond);
MachineInfo objInfo = new MachineInfo();
objInfo.MachineNumber = machineNumber;
objInfo.IndRegID = int.Parse(dwEnrollNumber1);
objInfo.DateTimeRecord = inputDate;
// MessageBox.Show(d.ToShortTimeString());
if (cnx.State == ConnectionState.Open)
{
if (tb.Rows.Count == 0)
{
DateTime datetime = DateTime.ParseExact(RecDate2, "yyyy-MM-dd HH:mm:ss", System.Globalization.CultureInfo.InvariantCulture);
cmd = new SqlCommand("insert into AtdRecord values('" + datetime.ToShortDateString() + "','" + datetime.ToShortTimeString() + "','" + datetime + "','" + dwEnrollNumber1 + "')", cnx);
cmd.ExecuteNonQuery();
}
else
{
bool b = true;
for (int i = 0; i < tb.Rows.Count; i++)
{
if ((tb.Rows[i][2].ToString() == dwEnrollNumber1.ToString() && tb.Rows[i][5].ToString() == inputDate.ToString()))
{
b = false;
}
}
if (b)
{
//cmd = new SqlCommand("insert into AtdRecord values('" + dwVerifyMode + "','" + dwEnrollNumber1 + "','" + recDate + "','" + recTime + "','" + RecDate2 + "')", cnx);
cmd = new SqlCommand("insert into AtdRecord values('" + datetime.ToShortDateString() + "','" + datetime.ToShortTimeString() + "','" + datetime + "','" + dwEnrollNumber1 + "')", cnx);
cmd.ExecuteNonQuery();
cmd2 = new SqlCommand("select * from AtdRecord", cnx);
dr = cmd2.ExecuteReader();
tb = new DataTable();
tb.Load(dr);
}
}
}
else
{
}
lstEnrollData.Add(objInfo);
}
cnx.Close();
return(lstEnrollData);
}