public bool AddDevice(LoopModel loop)
{
try
{
List <DeviceInfo8003> lstDevices = loop.GetDevices <DeviceInfo8003>();
foreach (var device in lstDevices)
{
device.Loop.ID = loop.ID;
device.LoopID = loop.ID;
//StringBuilder sbDeviceInfoSQL = new StringBuilder("REPLACE INTO DeviceInfo8003(");
//sbDeviceInfoSQL.Append("ID,");
//sbDeviceInfoSQL.Append("Code,");
//sbDeviceInfoSQL.Append("Disable,");
//sbDeviceInfoSQL.Append("Feature,");
//sbDeviceInfoSQL.Append("DelayValue,");
//sbDeviceInfoSQL.Append("SensitiveLevel,");
//sbDeviceInfoSQL.Append("LinkageGroup1,");
//sbDeviceInfoSQL.Append("LinkageGroup2,");
//sbDeviceInfoSQL.Append("LinkageGroup3,");
//sbDeviceInfoSQL.Append("sdpKey,");
//sbDeviceInfoSQL.Append("BroadcastZone,");
//sbDeviceInfoSQL.Append("ZoneNo,");
//sbDeviceInfoSQL.Append("Location,");
//sbDeviceInfoSQL.Append("LoopID,");
//sbDeviceInfoSQL.Append("TypeCode)");
//sbDeviceInfoSQL.Append(" VALUES(");
//sbDeviceInfoSQL.Append(device.ID + ",'");
//sbDeviceInfoSQL.Append(device.Code + "','");
//sbDeviceInfoSQL.Append(device.Disable + "','");
//sbDeviceInfoSQL.Append(device.Feature + "','");
//sbDeviceInfoSQL.Append(device.DelayValue + "','");
//sbDeviceInfoSQL.Append(device.SensitiveLevel + "','");
//sbDeviceInfoSQL.Append(device.LinkageGroup1 + "','");
//sbDeviceInfoSQL.Append(device.LinkageGroup2 + "','");
//sbDeviceInfoSQL.Append(device.LinkageGroup3 + "','");
//sbDeviceInfoSQL.Append(device.sdpKey + "','");
//sbDeviceInfoSQL.Append(device.BroadcastZone + "','");
//sbDeviceInfoSQL.Append(device.ZoneNo + "','");
//sbDeviceInfoSQL.Append(device.Location + "','");
//sbDeviceInfoSQL.Append(device.LoopID + "','");
//sbDeviceInfoSQL.Append(device.TypeCode + "');");
//_databaseService.ExecuteBySql(sbDeviceInfoSQL);
_dbFileVersionService.AddDeviceForControllerType8003(device);
}
}
catch (Exception ex)
{
return(false);
}
return(true);
}
