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