USP_DATAFORMTEMPLATE_EDIT_DAILYSALEITEMADMISSION

The save procedure used by the edit dataform template "Daily Sale Item Admission 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.
@DAILYADMISSIONPROGRAMID	uniqueidentifier	IN	Program
@PRICETYPECODEID	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
@DESCRIPTIONFIELD3TYPECODE	tinyint	IN

Definition

Copy


                CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_DAILYSALEITEMADMISSION (
                    @ID uniqueidentifier,
                    @CHANGEAGENTID uniqueidentifier = null,
                    @DAILYADMISSIONPROGRAMID uniqueidentifier,
                    @PRICETYPECODEID 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.DAILYSALEITEMPROGRAM set
                            PROGRAMID = @DAILYADMISSIONPROGRAMID,
                            PRICETYPECODEID = @PRICETYPECODEID,
                            CHANGEDBYID = @CHANGEAGENTID,
                            DATECHANGED = @CURRENTDATE
                        where ID = @ID
                    end try
                    begin catch
                        exec dbo.USP_RAISE_ERROR
                        return 1
                    end catch

                return 0;