public static ThermostatSettings ConvertFromDT(DataTable dt) { ThermostatSettings result = new ThermostatSettings(); foreach (DataRow row in dt.Rows) { result.Add(ThermostatSetting.GetThermostatSetting(row)); } return(result); }
public ThermostatSettings Sort(string column, bool desc) { var sortedList = desc ? this.OrderByDescending(x => x.GetPropertyValue(column)) : this.OrderBy(x => x.GetPropertyValue(column)); ThermostatSettings result = new ThermostatSettings(); foreach (var i in sortedList) { result.Add((ThermostatSetting)i); } return(result); }
public static ThermostatSettings LoadThermostatSettingsByThermostatId(System.Int32 thermostatId) { return(ThermostatSettings.LoadThermostatSettings("LoadThermostatSettingsByThermostatId", CommandType.StoredProcedure, new SqlParameter[] { new SqlParameter("@ThermostatId", thermostatId) })); }
public static ThermostatSettings LoadAllThermostatSettings() { return(ThermostatSettings.LoadThermostatSettings("LoadThermostatSettingsAll", CommandType.StoredProcedure, null)); }
public static ThermostatSettings LoadThermostatSettings(string sql, System.Data.CommandType commandType, System.Data.SqlClient.SqlParameter[] parameters) { return(ThermostatSettings.ConvertFromDT(Utils.ExecuteQuery(sql, commandType, parameters))); }