public static Temperature LoadCurrentTemperature(int thermostatId)
{
Temperatures temperatures = Temperatures.LoadTemperatures("SELECT TOP 1 * FROM Temperatures WHERE ThermostatId=@ThermostatId ORDER BY ID DESC", CommandType.Text, new SqlParameter[] { new SqlParameter("@ThermostatId", thermostatId) });
if (temperatures.Count == 0)
{
return(null);
}
else
{
return(temperatures[0]);
}
}
public static Temperatures LoadTemperaturesByThermostatId(System.Int32 thermostatId)
{
return(Temperatures.LoadTemperatures("LoadTemperaturesByThermostatId", CommandType.StoredProcedure, new SqlParameter[] { new SqlParameter("@ThermostatId", thermostatId) }));
}
public static Temperatures LoadAllTemperatures()
{
return(Temperatures.LoadTemperatures("LoadTemperaturesAll", CommandType.StoredProcedure, null));
}
public static Temperatures LoadRange(System.Int32 thermostatId, DateTime startDate, DateTime endDate)
{
return(Temperatures.LoadTemperatures("SELECT * FROM Temperatures WHERE ThermostatID=@ThermostatId AND LogDate BETWEEN @StartDate and @EndDate", CommandType.Text, new SqlParameter[] { new SqlParameter("@ThermostatId", thermostatId), new SqlParameter("@StartDate", startDate), new SqlParameter("@EndDate", endDate) }));
}
public static Temperatures LoadTemperaturesByThermostatId(int thermostatId)
{
return(Temperatures.LoadTemperatures("temperatures_load_by_thermostat_id", CommandType.StoredProcedure, new MySqlParameter[] { new MySqlParameter("@thermostat_id", thermostatId) }));
}
