USP_DATAFORMTEMPLATE_EDIT_DAILYSALEITEMSCHEDULEDPROGRAM

The save procedure used by the edit dataform template "Daily Sale Item Scheduled Program 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.
@PROGRAMID	uniqueidentifier	IN	Program
@PRICETYPECODEID	uniqueidentifier	IN	Price type
@SCHEDULEOPTIONTYPECODE	tinyint	IN	Time options
@ISACTIVE	bit	IN	Mark button active
@SHOWALLDATES	bit	IN
@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_DAILYSALEITEMSCHEDULEDPROGRAM (
                    @ID uniqueidentifier,
                    @CHANGEAGENTID uniqueidentifier = null,
                    @PROGRAMID uniqueidentifier,
                    @PRICETYPECODEID uniqueidentifier,
                    @SCHEDULEOPTIONTYPECODE tinyint,
                    @ISACTIVE bit,
                    @SHOWALLDATES 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 program record

                        update dbo.[DAILYSALEITEMPROGRAM] set 
                            PROGRAMID = @PROGRAMID,
                            PRICETYPECODEID = @PRICETYPECODEID,
                            SCHEDULEOPTIONTYPECODE = @SCHEDULEOPTIONTYPECODE,
                            SHOWALLDATES = @SHOWALLDATES,
                            CHANGEDBYID = @CHANGEAGENTID,
                            DATECHANGED = @CURRENTDATE
                        where ID = @ID
                    end try
                    begin catch
                        exec dbo.USP_RAISE_ERROR
                        return 1
                    end catch

                return 0;