USP_DATAFORMTEMPLATE_ADD_ADVOCACY_LOG

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

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	INOUT	The output parameter indicating the ID of the record added.
@CHANGEAGENTID	uniqueidentifier	IN	Input parameter indicating the ID of the change agent invoking the procedure.
@ADVOCACYLOGID	int	IN	Advocacy log ID
@SITECONTENTID	int	IN	SitecontentID
@ACTIONITEMID	uniqueidentifier	IN	ActionItemID
@CONSTITUENTID	uniqueidentifier	IN	ConstituentID
@SOURCECONSTITUENTID	uniqueidentifier	IN	SourceConstituentID
@ACTIONCLASSIFICATION	nvarchar(50)	IN	Actionclassification
@LEGISID	nvarchar(10)	IN	legislator ID
@TYPECODE	tinyint	IN	Message delivery Type
@FAILUREREASONID	int	IN	FAILUREREASONID
@FAXCOST	money	IN	Fax Cost
@FROMADDRESS	nvarchar(255)	IN	FROMADDRESS
@TOADDRESS	nvarchar(2000)	IN	TOADDRESS
@STATUSCODE	tinyint	IN	Message status
@REQUESTEDSERVER	nvarchar(100)	IN	REQUESTEDSERVER
@ORIGINALADVOCACYLOGID	int	IN	Original Advocacy Log ID Stored on Central Server
@ISINTERNATIONALFAX	bit	IN	Is this international fax number
@ISBILLABLE	bit	IN	Is this billable message delivery
@FVTRANSACTIONID	uniqueidentifier	IN	TransactionID
@TESTFLAG	bit	IN	Is this test message
@SALUTATION	nvarchar(100)	IN	SALUTATION
@MESSAGEHEADER	nvarchar(255)	IN	MESSAGEHEADER
@MESSAGESALUTATION	nvarchar(255)	IN	MESSAGESALUTATION
@MESSAGESIGNATURE	nvarchar(255)	IN	MESSAGESIGNATURE
@SUBJECTLINE	nvarchar(255)	IN	SUBJECTLINE
@MESSAGETEXT	nvarchar(max)	IN	Content of the message
@EMAILLOGID	uniqueidentifier	IN	Email log id from bbnc mail system
@TARGETNAME	varchar(500)	IN	Target Name
@FEDERALDISTRICTCODE	varchar(4)	IN	Federal District Code
@UPPERSTATEDISTRICTCODE	varchar(5)	IN	Upper District Code
@LOWERSTATEDISTRICTCODE	varchar(5)	IN	Lower District Code
@ISMESSAGETEXTCHANGED	bit	IN	Is Message Text Changed
@DISTRICTNAME	varchar(100)	IN	District Name
@DISTRICT	varchar(13)	IN	District Code
@ADDRESSLINE1	varchar(100)	IN	Address Line 1
@ADDRESSLINE2	varchar(100)	IN	Address Line 2
@CITY	varchar(50)	IN	City
@STATE	varchar(100)	IN	State
@COUNTRY	varchar(5)	IN	Country
@ZIP	varchar(12)	IN	Zipcode
@ISSUBJECTCHANGED	bit	IN	Is Message Subject Changed

Definition

Copy





CREATE procedure dbo.USP_DATAFORMTEMPLATE_ADD_ADVOCACY_LOG
(
    @ID uniqueidentifier = null output,
    @CHANGEAGENTID uniqueidentifier = null,
    @ADVOCACYLOGID int,
    @SITECONTENTID int,
    @ACTIONITEMID uniqueidentifier,
    @CONSTITUENTID uniqueidentifier,
    @SOURCECONSTITUENTID uniqueidentifier = null,
    @ACTIONCLASSIFICATION nvarchar(50)='',
    @LEGISID nvarchar(10),
    @TYPECODE tinyint = 0,
    @FAILUREREASONID int = null,
    @FAXCOST money = 0,
    @FROMADDRESS nvarchar(255) = '',
    @TOADDRESS nvarchar(2000) = '',
    @STATUSCODE tinyint=0,
    @REQUESTEDSERVER nvarchar(100) = '',
    @ORIGINALADVOCACYLOGID int = 0,
    @ISINTERNATIONALFAX bit = 0,
    @ISBILLABLE bit = 0,
    @FVTRANSACTIONID uniqueidentifier = null,
    @TESTFLAG bit = 0,
    @SALUTATION nvarchar(100) = '',
    @MESSAGEHEADER nvarchar(255) = '',
    @MESSAGESALUTATION nvarchar(255) = '',
    @MESSAGESIGNATURE nvarchar(255) = '',
    @SUBJECTLINE nvarchar(255) = '',
    @MESSAGETEXT nvarchar(MAX) = '',
    @EMAILLOGID uniqueidentifier = null,
    @TARGETNAME varchar(500) = null,
    @FEDERALDISTRICTCODE varchar(4) = null,
    @UPPERSTATEDISTRICTCODE varchar(5) = null,
    @LOWERSTATEDISTRICTCODE varchar(5) = null,
    @ISMESSAGETEXTCHANGED bit = 0,
    @DISTRICTNAME varchar(100) = null,
    @DISTRICT varchar(13) = null,
    @ADDRESSLINE1 varchar(100) = null,
    @ADDRESSLINE2 varchar(100) = null,
    @CITY varchar(50) = null,
    @STATE varchar(100) = null,
    @COUNTRY varchar(5) = null,
    @ZIP varchar(12) = null,
    @ISSUBJECTCHANGED bit = 0

)

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()

begin try

      -- handle inserting the data


    insert into dbo.ADVOCACYLOG   

    ([ID], [ADVOCACYLOGID], [SITECONTENTID], [ACTIONITEMID], [CONSTITUENTID], [SOURCECONSTITUENTID], [ACTIONCLASSIFICATION], [LEGISID], [TYPECODE], [FAILUREREASONID], [FAXCOST], [FROMADDRESS], [TOADDRESS], [STATUSCODE], [REQUESTEDSERVER], [ORIGINALADVOCACYLOGID], [ISINTERNATIONALFAX], [ISBILLABLE], [FVTRANSACTIONID], [TESTFLAG], [SALUTATION], [MESSAGEHEADER], [MESSAGESALUTATION], [MESSAGESIGNATURE], [SUBJECTLINE], [MESSAGETEXT], [EMAILLOGID], [TARGETNAME], 
    [FEDERALDISTRICTCODE], [UPPERSTATEDISTRICTCODE], [LOWERSTATEDISTRICTCODE], [ISMESSAGETEXTCHANGED], [DISTRICTNAME], [DISTRICT], [ADDRESSLINE1], [ADDRESSLINE2], [CITY], [STATE], [COUNTRY], [ZIP], [ISSUBJECTCHANGED], [ADDEDBYID], [CHANGEDBYID], [DATEADDED], [DATECHANGED])

    values 

    (@ID, @ADVOCACYLOGID, @SITECONTENTID, @ACTIONITEMID, @CONSTITUENTID, @SOURCECONSTITUENTID, @ACTIONCLASSIFICATION, @LEGISID, @TYPECODE, @FAILUREREASONID, @FAXCOST, @FROMADDRESS, @TOADDRESS, @STATUSCODE, @REQUESTEDSERVER, @ORIGINALADVOCACYLOGID, @ISINTERNATIONALFAX, @ISBILLABLE, @FVTRANSACTIONID, @TESTFLAG, @SALUTATION, @MESSAGEHEADER, @MESSAGESALUTATION, @MESSAGESIGNATURE, @SUBJECTLINE, @MESSAGETEXT, @EMAILLOGID, @TARGETNAME, 
    @FEDERALDISTRICTCODE, @UPPERSTATEDISTRICTCODE, @LOWERSTATEDISTRICTCODE, @ISMESSAGETEXTCHANGED, @DISTRICTNAME, @DISTRICT, @ADDRESSLINE1, @ADDRESSLINE2, @CITY, @STATE, @COUNTRY, @ZIP, @ISSUBJECTCHANGED, @CHANGEAGENTID, @CHANGEAGENTID, @CURRENTDATE, @CURRENTDATE) 

end try

begin catch

    exec dbo.USP_RAISE_ERROR

    return 1

end catch



return 0