USP_DATAFORMTEMPLATE_EDIT_ASSIGNMENTATTACHMENT

The save procedure used by the edit dataform template "Assignment Attachment Edit 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.
@TITLE	nvarchar(50)	IN	Title
@FILE	varbinary	IN	File
@FILENAME	nvarchar(255)	IN	File
@DISPLAYEDFILENAME	nvarchar(255)	IN	File
@FILECHANGED	bit	IN	File changed?

Definition

Copy



                CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_ASSIGNMENTATTACHMENT
                (
                    @ID uniqueidentifier,
                    @CHANGEAGENTID uniqueidentifier = null,
                    @TITLE nvarchar(50),
                    @FILE varbinary(max),
                    @FILENAME nvarchar(255),
                    @DISPLAYEDFILENAME nvarchar(255),
                    @FILECHANGED bit
                )
                as
                    set nocount on;

                    declare @CURRENTDATE datetime;

                    begin try
                        if @CHANGEAGENTID is null  
                            exec dbo.USP_CHANGEAGENT_GETORCREATECHANGEAGENT @CHANGEAGENTID output;

                        set @CURRENTDATE = getdate();

                        if @FILECHANGED = 1
                            update
                                dbo.[ASSIGNMENTATTACHMENT]
                            set
                                [TITLE] = @TITLE,
                                [FILE] = @FILE,
                                [FILENAME] = @DISPLAYEDFILENAME,
                                [CHANGEDBYID] = @CHANGEAGENTID,
                                [DATECHANGED] = @CURRENTDATE
                            where
                                [ID] = @ID;
                        else
                            update
                                dbo.[ASSIGNMENTATTACHMENT]
                            set
                                [TITLE] = @TITLE,
                                [CHANGEDBYID] = @CHANGEAGENTID,
                                [DATECHANGED] = @CURRENTDATE
                            where
                                [ID] = @ID;
                    end try

                    begin catch
                        exec dbo.USP_RAISE_ERROR;
                        return 1;
                    end catch

                    return 0;