public static Thermostat LoadThermostat(int locationId, string ipAddress) { Thermostats thermostats = Thermostats.LoadThermostats("SELECT * FROM Thermostats WHERE LocationId=@LocationId AND IpAddress=@IpAddress", CommandType.Text, new SqlParameter[] { new SqlParameter("@LocationId", locationId), new SqlParameter("@IpAddress", ipAddress) }); if (thermostats.Count == 0) { return(null); } else { return(thermostats[0]); } }
public static Thermostat LoadByKeyName(string keyName) { Thermostats thermostats = Thermostats.LoadThermostats("SELECT * FROM Thermostats WHERE KeyName=@KeyName", CommandType.Text, new SqlParameter[] { new SqlParameter("@KeyName", keyName) }); if (thermostats.Count == 0) { return(null); } else { return(thermostats[0]); } }
public static Thermostats LoadThermostatsByLocationId(System.Int32 locationId) { return(Thermostats.LoadThermostats("LoadThermostatsByLocationId", CommandType.StoredProcedure, new SqlParameter[] { new SqlParameter("@LocationId", locationId) })); }
public static Thermostats LoadAllThermostats() { return(Thermostats.LoadThermostats("LoadThermostatsAll", CommandType.StoredProcedure, null)); }
public static Thermostats LoadThermostatsByLocationId(int locationId) { return(Thermostats.LoadThermostats("thermostats_load_by_location_id", CommandType.StoredProcedure, new MySqlParameter[] { new MySqlParameter("@location_id", locationId) })); }