internal decimal GetCurrentTemperature()
{
var selectCommand = new SqlCommandInfo("SELECT TOP 1 temperature FROM TemperatureLog ORDER BY origin_datetime DESC");
var temperature = SqlExecutionHelper.ExecuteScalar <decimal>(selectCommand);
return(temperature);
}
public DeviceStates GetDeviceState(Devices device)
{
var selectCommand = new SqlCommandInfo(
"SELECT current_state" +
" FROM DeviceStates" +
" WHERE device = @device");
selectCommand.Parameters.Add("device", device);
var rawDeviceState = SqlExecutionHelper.ExecuteScalar <bool>(selectCommand);
return(rawDeviceState ? DeviceStates.On : DeviceStates.Off);
}
internal DateTime GetBootDateTime()
{
var selectCommand = new SqlCommandInfo(
@"SELECT TOP 1 boot_time
FROM
(
SELECT
LAG(origin_datetime) OVER(ORDER BY origin_datetime DESC) AS boot_time,
uptime,
LAG(uptime) OVER(ORDER BY origin_datetime DESC) AS next_uptime
FROM DiagnosticInfoLog
) subq
WHERE uptime > next_uptime" );
return(SqlExecutionHelper.ExecuteScalar <DateTime>(selectCommand));
}
internal long GetUptime()
{
var selectCommand = new SqlCommandInfo("SELECT TOP 1 uptime FROM DiagnosticInfoLog ORDER BY origin_datetime DESC");
return(SqlExecutionHelper.ExecuteScalar <long>(selectCommand));
}