USP_DATAFORMTEMPLATE_EDIT_ADVOCACY_CUSTOM

The save procedure used by the edit dataform template "Advocacy Custom 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.
@CUSTOMID	int	IN	Customid
@FIRSTNAME	nvarchar(100)	IN	Firstname
@LASTNAME	nvarchar(100)	IN	Lastname
@MIDDLENAME	nvarchar(20)	IN	Middlename
@ORGANIZATION	nvarchar(100)	IN	Organization
@ADDRESSBLOCK	nvarchar(150)	IN	Addressblock
@CITY	nvarchar(50)	IN	City
@STATEID	uniqueidentifier	IN	State
@COUNTRYID	uniqueidentifier	IN	Country
@ZIP	nvarchar(10)	IN	Zip
@PHONE	nvarchar(20)	IN	Phone
@FAX	nvarchar(20)	IN	Fax
@EMAIL	nvarchar(255)	IN	Email
@ADDRESSBLOCKOVERRIDE	nvarchar(1000)	IN	Addressblockoverride
@TITLE	nvarchar(20)	IN	Title
@SALUATIONOVERRIDE	nvarchar(200)	IN	Fax

Definition

Copy



CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_ADVOCACY_CUSTOM
(
    @ID uniqueidentifier,
    @CHANGEAGENTID uniqueidentifier = null,
    @CUSTOMID int,
    @FIRSTNAME nvarchar(100),
    @LASTNAME nvarchar(100),
    @MIDDLENAME nvarchar(20),
    @ORGANIZATION nvarchar(100),
    @ADDRESSBLOCK nvarchar(150),
    @CITY nvarchar(50),
    @STATEID uniqueidentifier,
    @COUNTRYID uniqueidentifier,
    @ZIP nvarchar(10),
    @PHONE nvarchar(20),
    @FAX nvarchar(20),
    @EMAIL nvarchar(255),
    @ADDRESSBLOCKOVERRIDE nvarchar(1000),
    @TITLE nvarchar(20) ,
    @SALUATIONOVERRIDE nvarchar(200)
)
as

    set nocount on;

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

    begin try
        -- handle updating the data

        update dbo.ADVOCACY_CUSTOM set
            CUSTOMID = @CUSTOMID,
            FIRSTNAME = @FIRSTNAME,
            LASTNAME = @LASTNAME,
            MIDDLENAME = @MIDDLENAME,
            ORGANIZATION = @ORGANIZATION,
            ADDRESSBLOCK = @ADDRESSBLOCK,
            CITY = @CITY,
            STATEID = @STATEID,
            COUNTRYID = @COUNTRYID,
            ZIP = @ZIP,
            PHONE = @PHONE,
            FAX = @FAX,
            EMAIL = @EMAIL,
            ADDRESSBLOCKOVERRIDE = @ADDRESSBLOCKOVERRIDE,
            TITLE = @TITLE,
            SALUATIONOVERRIDE =@SALUATIONOVERRIDE,
            CHANGEDBYID = @CHANGEAGENTID,
            DATECHANGED = getdate()
        where ID = @ID
    end try
    begin catch
        exec dbo.USP_RAISE_ERROR
        return 1
    end catch

return 0;