USP_DATAFORMTEMPLATE_EDIT_CURRENTUSERSESSION

The save procedure used by the edit dataform template "Application User Session Edit Data Form".

Parameters

Parameter	Parameter Type	Mode	Description
@CURRENTAPPUSERID	uniqueidentifier	IN	Input parameter indicating the ID of the current user.
@CHANGEAGENTID	uniqueidentifier	IN	Input parameter indicating the ID of the change agent invoking the procedure.
@SESSIONID	uniqueidentifier	IN	Session

Definition

Copy



CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_CURRENTUSERSESSION (
    @CURRENTAPPUSERID uniqueidentifier,
    @CHANGEAGENTID uniqueidentifier = null,
    @SESSIONID uniqueidentifier
)
as

    set nocount on;

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

    declare @CURRENTDATE datetime
    set @CURRENTDATE = getdate()

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

return 0;