USP_VOLUNTEER_MARKACTIVE

Executes the "Volunteer: Mark Active" record operation.
Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN	Input parameter indicating the ID of the record being updated.
@CHANGEAGENTID	uniqueidentifier	IN	Input parameter indicating the ID of the change agent invoking the update.
Definition

Copy


                    create procedure dbo.USP_VOLUNTEER_MARKACTIVE
                    (
                    @ID uniqueidentifier,
                    @CHANGEAGENTID uniqueidentifier
                    )
                    as
                        set nocount on;

                        declare @CURRENTDATE datetime;
                        set @CURRENTDATE = getdate();

                        declare @CURRENTDATEEARLIESTTIME datetime;
                        set @CURRENTDATEEARLIESTTIME = dbo.UFN_DATE_GETEARLIESTTIME(@CURRENTDATE);

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

                        declare @contextCache varbinary(128);
                        /* cache current context information */
                        set @contextCache = CONTEXT_INFO();
                        /* set CONTEXT_INFO to @CHANGEAGENTID */
                        if not @CHANGEAGENTID is null
                            set CONTEXT_INFO @CHANGEAGENTID

                        delete
                            dbo.VOLUNTEERDATERANGE
                        where
                            CONSTITUENTID = @ID and
                            (DATEFROM >= @CURRENTDATEEARLIESTTIME or DATETO is null);

                        /* reset CONTEXT_INFO to previous value */
                        if not @contextCache is null
                            set CONTEXT_INFO @contextCache

                        insert into dbo.VOLUNTEERDATERANGE
                        (
                            CONSTITUENTID,
                            DATEFROM,
                            DATETO,
                            ADDEDBYID,
                            CHANGEDBYID,
                            DATEADDED,
                            DATECHANGED
                        )
                        values
                        (
                            @ID,
                            @CURRENTDATEEARLIESTTIME,
                            null,
                            @CHANGEAGENTID,
                            @CHANGEAGENTID,
                            @CURRENTDATE,
                            @CURRENTDATE
                        );

                        if not exists (select 1 from dbo.VOLUNTEER where ID=@ID)
                            insert into dbo.VOLUNTEER (
                                ID,
                                ADDEDBYID,
                                CHANGEDBYID,
                                DATEADDED,
                                DATECHANGED
                            ) values (
                                @ID,
                                @CHANGEAGENTID,
                                @CHANGEAGENTID,
                                @CURRENTDATE,
                                @CURRENTDATE
                            );

                        return 0;

                        return 0;