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