@Transactional
    public void createOrderItems(List<ExternalOrderImportRequest> dto) {

        for (ExternalOrderImportRequest  orderDTO: dto) {
            OrderTypeEntity typeEntity = this.orderTypeRepository.findByName(orderDTO.getType().getName());
            OrderEntity orderEntity = this.orderRepository.findByOrderNumber(orderDTO.getOrderNumber());

            if (orderEntity == null) {
                orderEntity = new OrderEntity();
            }
            orderEntity.setOrderNumber(orderDTO.getOrderNumber());
            orderEntity.setDescription(orderDTO.getDescription());
            orderEntity.setDescriptionEn(orderDTO.getDescriptionEn());
            orderEntity.setCreated(orderDTO.getCreated());
            orderEntity.setUpdated(orderDTO.getUpdated());
            orderEntity.setType(typeEntity);
            this.orderRepository.save(orderEntity);

            for (ExternalItemDTO itemDTO: orderDTO.getItems()) {
                ItemEntity itemEntity = this.itemRepository.findByItemNumberAndOrderNumberAndItemType(orderDTO.getOrderNumber(),
                    itemDTO.getItemNumber(), typeEntity.getId());

                if (itemEntity == null) {
                    itemEntity = new ItemEntity();
                }
                itemEntity.setItemNumber(itemDTO.getItemNumber());
                itemEntity.setQuantity(itemDTO.getQuantity());
                itemEntity.setDescription(itemDTO.getDescription());
                itemEntity.setDescriptionEn(itemDTO.getDescriptionEn());
                itemEntity.setSupplierMaterialNumber(itemDTO.getSupplierMaterialNumber());
                itemEntity.setCreated(itemDTO.getCreated());
                itemEntity.setUpdated(itemDTO.getUpdated());
                this.itemRepository.save(itemEntity);

                OrderItemId pk = new OrderItemId();
                pk.setItem(itemEntity);
                pk.setOrder(orderEntity);

                OrderItemEntity orderItemEntity = new OrderItemEntity();
                orderItemEntity.setPk(pk);
                this.orderItemRepository.save(orderItemEntity);
            }
        }
    }