public static Thermostats ConvertFromDT(DataTable dt) { Thermostats result = new Thermostats(); foreach (DataRow row in dt.Rows) { result.Add(Thermostat.GetThermostat(row)); } return(result); }
public Thermostats Sort(string column, bool desc) { var sortedList = desc ? this.OrderByDescending(x => x.GetPropertyValue(column)) : this.OrderBy(x => x.GetPropertyValue(column)); Thermostats result = new Thermostats(); foreach (var i in sortedList) { result.Add((Thermostat)i); } return(result); }
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]); } }
protected void Page_Load(object sender, EventArgs e) { System.Text.StringBuilder sb = new System.Text.StringBuilder(); ThermostatMonitorLib.Locations locations = ThermostatMonitorLib.Locations.LoadLocationsByUserId(AppUser.Current.UserData.Id); foreach (ThermostatMonitorLib.Location location in locations) { sb.Append("<tr><td><a href=\"location.aspx?id=" + location.Id.ToString() + "\">" + location.Name.ToString() + "</a></td><td> - API Key: <b>" + location.ApiKey + "</b></td></tr>"); ThermostatMonitorLib.Thermostats thermostats = ThermostatMonitorLib.Thermostats.LoadThermostatsByLocationId(location.Id); foreach (ThermostatMonitorLib.Thermostat thermostat in thermostats) { sb.Append("<tr><td></td><td> - <a href=\"thermostat.aspx?id=" + thermostat.Id.ToString() + "\">" + thermostat.DisplayName + "</a> [<a href=\"editthermostat.aspx?id=" + thermostat.Id.ToString() + "\">Edit</a>]</td></tr>"); } } ThermostatsLit.Text = sb.ToString(); }
private void LoadSettings(ThermostatMonitorLib.Location location) { //Build array list of thermostats ThermostatMonitorLib.Thermostats thermostats = ThermostatMonitorLib.Thermostats.LoadThermostatsByLocationId(location.Id); ArrayList al = new ArrayList(); foreach (ThermostatMonitorLib.Thermostat thermostat in thermostats) { System.Collections.Hashtable hash = new System.Collections.Hashtable(); hash.Add("name", thermostat.DisplayName); hash.Add("ipAddress", thermostat.IpAddress); hash.Add("brand", thermostat.Brand); al.Add(hash); } Hashtable result = new Hashtable(); result.Add("thermostats", al); result.Add("zipCode", location.ZipCode); Response.Write(ThermostatMonitorLib.JSON.JsonEncode(result)); Response.End(); }
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 LoadThermostats(string sql, System.Data.CommandType commandType, System.Data.SqlClient.SqlParameter[] parameters) { return(Thermostats.ConvertFromDT(Utils.ExecuteQuery(sql, commandType, parameters))); }
public static Thermostats LoadThermostatsByLocationId(int locationId) { return(Thermostats.LoadThermostats("thermostats_load_by_location_id", CommandType.StoredProcedure, new MySqlParameter[] { new MySqlParameter("@location_id", locationId) })); }