USP_DATAFORMTEMPLATE_ADD_SALESORDERITEMMEMBERSHIPGIFT_PRELOAD

The load procedure used by the edit dataform template "Sales Order Item Membership Gift Add Data Form"

Parameters

Parameter	Parameter Type	Mode	Description
@SALESORDERID	uniqueidentifier	IN	Input parameter indicating the context ID for the record being added.
@ORDERCONSTITUENTID	uniqueidentifier	INOUT
@ORDERCONSTITUENTNAME	nvarchar(154)	INOUT
@TRANSACTIONDATE	datetime	INOUT

Definition

Copy



                    CREATE procedure dbo.USP_DATAFORMTEMPLATE_ADD_SALESORDERITEMMEMBERSHIPGIFT_PRELOAD
                    (
                        @SALESORDERID uniqueidentifier,
                        @ORDERCONSTITUENTID uniqueidentifier = null output,
                        @ORDERCONSTITUENTNAME nvarchar(154) = null output,
                        @TRANSACTIONDATE datetime = null output
                    )
                    as
                        set nocount on;

                        declare @MEMBERSHIPPROGRAMID uniqueidentifier;

                        set @TRANSACTIONDATE = getdate();

                        select
                            @ORDERCONSTITUENTID = CONSTITUENT.ID,
                            @ORDERCONSTITUENTNAME = CONSTITUENT.NAME
                        from
                            dbo.SALESORDER
                        inner join
                            dbo.CONSTITUENT on SALESORDER.CONSTITUENTID = CONSTITUENT.ID
                        where
                            SALESORDER.ID = @SALESORDERID;

                        if (select count(ID) from dbo.MEMBERSHIPPROGRAM) = 1
                            select @MEMBERSHIPPROGRAMID = MEMBERSHIPPROGRAMID from dbo.MEMBERSHIP;

                        return 0;