Workflow Bestätigung des Newsletterlink

<?xml version="1.0"?>
<workflow name="SendInBlueMCNewsletter" trigger="NewsletterOptIn" start="#1050">
    <step id="#1050" name="Gutschein erstellen" action="Centauri.Shop.Workflows.Database.SQLCommand">
        <parameter>
            <command><![CDATA[insert into giftcodes (giftcode, text, type, validFrom, validTo, value_eur, credit, usage, valuecode, cardnr, customernr, transferitemnr ) select top 1 right(replace(cast(newid() as varchar(50)), '-', ''),10), 'Newsletter-Bonus', 'SINGLE', GETDATE(), GETDATE()+365, 5, 1, 0, 1, email, (select top 1 customernr from vip where vip.email=newslettermembers.email), '9newsletter' from newslettermembers where email not in (select cardnr from giftcodes where text='Newsletter-Bonus') and confirmed<>0 ]]></command>
            <ignoreerror>false</ignoreerror>
        </parameter>
        <transition destination="#1051" success="yes"/>
    </step>
    <step id="#1051" name="Gutschein laden" action="Centauri.Shop.Workflows.Database.SQLQuery">
        <parameter>
            <command>select top 1 giftcode from giftcodes where text='Newsletter-Bonus' and property1 is null order by validFrom desc
            </command>
            <parameter>giftcode</parameter>
            <ignoreerror>false</ignoreerror>
        </parameter>
        <transition destination="#1052" success="yes"/>
    </step>
    <step id="#1052" name="Gutschein überprüfen" action="Centauri.Shop.Workflows.Process.Check">
        <data>
            <parameter>giftcode</parameter>
        </data>
        <transition destination="#1053" success="yes"/>
    </step>
    <step id="#1053" name="Gutschein E-Mail laden" action="Centauri.Shop.Workflows.Database.SQLQuery">
        <data>
            <parameter>email</parameter>
            <command>select top 1 cardnr from giftcodes where giftcode=@giftcode</command>
        </data>
        <transition destination="#1054" success="yes"/>
    </step>
    <step id="#1054" name="Newsletter verschicken" action="Centauri.Shop.Workflows.SendInBlue.Send">
        <data>
            <template>27</template>
            <parameter>giftcode</parameter>
        </data>
        <transition destination="#1055" success="yes"/>
    </step>
    <step id="#1055" name="Datum dokumentieren" action="Centauri.Shop.Workflows.Database.SQLCommand" final="yes">
        <data>
            <parameter>email</parameter>
            <command>update giftcodes set property1=getdate() where giftcode=@giftcode</command>
        </data>
    </step>
    <mapping origin="*"/>
</workflow>