USP_DATAFORMTEMPLATE_COMM_EDITLOAD_SITEIMAGE

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

Parameters

Parameter	Parameter Type	Mode	Description
@ID	int	IN	The input ID parameter used to load the fields defined on the form.
@DATALOADED	bit	INOUT	Output parameter indicating whether or not data was actually loaded.
@TSLONG	bigint	INOUT	Output parameter indicating the TSLONG value of the record being edited. This is used to manage multi-user concurrency issues when multiple users access the same record.
@NAME	nvarchar(256)	INOUT	Name
@CAPTION	nvarchar(256)	INOUT	Caption
@PHOTOGRAPHER	nvarchar(256)	INOUT	Photographer
@CATEGORIES	xml	INOUT	Categories
@PICTURE	varbinary	INOUT	Image
@PICTUREFILENAME	nvarchar(256)	INOUT
@PICTUREFILENAMEEXT	nvarchar(50)	INOUT
@PICTURETYPE	nvarchar(50)	INOUT
@PICTURESIZE	int	INOUT
@DATETAKEN	datetime	INOUT	Date taken
@DBGUID	uniqueidentifier	INOUT

Definition

Copy


CREATE procedure dbo.[USP_DATAFORMTEMPLATE_COMM_EDITLOAD_SITEIMAGE]
(
  @ID integer,
  @DATALOADED bit = 0 output,
  @TSLONG bigint = 0 output,
  @NAME nvarchar(256) = null output,
  @CAPTION nvarchar(256) = null output,
  @PHOTOGRAPHER nvarchar(256) = null output,
  @CATEGORIES xml = null output,
  @PICTURE varbinary(max) = null output,
  @PICTUREFILENAME nvarchar(256) = null output,
  @PICTUREFILENAMEEXT nvarchar(50) = null output,
  @PICTURETYPE nvarchar(50) = null output,
  @PICTURESIZE int = null output,
  @DATETAKEN datetime = null output,
  @DBGUID uniqueidentifier = null output
)
as
  set nocount on;

  set @DATALOADED = 0
  set @TSLONG = 0

  select
    @DATALOADED = 1,
    @NAME = Name,
    @CAPTION = Caption,
    @PHOTOGRAPHER = Photographer,
    @PICTURE = ImageContent,
    @PICTUREFILENAME = UploadFileName,
    @PICTURETYPE = ImageType,
    @PICTURESIZE = ImageSize,
    @DATETAKEN = case PhotoDateTaken when convert(datetime, 0) then null else PhotoDateTaken end,
    --@CREATEDATE = CreateDate,
    --@UPDATEDATE = dbo.fnLastModifiedDate(Guid),
    @DBGUID = Guid
  from dbo.SiteImages
  where ID = @ID

  set @CATEGORIES = (
    select SiteFolderID as ID
    from dbo.SiteImageFolders
    where SiteImageId = @ID
    for xml raw('ITEM'),type,elements,root('CATEGORIES'),BINARY BASE64
  )

  return 0;