public bool AddDevice(LoopModel loop) { try { List <DeviceInfo8021> lstDevices = loop.GetDevices <DeviceInfo8021>(); foreach (var device in lstDevices) { device.Loop.ID = loop.ID; device.LoopID = loop.ID; //StringBuilder sbDeviceInfoSQL = new StringBuilder("REPLACE INTO DeviceInfo8021("); //sbDeviceInfoSQL.Append("ID,"); //sbDeviceInfoSQL.Append("Code,"); //sbDeviceInfoSQL.Append("Disable,"); //sbDeviceInfoSQL.Append("CurrentThreshold,"); //sbDeviceInfoSQL.Append("TemperatureThreshold,"); //sbDeviceInfoSQL.Append("BuildingNo,"); //sbDeviceInfoSQL.Append("ZoneNo,"); //sbDeviceInfoSQL.Append("FloorNo,"); //sbDeviceInfoSQL.Append("RoomNo,"); //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.CurrentThreshold + "','"); //sbDeviceInfoSQL.Append(device.TemperatureThreshold + "','"); //sbDeviceInfoSQL.Append(device.BuildingNo + "','"); //sbDeviceInfoSQL.Append(device.ZoneNo + "','"); //sbDeviceInfoSQL.Append(device.FloorNo + "','"); //sbDeviceInfoSQL.Append(device.RoomNo + "','"); //sbDeviceInfoSQL.Append(device.Location + "','"); //sbDeviceInfoSQL.Append(device.LoopID + "','"); //sbDeviceInfoSQL.Append(device.TypeCode + "');"); //_databaseService.ExecuteBySql(sbDeviceInfoSQL); _dbFileVersionService.AddDeviceForControllerType8021(device); } } catch (Exception ex) { return(false); } return(true); }