public void GetGeneratLog(ZkemClient objZkeeper, int machineNumber, string enrollNo)
{
string name = null;
string password = null;
int previlage = 0;
bool enabled = false;
byte[] byTmpData = new byte[2000];
int tempLength = 0;
int idwFingerIndex = 0;// [ <--- Enter your fingerprint index here ]
int iFlag = 0;
objZkeeper.ReadAllTemplate(machineNumber);
while (objZkeeper.SSR_GetUserInfo(machineNumber, enrollNo, out name, out password, out previlage, out enabled))
{
if (objZkeeper.GetUserTmpEx(machineNumber, enrollNo, idwFingerIndex, out iFlag, out byTmpData[0], out tempLength))
{
break;
}
}
}
private void addUser(ZkemClient objZkeeper, Device device)
{
// manipulator.PushUserDataToDevice(objZkeeper, int.Parse(device.DeviceId), "xxxsssxxx");
//ICollection<UserIDInfo> lstUserIDInfo = manipulator.GetAllUserID(objZkeeper, int.Parse(device.DeviceId));
ICollection <UserInfo> lstUserInfo = manipulator.GetAllUserInfo(objZkeeper, int.Parse(device.DeviceId));
//Console.WriteLine("-> user id count: " + lstUserIDInfo.Count);
Console.WriteLine("-> user count: " + lstUserInfo.Count);
UserInfo sinfo = new UserInfo();
sinfo.EnrollNumber = "40";
sinfo.Name = "Erfan";
sinfo.FingerIndex = 0;
sinfo.TmpData = "";
sinfo.Privelage = 0;
sinfo.Password = "******";
sinfo.Enabled = true;
sinfo.iFlag = "1";
sinfo.MachineNumber = 1;
List <UserInfo> lstUserInfo2 = new List <UserInfo>();
lstUserInfo2.Add(sinfo);
try
{
manipulator.UploadFTPTemplate(objZkeeper, 1, lstUserInfo2);
}
catch (Exception rrr) {
Console.WriteLine("----------------error------------");
Console.WriteLine(rrr);
}
lstUserInfo = manipulator.GetAllUserInfo(objZkeeper, int.Parse(device.DeviceId));
//Console.WriteLine("-> user id count: " + lstUserIDInfo.Count);
Console.WriteLine("-> user count: " + lstUserInfo.Count);
}
//public bool ClearGLog(ZkemClient objZkeeper, int machineNumber)
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);
try
{
var SL = GetSerialNumber(objZkeeper, 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;
objInfo.SerialNumber = SL;
lstEnrollData.Add(objInfo);
}
}
catch (Exception ex)
{
}
return(lstEnrollData);
}
///Getting All the User's Info
public ICollection <UserInfo> GetAllUserInfo(ZkemClient objZkeeper, int machineNumber)
{
string sdwEnrollNumber = string.Empty, sName = string.Empty, sPassword = string.Empty, sTmpData = string.Empty;
int iPrivilege = 0, iTmpLength = 0, iFlag = 0, idwFingerIndex;
bool bEnabled = false;
ICollection <UserInfo> lstFPTemplates = new List <UserInfo>();
objZkeeper.ReadAllUserID(machineNumber);
objZkeeper.ReadAllTemplate(machineNumber);
while (objZkeeper.SSR_GetAllUserInfo(machineNumber, out sdwEnrollNumber, out sName, out sPassword, out iPrivilege, out bEnabled))
{
for (idwFingerIndex = 0; idwFingerIndex <= 10; idwFingerIndex++)
{
if (objZkeeper.GetUserTmpExStr(machineNumber, sdwEnrollNumber, idwFingerIndex, out iFlag, out sTmpData, out iTmpLength))
{
UserInfo fpInfo = new UserInfo();
fpInfo.MachineNumber = machineNumber;
fpInfo.EnrollNumber = sdwEnrollNumber;
fpInfo.Name = sName;
fpInfo.FingerIndex = idwFingerIndex;
fpInfo.TmpData = sTmpData;
fpInfo.Privelage = iPrivilege;
fpInfo.Password = sPassword;
fpInfo.Enabled = bEnabled;
fpInfo.iFlag = iFlag.ToString();
lstFPTemplates.Add(fpInfo);
}
}
}
return(lstFPTemplates);
}
// Get All User's ID
public ICollection <UserIDInfo> GetAllUserID(ZkemClient objZkeeper, int machineNumber)
{
int dwEnrollNumber = 0;
int dwEMachineNumber = 0;
int dwBackUpNumber = 0;
int dwMachinePrivelage = 0;
int dwEnabled = 0;
ICollection <UserIDInfo> lstUserIDInfo = new List <UserIDInfo>();
objZkeeper.ReadAllUserID(machineNumber);
while (objZkeeper.GetAllUserID(machineNumber, ref dwEnrollNumber, ref dwEMachineNumber, ref dwBackUpNumber, ref dwMachinePrivelage, ref dwEnabled))
{
UserIDInfo userID = new UserIDInfo();
userID.BackUpNumber = dwBackUpNumber;
userID.Enabled = dwEnabled;
userID.EnrollNumber = dwEnrollNumber;
userID.MachineNumber = dwEMachineNumber;
userID.Privelage = dwMachinePrivelage;
lstUserIDInfo.Add(userID);
}
return(lstUserIDInfo);
}
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);
}
private void tsm_baglan_Click(object sender, EventArgs e)
{
try
{
this.Cursor = Cursors.WaitCursor;
ShowStatusBar("Bağlantı Kuruluyor.", true);
if (IsDeviceConnected)
{
IsDeviceConnected = false;
this.Cursor = Cursors.Default;
//enable device
if (checkBox1.Checked)
{
bool deviceEnabled = objZkeeper.EnableDevice(int.Parse(toolStripTextBox3.Text.Trim()), true);
}
return;
}
string ipAddress = toolStripTextBox1.Text.Trim();
string port = toolStripTextBox2.Text.Trim();
if (ipAddress == string.Empty || port == string.Empty)
{
throw new Exception("The Device IP Address and Port is mandotory !!");
}
int portNumber = 4370;
if (!int.TryParse(port, out portNumber))
{
throw new Exception("Not a valid port number");
}
bool isValidIpA = UniversalStatic.ValidateIP(ipAddress);
if (!isValidIpA)
{
throw new Exception("The Device IP is invalid !!");
}
isValidIpA = UniversalStatic.PingTheDevice(ipAddress);
if (!isValidIpA)
{
throw new Exception("The device at " + ipAddress + ":" + port + " did not respond!!");
}
objZkeeper = new ZkemClient(RaiseDeviceEvent);
IsDeviceConnected = objZkeeper.Connect_Net(ipAddress, portNumber);
if (IsDeviceConnected)
{
string deviceInfo = manipulator.FetchDeviceInfo(objZkeeper, int.Parse(toolStripTextBox3.Text.Trim()));
this.Text = "Ana Menü - " + deviceInfo;
}
machineNumber = toolStripTextBox3.Text;
//disable device
if (checkBox1.Checked)
{
bool deviceDisabled = objZkeeper.DisableDeviceWithTimeOut(int.Parse(toolStripTextBox3.Text.Trim()), 3000);
}
}
catch (Exception ex)
{
ShowStatusBar(ex.Message, false);
}
this.Cursor = Cursors.Default;
}
private void opendoorBtn_Click(object sender, EventArgs e)
{
ZkemClient client = new ZkemClient(null);
client.ACUnlock(int.Parse(tbxMachineNumber.Text), 0);
}
private void btnConnect_Click(object sender, EventArgs e)
{
try
{
this.Cursor = Cursors.WaitCursor;
ShowStatusBar(string.Empty, true);
if (IsDeviceConnected)
{
IsDeviceConnected = false;
this.Cursor = Cursors.Default;
return;
}
string ipAddress = tbxDeviceIP.Text.Trim();
string port = tbxPort.Text.Trim();
if (ipAddress == string.Empty || port == string.Empty)
{
throw new Exception("The Device IP Address and Port is mandatory !!");
}
int portNumber = 4370;
if (!int.TryParse(port, out portNumber))
{
throw new Exception("Not a valid port number");
}
bool isValidIpA = UniversalStatic.ValidateIP(ipAddress);
if (!isValidIpA)
{
throw new Exception("The Device IP is invalid !!");
}
isValidIpA = UniversalStatic.PingTheDevice(ipAddress);
if (!isValidIpA)
{
throw new Exception("The device at " + ipAddress + ":" + port + " did not respond!!");
}
objZkeeper = new ZkemClient(RaiseDeviceEvent);
IsDeviceConnected = objZkeeper.Connect_Net(ipAddress, portNumber);
getTodayRec();
//Send Without Click
timerAuto();
if (IsDeviceConnected)
{
string deviceInfo = manipulator.FetchDeviceInfo(objZkeeper, int.Parse(tbxMachineNumber.Text.Trim()));
lblDeviceInfo.Text = deviceInfo;
}
}
catch (Exception ex)
{
ShowStatusBar(ex.Message, false);
}
this.Cursor = Cursors.Default;
}
private void DisableDevice(ZkemClient objZkeeper, Device device)
{
// This is of no use since i implemented zkemKeeper the other way
bool deviceDisabled = objZkeeper.DisableDeviceWithTimeOut(int.Parse(device.DeviceId), 3000);
}
private Boolean GetLogsToMySql(Combination combination)
{
Device device = combination.device;
ZkemClient objZkeeper = combination.objZkeeper;
Boolean status = false;
if (device.status)
{
try
{
ShowStatusBar(string.Empty, true);
ICollection <MachineInfo> lstMachineInfo = manipulator.GetLogData(objZkeeper, int.Parse(device.DeviceId));
if (lstMachineInfo != null && lstMachineInfo.Count > 0)
{
Boolean clearedLog = false;
ShowStatusBar(device.IP + " -> " + lstMachineInfo.Count + " records found !!", true);
Console.WriteLine("---");
Console.WriteLine(lstMachineInfo.Count);
IEnumerator enumerator = lstMachineInfo.GetEnumerator();
string theCommand = "INSERT INTO log (MachineNumber, IndRegID, DateTimeRecord ) VALUES ";
int count = 0;
while (enumerator.MoveNext())
{
MachineInfo item = (MachineInfo)enumerator.Current;
theCommand += "('" + item.MachineNumber + "', '" + item.IndRegID + "', '" + item.DateTimeRecord + "')";
count++;
if (count < lstMachineInfo.Count)
{
theCommand += ", ";
}
}
Console.WriteLine(theCommand);
MySqlCommand command = conn.CreateCommand();
command.CommandText = theCommand;
Boolean mysqlInsertSuccess = false;
try
{
int o = command.ExecuteNonQuery();
mysqlInsertSuccess = true;
}
catch (Exception ex)
{
Console.WriteLine(ex);
mysqlInsertSuccess = false;
}
if (mysqlInsertSuccess)
{
clearedLog = manipulator.ClearGLog(objZkeeper, int.Parse(device.DeviceId));
}
status = true;
}
else
{
DisplayListOutput("No records found");
status = false;
}
}
catch (Exception ex)
{
DisplayListOutput(ex.Message);
}
}
return(status);
}
private void Beep(ZkemClient objZkeeper)
{
objZkeeper.Beep(100);
}
private Boolean GetUsersToMySql(Combination combination)
{
Device device = combination.device;
ZkemClient objZkeeper = combination.objZkeeper;
Boolean status = false;
if (device.status)
{
Console.WriteLine("Getting users for Device at: " + device.IP);
ICollection <UserInfo> lstUserInfo = manipulator.GetAllUserInfo(objZkeeper, int.Parse(device.DeviceId));
if (lstUserInfo != null && lstUserInfo.Count > 0)
{
Boolean clearedLog = false;
Console.WriteLine(lstUserInfo.Count);
IEnumerator enumerator = lstUserInfo.GetEnumerator();
string theCommand = "INSERT INTO user_info (tmp_data, privilege, password, name, machine_number, i_flag, finger_index, enroll_number, enabled , officeCode) VALUES ";
int count = 0;
int countShouldTheCommandBeExecuted = 0;
while (enumerator.MoveNext())
{
UserInfo item = (UserInfo)enumerator.Current;
string checkStatement = "SELECT * FROM user_info WHERE machine_number=" + item.MachineNumber + " AND enroll_number='" + item.EnrollNumber + "' AND tmp_data='" + item.TmpData + "'";
// Console.WriteLine(checkStatement);
var cmd = new MySql.Data.MySqlClient.MySqlCommand(checkStatement, conn);
var reader = cmd.ExecuteReader();
int c = 0;
while (reader.Read())
{
c++;
}
reader.Close();
if (c > 0)
{
Console.WriteLine("----------------->");
}
else
{
countShouldTheCommandBeExecuted++;
int shit = 0;
if (item.Enabled)
{
shit = 1;
}
theCommand += "('" + item.TmpData + "', '" + item.Privelage + "', '" + item.Password + "', '" + item.Name + "', '" + item.MachineNumber + "', '" + item.iFlag + "', '" + item.FingerIndex + "', '" + item.EnrollNumber + "', '" + shit + "', '" + config + "' )";
count++;
if (count < lstUserInfo.Count)
{
theCommand += ", ";
}
}
}
if (countShouldTheCommandBeExecuted > 0)
{
theCommand = theCommand.TrimEnd(' ');
theCommand = theCommand.TrimEnd(',');
// Console.WriteLine(theCommand);
MySqlCommand command = conn.CreateCommand();
command.CommandText = theCommand;
Boolean mysqlInsertSuccess = false;
try
{
int o = command.ExecuteNonQuery();
mysqlInsertSuccess = true;
}
catch (Exception ex)
{
Console.WriteLine(ex);
mysqlInsertSuccess = false;
}
if (mysqlInsertSuccess)
{
clearedLog = manipulator.ClearGLog(objZkeeper, int.Parse(device.DeviceId));
}
}
status = true;
}
else
{
Console.WriteLine("changes 0");
// status = false;
}
pushToMachine(combination);
}
return(status);
}
private Boolean GetLogsToMySql(Combination combination)
{
Device device = combination.device;
ZkemClient objZkeeper = combination.objZkeeper;
Boolean status = false;
if (device.status)
{
Console.WriteLine("Getting logs for Device at: " + device.IP);
try
{
ICollection <MachineInfo> lstMachineInfo = manipulator.GetLogData(objZkeeper, int.Parse(device.DeviceId));
if (lstMachineInfo != null && lstMachineInfo.Count > 0)
{
Boolean clearedLog = false;
Console.WriteLine(lstMachineInfo.Count);
IEnumerator enumerator = lstMachineInfo.GetEnumerator();
string theCommand = "INSERT INTO logs (machine_number, ind_reg_id, date_time_record ) VALUES ";
int count = 0;
while (enumerator.MoveNext())
{
MachineInfo item = (MachineInfo)enumerator.Current;
theCommand += "('" + item.MachineNumber + "', '" + item.IndRegID + "', '" + item.DateTimeRecord + "')";
count++;
if (count < lstMachineInfo.Count)
{
theCommand += ", ";
}
}
// Console.WriteLine(theCommand);
MySqlCommand command = conn.CreateCommand();
command.CommandText = theCommand;
Boolean mysqlInsertSuccess = false;
try
{
int o = command.ExecuteNonQuery();
mysqlInsertSuccess = true;
}
catch (Exception ex)
{
Console.WriteLine(ex);
mysqlInsertSuccess = false;
}
if (mysqlInsertSuccess)
{
clearedLog = manipulator.ClearGLog(objZkeeper, int.Parse(device.DeviceId));
}
status = true;
}
else
{
Console.WriteLine("changes 0");
status = false;
}
}
catch (Exception ex)
{
Console.WriteLine(ex);
}
}
return(status);
}
private void btnConnect_Click(object sender, EventArgs e)
{
try
{
this.Cursor = Cursors.WaitCursor;
ShowStatusBar(string.Empty, true);
if (IsDeviceConnected)
{
IsDeviceConnected = false;
this.Cursor = Cursors.Default;
return;
}
string ipAddress = tbxDeviceIP.Text.Trim();
string port = tbxPort.Text.Trim();
if (ipAddress == string.Empty || port == string.Empty)
{
throw new Exception("The Device IP Address and Port is mandotory !!");
}
int portNumber = 4370;
if (!int.TryParse(port, out portNumber))
{
throw new Exception("Not a valid port number");
}
bool isValidIpA = UniversalStatic.ValidateIP(ipAddress);
if (!isValidIpA)
{
throw new Exception("The Device IP is invalid !!");
}
isValidIpA = UniversalStatic.PingTheDevice(ipAddress);
if (!isValidIpA)
{
throw new Exception("The device at " + ipAddress + ":" + port + " did not respond!!");
}
objZkeeper = new ZkemClient(RaiseDeviceEvent);
IsDeviceConnected = objZkeeper.Connect_Net(ipAddress, portNumber);
if (IsDeviceConnected)
{
string deviceInfo = manipulator.FetchDeviceInfo(objZkeeper, int.Parse(tbxMachineNumber.Text.Trim()));
lblDeviceInfo.Text = deviceInfo;
/* objZkeeper.OnAttTransaction(string EnrollNumber, int IsInValid, int AttState, int VerifyMethod, int Year, int Month, int Day, int Hour, int Minute, int Second, int WorkCode)
* {
* string time = Year + "-" + Month + "-" + Day + " " + Hour + ":" + Minute + ":" + Second;
*
* gRealEventListBox.Items.Add("Verify OK.UserID=" + EnrollNumber + " isInvalid=" + IsInValid.ToString() + " state=" + AttState.ToString() + " verifystyle=" + VerifyMethod.ToString() + " time=" + time);
*
* throw new NotImplementedException();
* }*/
}
}
catch (Exception ex)
{
ShowStatusBar(ex.Message, false);
}
this.Cursor = Cursors.Default;
}
public bool ClearGLog(ZkemClient objZkeeper, int machineNumber)
{
return(objZkeeper.ClearGLog(machineNumber));
}
private void EnableDevice(ZkemClient objZkeeper, Device device)
{
// This is of no use since i implemented zkemKeeper the other way
bool deviceEnabled = objZkeeper.EnableDevice(int.Parse(device.DeviceId), true);
}
private void btnInsert_Click(object sender, EventArgs e)
{
try
{
using (FingerPrintDB db = new FingerPrintDB())
{
foreach (var machine in machines)
{
string ipAddress = machine.IP;
string port = machine.Port;
if (ipAddress == string.Empty || port == string.Empty)
{
throw new Exception("The Device IP Address and Port is mandotory !!");
}
int portNumber = 4370;
if (!int.TryParse(port, out portNumber))
{
throw new Exception("Not a valid port number");
}
bool isValidIpA = UniversalStatic.ValidateIP(ipAddress);
if (!isValidIpA)
{
throw new Exception("The Device IP is invalid !!");
}
isValidIpA = UniversalStatic.PingTheDevice(ipAddress);
if (!isValidIpA)
{
throw new Exception("The device at " + ipAddress + ":" + port + " did not respond!!");
}
objZkeeper = new ZkemClient(RaiseDeviceEvent);
objZkeeper.Connect_Net(ipAddress, portNumber);
ICollection <MachineInfo> lstMachineInfo = manipulator.GetLogData(objZkeeper, machine.Number);
foreach (var log in lstMachineInfo)
{
string timeOnly = Convert.ToDateTime(log.DateTimeRecord).ToShortTimeString();
if (db.Logs.Any(f => f.IndRegID == log.IndRegID && f.DateOnlyRecord == log.DateOnlyRecord && f.TimeOnlyRecord == timeOnly) != true)
{
db.Logs.Add(new Log
{
Status = machine.Type,
MachineNumber = machine.Number,
IndRegID = log.IndRegID,
DateTimeRecord = Convert.ToDateTime(log.DateTimeRecord),
DateOnlyRecord = log.DateOnlyRecord,
TimeOnlyRecord = Convert.ToDateTime(log.DateTimeRecord).ToShortTimeString()
});
db.SaveChanges();
}
}
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}