USP_DATAFORMTEMPLATE_EDIT_STEWARDSHIPATTACHMENT

The save procedure used by the edit dataform template "Stewardship Plan 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.
@DATEENTERED	datetime	IN	Date
@TITLE	nvarchar(50)	IN	Title
@AUTHORID	uniqueidentifier	IN	Author
@ATTACHMENTTYPECODEID	uniqueidentifier	IN	Type
@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_STEWARDSHIPATTACHMENT
(
@ID uniqueidentifier,
@CHANGEAGENTID uniqueidentifier = null,
@DATEENTERED datetime, 
@TITLE nvarchar(50),
@AUTHORID uniqueidentifier,
@ATTACHMENTTYPECODEID uniqueidentifier,
@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.[STEWARDSHIPATTACHMENT]
        set
            [DATEENTERED] = @DATEENTERED,
            [TITLE] = @TITLE,
            [AUTHORID] = @AUTHORID,
            [STEWARDSHIPATTACHMENTTYPECODEID] = @ATTACHMENTTYPECODEID,
            [FILE] = @FILE,
            [FILENAME] = @DISPLAYEDFILENAME,
            [CHANGEDBYID] = @CHANGEAGENTID,
            [DATECHANGED] = @CURRENTDATE
        where
            [ID] = @ID;
    else
        update
            dbo.[STEWARDSHIPATTACHMENT]
        set
            [DATEENTERED] = @DATEENTERED,
            [TITLE] = @TITLE,
            [AUTHORID] = @AUTHORID,
            [STEWARDSHIPATTACHMENTTYPECODEID] = @ATTACHMENTTYPECODEID,
            [CHANGEDBYID] = @CHANGEAGENTID,
            [DATECHANGED] = @CURRENTDATE
        where
            [ID] = @ID;
end try

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

return 0;