/// <summary>
/// A method to insert a new Adapter
/// </summary>
/// <param name="temperatureCurve">An adapter entity with information about the new adapter</param>
public void insert(SensorHub.Model.NKTemperatureCurveInfo temperatureCurve)
{
if (string.IsNullOrEmpty(temperatureCurve.DEVID))
{
return;
}
SensorHub.IDAL.INKTemperatureCurve dal = SensorHub.DALFactory.NKTemperatureCurve.Create();
dal.insert(temperatureCurve);
}
public void insert(SensorHub.Model.NKTemperatureCurveInfo temperatureCurve)
{
OracleParameter[] parms = GetAdapterParameters();
SetAdapterParameters(parms, temperatureCurve);
try
{
OracleHelper.ExecuteNonQuery(OracleHelper.ConnectionStringOrderDistributedTransaction, CommandType.Text, SQL_INSERT_NK_GX_TEMPERATURE_CURVE, parms);
}
catch (Exception e)
{
throw (e);
}
}
/// <summary>
/// An internal function to bind values parameters for insert
/// </summary>
/// <param name="parms">Database parameters</param>
/// <param name="temperatureCurve">Values to bind to parameters</param>
private void SetAdapterParameters(OracleParameter[] parms, SensorHub.Model.NKTemperatureCurveInfo temperatureCurve)
{
parms[0].Value = temperatureCurve.DEVID;
if (null != temperatureCurve.DISTANCE)
{
parms[1].Value = temperatureCurve.DISTANCE;
}
else
{
parms[1].Value = DBNull.Value;
}
if (null != temperatureCurve.TEMPERATURE)
{
parms[2].Value = temperatureCurve.TEMPERATURE;
}
else
{
parms[2].Value = DBNull.Value;
}
if (null != temperatureCurve.UPTIME)
{
parms[3].Value = temperatureCurve.UPTIME;
}
else
{
parms[3].Value = DBNull.Value;
}
if (null != temperatureCurve.LOGTIME)
{
parms[4].Value = temperatureCurve.LOGTIME;
}
else
{
parms[4].Value = DBNull.Value;
}
}
