USP_DATAFORMTEMPLATE_EDIT_ADDRESSBOOKFAF

The save procedure used by the edit dataform template "AddressBookFAF 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(255)	IN	Firstname
@LASTNAME	nvarchar(255)	IN	Lastname
@MIDDLENAME	nvarchar(100)	IN	Middlename
@TITLECODEID	uniqueidentifier	IN	Title
@SALUTATION	nvarchar(255)	IN	Salutation
@EMAILADDRESS	UDT_EMAILADDRESS	IN	Emailaddress
@HOMEPHONE	nvarchar(25)	IN	Homephone
@CELLPHONE	nvarchar(25)	IN	Cellphone
@ADDRESSBLOCK	nvarchar(300)	IN	Addressblock
@CITY	nvarchar(100)	IN	City
@STATEID	uniqueidentifier	IN	State
@COUNTRYID	uniqueidentifier	IN	Country
@POSTCODE	nvarchar(24)	IN	Postcode
@PREFERREDCOMMUNICATIONCODE	tinyint	IN	Preferredcommunication
@CONSTITUENTID	uniqueidentifier	IN	Constituent ID
@BUSINESSPHONE	nvarchar(25)	IN	Business phone
@BUSINESSADDRESS	nvarchar(300)	IN	Business address
@SECONDARYEMAILADDRESS	UDT_EMAILADDRESS	IN	Secondary Email address
@SECONDARYCITY	nvarchar(100)	IN	Secondary City
@SECONDARYSTATEID	uniqueidentifier	IN	Secondary State
@SECONDARYPOSTCODE	nvarchar(24)	IN	Secondary PostCode
@SECONDARYCOUNTRYID	uniqueidentifier	IN	Secondary Country
@COMPANYNAME	nvarchar(255)	IN	Company name
@NOTES	nvarchar(1000)	IN	Notes

Definition

Copy



CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_ADDRESSBOOKFAF
(
    @ID uniqueidentifier,
    @CHANGEAGENTID uniqueidentifier = null,
    @FIRSTNAME nvarchar(255),
    @LASTNAME nvarchar(255),
    @MIDDLENAME nvarchar(100),
    @TITLECODEID uniqueidentifier,
    @SALUTATION nvarchar(255),
    @EMAILADDRESS dbo.UDT_EMAILADDRESS,
    @HOMEPHONE nvarchar(25),
    @CELLPHONE nvarchar(25),
    @ADDRESSBLOCK nvarchar(300),
    @CITY nvarchar(100),
    @STATEID uniqueidentifier,
    @COUNTRYID uniqueidentifier,
    @POSTCODE nvarchar(24),
    @PREFERREDCOMMUNICATIONCODE tinyint

    , @CONSTITUENTID uniqueidentifier 
    , @BUSINESSPHONE nvarchar(25)
    , @BUSINESSADDRESS nvarchar(300)
    , @SECONDARYEMAILADDRESS dbo.UDT_EMAILADDRESS

    , @SECONDARYCITY nvarchar(100) 
    , @SECONDARYSTATEID uniqueidentifier  
    , @SECONDARYPOSTCODE nvarchar(24)  
    , @SECONDARYCOUNTRYID uniqueidentifier  

  , @COMPANYNAME nvarchar(255)
  , @NOTES nvarchar(1000)

)
as
    set nocount on;

  DECLARE @ClientUserID int

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

    begin try
        -- handle updating the data

        update dbo.ADDRESSBOOKFAF set
            FIRSTNAME = @FIRSTNAME,
            LASTNAME = @LASTNAME,
            MIDDLENAME = @MIDDLENAME,
            TITLECODEID = @TITLECODEID,
            SALUTATION = @SALUTATION,
            EMAILADDRESS = @EMAILADDRESS,
            HOMEPHONE = @HOMEPHONE,
            CELLPHONE = @CELLPHONE,
            ADDRESSBLOCK = @ADDRESSBLOCK,
            CITY = @CITY,
            STATEID = @STATEID,
            COUNTRYID = @COUNTRYID,
            POSTCODE = @POSTCODE,
            PREFERREDCOMMUNICATIONCODE = @PREFERREDCOMMUNICATIONCODE,

            CONSTITUENTID = @CONSTITUENTID, 
            BUSINESSPHONE = @BUSINESSPHONE, 
            BUSINESSADDRESS = @BUSINESSADDRESS, 
            SECONDARYEMAILADDRESS = @SECONDARYEMAILADDRESS,

            SECONDARYCITY = @SECONDARYCITY, 
            SECONDARYSTATEID = @SECONDARYSTATEID, 
            SECONDARYPOSTCODE = @SECONDARYPOSTCODE, 
            SECONDARYCOUNTRYID = @SECONDARYCOUNTRYID,

      COMPANYNAME = @COMPANYNAME, 
      NOTES = @NOTES, 

            CHANGEDBYID = @CHANGEAGENTID,
            DATECHANGED = getdate()
        where ID = @ID

    -- update addressbook id

    Select @ClientUserID = ClientUsersid from AddressBookFAF Where ID = @ID

    Update FAFCOMMUNICATIONSLOG set AddressbookID = @ID 
       where EMAILADDRESS = @EMAILADDRESS and ClientUsersid = @ClientUserID
    end try
    begin catch
        exec dbo.USP_RAISE_ERROR
        return 1
    end catch

return 0;