private void zkemClient_OnAttTransactionEx(string EnrollNumber, int IsInValid, int AttState, int VerifyMethod, int Year, int Month, int Day, int Hour, int Minute, int Second, int WorkCode)
{
var connectionString = ConfigurationManager.ConnectionStrings["DBInformix"].ConnectionString;
ip = ConfigurationManager.AppSettings["device_ip"];
using (StreamWriter writer = new StreamWriter(filePath, true))
{
writer.WriteLine(" OnAttTrasactionEx Has been Triggered,Verified OK on" + "Date :" + "Enrollnumber: " + EnrollNumber + "|" + DateTime.Now.ToString());
writer.WriteLine(Environment.NewLine + "-----------------------------------------------------------------------------" + Environment.NewLine);
}
PerInformixDB per = new PerInformixDB();
try
{
checkinout entidad = new checkinout();
entidad.anio = Year;
entidad.mes = Month;
entidad.dia = Day;
entidad.hora = Hour;
entidad.minuto = Minute;
entidad.segundo = Second;
entidad.numeroCredencial = int.Parse(EnrollNumber);
entidad.Device = ip;
per.AbrirConexion();
EventLog.WriteEntry("Connection Open");
var sql = "insert into checkinout (enrollnumber,date,hour,checkinout,device) values (?,?,?,?,?);";
using (var cmd = new IfxCommand(sql, per.Conexion))
{
cmd.Parameters.Add(new IfxParameter()).Value = entidad.numeroCredencial;
cmd.Parameters.Add(new IfxParameter()).Value = entidad.pFecha;
cmd.Parameters.Add(new IfxParameter()).Value = entidad.pHora;
cmd.Parameters.Add(new IfxParameter()).Value = entidad.Ckecked;
cmd.Parameters.Add(new IfxParameter()).Value = entidad.Device;
cmd.ExecuteNonQuery();
}
EventLog.WriteEntry("Insert EnrollNumber: " + EnrollNumber);
}
catch (Exception ex)
{
EventLog.WriteEntry("Error:" + ex.Message);
}
finally
{
per.CerrarConexion();
}
}
//private void zkemClient_OnAttTransactionEx(string EnrollNumber, int IsInValid, int AttState, int VerifyMethod, int Year, int Month, int Day, int Hour, int Minute, int Second, int WorkCode)
//{
// var connectionString = ConfigurationManager.ConnectionStrings["DBInformix"].ConnectionString;
// ip = ConfigurationManager.AppSettings["device_ip"];
// string Finger_Empleado = GetFingerEmpleado(int.Parse(id_dispositivo), int.Parse(EnrollNumber));
// int Id_Empleado = GetIdEmpleado(int.Parse(id_dispositivo), int.Parse(EnrollNumber));
// using (StreamWriter writer = new StreamWriter(filePath, true))
// {
// writer.WriteLine(" OnAttTrasactionEx Has been Triggered,Verified OK on" + "Date :" + "Enrollnumber: " + EnrollNumber +"|"+ DateTime.Now.ToString());
// writer.WriteLine(Environment.NewLine + "-----------------------------------------------------------------------------" + Environment.NewLine);
// writer.WriteLine("Huella: " + Id_Empleado + Finger_Empleado.ToString());
// }
// //---------------------------------------------
// PerInformixDB per = new PerInformixDB();
// try
// {
// EmpleadoHuella entidad = new EmpleadoHuella();
// entidad.id_empleado = Id_Empleado;
// entidad.enrollnumber = EnrollNumber;
// entidad.huella = Finger_Empleado;
// entidad.b64huella = null;
// EventLog.WriteEntry("Huella Registrado: " + entidad.id_empleado +"-"+ entidad.enrollnumber +"-"+ entidad.huella);
// per.AbrirConexion();
// EventLog.WriteEntry("Connection Open");
// var sql = "insert into empleado_huella (id_empleado,b64huella,huella,enrollnumber) values (?,?,?,?);";
// using (var cmd = new IfxCommand(sql, per.Conexion))
// {
// cmd.Parameters.Add(new IfxParameter()).Value = entidad.id_empleado;
// cmd.Parameters.Add(new IfxParameter()).Value = entidad.b64huella;
// cmd.Parameters.Add(new IfxParameter()).Value = entidad.huella;
// cmd.Parameters.Add(new IfxParameter()).Value = entidad.enrollnumber;
// cmd.ExecuteNonQuery();
// }
// EventLog.WriteEntry("Huella Registrado: " + entidad.id_empleado);
// }
// catch (Exception ex)
// {
// EventLog.WriteEntry("Error:"+ex.Message);
// }
// finally
// {
// per.CerrarConexion();
// }
//}
public void GetLogDataDevice(int device_number)
{
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;
string sName = string.Empty, sId_Empleado = string.Empty;
int sPrivilegio = 0;
bool sActivo;
List <checkinout> ListaEmpleadoEnrrolados = new List <checkinout>();
EventLog.WriteEntry("Obteniendo Datos del Dispositivo!!");
connSatus = Connect_Net(ip, int.Parse(port));
Mensaje_Conexion_Dispositivo(connSatus);
if (connSatus)
{
objCZKEM.ReadAllGLogData(device_number);
while (objCZKEM.SSR_GetGeneralLogData(device_number, 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();
//Obtener IDEMPLEADO
if (objCZKEM.ReadAllUserID(device_number))
{
bool result = objCZKEM.SSR_GetUserInfo(device_number, dwEnrollNumber1, out sName, out sId_Empleado, out sPrivilegio, out sActivo);
checkinout entCheck = new checkinout();
entCheck.anio = dwYear;
entCheck.mes = dwMonth;
entCheck.dia = dwDay;
entCheck.hora = dwHour;
entCheck.minuto = dwMinute;
entCheck.segundo = dwSecond;
entCheck.numeroCredencial = int.Parse(dwEnrollNumber1);
entCheck.Device = ip;
entCheck.id_dispositivo = device_number;
entCheck.id_empleado = int.Parse(sId_Empleado);
ListaEmpleadoEnrrolados.Add(entCheck);
}
}
if (ListaEmpleadoEnrrolados.Count() > 0)
{
Insertar_Enrrolamiento_BD(ListaEmpleadoEnrrolados);
//ELIMINA LOS REGISTRO DEL DISPOSITIVO DEL RELOJ
objCZKEM.ClearGLog(device_number);
using (StreamWriter writer = new StreamWriter(filePath, true))
{
writer.WriteLine(Environment.NewLine + "---Se eliminaron todas las asitencia del Dispositivo-----------------------------------" + Environment.NewLine);
}
}
else
{
using (StreamWriter writer = new StreamWriter(filePath, true))
{
writer.WriteLine(Environment.NewLine + "---No hay Datos de Asistencia en el Dispositivo-----------------------------------" + Environment.NewLine);
}
}
}
}
