USP_DATAFORMTEMPLATE_ADD_REGISTRATIONINFORMATION

Parameters

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

Definition

Copy


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

    if @ID is null
        set @ID = newid();

    if @CHANGEAGENTID is null  
        exec dbo.USP_CHANGEAGENT_GETORCREATECHANGEAGENT @CHANGEAGENTID output;

    declare @CURRENTDATE datetime = getdate();

    begin try
        exec dbo.USP_REGISTRATIONINFORMATION_VALIDATEANDCORRECTPARAMETERS
            @TYPECODE,
            @DISPLAYONLINE output,
            @ONLINEHTML output,
            @RESPONSETYPECODE output,
            @REGISTRATIONINFORMATIONOPTIONS output,
            @ALLPRICETYPES output,
            @REGISTRATIONINFORMATIONPRICETYPES output,
            @ASKPERSONPHONE2 output,
            @ASKPERSONEMAIL output;

        insert into dbo.REGISTRATIONINFORMATION
            (ID, NAME, TYPECODE, DISPLAYONLINE, ONLINEHTML, RESPONSETYPECODE, INACTIVE, ALLPRICETYPES, ASKPERSONPHONE2, ASKPERSONEMAIL, ADDEDBYID, CHANGEDBYID, DATEADDED, DATECHANGED)
        values
            (@ID, @NAME, @TYPECODE, @DISPLAYONLINE, @ONLINEHTML, @RESPONSETYPECODE, @INACTIVE, @ALLPRICETYPES, @ASKPERSONPHONE2, @ASKPERSONEMAIL, @CHANGEAGENTID, @CHANGEAGENTID, @CURRENTDATE, @CURRENTDATE);

        exec dbo.USP_REGISTRATIONINFORMATION_GETREGISTRATIONINFORMATIONOPTIONS_ADDFROMXML @ID, @REGISTRATIONINFORMATIONOPTIONS, @CHANGEAGENTID, @CURRENTDATE;

        exec dbo.USP_REGISTRATIONINFORMATION_GETPRICETYPES_ADDFROMXML @ID, @REGISTRATIONINFORMATIONPRICETYPES, @CHANGEAGENTID, @CURRENTDATE;        
    end try

    begin catch
        exec dbo.USP_RAISE_ERROR;
        return 1;
    end catch

    return 0