USP_DATAFORMTEMPLATE_PRELOAD_ADD_PROGRAMDAILYADMISSION

The load procedure used by the edit dataform template "Daily Admission Program Add Form"

Parameters

Parameter	Parameter Type	Mode	Description
@CURRENTAPPUSERID	uniqueidentifier	IN	Input parameter indicating the ID of the current user.
@ISDAILYADMISSION	bit	INOUT	Is daily admission
@ONSALEINFORMATION	xml	INOUT	Available for sale

Definition

Copy


        CREATE procedure dbo.USP_DATAFORMTEMPLATE_PRELOAD_ADD_PROGRAMDAILYADMISSION
                    (
                        @CURRENTAPPUSERID uniqueidentifier,
                        @ISDAILYADMISSION bit = null output,
                        @ONSALEINFORMATION xml = null output
                    )
                    as
                    begin
                        set nocount on;

                        set @ISDAILYADMISSION = 1;

                        set @ONSALEINFORMATION =
                        (
                            select
                                SALESMETHOD.ID as SALESMETHODID,
                                SALESMETHOD.TYPE as SALESMETHODTYPE,
                                1 as ISAVAILABLE
                            from dbo.SALESMETHOD
                            where ISACTIVE = 1
                            for xml raw ('ITEM'), type, elements, root('ONSALEINFORMATION'), BINARY BASE64
                        )


                        return 0;
                    end