USP_DATAFORMTEMPLATE_EDITLOAD_DAILYSALESBUTTONORDER

The load procedure used by the edit dataform template "Daily Sales Button Order Edit Data Form"
Parameters

Parameter	Parameter Type	Mode	Description
@DATALOADED	bit	INOUT	Output parameter indicating whether or not data was actually loaded.
@AVAILABLEBUTTONS	xml	INOUT	Inactive buttons
@ACTIVEBUTTONS	xml	INOUT	Active buttons
Definition

Copy

CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDITLOAD_DAILYSALESBUTTONORDER
(
    @DATALOADED bit = 0 output,
    @AVAILABLEBUTTONS xml = null output,
    @ACTIVEBUTTONS xml = null output
)
as

    set nocount on;

    declare @CURRENCYSYMBOL nchar(5)

    select
        @CURRENCYSYMBOL = [CURRENCYSYMBOL]
    from dbo.[CURRENCY]
    where [ISORGANIZATIONCURRENCY] = 1;

    select
        @DATALOADED = 1

    set @AVAILABLEBUTTONS =
    (
        select
            [ID],
            [BUTTONNAME],
            [BUTTONORDER]
        from
        (
            select
                [ID],
                case [TYPECODE]
                    when 0 then dbo.UFN_DAILYSALEITEM_BUILDPROGRAMBUTTONTEXT([ID], @CURRENCYSYMBOL)
                    when 1 then dbo.UFN_DAILYSALEITEM_BUILDPROGRAMBUTTONTEXT([ID], @CURRENCYSYMBOL)
                    when 2 then dbo.UFN_DAILYSALEITEM_BUILDMEMBERSHIPBUTTONTEXT([ID], @CURRENCYSYMBOL)
                    when 3 then dbo.UFN_DAILYSALEITEM_BUILDDISCOUNTBUTTONTEXT([ID], @CURRENCYSYMBOL)
                    when 4 then dbo.UFN_DAILYSALEITEM_BUILDDONATIONBUTTONTEXT([ID], @CURRENCYSYMBOL)
                    when 5 then dbo.UFN_DAILYSALEITEM_BUILDEVENTREGISTRATIONBUTTONTEXT([ID], @CURRENCYSYMBOL)
                    when 6 then dbo.UFN_DAILYSALEITEM_BUILDCOMBINATIONBUTTONTEXT([ID], @CURRENCYSYMBOL)
                    when 7 then dbo.UFN_DAILYSALEITEM_BUILDMEMBERSHIPPROMOBUTTONTEXT([ID], @CURRENCYSYMBOL)
                end as [BUTTONNAME],
                [BUTTONORDER]
            from dbo.[DAILYSALEITEM]
            where [BUTTONORDER] = 0

            union all

            select
                [ID],
                [TYPE] as [BUTTONNAME],
                [BUTTONORDER]
            from dbo.UFN_DAILYSALESGENERICACTION_GETGENERICBUTTONS(1) 
            where [BUTTONORDER] = 0 
        ) [BUTTONS]
        order by [BUTTONNAME]
        for xml raw('ITEM'),type,elements,root('AVAILABLEBUTTONS'),binary base64
    )

    set @ACTIVEBUTTONS =
    (
        select
            [ID],
            [BUTTONNAME],
            [BUTTONORDER]
        from
        (
            select
                [ID],
                case [TYPECODE]
                    when 0 then dbo.UFN_DAILYSALEITEM_BUILDPROGRAMBUTTONTEXT([ID], @CURRENCYSYMBOL)
                    when 1 then dbo.UFN_DAILYSALEITEM_BUILDPROGRAMBUTTONTEXT([ID], @CURRENCYSYMBOL)
                    when 2 then dbo.UFN_DAILYSALEITEM_BUILDMEMBERSHIPBUTTONTEXT([ID], @CURRENCYSYMBOL)
                    when 3 then dbo.UFN_DAILYSALEITEM_BUILDDISCOUNTBUTTONTEXT([ID], @CURRENCYSYMBOL)
                    when 4 then dbo.UFN_DAILYSALEITEM_BUILDDONATIONBUTTONTEXT([ID], @CURRENCYSYMBOL)
                    when 5 then dbo.UFN_DAILYSALEITEM_BUILDEVENTREGISTRATIONBUTTONTEXT([ID], @CURRENCYSYMBOL)
                    when 6 then dbo.UFN_DAILYSALEITEM_BUILDCOMBINATIONBUTTONTEXT([ID], @CURRENCYSYMBOL)
                    when 7 then dbo.UFN_DAILYSALEITEM_BUILDMEMBERSHIPPROMOBUTTONTEXT([ID], @CURRENCYSYMBOL)
                end as [BUTTONNAME],
                [BUTTONORDER]
            from dbo.[DAILYSALEITEM]
            where [BUTTONORDER] <> 0

            union all

            select
                [ID],
                [TYPE] as [BUTTONNAME],
                [BUTTONORDER]
            from dbo.UFN_DAILYSALESGENERICACTION_GETGENERICBUTTONS(1) 
            where [BUTTONORDER] <> 0 
        ) [BUTTONS]
        order by [BUTTONORDER]
        for xml raw('ITEM'),type,elements,root('ACTIVEBUTTONS'),binary base64
    )


    return 0;