USP_DATAFORMTEMPLATE_ADD_ADDRESSBOOKFAF

The save procedure used by the add dataform template "AddressBookFAF Add Form".

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	INOUT	The output parameter indicating the ID of the record added.
@CLIENTUSERSID	int	IN	Client users ID
@CHANGEAGENTID	uniqueidentifier	IN	Input parameter indicating the ID of the change agent invoking the procedure.
@FIRSTNAME	nvarchar(255)	IN	First name
@MIDDLENAME	nvarchar(100)	IN	Middle name
@LASTNAME	nvarchar(255)	IN	Last name
@PREFERREDCOMMUNICATIONCODE	tinyint	IN	Preferred communication
@SALUTATION	nvarchar(255)	IN	Salutation
@EMAILADDRESS	UDT_EMAILADDRESS	IN	Email address
@ADDRESSBLOCK	nvarchar(300)	IN	Address block
@CITY	nvarchar(100)	IN	City
@STATEID	uniqueidentifier	IN	State
@POSTCODE	nvarchar(24)	IN	PostCode
@COUNTRYID	uniqueidentifier	IN	Country
@CELLPHONE	nvarchar(25)	IN	Cell phone
@TEXTMESSAGESEND	bit	IN	Text Message Send
@HOMEPHONE	nvarchar(25)	IN	Home phone
@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
@STATEDESCRIPTION	nvarchar(100)	IN	State Description
@STATEABBREVIATION	nvarchar(5)	IN	State Abbreviation
@COUNTRYDESCRIPTION	nvarchar(100)	IN	Country Description
@COUNTRYABBREVIATION	nvarchar(5)	IN	Country Abbreviation
@SECONDARYSTATEDESCRIPTION	nvarchar(100)	IN	Secondary State Description
@SECONDARYSTATEABBREVIATION	nvarchar(5)	IN	Secondary State Abbreviation
@SECONDARYCOUNTRYDESCRIPTION	nvarchar(100)	IN	Secondary Country Description
@SECONDARYCOUNTRYABBREVIATION	nvarchar(5)	IN	Secondary Country Abbreviation

Definition

Copy



CREATE procedure dbo.USP_DATAFORMTEMPLATE_ADD_ADDRESSBOOKFAF
(

@ID uniqueidentifier = null output,
@CLIENTUSERSID int,
@CHANGEAGENTID uniqueidentifier = null,
--@CONTACTTYPECODE tinyint = 1,

@FIRSTNAME nvarchar(255) = '',
@MIDDLENAME nvarchar(100) = '',
@LASTNAME nvarchar(255) = '',
@PREFERREDCOMMUNICATIONCODE tinyint = 1,
@SALUTATION nvarchar(255)= '',
@EMAILADDRESS dbo.UDT_EMAILADDRESS = null,
@ADDRESSBLOCK nvarchar(300)= '',
@CITY nvarchar(100) = '',
@STATEID uniqueidentifier= null,
@POSTCODE nvarchar(24) = '',
@COUNTRYID uniqueidentifier= null,
@CELLPHONE nvarchar(25)= '',
@TEXTMESSAGESEND bit= 0,
@HOMEPHONE nvarchar(25) = ''

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

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

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

, @STATEDESCRIPTION nvarchar(100) = ''
, @STATEABBREVIATION nvarchar(5) = ''
, @COUNTRYDESCRIPTION nvarchar(100) = ''
, @COUNTRYABBREVIATION nvarchar(5) = ''

, @SECONDARYSTATEDESCRIPTION nvarchar(100) = ''
, @SECONDARYSTATEABBREVIATION nvarchar(5) = ''
, @SECONDARYCOUNTRYDESCRIPTION nvarchar(100) = ''
, @SECONDARYCOUNTRYABBREVIATION nvarchar(5) = ''
)
as

set nocount on;

if @ID is null
set @ID = newid()

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

declare @CURRENTDATE datetime
set @CURRENTDATE = getdate()

IF @STATEID   IS NULL   SELECT @STATEID=    ID  FROM STATE    WHERE DESCRIPTION= @STATEDESCRIPTION   OR ABBREVIATION= @STATEABBREVIATION 
IF @COUNTRYID IS NULL   SELECT @COUNTRYID=  ID  FROM COUNTRY  WHERE DESCRIPTION= @COUNTRYDESCRIPTION OR ABBREVIATION= @COUNTRYABBREVIATION

IF @SECONDARYSTATEID    IS NULL SELECT @SECONDARYSTATEID=    ID  FROM STATE    WHERE DESCRIPTION= @SECONDARYSTATEDESCRIPTION   OR ABBREVIATION= @SECONDARYSTATEABBREVIATION 
IF @SECONDARYCOUNTRYID  IS NULL SELECT @SECONDARYCOUNTRYID=  ID  FROM COUNTRY  WHERE DESCRIPTION= @SECONDARYCOUNTRYDESCRIPTION OR ABBREVIATION= @SECONDARYCOUNTRYABBREVIATION

begin try
    INSERT INTO dbo.ADDRESSBOOKFAF
         (ID, CLIENTUSERSID, FIRSTNAME, MIDDLENAME, LASTNAME, PREFERREDCOMMUNICATIONCODE, SALUTATION, EMAILADDRESS, ADDRESSBLOCK,  CITY, STATEID, 
          POSTCODE, COUNTRYID, CELLPHONE, TEXTMESSAGESEND, HOMEPHONE, CONSTITUENTID, BUSINESSPHONE, BUSINESSADDRESS, SECONDARYEMAILADDRESS, 
          SECONDARYCITY, SECONDARYSTATEID, SECONDARYPOSTCODE, SECONDARYCOUNTRYID,    COMPANYNAME, NOTES, ADDEDBYID, CHANGEDBYID, DATEADDED, DATECHANGED)
    VALUES
        (@ID, @CLIENTUSERSID, @FIRSTNAME, @MIDDLENAME, @LASTNAME, @PREFERREDCOMMUNICATIONCODE, @SALUTATION, @EMAILADDRESS, @ADDRESSBLOCK, @CITY, @STATEID, 
         @POSTCODE, @COUNTRYID, @CELLPHONE, @TEXTMESSAGESEND, @HOMEPHONE, @CONSTITUENTID, @BUSINESSPHONE, @BUSINESSADDRESS, @SECONDARYEMAILADDRESS, 
         @SECONDARYCITY, @SECONDARYSTATEID, @SECONDARYPOSTCODE, @SECONDARYCOUNTRYID, @COMPANYNAME, @NOTES,    @CHANGEAGENTID, @CHANGEAGENTID, @CURRENTDATE, @CURRENTDATE)

end try

begin catch
exec dbo.USP_RAISE_ERROR
return 1
end catch

return 0