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