spAddOrderLine

DROP PROCEDURE IF EXISTS `spAddOrderLine`;
DELIMITER //
CREATE PROCEDURE spAddOrderline(IN articleNumber INT, IN orderNumber INT, IN qty INT, OUT RESULT INT)
    BEGIN
        IF (
            (
                (SELECT `TotalPrice` FROM `CustomOrder` WHERE `Nr` = orderNumber) +
                (SELECT a.`Price`*qty FROM `Article` a WHERE a.`Nr` = articleNumber)
            )
            <=
            1000
        )
        THEN
            INSERT INTO `OrderLine`(`ArtNr`, `OrderNr`, `Amount`)
            VALUES(articleNumber, orderNumber, qty);
            SET RESULT = 1;
        ELSE
            SET RESULT = 0;
        END IF;
    END //
DELIMITER ;