USP_DATAFORMTEMPLATE_EDIT_EXTENDEDRELATIONSHIP_BOLINKINDTOCONSTIT

The save procedure used by the edit dataform template "Extended Relationship Business Ownership Link Individual To Constituent Edit Data 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.
@CONSTITUENTID	uniqueidentifier	IN	Related individual
@LASTNAME	nvarchar(100)	IN	Last name
@FIRSTNAME	nvarchar(50)	IN	First name
@MIDDLENAME	nvarchar(50)	IN	Middle name
@SUFFIXCODEID	uniqueidentifier	IN	Suffix
@TITLECODEID	uniqueidentifier	IN	Title
@YEAROFBIRTH	UDT_YEAR	IN	Year of birth
@GENDERCODE	tinyint	IN	Gender
@ADDRESS1	nvarchar(100)	IN	Address 1
@CITY1	nvarchar(50)	IN	City 1
@STATEID1	uniqueidentifier	IN	State 1
@ZIP1	nvarchar(10)	IN	Zip 1
@ADDRESS2	nvarchar(100)	IN	Address 2
@CITY2	nvarchar(50)	IN	City 2
@STATEID2	uniqueidentifier	IN	State 2
@ZIP2	nvarchar(10)	IN	Zip 2
@B_ADDRESS	nvarchar(100)	IN	Business address
@B_CITY	nvarchar(50)	IN	Business city
@B_STATEID	uniqueidentifier	IN	Business state
@B_ZIP	nvarchar(10)	IN	Business zip
@B_ID	uniqueidentifier	IN	Business ID
@B_NAME	nvarchar(100)	IN	Business name
@B_PHONE	nvarchar(20)	IN	Business phone
@POSITION	nvarchar(30)	IN	Job title
@CONSTITUENTNAME	nvarchar(200)	IN	Name
@INFOSOURCECODEID	uniqueidentifier	IN	Info source code

Definition

Copy



CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_EXTENDEDRELATIONSHIP_BOLINKINDTOCONSTIT (
    @ID uniqueidentifier,
    @CHANGEAGENTID uniqueidentifier = null,
    @CONSTITUENTID uniqueidentifier,
    @LASTNAME nvarchar(100),
    @FIRSTNAME nvarchar(50),
    @MIDDLENAME nvarchar(50),
    @SUFFIXCODEID uniqueidentifier,
    @TITLECODEID uniqueidentifier,
    @YEAROFBIRTH dbo.UDT_YEAR,
    @GENDERCODE tinyint,
    @ADDRESS1 nvarchar(100),
    @CITY1 nvarchar(50),
    @STATEID1 uniqueidentifier,
    @ZIP1 nvarchar(10),
    @ADDRESS2 nvarchar(100),
    @CITY2 nvarchar(50),
    @STATEID2 uniqueidentifier,
    @ZIP2 nvarchar(10),
    @B_ADDRESS nvarchar(100),
    @B_CITY nvarchar(50),
    @B_STATEID uniqueidentifier,
    @B_ZIP nvarchar(10),
    @B_ID uniqueidentifier,
    @B_NAME nvarchar(100),
    @B_PHONE nvarchar(20),
    @POSITION nvarchar(30),
    @CONSTITUENTNAME nvarchar(200),
    @INFOSOURCECODEID uniqueidentifier
)
as

    set nocount on;

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

    declare @CURRENTDATE datetime
    set @CURRENTDATE = getdate()

    begin try
        -- handle updating the data

        update dbo.WPRELATIONSHIP_BO_IND set
            CONSTITUENTID = @CONSTITUENTID,
            CHANGEDBYID = @CHANGEAGENTID,
            DATECHANGED = @CURRENTDATE
        where 
            ID = @ID

    end try
    begin catch
        exec dbo.USP_RAISE_ERROR
        return 1
    end catch

return 0;