USP_WEALTHPOINT_UPDATEACCOUNTSTATUS

Updates WealthPoint configuration with the account status.
Parameters

Parameter	Parameter Type	Mode
@CHANGEAGENTID	uniqueidentifier	IN
@REGISTERED	bit	IN
@ACCOUNTTYPECODE	int	IN
@SOCIALENABLED	bit	IN
Definition

Copy


            CREATE procedure dbo.USP_WEALTHPOINT_UPDATEACCOUNTSTATUS (
                @CHANGEAGENTID uniqueidentifier = null,
                @REGISTERED bit,
                @ACCOUNTTYPECODE integer,
        @SOCIALENABLED bit = 0
            ) as begin
                set nocount on;

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

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

                declare @WEALTHPOINTCONFIGURATIONID uniqueidentifier;
                select top 1
                    @WEALTHPOINTCONFIGURATIONID = WEALTHPOINTCONFIGURATION.ID
                from
                    dbo.WEALTHPOINTCONFIGURATION;

                if @WEALTHPOINTCONFIGURATIONID is not null begin
                    update
                        dbo.WEALTHPOINTCONFIGURATION
                    set
                        REGISTERED = @REGISTERED,
                        ACCOUNTTYPECODE = @ACCOUNTTYPECODE,
            SOCIALENABLED = @SOCIALENABLED,
                        CHANGEDBYID = @CHANGEAGENTID,
                        DATECHANGED = @CURRENTDATE
                    where
                        ID = @WEALTHPOINTCONFIGURATIONID;
                end
                else begin
                    insert into dbo.WEALTHPOINTCONFIGURATION (
                        REGISTERED,
                        ACCOUNTTYPECODE,
            SOCIALENABLED,
                        ADDEDBYID,
                        CHANGEDBYID,
                        DATEADDED,
                        DATECHANGED
                    )
                    values (
                        @REGISTERED,
                        @ACCOUNTTYPECODE,
            @SOCIALENABLED,
                        @CHANGEAGENTID,
                        @CHANGEAGENTID,
                        @CURRENTDATE,
                        @CURRENTDATE
                    );
                end

                return 0;
            end;