USP_DATAFORMTEMPLATE_EDIT_FAF_COMMUNICATIONS_LOG

The save procedure used by the edit dataform template "FAF Communications Log 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.
@CLIENTUSERSID	int	IN	Clientusers
@ADDRESSBOOKID	uniqueidentifier	IN	Addressbook
@EMAILADDRESS	UDT_EMAILADDRESS	IN	Emailaddress
@MESSAGETYPECODE	tinyint	IN	Messagetype
@DATESENT	datetime	IN	Datesent
@CONSTITUENTID	uniqueidentifier	IN	Constituent
@EMAILJOBID	int	IN	EmailJob
@ISUPDATEPAGEVISITED	bit	IN	IsUpdatePagevisited

Definition

Copy


CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_FAF_COMMUNICATIONS_LOG
(
    @ID uniqueidentifier,
    @CHANGEAGENTID uniqueidentifier = null,
    @CLIENTUSERSID int,
    @ADDRESSBOOKID uniqueidentifier,
    @EMAILADDRESS dbo.UDT_EMAILADDRESS,
    @MESSAGETYPECODE tinyint,
    @DATESENT datetime,
      @CONSTITUENTID uniqueidentifier,
      @EMAILJOBID int,
    @ISUPDATEPAGEVISITED bit
)
as

    set nocount on;

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

    begin try
        -- handle updating the data
        update dbo.FAFCOMMUNICATIONSLOG set
            CLIENTUSERSID = @CLIENTUSERSID,
            ADDRESSBOOKID = @ADDRESSBOOKID,
            EMAILADDRESS = @EMAILADDRESS,
            MESSAGETYPECODE = @MESSAGETYPECODE,
            DATESENT = @DATESENT,
            CONSTITUENTID = @CONSTITUENTID,
            EMAILJOBID = @EMAILJOBID,
      PAGEVISITS = (CASE WHEN @ISUPDATEPAGEVISITED = 1 THEN PAGEVISITS+1 ELSE PAGEVISITS END),

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

    end try
    begin catch
        exec dbo.USP_RAISE_ERROR
        return 1
    end catch

return 0;