USP_DATAFORMTEMPLATE_EDIT_DAILYSALEITEMEVENTREGISTRATION

The save procedure used by the edit dataform template "Daily Sale Item Event Registration Edit Data 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.
@EVENTID	uniqueidentifier	IN	Event
@EVENTPRICEID	uniqueidentifier	IN	Price type
@ISACTIVE	bit	IN	Mark button active
@DESCRIPTIONFIELD1	nvarchar(20)	IN	Row 1
@DESCRIPTIONFIELD2	nvarchar(20)	IN	Row 2
@DESCRIPTIONFIELD3	nvarchar(20)	IN	Row 3
@DESCRIPTIONFIELD1TYPECODE	tinyint	IN	Row 1
@DESCRIPTIONFIELD2TYPECODE	tinyint	IN	Row 2
@DESCRIPTIONFIELD3TYPECODE	tinyint	IN	Row 3

Definition

Copy



                CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_DAILYSALEITEMEVENTREGISTRATION (
                    @ID uniqueidentifier,
                    @CHANGEAGENTID uniqueidentifier = null,
                    @EVENTID uniqueidentifier,
                    @EVENTPRICEID uniqueidentifier,
                    @ISACTIVE bit,
                    @DESCRIPTIONFIELD1 nvarchar(20),
                    @DESCRIPTIONFIELD2 nvarchar(20),
                    @DESCRIPTIONFIELD3 nvarchar(20),
                    @DESCRIPTIONFIELD1TYPECODE tinyint,
                    @DESCRIPTIONFIELD2TYPECODE tinyint,
                    @DESCRIPTIONFIELD3TYPECODE tinyint
                )
                as

                    set nocount on;

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

                    declare @CURRENTDATE datetime
                    set @CURRENTDATE = getdate()

                    begin try
                        -- Update daily sale item record

                        exec dbo.USP_DAILYSALEITEM_UPDATEDAILYSALEITEMRECORD @ID,@CHANGEAGENTID,@ISACTIVE,@DESCRIPTIONFIELD1,@DESCRIPTIONFIELD2,@DESCRIPTIONFIELD3,@DESCRIPTIONFIELD1TYPECODE,@DESCRIPTIONFIELD2TYPECODE,@DESCRIPTIONFIELD3TYPECODE

                        -- Update daily sale item event registration record

                        update dbo.[DAILYSALEITEMEVENTREGISTRATION] set 
                            EVENTID = @EVENTID,
                            EVENTPRICEID = @EVENTPRICEID,
                            CHANGEDBYID = @CHANGEAGENTID,
                            DATECHANGED = @CURRENTDATE
                        where ID = @ID

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

                return 0;