USP_DATAFORMTEMPLATE_EDIT_DAILYSALEITEMMEMBERSHIPPROMO

The save procedure used by the edit dataform template "Daily Sale Item Membership Promotion 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.
@APPLICATIONTYPECODE	tinyint	IN	Type
@MEMBERSHIPPROMOID	uniqueidentifier	IN	Name
@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_DAILYSALEITEMMEMBERSHIPPROMO (
    @ID uniqueidentifier,
    @CHANGEAGENTID uniqueidentifier,
    @APPLICATIONTYPECODE tinyint,
    @MEMBERSHIPPROMOID 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 discount record

        update dbo.[DAILYSALEITEMMEMBERSHIPPROMO] set 
            MEMBERSHIPPROMOID = @MEMBERSHIPPROMOID,
            CHANGEDBYID = @CHANGEAGENTID,
            DATECHANGED = @CURRENTDATE
        where ID = @ID
    end try
    begin catch
        exec dbo.USP_RAISE_ERROR
        return 1
    end catch

return 0;