USP_DATAFORMTEMPLATE_EDITSAVE_OTHERASSET

The save procedure used by the edit dataform template "WealthPoint Other Asset 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.
@SOURCE	nvarchar(100)	IN	Source
@DESCRIPTION	nvarchar(100)	IN	Description
@VALUE	money	IN	Value
@NOTES	nvarchar(1024)	IN	Notes

Definition

Copy



                    CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDITSAVE_OTHERASSET (
                        @ID uniqueidentifier,
                        @CHANGEAGENTID uniqueidentifier = null,
                        @SOURCE nvarchar(100),
                        @DESCRIPTION nvarchar(100),
                        @VALUE money,
                        @NOTES nvarchar(1024)
                    ) as begin

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

            declare @CURRENTDATE datetime = getdate();

            --wealth source updates

            if(select
                            count(WEALTHSOURCE.SOURCE)
                        from
                            dbo.WEALTHSOURCE 
            where SOURCE = @SOURCE
                        ) = 0
                        begin
                            insert into dbo.WEALTHSOURCE (
                                [SOURCE],
                                [ISBUILTIN],
                                [ADDEDBYID],
                                [CHANGEDBYID]
                            )values(
                                @SOURCE,
                                0,
                                @CHANGEAGENTID,
                                @CHANGEAGENTID
                            );
            end 

            if(
            not exists (select top 1 1 from dbo.WEALTHCAPACITYFORMULAOTHERASSETSOURCE where SOURCE = @SOURCE)
              and
            not exists (select top 1 1 from dbo.WPOTHERASSET where SOURCE = @SOURCE)
            )
            begin
            insert into WEALTHCAPACITYFORMULAOTHERASSETSOURCE(                
              WEALTHCAPACITYFORMULAID,
              [SOURCE],
              [ADDEDBYID],
              [CHANGEDBYID],
              [DATEADDED],
              [DATECHANGED]
            )
            select 
              ID,
              @SOURCE,
              @CHANGEAGENTID,
              @CHANGEAGENTID,
              @CURRENTDATE,
              @CURRENTDATE
              from WEALTHCAPACITYFORMULA;
                        end  

                        update dbo.WPOTHERASSET set
                            CHANGEDBYID = @CHANGEAGENTID,
                            DATECHANGED = @CURRENTDATE,
                            SOURCE = @SOURCE,
                            DESCRIPTION = @DESCRIPTION,
                            VALUE = @VALUE,
                            NOTES = @NOTES
                        where
                            ID=@ID;

                        declare @WEALTHID uniqueidentifier;
                        select @WEALTHID=WEALTHID from dbo.WPOTHERASSET where ID=@ID;

                        exec dbo.USP_WEALTHPOINT_UPDATEWEALTHSUMMARY_OTHERASSET @WEALTHID, @CHANGEAGENTID;
                        exec dbo.USP_WEALTHCAPACITY_UPDATE @WEALTHID, @CHANGEAGENTID;

                        return 0;

                    end;