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