USP_DATAFORMTEMPLATE_EDIT_NEWCONSTITUENTNAMEFROMASSESSEE

The save procedure used by the edit dataform template "Prospect Quick Search New Constituent From Assessee Name Edit 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.
@FIRSTNAME	nvarchar(100)	IN	First name
@KEYNAME	nvarchar(100)	IN	Last name
@MIDDLENAME	nvarchar(100)	IN	Middle name
@FULLNAME	nvarchar(256)	IN	Full name
@SPOUSE_KEYNAME	nvarchar(100)	IN	Last name
@SPOUSE_FIRSTNAME	nvarchar(100)	IN	First name
@SPOUSE_MIDDLENAME	nvarchar(100)	IN	Middle name
@SPOUSE_RELATIONSHIPTYPECODEID	uniqueidentifier	IN	Relationship type
@SPOUSE_RECIPROCALTYPECODEID	uniqueidentifier	IN	Reciprocal relationship type
@ADDREALESTATERECORD	bit	IN	Add property as asset
@ADDREALESTATESPOUSE	bit	IN	Add property as asset

Definition

Copy


CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_NEWCONSTITUENTNAMEFROMASSESSEE (
    @ID uniqueidentifier,
    @CHANGEAGENTID uniqueidentifier = null,
    @FIRSTNAME nvarchar(100),
    @KEYNAME nvarchar(100),
    @MIDDLENAME nvarchar(100),
    @FULLNAME nvarchar(256),
    @SPOUSE_KEYNAME nvarchar(100),
    @SPOUSE_FIRSTNAME nvarchar(100),
    @SPOUSE_MIDDLENAME nvarchar(100),
    @SPOUSE_RELATIONSHIPTYPECODEID uniqueidentifier,
    @SPOUSE_RECIPROCALTYPECODEID uniqueidentifier,
    @ADDREALESTATERECORD bit,
    @ADDREALESTATESPOUSE bit
)
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.PARTIALINFORMATIONSEARCHRESULT_REALESTATE set
            FIRSTNAME = coalesce(@FIRSTNAME, ''),
            KEYNAME = coalesce(@KEYNAME, ''),
            MIDDLENAME = coalesce(@MIDDLENAME, ''),
            SPOUSE_FIRSTNAME = coalesce(@SPOUSE_FIRSTNAME, ''),
            SPOUSE_KEYNAME = coalesce(@SPOUSE_KEYNAME, ''),
            SPOUSE_MIDDLENAME = coalesce(@SPOUSE_MIDDLENAME, ''),
            SPOUSE_RELATIONSHIPTYPECODEID = @SPOUSE_RELATIONSHIPTYPECODEID,
            SPOUSE_RECIPROCALTYPECODEID = @SPOUSE_RECIPROCALTYPECODEID,
            CHANGEDBYID = @CHANGEAGENTID,
            DATECHANGED = @CURRENTDATE
        where ID = @ID
    end try
    begin catch
        exec dbo.USP_RAISE_ERROR
        return 1
    end catch

return 0;