USP_DATAFORMTEMPLATE_COMM_EDIT_SITEIMAGE

The save procedure used by the edit dataform template "Image Edit Data Form".

Parameters

Parameter	Parameter Type	Mode	Description
@ID	int	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.
@NAME	nvarchar(256)	IN	Name
@CAPTION	nvarchar(256)	IN	Caption
@PHOTOGRAPHER	nvarchar(256)	IN	Photographer
@CATEGORIES	xml	IN	Categories
@PICTURE	varbinary	IN	Image
@PICTUREFILENAME	nvarchar(256)	IN
@PICTURETYPE	nvarchar(50)	IN
@PICTURESIZE	int	IN
@DATETAKEN	datetime	IN	Date taken
@DBGUID	uniqueidentifier	IN

Definition

Copy


CREATE procedure dbo.[USP_DATAFORMTEMPLATE_COMM_EDIT_SITEIMAGE]
(
  @ID integer,
  @CHANGEAGENTID uniqueidentifier = null,
  @NAME nvarchar(256),
  @CAPTION nvarchar(256),
  @PHOTOGRAPHER nvarchar(256),
  @CATEGORIES xml,
  @PICTURE varbinary(max),
  @PICTUREFILENAME nvarchar(256),
  @PICTURETYPE nvarchar(50),
  @PICTURESIZE int,
  @DATETAKEN datetime,
  @DBGUID uniqueidentifier
)
as
  set nocount on;

  declare @CATEGORIESNTEXT nvarchar(max) = cast((
    select 
      @ID as SiteImageID,
      ImageCategory.c.value('(ID)[1]','integer') as SiteFolderID
    from @CATEGORIES.nodes('/CATEGORIES/ITEM') ImageCategory(c)
    for xml auto,root('Image')
  ) as nvarchar(max))

  begin try
    exec dbo.spAddUpdate_SiteImages
      @ID,
      1, -- Current user
      1, -- Site
      @NAME,
      '', -- file name on the server, not used for edits
      '', -- file extension, not used for edits
      @PICTUREFILENAME,
      @PICTURE,
      @PICTURETYPE,
      @PICTURESIZE,
      @DBGUID,
      0, -- Type
      @CAPTION,
      1, -- Approved
      0, -- Private
      @CATEGORIESNTEXT,
      1, -- Album
      @PHOTOGRAPHER,
      @DATETAKEN,
      0 -- Deleted

  end try

  begin catch
    exec dbo.USP_RAISE_ERROR
    return 1
  end catch

  return 0;