USP_WPGIFT_ADD

Adds Prospect Wealth Philanthropic Gift information for a prospect.

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	INOUT
@CHANGEAGENTID	uniqueidentifier	IN
@WEALTHID	uniqueidentifier	IN
@SOURCE	nvarchar(100)	IN
@WMID	int	IN
@REVISION	int	IN
@ORIGINALID	int	IN
@NEWROW	bit	IN
@LASTCHANGEDON	datetime	IN
@ADDEDON	datetime	IN
@CDATE	datetime	IN
@CVALUE	money	IN
@CNOTES	nvarchar(1024)	IN
@FULLHASH	nvarchar(32)	IN
@PARTIALHASH	nvarchar(32)	IN
@MC	nvarchar(2)	IN
@ORGANIZATION	nvarchar(200)	IN
@LOCATION	nvarchar(100)	IN
@GIFTYEAR	UDT_YEAR	IN
@GIFTRANGE	nvarchar(50)	IN
@TYPE	nvarchar(30)	IN
@CATEGORY	nvarchar(201)	IN
@LO	money	IN
@HI	money	IN
@NAME	nvarchar(200)	IN
@ORGANIZATIONWEBADDRESS	nvarchar(2000)	IN
@SOURCEMATERIAL	nvarchar(2000)	IN
@GIFTYEARHI	UDT_YEAR	IN
@GIFTYEARLO	UDT_YEAR	IN
@TYPECODE	int	IN
@EIN	nvarchar(50)	IN

Definition

Copy



            create procedure dbo.USP_WPGIFT_ADD (
                @ID uniqueidentifier = null output,
                @CHANGEAGENTID uniqueidentifier = null,
                @WEALTHID uniqueidentifier,
                @SOURCE nvarchar(100),
                @WMID int = 0,
                @REVISION int = 0,
                @ORIGINALID int = 0,
                @NEWROW bit = 0,
                @LASTCHANGEDON datetime = null,
                @ADDEDON datetime = null,
                @CDATE datetime = null,
                @CVALUE money = 0,
                @CNOTES nvarchar(1024) = '',
                @FULLHASH nvarchar(32) = '',
                @PARTIALHASH nvarchar(32) = '',
                @MC nvarchar(2) = '',
                @ORGANIZATION nvarchar(200) = '',
                @LOCATION nvarchar(100) = '',
                @GIFTYEAR dbo.UDT_YEAR = 0,
                @GIFTRANGE nvarchar(50) = '',
                @TYPE nvarchar(30) = '',
                @CATEGORY nvarchar(201) = '',
                @LO money = 0,
                @HI money = 0,
                @NAME nvarchar(200) = '',
                @ORGANIZATIONWEBADDRESS nvarchar(2000) = '',
                @SOURCEMATERIAL nvarchar(2000) = '',
                @GIFTYEARHI dbo.UDT_YEAR = 0,
                @GIFTYEARLO dbo.UDT_YEAR = 0,
                @TYPECODE int = 0,
                @EIN nvarchar(50) = ''
            ) as begin

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

                begin try

                    if exists(select 1 from dbo.WPGIFT where WEALTHID=@WEALTHID and FULLHASH=@FULLHASH) 

                        set @ID = null;

                    else begin

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

                        insert into dbo.WPGIFT (
                            ID,ADDEDBYID,CHANGEDBYID,
                            WEALTHID,
                            SOURCE,
                            WMID,
                            REVISION,
                            ORIGINALID,
                            NEWROW,
                            LASTCHANGEDON,
                            ADDEDON,
                            CDATE,
                            CVALUE,
                            CNOTES,
                            FULLHASH,
                            PARTIALHASH,
                            MC,
                            ORGANIZATION,
                            LOCATION,
                            GIFTYEAR,
                            GIFTRANGE,
                            TYPE,
                            CATEGORY,
                            LO,
                            HI,
                            NAME,
                            ORGANIZATIONWEBADDRESS,
                            SOURCEMATERIAL,
                            GIFTYEARHI,
                            GIFTYEARLO,
                            TYPECODE,
                            EIN
                        ) values (
                            @ID,@CHANGEAGENTID,@CHANGEAGENTID,
                            @WEALTHID,
                            @SOURCE,
                            @WMID,
                            @REVISION,
                            @ORIGINALID,
                            @NEWROW,
                            @LASTCHANGEDON,
                            @ADDEDON,
                            @CDATE,
                            @CVALUE,
                            @CNOTES,
                            @FULLHASH,
                            @PARTIALHASH,
                            @MC,
                            @ORGANIZATION,
                            @LOCATION,
                            @GIFTYEAR,
                            @GIFTRANGE,
                            @TYPE,
                            @CATEGORY,
                            @LO,
                            @HI,
                            @NAME,
                            @ORGANIZATIONWEBADDRESS,
                            @SOURCEMATERIAL,
                            @GIFTYEARHI,
                            @GIFTYEARLO,
                            @TYPECODE,
                            @EIN
                        );
                    end;

                end try
                begin catch
                    exec dbo.USP_RAISE_ERROR;
                end catch

                return 0;
            end;