USP_DATAFORMTEMPLATE_VIEW_PEOPLELINKCONTACT

The load procedure used by the view dataform template "PeopleFinder Contact View Form"

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN	The input ID parameter used to load the fields defined on the form.
@DATALOADED	bit	INOUT	Output parameter indicating whether or not data was actually loaded.
@ORGNAME	nvarchar(150)	INOUT	Organization
@SOURCE	nvarchar(150)	INOUT	Source
@FULLNAME	nvarchar(150)	INOUT	Name
@RELATIONSHIP	nvarchar(150)	INOUT	Relationship
@ADDRESS	nvarchar(300)	INOUT	Address
@TICKER	nvarchar(150)	INOUT	Ticker symbol

Definition

Copy



                CREATE procedure dbo.USP_DATAFORMTEMPLATE_VIEW_PEOPLELINKCONTACT (
                    @ID uniqueidentifier,
                    @DATALOADED bit = 0 output,
                    @ORGNAME nvarchar(150) = null output,
                    @SOURCE nvarchar(150) = null output,
                    @FULLNAME nvarchar(150) = null output,
                    @RELATIONSHIP nvarchar(150) = null output,
                    @ADDRESS nvarchar(300) = null output,
                    @TICKER nvarchar(150) = null output
                ) as begin

                    set nocount on;

                    set @DATALOADED = 0;

                    declare @ADDRESSBLOCK nvarchar(150);
                    declare @CITY nvarchar(50);
                    declare @STATEABBREVIATION nvarchar(2);
                    declare @POSTCODE nvarchar(10);

                    select
                        @DATALOADED = 1,
                        @ORGNAME = PFO.ORGNAME,
                        @SOURCE = PFO.SOURCE,
                        @FULLNAME = PFC.FULLNAME,
                        @RELATIONSHIP = PFC.RELATIONSHIP,
                        @ADDRESSBLOCK = PFO.LINE1,
                        @CITY = PFO.CITY,
                        @STATEABBREVIATION = PFO.STATE,
                        @POSTCODE = PFO.ZIP,
                        @TICKER = PFO.TICKER
                    from
                        dbo.PEOPLELINKCONTACT PFC
                        inner join dbo.PEOPLELINKORGANIZATION PFO on PFO.ID=PFC.PEOPLELINKORGANIZATIONID
                    where
                        PFC.ID=@ID;

                    -- Build the address string


                    set @ADDRESS = '';

                    if len(@ADDRESSBLOCK) > 0
                        set @ADDRESS = @ADDRESSBLOCK;

                    if len(@ADDRESSBLOCK) > 0 and (len(@CITY) > 0 or len(@STATEABBREVIATION) > 0 or len(@POSTCODE) > 0)
                        set @ADDRESS = @ADDRESS + NCHAR(13) + NCHAR(10);

                    if len(@CITY) > 0
                        set @ADDRESS = @ADDRESS + @CITY;

                    if len(@CITY) > 0 and (len(@STATEABBREVIATION) > 0 or len(@POSTCODE) > 0)
                        set @ADDRESS = @ADDRESS + NCHAR(44) + NCHAR(32);

                    if len(@STATEABBREVIATION) > 0
                        set @ADDRESS = @ADDRESS + @STATEABBREVIATION;

                    if (len(@CITY) > 0 or len(@STATEABBREVIATION) > 0) and len(@POSTCODE) > 0
                        set @ADDRESS = @ADDRESS + NCHAR(32)

                    if len(@STATEABBREVIATION) > 0 and len(@POSTCODE) > 0
                        set @ADDRESS = @ADDRESS + NCHAR(32)

                    if len(@POSTCODE) > 0
                        set @ADDRESS = @ADDRESS + @POSTCODE;

                    return 0;

                end;