public static int SaveThermostatSetting(ThermostatSetting thermostatSetting) { int result = 0; SqlCommand cmd = new SqlCommand("SaveThermostatSetting", ThermostatMonitorLib.Global.Connection); cmd.CommandType = CommandType.StoredProcedure; if (thermostatSetting._isIdNull) { cmd.Parameters.AddWithValue("@Id", System.DBNull.Value); } else { cmd.Parameters.AddWithValue("@Id", thermostatSetting._id); } if (thermostatSetting._isThermostatIdNull) { cmd.Parameters.AddWithValue("@ThermostatId", System.DBNull.Value); } else { cmd.Parameters.AddWithValue("@ThermostatId", thermostatSetting._thermostatId); } if (thermostatSetting._isLogDateNull) { cmd.Parameters.AddWithValue("@LogDate", System.DBNull.Value); } else { cmd.Parameters.AddWithValue("@LogDate", thermostatSetting._logDate); } if (thermostatSetting._isDegreesNull) { cmd.Parameters.AddWithValue("@Degrees", System.DBNull.Value); } else { cmd.Parameters.AddWithValue("@Degrees", thermostatSetting._degrees); } if (thermostatSetting._isModeNull) { cmd.Parameters.AddWithValue("@Mode", System.DBNull.Value); } else { cmd.Parameters.AddWithValue("@Mode", thermostatSetting._mode); } cmd.Connection.Open(); try { result = Convert.ToInt32(cmd.ExecuteScalar()); } finally { cmd.Connection.Close(); } thermostatSetting.Id = result; return(result); }
internal static ThermostatSetting GetThermostatSetting(DataRow row) { ThermostatSetting result = new ThermostatSetting(); if (row.Table.Columns.Contains("Id")) { if (Convert.IsDBNull(row["Id"])) { result._isIdNull = true; } else { result._id = Convert.ToInt32(row["Id"]); result._isIdNull = false; } } if (row.Table.Columns.Contains("ThermostatId")) { if (Convert.IsDBNull(row["ThermostatId"])) { result._isThermostatIdNull = true; } else { result._thermostatId = Convert.ToInt32(row["ThermostatId"]); result._isThermostatIdNull = false; } } if (row.Table.Columns.Contains("LogDate")) { if (Convert.IsDBNull(row["LogDate"])) { result._isLogDateNull = true; } else { result._logDate = Convert.ToDateTime(row["LogDate"]); result._isLogDateNull = false; } } if (row.Table.Columns.Contains("Degrees")) { if (Convert.IsDBNull(row["Degrees"])) { result._isDegreesNull = true; } else { result._degrees = Convert.ToDouble(row["Degrees"]); result._isDegreesNull = false; } } if (row.Table.Columns.Contains("Mode")) { if (Convert.IsDBNull(row["Mode"])) { result._isModeNull = true; } else { result._mode = Convert.ToString(row["Mode"]); result._isModeNull = false; } } return result; }
internal static ThermostatSetting GetThermostatSetting(DataRow row) { ThermostatSetting result = new ThermostatSetting(); if (row.Table.Columns.Contains("Id")) { if (Convert.IsDBNull(row["Id"])) { result._isIdNull = true; } else { result._id = Convert.ToInt32(row["Id"]); result._isIdNull = false; } } if (row.Table.Columns.Contains("ThermostatId")) { if (Convert.IsDBNull(row["ThermostatId"])) { result._isThermostatIdNull = true; } else { result._thermostatId = Convert.ToInt32(row["ThermostatId"]); result._isThermostatIdNull = false; } } if (row.Table.Columns.Contains("LogDate")) { if (Convert.IsDBNull(row["LogDate"])) { result._isLogDateNull = true; } else { result._logDate = Convert.ToDateTime(row["LogDate"]); result._isLogDateNull = false; } } if (row.Table.Columns.Contains("Degrees")) { if (Convert.IsDBNull(row["Degrees"])) { result._isDegreesNull = true; } else { result._degrees = Convert.ToDouble(row["Degrees"]); result._isDegreesNull = false; } } if (row.Table.Columns.Contains("Mode")) { if (Convert.IsDBNull(row["Mode"])) { result._isModeNull = true; } else { result._mode = Convert.ToString(row["Mode"]); result._isModeNull = false; } } return(result); }
public static int SaveThermostatSetting(ThermostatSetting thermostatSetting) { int result = 0; SqlCommand cmd = new SqlCommand("SaveThermostatSetting", ThermostatMonitorLib.Global.Connection); cmd.CommandType = CommandType.StoredProcedure; if (thermostatSetting._isIdNull) { cmd.Parameters.AddWithValue("@Id", System.DBNull.Value); } else { cmd.Parameters.AddWithValue("@Id", thermostatSetting._id); } if (thermostatSetting._isThermostatIdNull) { cmd.Parameters.AddWithValue("@ThermostatId", System.DBNull.Value); } else { cmd.Parameters.AddWithValue("@ThermostatId", thermostatSetting._thermostatId); } if (thermostatSetting._isLogDateNull) { cmd.Parameters.AddWithValue("@LogDate", System.DBNull.Value); } else { cmd.Parameters.AddWithValue("@LogDate", thermostatSetting._logDate); } if (thermostatSetting._isDegreesNull) { cmd.Parameters.AddWithValue("@Degrees", System.DBNull.Value); } else { cmd.Parameters.AddWithValue("@Degrees", thermostatSetting._degrees); } if (thermostatSetting._isModeNull) { cmd.Parameters.AddWithValue("@Mode", System.DBNull.Value); } else { cmd.Parameters.AddWithValue("@Mode", thermostatSetting._mode); } cmd.Connection.Open(); try { result = Convert.ToInt32(cmd.ExecuteScalar()); } finally { cmd.Connection.Close(); } thermostatSetting.Id = result; return result; }