USP_DATAFORMTEMPLATE_EDITSAVE_REGISTRATIONINFORMATION

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	IN
@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_EDITSAVE_REGISTRATIONINFORMATION
(
    @ID uniqueidentifier,
    @CHANGEAGENTID uniqueidentifier = null,
    @NAME nvarchar(100),
    @TYPECODE tinyint,
    @DISPLAYONLINE bit,
    @ONLINEHTML nvarchar(max),
    @RESPONSETYPECODE tinyint,
    @REGISTRATIONINFORMATIONOPTIONS xml,
    @INACTIVE bit,
    @ALLPRICETYPES bit,
    @REGISTRATIONINFORMATIONPRICETYPES xml,
    @ASKPERSONPHONE2 bit,
    @ASKPERSONEMAIL bit
)
as
    set nocount on;

    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;

        update dbo.REGISTRATIONINFORMATION set
            NAME = @NAME,
            TYPECODE = @TYPECODE,
            DISPLAYONLINE = @DISPLAYONLINE,
            ONLINEHTML = @ONLINEHTML,
            RESPONSETYPECODE = @RESPONSETYPECODE, 
            INACTIVE = @INACTIVE, 
            ALLPRICETYPES = @ALLPRICETYPES, 
            ASKPERSONPHONE2 = @ASKPERSONPHONE2, 
            ASKPERSONEMAIL = @ASKPERSONEMAIL,
            CHANGEDBYID = @CHANGEAGENTID,
            DATECHANGED = @CURRENTDATE
        where ID = @ID;

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

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

    begin catch
        exec dbo.USP_RAISE_ERROR
        return 1
    end catch

    return 0;