USP_DATAFORMTEMPLATE_VIEW_DAILYSALESMIDTERMUPGRADEBUTTONS

The load procedure used by the view dataform template "Daily Sales Mid Term Upgrade Buttons View Form"
Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN	The input ID parameter used to load the fields defined on the form.
@DATALOADED	bit	INOUT	Output parameter indicating whether or not data was actually loaded.
@BUTTONS	xml	INOUT	BUTTONS
Definition

Copy

            CREATE procedure dbo.USP_DATAFORMTEMPLATE_VIEW_DAILYSALESMIDTERMUPGRADEBUTTONS
            (
                @ID uniqueidentifier,
                @DATALOADED bit = 0 output,
                @BUTTONS xml = null output
            )
            as
                set nocount on;

                set @DATALOADED = 0;

                declare @CONSTITUENTID uniqueidentifier = (select CONSTITUENTID from dbo.SALESORDER where ID = @ID);

                declare @BUTTONTEMPTABLE table
                (
                    QUICKBUTTONID uniqueidentifier,
                    TYPECODE tinyint,
                    BUTTONTEXT nvarchar(250),
                    ISENABLED bit,
                    ISGENERIC bit,
                    PARAM1 uniqueidentifier,
                    PARAM2 uniqueidentifier,
                    PARAM3 uniqueidentifier,
                    PARAM4 uniqueidentifier,
                    PARAM5 uniqueidentifier,
                    BUTTONORDER integer
                )


                -- THE BACK BUTTTON
                insert into @BUTTONTEMPTABLE
                select
                    null,
                    200, -- Special flag to indicate back button
                    'Back',
                    1,
                    1,
                    null,
                    null,
                    null,
                    null,
                    null,
                    -1;



                -- ACTUAL UPGRADE OPTIONS

                insert into @BUTTONTEMPTABLE
                select
                    null,
                    2,
                    MEMBERSHIPPROGRAMNAME + char(10) + MEMBERSHIPLEVELNAME + char(10) + convert(nvarchar(20),dbo.UFN_MEMBERSHIP_GETMIDTERMUPGRADEPRICE(MEMBERSHIPID, MEMBERSHIPLEVELID)),
                    1,
                    1,
                    MEMBERSHIPID,
                    MEMBERSHIPPROGRAMID,
                    MEMBERSHIPLEVELID,
                    MEMBERSHIPLEVELTERMID,
                    null,
                    row_number() over(order by EXPIRATIONDATE asc, LOOKUPID asc, SEQUENCE asc)
                from dbo.UFN_SALESORDER_GETPATRONUPGRADELEVELS(@CONSTITUENTID)

                select @DATALOADED = 1,
                       @BUTTONS = (
                        select
                            QUICKBUTTONID,
                            TYPECODE,
                            BUTTONTEXT,
                            ISENABLED,
                            ISGENERIC,
                            PARAM1,
                            PARAM2,
                            PARAM3,
                            PARAM4,
                            PARAM5
                        from @BUTTONTEMPTABLE
                        order by BUTTONORDER asc
                        for xml raw ('ITEM'), type, elements, root('BUTTONS'), BINARY BASE64

                )

                return 0;