--//InsertMoney
-----------------------------
CREATE PROCEDURE InsertMoney
@accountNr INT,
@balance MONEY
AS
BEGIN
    DECLARE @accountId AS INT;
    SET @accountId =(SELECT Id FROM bank_Account WHERE AccountNumber=@accountNr);
    IF(@accountId IS NOT NULL)
    BEGIN
        IF(@balance>0)
        BEGIN
            BEGIN TRANSACTION
            UPDATE bank_Account SET Balance=Balance+@balance WHERE Id=@accountId;
            INSERT INTO bank_Transactions(IdAccount, AccountNumber, DateOfTransaction, Balance)
            VALUES(@accountId, 0, GETDATE(), @balance);--Logga
            COMMIT TRANSACTION;
            SELECT 0 AS RESULT;
        END;
        ELSE
            SELECT 'Balance måste vara större än 0' AS RESULT;
    END;
    ELSE
        SELECT 'Inget existerande konto hittades' AS RESULT;
END;