public static int SaveTransitionStat(TransitionStat transitionStat)
{
int result = 0;
SqlCommand cmd = new SqlCommand("SaveTransitionStat", ThermostatMonitorLib.Global.Connection);
cmd.CommandType = CommandType.StoredProcedure;
if (transitionStat._isIdNull)
{
cmd.Parameters.AddWithValue("@Id", System.DBNull.Value);
}
else
{
cmd.Parameters.AddWithValue("@Id", transitionStat._id);
}
if (transitionStat._isThermostatIdNull)
{
cmd.Parameters.AddWithValue("@ThermostatId", System.DBNull.Value);
}
else
{
cmd.Parameters.AddWithValue("@ThermostatId", transitionStat._thermostatId);
}
if (transitionStat._isTransitionTypeNull)
{
cmd.Parameters.AddWithValue("@TransitionType", System.DBNull.Value);
}
else
{
cmd.Parameters.AddWithValue("@TransitionType", transitionStat._transitionType);
}
if (transitionStat._isTemperatureDeltaNull)
{
cmd.Parameters.AddWithValue("@TemperatureDelta", System.DBNull.Value);
}
else
{
cmd.Parameters.AddWithValue("@TemperatureDelta", transitionStat._temperatureDelta);
}
if (transitionStat._isMinutesPerDegreeNull)
{
cmd.Parameters.AddWithValue("@MinutesPerDegree", System.DBNull.Value);
}
else
{
cmd.Parameters.AddWithValue("@MinutesPerDegree", transitionStat._minutesPerDegree);
}
if (transitionStat._isOccurancesNull)
{
cmd.Parameters.AddWithValue("@Occurances", System.DBNull.Value);
}
else
{
cmd.Parameters.AddWithValue("@Occurances", transitionStat._occurances);
}
cmd.Connection.Open();
try
{
result = Convert.ToInt32(cmd.ExecuteScalar());
}
finally
{
cmd.Connection.Close();
}
transitionStat.Id = result;
return(result);
}
internal static TransitionStat GetTransitionStat(DataRow row)
{
TransitionStat result = new TransitionStat();
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("TransitionType"))
{
if (Convert.IsDBNull(row["TransitionType"]))
{
result._isTransitionTypeNull = true;
}
else
{
result._transitionType = Convert.ToString(row["TransitionType"]);
result._isTransitionTypeNull = false;
}
}
if (row.Table.Columns.Contains("TemperatureDelta"))
{
if (Convert.IsDBNull(row["TemperatureDelta"]))
{
result._isTemperatureDeltaNull = true;
}
else
{
result._temperatureDelta = Convert.ToInt32(row["TemperatureDelta"]);
result._isTemperatureDeltaNull = false;
}
}
if (row.Table.Columns.Contains("MinutesPerDegree"))
{
if (Convert.IsDBNull(row["MinutesPerDegree"]))
{
result._isMinutesPerDegreeNull = true;
}
else
{
result._minutesPerDegree = Convert.ToDouble(row["MinutesPerDegree"]);
result._isMinutesPerDegreeNull = false;
}
}
if (row.Table.Columns.Contains("Occurances"))
{
if (Convert.IsDBNull(row["Occurances"]))
{
result._isOccurancesNull = true;
}
else
{
result._occurances = Convert.ToInt32(row["Occurances"]);
result._isOccurancesNull = false;
}
}
return result;
}
internal static TransitionStat GetTransitionStat(DataRow row)
{
TransitionStat result = new TransitionStat();
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("TransitionType"))
{
if (Convert.IsDBNull(row["TransitionType"]))
{
result._isTransitionTypeNull = true;
}
else
{
result._transitionType = Convert.ToString(row["TransitionType"]);
result._isTransitionTypeNull = false;
}
}
if (row.Table.Columns.Contains("TemperatureDelta"))
{
if (Convert.IsDBNull(row["TemperatureDelta"]))
{
result._isTemperatureDeltaNull = true;
}
else
{
result._temperatureDelta = Convert.ToInt32(row["TemperatureDelta"]);
result._isTemperatureDeltaNull = false;
}
}
if (row.Table.Columns.Contains("MinutesPerDegree"))
{
if (Convert.IsDBNull(row["MinutesPerDegree"]))
{
result._isMinutesPerDegreeNull = true;
}
else
{
result._minutesPerDegree = Convert.ToDouble(row["MinutesPerDegree"]);
result._isMinutesPerDegreeNull = false;
}
}
if (row.Table.Columns.Contains("Occurances"))
{
if (Convert.IsDBNull(row["Occurances"]))
{
result._isOccurancesNull = true;
}
else
{
result._occurances = Convert.ToInt32(row["Occurances"]);
result._isOccurancesNull = false;
}
}
return(result);
}
public static int SaveTransitionStat(TransitionStat transitionStat)
{
int result = 0;
SqlCommand cmd = new SqlCommand("SaveTransitionStat", ThermostatMonitorLib.Global.Connection);
cmd.CommandType = CommandType.StoredProcedure;
if (transitionStat._isIdNull)
{
cmd.Parameters.AddWithValue("@Id", System.DBNull.Value);
}
else
{
cmd.Parameters.AddWithValue("@Id", transitionStat._id);
}
if (transitionStat._isThermostatIdNull)
{
cmd.Parameters.AddWithValue("@ThermostatId", System.DBNull.Value);
}
else
{
cmd.Parameters.AddWithValue("@ThermostatId", transitionStat._thermostatId);
}
if (transitionStat._isTransitionTypeNull)
{
cmd.Parameters.AddWithValue("@TransitionType", System.DBNull.Value);
}
else
{
cmd.Parameters.AddWithValue("@TransitionType", transitionStat._transitionType);
}
if (transitionStat._isTemperatureDeltaNull)
{
cmd.Parameters.AddWithValue("@TemperatureDelta", System.DBNull.Value);
}
else
{
cmd.Parameters.AddWithValue("@TemperatureDelta", transitionStat._temperatureDelta);
}
if (transitionStat._isMinutesPerDegreeNull)
{
cmd.Parameters.AddWithValue("@MinutesPerDegree", System.DBNull.Value);
}
else
{
cmd.Parameters.AddWithValue("@MinutesPerDegree", transitionStat._minutesPerDegree);
}
if (transitionStat._isOccurancesNull)
{
cmd.Parameters.AddWithValue("@Occurances", System.DBNull.Value);
}
else
{
cmd.Parameters.AddWithValue("@Occurances", transitionStat._occurances);
}
cmd.Connection.Open();
try
{
result = Convert.ToInt32(cmd.ExecuteScalar());
}
finally
{
cmd.Connection.Close();
}
transitionStat.Id = result;
return result;
}
