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