USP_DATAFORMTEMPLATE_EDITLOAD_REGISTRATIONINFORMATION

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	IN
@DATALOADED	bit	INOUT
@TSLONG	bigint	INOUT
@NAME	nvarchar(100)	INOUT
@TYPECODE	tinyint	INOUT
@DISPLAYONLINE	bit	INOUT
@ONLINEHTML	nvarchar(max)	INOUT
@RESPONSETYPECODE	tinyint	INOUT
@REGISTRATIONINFORMATIONOPTIONS	xml	INOUT
@INACTIVE	bit	INOUT
@ALLPRICETYPES	bit	INOUT
@REGISTRATIONINFORMATIONPRICETYPES	xml	INOUT
@ASKPERSONPHONE2	bit	INOUT
@ASKPERSONEMAIL	bit	INOUT
@LOCKTYPECODE	bit	INOUT

Definition

Copy


CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDITLOAD_REGISTRATIONINFORMATION
(
    @ID uniqueidentifier,
    @DATALOADED bit = 0 output,
    @TSLONG bigint = 0 output,
    @NAME nvarchar(100) = null output,
    @TYPECODE tinyint = null output,
    @DISPLAYONLINE bit = null output,
    @ONLINEHTML nvarchar(max) = null output,
    @RESPONSETYPECODE tinyint = null output,
    @REGISTRATIONINFORMATIONOPTIONS xml = null output,
    @INACTIVE bit = null output,
    @ALLPRICETYPES bit = null output,
    @REGISTRATIONINFORMATIONPRICETYPES xml = null output,
    @ASKPERSONPHONE2 bit = null output,
    @ASKPERSONEMAIL bit = null output,
    @LOCKTYPECODE bit = null output
)
as
    set nocount on;

    set @DATALOADED = 0;
    set @TSLONG = 0;

    select 
        @DATALOADED = 1,
        @TSLONG = TSLONG,
        @NAME = NAME,
        @TYPECODE = TYPECODE,
        @DISPLAYONLINE = DISPLAYONLINE,
        @ONLINEHTML = ONLINEHTML,
        @RESPONSETYPECODE = RESPONSETYPECODE, 
        @INACTIVE = INACTIVE, 
        @ALLPRICETYPES = ALLPRICETYPES, 
        @ASKPERSONPHONE2 = ASKPERSONPHONE2, 
        @ASKPERSONEMAIL = ASKPERSONEMAIL,
        @REGISTRATIONINFORMATIONOPTIONS = dbo.UFN_REGISTRATIONINFORMATION_GETREGISTRATIONINFORMATIONOPTIONS_TOITEMLISTXML(@ID),
        @REGISTRATIONINFORMATIONPRICETYPES = dbo.UFN_REGISTRATIONINFORMATION_GETPRICETYPES_TOITEMLISTXML(@ID),
        @LOCKTYPECODE = 
            case
                when exists(select ID from dbo.REGISTRANTREGISTRATIONINFORMATION where REGISTRATIONINFORMATIONID = @ID) then 1
                else 0
            end
    from dbo.REGISTRATIONINFORMATION
    where ID = @ID;

    return 0;