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