public List <Attendance_Record> fetchAttendance(AttendanceDataConfig config) { try { objZkeeper = new ZkemClient(RaiseDeviceEvent); bool IsDeviceConnected = objZkeeper.Connect_Net(config.IPAddress, config.PortNumber); int todaysRecord = 0; if (IsDeviceConnected) { string deviceInfo = manipulator.FetchDeviceInfo(objZkeeper, config.MachineNumber); ///tbxMachineNumber.Text.Trim() ///lblDeviceInfo.Text = deviceInfo; ICollection <MachineInfo> lstMachineInfo = manipulator.GetLogData(objZkeeper, config.MachineNumber); ///tbxMachineNumber.Text.Trim() var attendanceRecord = new List <Attendance_Record>(); foreach (var item in lstMachineInfo) { if (DateTime.Compare(item.DateOnlyRecord, config.DateTo) == 0)///DateTime.Parse(item.DateTimeRecord).Date { attendanceRecord.Add(new Attendance_Record() { Information_Id = item.IndRegID, Attendance_Timing = DateTime.Parse(item.DateTimeRecord) }); todaysRecord++; } } return(attendanceRecord); } return(new List <Attendance_Record>()); } catch (Exception ex) { return(new List <Attendance_Record>()); } }
private static void Sincronizar(int index) { var lstMachineInfo = manipulator.GetLogData(objZkeeper, 1); Console.WriteLine("Machine info nula? :" + (lstMachineInfo == null)); Console.WriteLine("Total de eventos a cargar :" + lstMachineInfo.Count()); if (InsertarEvento("El usuario TESTMARCA ha iniciado la sincronización de la terminal " + marcadores[index].UBICACION)) { try { var total = 0; var errores = 0; if (lstMachineInfo != null && lstMachineInfo.Any()) { foreach (var item in lstMachineInfo) { if (InsertRecord(0, item.IndRegID, DateTime.Parse(item.DateTimeRecord), item.InOutModel, index)) { total++; } else { errores++; } } InsertarEvento("El proceso de sincronización iniciado por TESTMARCA en la terminal '" + marcadores[index].UBICACION + "' ha finalizado. Registros insertados: " + total); //ShowStatusBar("El proceso de sincronización a finalizado exitosamente. Registros insertados: " + total, true); } else { Console.WriteLine("~> No se extrajeron resultados."); } } catch (Exception ex) { Console.WriteLine("~> " + ex.Message); } } }
static ICollection <MachineInfo> GetMachineLog(DeviceManipulator manipulator, ZkemClient objZkeeper) { var machineLogs = new List <MachineInfo>(); try { machineLogs = manipulator.GetLogData(objZkeeper, 1).ToList(); machineLogs = machineLogs.Where(i => i.DateOnlyRecord.Date >= DateTime.Now.Date && i.DateOnlyRecord.Date <= DateTime.Now.Date).ToList(); } catch (Exception ex) { WriteToErrorLog("Something wrong with GetMachineLog()", ex.ToString()); } return(machineLogs); }
//public ICollection<AttendanceInfo> GetPullData_Click(object sender, EventArgs e) //{ // ICollection<AttendanceInfo> lstMachineInfo = manipulator.GetLogData(objZkeeper, this.MachineNumber); // return lstMachineInfo; //} public ICollection <BiometricLogModel> GetBiometricData() { //IPAddress[] ipaddress = Dns.GetHostAddresses(this.HostName); ICollection <BiometricLogModel> logs = new HashSet <BiometricLogModel>(); //if (ipaddress.Length > 0) //{ // this.DeviceIP = ipaddress[0].ToString(); //} if (this.ConnectToZKTeco()) { logs = manipulator.GetLogData(objZkeeper, this.MachineNumber); objZkeeper.Disconnect(); } else { throw new ZkTecoClientException($"Failed to connect to Biometric Device at {this.DeviceIP}: {this.PortNumber}"); } return(logs); }
public ActionResult ObtenerAsistencia() { var listaRegistros = new List <MachineInfo>(); if (Connect()) { ICollection <MachineInfo> lstMachineInfo = manipulator.GetLogData(objZkeeper, 1); foreach (var item in lstMachineInfo) { MachineInfo ent = new MachineInfo(); ent.MachineNumber = item.MachineNumber; ent.IndRegID = item.IndRegID; ent.DateTimeRecord = item.DateTimeRecord; listaRegistros.Add(ent); } listaRegistros = listaRegistros.OrderByDescending(p => p.DateTimeRecord).ToList(); } return(Json(new { data = listaRegistros }, JsonRequestBehavior.AllowGet)); }
private void BtnPullData_Click(object sender, EventArgs e) { try { ShowStatusBar(string.Empty, true); ICollection <MachineInfo> lstMachineInfo = manipulator.GetLogData(objZkeeper, int.Parse(tbxMachineNumber.Text.Trim())); if (lstMachineInfo != null && lstMachineInfo.Count > 0) { BindToGridView(lstMachineInfo); ShowStatusBar(lstMachineInfo.Count + " records found !!", true); } else { DisplayListOutput("No records found"); } } catch (Exception ex) { DisplayListOutput(ex.Message); } }
private static void Sincronizar(int index) { var lstMachineInfo = manipulator.GetLogData(objZkeeper, 1); if (InsertarEvento("El usuario BERIVERA ha iniciado la sincronización de la terminal " + marcadores[index].UBICACION)) { try { var total = 0; var errores = 0; if (lstMachineInfo != null && lstMachineInfo.Any()) { foreach (var item in lstMachineInfo) { if (InsertRecord(0, item.IndRegID, DateTime.Parse(item.DateTimeRecord), item.InOutModel, index)) { total++; } else { errores++; } } InsertarEvento("El proceso de sincronización iniciado por BERIVERA en la terminal '" + marcadores[index].UBICACION + "' ha finalizado. Registros insertados: " + total); //ShowStatusBar("El proceso de sincronización a finalizado exitosamente. Registros insertados: " + total, true); } else { } } catch (Exception ex) { } } }
private void PullAllData() { listBox1.Items.Clear(); try { master.ShowStatusBar(string.Empty, true); lstMachineInfo = manipulator.GetLogData(master.objZkeeper, int.Parse(master.machineNumber.Trim())); lstFingerPrintTemplates = manipulator.GetAllUserInfo(master.objZkeeper, int.Parse(master.machineNumber.Trim())); if (lstMachineInfo != null && lstMachineInfo.Count > 0) { foreach (MachineInfo item in lstMachineInfo) { string g_kisi = item.IndRegID.ToString(); string g_cesit = item.dwInOutMode.ToString(); string g_yontem = item.dwVerifyMode.ToString(); if (radioButton2.Checked && g_yontem == "1") { continue; } if (radioButton3.Checked && g_yontem == "0") { continue; } if (!checkedListBox1.GetItemChecked(0) && g_cesit == "0") { continue; } if (!checkedListBox1.GetItemChecked(1) && g_cesit == "1") { continue; } if (!checkedListBox1.GetItemChecked(2) && g_cesit == "4") { continue; } if (!checkedListBox1.GetItemChecked(3) && g_cesit == "5") { continue; } if (checkBox1.Checked) { DateTime temp = Convert.ToDateTime(item.DateTimeRecord); if (!(monthCalendar1.SelectionStart.Date <= temp && temp <= monthCalendar1.SelectionEnd.Date.AddHours(23).AddMinutes(59))) { continue; } } if (lstFingerPrintTemplates != null && lstFingerPrintTemplates.Count > 0) { foreach (UserInfo kisi in lstFingerPrintTemplates) { if (g_kisi == kisi.EnrollNumber.ToString()) { g_kisi = kisi.Name; break; } } } switch (g_cesit) { case "0": g_cesit = "Giriş"; break; case "1": g_cesit = "Çıkış"; break; case "4": g_cesit = "Fm_Giriş"; break; case "5": g_cesit = "Fm_Çıkış"; break; default: break; } switch (g_yontem) { case "0": g_yontem = "Şifre"; break; case "1": g_yontem = "Parmak İzi"; break; default: break; } listBox1.Items.Add(g_kisi + " - " + g_cesit + " - " + g_yontem + " - " + item.DateTimeRecord); } master.ShowStatusBar(lstMachineInfo.Count + " kayıt bulundu! " + listBox1.Items.Count + " adet kayıt istenilen kriterlerde.", true); } else { master.ShowStatusBar("Hiç kayıt bulunamadı", false); } } catch (Exception ex) { master.ShowStatusBar(ex.Message, false); } }
public ICollection <MachineInfo> ReadMachineData(string machineId, string status, string ipAddress, int port, DateTime fromDate, DateTime toDate) { IList <MachineInfo> listAttandance = new List <MachineInfo>(); { try { List <TimeConfigSettings> timeConfigSettings = new List <TimeConfigSettings>(); TimeConfigSettings _timeConfigSettings = new TimeConfigSettings(); timeConfigSettings = GetDynamic(" where IP = " + "'" + ipAddress + "'"); _timeConfigSettings = timeConfigSettings[0]; DateTime fromDate2 = _timeConfigSettings.LastUpdateTime; if (status.Trim() == "Device Is Online") { objZkeeper = new ZkemClient(); bool IsDeviceConnected = objZkeeper.Connect_Net(ipAddress, port); if (IsDeviceConnected) { ICollection <MachineInfo> lstMachineInfo = manipulator.GetLogData(objZkeeper, int.Parse(machineId.Trim())); if (lstMachineInfo != null && lstMachineInfo.Count > 0) { DateTime fromDate1 = DateTime.Parse(fromDate.ToString("yyyy-MM-dd")); DateTime fromDate3 = DateTime.Parse(fromDate2.ToString("yyyy-MM-dd")); DateTime toDate1 = Convert.ToDateTime(toDate.ToString("yyyy-MM-dd")); var myQuery = from p in lstMachineInfo where p.PunchDate > fromDate2 //&& p.PunchDate <= toDate1 orderby p.EmployeeID select p; if (myQuery.ToList <MachineInfo>().Count > 0) { listAttandance = myQuery.ToList <MachineInfo>(); } else { listAttandance = null; } } else { listAttandance = null; } } else { listAttandance = null; } } } catch (Exception ex) { // MessageBox.Show(ex.Message); } } return(listAttandance); }