USP_DATAFORMTEMPLATE_EDIT_BATCHEVENTREGISTRANTBATCHROW_2

The save procedure used by the edit dataform template "Event Registrant Batch Row Edit Form".

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN	The input ID parameter indicating the ID of the record being edited.
@CHANGEAGENTID	uniqueidentifier	IN	Input parameter indicating the ID of the change agent invoking the procedure.
@SEQUENCE	int	IN	Sequence
@EVENTID	uniqueidentifier	IN	Event
@CONSTITUENTID	uniqueidentifier	IN	Registrant
@DATEPURCHASED	datetime	IN	Date
@EVENTPRICEID	uniqueidentifier	IN	Registration option
@REGISTRANTSTATUSCODE	tinyint	IN	Status
@WAIVEBENEFITS	bit	IN	Waive benefits
@QUANTITY	int	IN	Quantity
@GUESTS	xml	IN	Guests
@REGISTRANTLOOKUPID	nvarchar(100)	IN	Registrant ID
@DESIGNATIONID	uniqueidentifier	IN	Designation
@REGISTRATIONTYPECODE	tinyint	IN	Registration type
@REGISTRATIONSTATUSCODE	tinyint	IN	Status
@REGISTRATIONATTENDEDCODE	tinyint	IN	Attended

Definition

Copy



CREATE procedure USP_DATAFORMTEMPLATE_EDIT_BATCHEVENTREGISTRANTBATCHROW_2
(
    @ID uniqueidentifier,
    @CHANGEAGENTID uniqueidentifier,
    @SEQUENCE int,
    @EVENTID uniqueidentifier,
    @CONSTITUENTID uniqueidentifier,
    @DATEPURCHASED datetime,
    @EVENTPRICEID uniqueidentifier,
    @REGISTRANTSTATUSCODE tinyint,
    @WAIVEBENEFITS bit,
    @QUANTITY int,
    @GUESTS xml,
    @REGISTRANTLOOKUPID nvarchar(100),
    @DESIGNATIONID uniqueidentifier,
    @REGISTRATIONTYPECODE tinyint,
    @REGISTRATIONSTATUSCODE tinyint ,
    @REGISTRATIONATTENDEDCODE tinyint
)

as
  set nocount on;

    declare @EVENT_IMPORTLOOKUPID nvarchar(100);

  exec dbo.USP_DATAFORMTEMPLATE_EDITLOAD_BATCHEVENTREGISTRANTBATCHROW
        @ID = @ID,
        @EVENT_IMPORTLOOKUPID = @EVENT_IMPORTLOOKUPID output

  exec dbo.USP_DATAFORMTEMPLATE_EDIT_BATCHEVENTREGISTRANTBATCHROW_3
        @ID,
        @CHANGEAGENTID,
        @SEQUENCE,
        @EVENTID,
        @CONSTITUENTID,
        @DATEPURCHASED,
        @EVENTPRICEID,
        @REGISTRANTSTATUSCODE,
        @WAIVEBENEFITS,
        @QUANTITY,
        @GUESTS,
        @REGISTRANTLOOKUPID,
        @DESIGNATIONID,
        @REGISTRATIONTYPECODE,
        @REGISTRATIONSTATUSCODE,
        @REGISTRATIONATTENDEDCODE,
        @EVENT_IMPORTLOOKUPID

  return 0;