USP_DATAFORMTEMPLATE_EDIT_EVENTTASKALERTAPPUSERSETTINGS

The save procedure used by the edit dataform template "Event Task Application User Settings 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.
@SENDTASKREMINDERS	bit	IN	Send me an alert for task reminders
@EMAILADDRESS	UDT_EMAILADDRESS	IN	Send email alerts to

Definition

Copy



CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_EVENTTASKALERTAPPUSERSETTINGS (
    @ID uniqueidentifier,
    @CHANGEAGENTID uniqueidentifier = null,
    @SENDTASKREMINDERS bit,
    @EMAILADDRESS dbo.UDT_EMAILADDRESS
)
as

    set nocount on;

    if @CHANGEAGENTID is null  
        exec dbo.USP_CHANGEAGENT_GETORCREATECHANGEAGENT @CHANGEAGENTID output

    declare @CURRENTDATE datetime
    set @CURRENTDATE = getdate()

    begin try
        exec dbo.USP_APPUSERALERTTYPESETTING_CREATEORUPDATE @ID, '02863BF9-BA85-481E-8AA0-CC60758C6789', @SENDTASKREMINDERS, @CHANGEAGENTID;

        if exists(select top(1) ID from dbo.APPUSERALERTSETTING where ID = @ID)
            update
                dbo.APPUSERALERTSETTING
            set
                EMAILADDRESS = @EMAILADDRESS
                , CHANGEDBYID = @CHANGEAGENTID
                , DATECHANGED = @CURRENTDATE
            where
                ID = @ID
        else
            insert into dbo.APPUSERALERTSETTING (
                ID
                , EMAILADDRESS
                , ADDEDBYID
                , CHANGEDBYID
                , DATECHANGED
                , DATEADDED
            ) values (
                @ID
                , @EMAILADDRESS
                , @CHANGEAGENTID
                , @CHANGEAGENTID
                , @CURRENTDATE
                , @CURRENTDATE
            )
    end try
    begin catch
        exec dbo.USP_RAISE_ERROR
        return 1
    end catch

    return 0;