USP_DATAFORMTEMPLATE_ADD_SITEIMAGES
The save procedure used by the add dataform template "SiteImages 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. |
| @SITEIMAGESID | int | IN | SiteImagesid |
| @CLIENTUSERSID | int | IN | ClientUsersID |
| @CLIENTSITESID | int | IN | ClientSitesID |
| @NAME | nvarchar(256) | IN | Name |
| @FILENAME | nvarchar(256) | IN | Filename |
| @FILEEXT | nvarchar(50) | IN | FileExt |
| @UPLOADFILENAME | nvarchar(256) | IN | Uploadfilename |
| @IMAGECONTENT | image | IN | Imagecontent |
| @IMAGETYPE | nvarchar(50) | IN | Imagetype |
| @IMAGESIZE | int | IN | Imagesize |
| @TYPE | int | IN | |
| @CAPTION | nvarchar(256) | IN | Caption |
| @APPROVED | bit | IN | Approved |
| @PRIVATE | bit | IN | Private |
| @CATEGORIES | varchar(max) | IN | Categories |
| @IMAGEALBUMID | int | IN | ImageAlbumID |
| @PHOTOGRAPHER | nvarchar(255) | IN | Photographer |
| @PHOTODATETAKEN | nvarchar(100) | IN | Photodatetaken |
Definition
Copy
CREATE procedure dbo.USP_DATAFORMTEMPLATE_ADD_SITEIMAGES
(
@ID uniqueidentifier = null output,
@CHANGEAGENTID uniqueidentifier = null,
@SITEIMAGESID int = 0,
@CLIENTUSERSID int = null,
@CLIENTSITESID int = null,
@NAME nvarchar(256) = '',
@FILENAME nvarchar(256) = '',
@FILEEXT nvarchar(50) = '',
@UPLOADFILENAME nvarchar(256) = '',
@IMAGECONTENT image = '',
@IMAGETYPE nvarchar(50) = '',
@IMAGESIZE int = 1,
@TYPE int = 0,
@CAPTION nvarchar(256) = '',
@APPROVED bit = 1,
@PRIVATE bit = 0,
@CATEGORIES varchar(max) = '',
@IMAGEALBUMID int = 0,
@PHOTOGRAPHER nvarchar(255) = '',
@PHOTODATETAKEN nvarchar(100) = ''
)
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
EXEC [dbo].[spAddUpdate_SiteImages] @PKID = @SiteImagesId , @CurrentUsersID = @ClientUsersID, @ClientSitesID = @ClientSitesID, @Name = @Name,
@FileName = @FileName, @FileExt = @FileExt, @UploadFileName = @UploadFileName, @ImageContent = @ImageContent, @ImageType = @ImageType, @ImageSize = @ImageSize,
@Guid = @ID, @Type = @Type, @Caption = @Caption, @Approved = @Approved, @Private = @Private, @Categories = @Categories, @ImageAlbumID = @ImageAlbumID,
@Photographer = @Photographer, @PhotoDateTaken = @PhotoDateTaken, @Deleted = 0
end try
begin catch
exec dbo.USP_RAISE_ERROR
return 1
end catch
return 0