USP_DATAFORMTEMPLATE_ADD_FAF_IMAGES

The save procedure used by the add dataform template "FAF Images Add 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.
@CONSTITUENTID	uniqueidentifier	IN	Constituentid
@EVENTID	uniqueidentifier	IN	Eventid
@NAME	nvarchar(256)	IN	Name
@DESCRIPTION	nvarchar(256)	IN	Description
@FILENAME	nvarchar(256)	IN	Filename
@UPLOADFILENAME	nvarchar(256)	IN	Uploadfilename
@IMAGETYPE	nvarchar(50)	IN	Imagetype
@IMAGESIZE	int	IN	Imagesize
@IMAGECONTENT	varbinary	IN	Imagecontent
@CAPTION	nvarchar(256)	IN	Caption
@APPROVED	bit	IN	Approved
@PRIVATE	bit	IN	Private
@PHOTOGRAPHER	nvarchar(256)	IN	Photographer
@PHOTODATETAKEN	datetime	IN	Photodatetaken
@TAGS	nvarchar(256)	IN	Tags
@EXTERNALFLAG	bit	IN	Externalflag
@IMAGESOURCECODE	tinyint	IN	Imagesource
@EXTERNALURL	nvarchar(256)	IN	Externalurl

Definition

Copy


CREATE procedure dbo.USP_DATAFORMTEMPLATE_ADD_FAF_IMAGES
(
    @ID uniqueidentifier = null output,
    @CHANGEAGENTID uniqueidentifier = null,
    @CONSTITUENTID uniqueidentifier = null,
    @EVENTID uniqueidentifier = null,
    @NAME nvarchar(256) = '',
    @DESCRIPTION nvarchar(256) = '',
    @FILENAME nvarchar(256),
    @UPLOADFILENAME nvarchar(256) = '',
    @IMAGETYPE nvarchar(50),
    @IMAGESIZE int = 0,
    @IMAGECONTENT varbinary(max),
    @CAPTION nvarchar(256) = '',
    @APPROVED bit = 0,
    @PRIVATE bit = 0,
    @PHOTOGRAPHER nvarchar(256) = '',
    @PHOTODATETAKEN datetime = null,
    @TAGS nvarchar(256) = '',
    @EXTERNALFLAG bit = 0,
    @IMAGESOURCECODE tinyint = 0,
    @EXTERNALURL nvarchar(256) = ''
)
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.FAFIMAGES
        (ID, CONSTITUENTID, EVENTID, NAME, DESCRIPTION, FILENAME, UPLOADFILENAME, IMAGETYPE, IMAGESIZE, IMAGECONTENT, CAPTION, APPROVED, PRIVATE, PHOTOGRAPHER, PHOTODATETAKEN, TAGS, EXTERNALFLAG, IMAGESOURCECODE, EXTERNALURL, ADDEDBYID, CHANGEDBYID, DATEADDED, DATECHANGED)
    values
        (@ID, @CONSTITUENTID, @EVENTID, @NAME, @DESCRIPTION, @FILENAME, @UPLOADFILENAME, @IMAGETYPE, @IMAGESIZE, @IMAGECONTENT, @CAPTION, @APPROVED, @PRIVATE, @PHOTOGRAPHER, @PHOTODATETAKEN, @TAGS, @EXTERNALFLAG, @IMAGESOURCECODE, @EXTERNALURL, @CHANGEAGENTID, @CHANGEAGENTID, @CURRENTDATE, @CURRENTDATE)
end try

begin catch
    exec dbo.USP_RAISE_ERROR
    return 1
end catch

return 0