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