USP_WPSECURITIESTRANSACTION_ADD

Adds a securities transaction record for a prospect.

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	INOUT
@CHANGEAGENTID	uniqueidentifier	IN
@WPSECURITIESID	uniqueidentifier	IN
@HOLDINGSID	int	IN
@AMOUNT	bigint	IN
@DATEFROM	datetime	IN
@DATETO	datetime	IN
@BB_PRICE	money	IN
@AMOUNTTYPE	nvarchar(50)	IN
@TRANSDESC	nvarchar(100)	IN
@TRANSVALUE	nvarchar(100)	IN
@BB_TRANSVALUE	money	IN
@TRANSTYPE	nvarchar(50)	IN
@CURRENTAPPUSERID	uniqueidentifier	IN
@FULLHASH	nvarchar(32)	IN

Definition

Copy



            CREATE procedure dbo.USP_WPSECURITIESTRANSACTION_ADD (
                @ID uniqueidentifier = null output,
                @CHANGEAGENTID uniqueidentifier = null,
                @WPSECURITIESID uniqueidentifier,
                @HOLDINGSID int = 0,
                @AMOUNT bigint = 0,
                @DATEFROM datetime = null,
                @DATETO datetime = null,
                @BB_PRICE money = 0,
                @AMOUNTTYPE nvarchar(50) = '',
                @TRANSDESC nvarchar(100) = '',
                @TRANSVALUE nvarchar(100) = '',
                @BB_TRANSVALUE money = 0,
                @TRANSTYPE nvarchar(50) = '',
                @CURRENTAPPUSERID uniqueidentifier = null,
                @FULLHASH nvarchar(32) = ''
            ) as begin
                set nocount on;

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

                if @ID is null
                    set @ID = newid();

                begin try
                    if not exists(select 1 from dbo.WPSECURITIESTRANSACTION where WPSECURITIESID = @WPSECURITIESID and FULLHASH = @FULLHASH)
                    begin               
                        insert into dbo.WPSECURITIESTRANSACTION (
                            ID,
                            ADDEDBYID,
                            CHANGEDBYID,
                            WPSECURITIESID,
                            HOLDINGSID,
                            AMOUNT,
                            DATEFROM,
                            DATETO,
                            BB_PRICE,
                            AMOUNTTYPE,
                            TRANSDESC,
                            TRANSVALUE,
                            BB_TRANSVALUE,
                            TRANSTYPE,
                            FULLHASH
                        ) values (
                            @ID,@CHANGEAGENTID,@CHANGEAGENTID,
                            @WPSECURITIESID,
                            coalesce(@HOLDINGSID, 0),
                            coalesce(@AMOUNT, 0),
                            @DATEFROM,
                            @DATETO,
                            coalesce(@BB_PRICE, 0),
                            coalesce(@AMOUNTTYPE, ''),
                            coalesce(@TRANSDESC, ''),
                            coalesce(@TRANSVALUE, ''),
                            coalesce(@BB_TRANSVALUE, 0),
                            coalesce(@TRANSTYPE, ''),
                            coalesce(@FULLHASH, '')
                        );
                    end
                end try
                begin catch
                    exec dbo.USP_RAISE_ERROR;
                    return 1;
                end catch

                return 0;
            end