USP_DATAFORMTEMPLATE_EDIT_STEWARDSHIPMEDIALINK

The save procedure used by the edit dataform template "Stewardship Plan Media Link 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
@MEDIAURL	UDT_WEBADDRESS	IN	Media URL
@AUTHORID	uniqueidentifier	IN	Author
@MEDIALINKTYPECODEID	uniqueidentifier	IN	Type

Definition

Copy



CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_STEWARDSHIPMEDIALINK
    (
    @ID uniqueidentifier,
    @CHANGEAGENTID uniqueidentifier = null,
    @DATEENTERED datetime, 
    @TITLE nvarchar(50),
    @MEDIAURL dbo.UDT_WEBADDRESS,
    @AUTHORID uniqueidentifier,
    @MEDIALINKTYPECODEID uniqueidentifier
    )
as
    set nocount on;

    declare @CURRENTDATE datetime;

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

        set @CURRENTDATE = getdate();

        update
            dbo.[STEWARDSHIPMEDIALINK]
        set [DATEENTERED] = @DATEENTERED,
            [TITLE] = @TITLE,
            [MEDIAURL] = @MEDIAURL,
            [AUTHORID] = @AUTHORID,
            [STEWARDSHIPMEDIALINKTYPECODEID] = @MEDIALINKTYPECODEID,
            [CHANGEDBYID] = @CHANGEAGENTID,
            [DATECHANGED] = @CURRENTDATE
        where
            [ID] = @ID;
    end try

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

    return 0;