public List <TimeConfigSettings> GetDynamic(string whereCondition) { try { List <TimeConfigSettings> _TimeConfigSettings = new List <TimeConfigSettings>(); osqlConnection.Open(); string osqlCommandText = "SELECT * FROM TRN_SM_TimeConfigSettings_t " + whereCondition; SqlCommand osqlCommand = new SqlCommand(osqlCommandText, osqlConnection); SqlDataReader osqlDataReader = osqlCommand.ExecuteReader(); while (osqlDataReader.Read()) { TimeConfigSettings timeConfigSettings = new TimeConfigSettings(); timeConfigSettings.Id = osqlDataReader.GetInt32(0); timeConfigSettings.IP = osqlDataReader.GetString(1); timeConfigSettings.LastUpdateTime = osqlDataReader.GetDateTime(2); _TimeConfigSettings.Add(timeConfigSettings); } return(_TimeConfigSettings); } catch (Exception ex) { throw ex; } finally { if (osqlConnection.State == ConnectionState.Open) { osqlConnection.Close(); } } }
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); }