USP_DATAFORMTEMPLATE_EDIT_DAILYSALEITEMDISCOUNT

The save procedure used by the edit dataform template "Daily Sale Item Discount 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
@DISCOUNTID	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
@DISCOUNTLIMITAPPLICATIONTYPECODE	tinyint	IN	Apply discount

Definition

Copy



                CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_DAILYSALEITEMDISCOUNT (
                    @ID uniqueidentifier,
                    @CHANGEAGENTID uniqueidentifier,
                    @APPLICATIONTYPECODE tinyint,
                    @DISCOUNTID uniqueidentifier,
                    @ISACTIVE bit,
                    @DESCRIPTIONFIELD1 nvarchar(20),
                    @DESCRIPTIONFIELD2 nvarchar(20),
                    @DESCRIPTIONFIELD3 nvarchar(20),
                    @DESCRIPTIONFIELD1TYPECODE tinyint,
                    @DESCRIPTIONFIELD2TYPECODE tinyint,
                    @DESCRIPTIONFIELD3TYPECODE tinyint,
                    @DISCOUNTLIMITAPPLICATIONTYPECODE 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.[DAILYSALEITEMDISCOUNT] set 
                            DISCOUNTID = @DISCOUNTID,
                            DISCOUNTLIMITAPPLICATIONTYPECODE = @DISCOUNTLIMITAPPLICATIONTYPECODE,
                            CHANGEDBYID = @CHANGEAGENTID,
                            DATECHANGED = @CURRENTDATE
                        where ID = @ID

                    end try

                    begin catch
                        exec dbo.USP_RAISE_ERROR
                        return 1
                    end catch

                return 0;