USP_DATAFORMTEMPLATE_EDIT_EXTENDEDRELATIONSHIP_PFLINKINDTOCONSTIT

The save procedure used by the edit dataform template "Extended Relationship Private Foundation 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
@ADDRESS	nvarchar(100)	IN	Address
@CITY	nvarchar(50)	IN	City
@STATEID	uniqueidentifier	IN	State 1
@ZIP	nvarchar(10)	IN	Zip
@CURRENTAPPUSERID	uniqueidentifier	IN	Input parameter indicating the ID of the current user.
@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
@B_WEBSITE	UDT_WEBADDRESS	IN	Business website
@POSITION	nvarchar(30)	IN	Job title
@INFOSOURCECODEID	uniqueidentifier	IN	Info source code

Definition

Copy



CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_EXTENDEDRELATIONSHIP_PFLINKINDTOCONSTIT (
    @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,
    @ADDRESS nvarchar(100),
    @CITY nvarchar(50),
    @STATEID uniqueidentifier,
    @ZIP nvarchar(10),
    @CURRENTAPPUSERID uniqueidentifier,
    @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),
    @B_WEBSITE dbo.UDT_WEBADDRESS,
    @POSITION nvarchar(30),
    @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_PF_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;