/// <summary>
/// A method to insert a new Adapter
/// </summary>
/// <param name="VibratingCurve">An adapter entity with information about the new adapter</param>
public void insert(SensorHub.Model.NKVibratingCurveInfo VibratingCurve)
{
if (string.IsNullOrEmpty(VibratingCurve.DEVID))
{
return;
}
SensorHub.IDAL.INKVibratingCurve dal = SensorHub.DALFactory.NKVibratingCurve.Create();
dal.insert(VibratingCurve);
}
public void insert(SensorHub.Model.NKVibratingCurveInfo vibratingCurve)
{
OracleParameter[] parms = GetAdapterParameters();
SetAdapterParameters(parms, vibratingCurve);
try
{
OracleHelper.ExecuteNonQuery(OracleHelper.ConnectionStringOrderDistributedTransaction, CommandType.Text, SQL_INSERT_NK_GX_VIBRATING_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="vibratingCurve">Values to bind to parameters</param>
private void SetAdapterParameters(OracleParameter[] parms, SensorHub.Model.NKVibratingCurveInfo vibratingCurve)
{
parms[0].Value = vibratingCurve.DEVID;
if (null != vibratingCurve.DISTANCE)
{
parms[1].Value = vibratingCurve.DISTANCE;
}
else
{
parms[1].Value = DBNull.Value;
}
if (null != vibratingCurve.VIBRATING)
{
parms[2].Value = vibratingCurve.VIBRATING;
}
else
{
parms[2].Value = DBNull.Value;
}
if (null != vibratingCurve.UPTIME)
{
parms[3].Value = vibratingCurve.UPTIME;
}
else
{
parms[3].Value = DBNull.Value;
}
if (null != vibratingCurve.LOGTIME)
{
parms[4].Value = vibratingCurve.LOGTIME;
}
else
{
parms[4].Value = DBNull.Value;
}
}