spAddUpdate_DocUploadParts

Parameters

Parameter	Parameter Type	Mode
@PKID	int	INOUT
@SiteContentID	int	IN
@CurrentUsersID	int	IN
@Name	nvarchar(100)	IN
@Description	nvarchar(1024)	IN
@MaxSize	int	IN
@UploadCaption	nvarchar(100)	IN
@RequiresApproval	bit	IN
@Guid	uniqueidentifier	IN
@MimeTypes	xml	IN
@UseMimeTypes	bit	IN
@SITEFOLDERID	int	IN

Definition

Copy


CREATE procedure [dbo].[spAddUpdate_DocUploadParts]
(
    @PKID                int output,
    @SiteContentID        int,    
    @CurrentUsersID        int,
    @Name                nvarchar(100),
    @Description        nvarchar(1024),
    @MaxSize            int,
    @UploadCaption        nvarchar(100),
    @RequiresApproval    bit,    
    @Guid                uniqueidentifier,
    @MimeTypes            xml,
    @UseMimeTypes        bit,
    @SITEFOLDERID        int = null
)
as

begin transaction

if @SITEFOLDERID <= 0
    set @SITEFOLDERID = null;

if (@PKID<=0)
begin
    insert into dbo.[DocUploadPart]
    (
        [SiteContentID],
        [Name],
        [Description],
        [MaxSize],
        [UploadCaption],
        [RequiresApproval],
        [Guid],
        [MimeTypes],
        [UseMimeTypes],
        [SITEFOLDERID]
    )
    VALUES
    (
        @SiteContentID,
        @Name,
        @Description,
        @MaxSize,
        @UploadCaption,
        @RequiresApproval,
        @Guid,
        @MimeTypes,
        @UseMimeTypes,
        @SITEFOLDERID
    )
    select @PKID = @@Identity
    exec spAuditThis @CurrentUsersID, 1, @Guid, 20
end 
else 
begin
    update dbo.[DocUploadPart] set
        [Name]                =@Name,
        [Description]        =@Description,
        [MaxSize]            =@MaxSize,
        [UploadCaption]        =@UploadCaption,
        [RequiresApproval]    =@RequiresApproval, 
        [Guid]                =@Guid,
        [MimeTypes]            =@MimeTypes,
        [UseMimeTypes]        =@UseMimeTypes,
        [SITEFOLDERID]        =@SITEFOLDERID
    where ID=@PKID
    exec spAuditThis @CurrentUsersID, 2, @Guid, 20
end

commit transaction