USP_DATAFORMTEMPLATE_EDIT_DAILYSALEITEMMEMBERSHIP

The save procedure used by the edit dataform template "Daily Sale Item Membership 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.
@MEMBERSHIPPROGRAMID	uniqueidentifier	IN	Program
@MEMBERSHIPLEVELID	uniqueidentifier	IN	Level
@MEMBERSHIPLEVELTERMID	uniqueidentifier	IN	Term
@MEMBERSHIPLEVELTYPECODEID	uniqueidentifier	IN	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_DAILYSALEITEMMEMBERSHIP (
                    @ID uniqueidentifier,
                    @CHANGEAGENTID uniqueidentifier,
                    @MEMBERSHIPPROGRAMID uniqueidentifier,
                    @MEMBERSHIPLEVELID uniqueidentifier,
                    @MEMBERSHIPLEVELTERMID uniqueidentifier,
                    @MEMBERSHIPLEVELTYPECODEID 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 dbo.DAILYSALEITEMMEMBERSHIP set
                            MEMBERSHIPPROGRAMID = @MEMBERSHIPPROGRAMID,
                            MEMBERSHIPLEVELID = @MEMBERSHIPLEVELID,
                            MEMBERSHIPLEVELTERMID = @MEMBERSHIPLEVELTERMID,
                            MEMBERSHIPLEVELTYPECODEID = @MEMBERSHIPLEVELTYPECODEID,
                            CHANGEDBYID = @CHANGEAGENTID,
                            DATECHANGED = @CURRENTDATE
                        where ID = @ID
                    end try
                    begin catch
                        exec dbo.USP_RAISE_ERROR
                        return 1
                    end catch

                    return 0;