spAddUpdate_DocUploadFiles

Parameters

Parameter	Parameter Type	Mode
@PKID	int	INOUT
@CID	int	IN
@Name	nvarchar(100)	IN
@FileName	nvarchar(100)	IN
@Description	nvarchar(1024)	IN
@ContentType	nvarchar(255)	IN
@OwnerID	int	IN
@Contents	image	IN
@Size	int	IN
@Date	datetime	IN
@Approved	bit	IN
@FOLDERID	int	IN
@CLIENTSITESID	int	IN
@URL	nvarchar(255)	IN
@DISCOVERABLE	bit	IN
@DISCOVERABLETITLE	nvarchar(256)	IN
@DISCOVERABLESUMMARY	nvarchar(4000)	IN
Definition

Copy

                  CREATE procedure [dbo].[spAddUpdate_DocUploadFiles]
            (
                @PKID            int output,
                @CID            int,    
                @Name            nvarchar(100),
                @FileName        nvarchar(100)    ,
                @Description    nvarchar(1024)    ,
                @ContentType    nvarchar(255)    ,
                @OwnerID        int,
                @Contents        image,
                @Size            int,
                @Date            datetime,
                @Approved        bit,
                @FOLDERID        int = null,
                @CLIENTSITESID    int = null,
                @URL            nvarchar(255) = null,
                @DISCOVERABLE    bit = 0,
                @DISCOVERABLETITLE nvarchar(256) = '',
                @DISCOVERABLESUMMARY nvarchar(4000) = ''
            )
            as
            begin transaction t1

            if @FOLDERID <= 0
                set @FOLDERID = null

            if @URL <= ''
                set @URL = null

            if (@PKID<=0)
            begin
                insert into dbo.[DocUploadFiles]
                (
                    [CID],
                    [FileName],
                    [Description],
                    [ContentType],
                    [OwnerID],
                    [Contents],
                    [Size],
                    [Name],
                    [Approved],
                    [FOLDERID],
                    [CLIENTSITESID],
                    [URL],
                    [DISCOVERABLE],
                    [DISCOVERABLETITLE],
                    [DISCOVERABLESUMMARY]
                )
                values
                (
                    @CID,
                    @FileName,
                    @Description,
                    @ContentType,
                    @OwnerID,
                    @Contents,
                    @Size,
                    @Name,
                    @Approved,
                    @FOLDERID,
                    @CLIENTSITESID,
                    @URL,
                    @DISCOVERABLE,
                    @DISCOVERABLETITLE,
                    @DISCOVERABLESUMMARY
                )
                select @PKID = @@Identity
            end 
            else 
            begin
                update dbo.[DocUploadFiles]
                set
                    [CID]            =@CID,
                    [FileName]        =@FileName,
                    [Description]    =@Description,
                    [ContentType]    =@ContentType,
                    [OwnerID]        =@OwnerID,
                    [Contents]        =@Contents,
                    [Size]            =@Size,
                    [Name]            =@Name,
                    [UploadDate]    =@Date,
                    [Approved]        =@Approved,
                    [FOLDERID]        =@FOLDERID,
                    [CLIENTSITESID] =@CLIENTSITESID,
                    [URL] = @URL,
                    [DISCOVERABLE]    =@DISCOVERABLE,
                    [DISCOVERABLETITLE] = @DISCOVERABLETITLE,
                    [DISCOVERABLESUMMARY] = @DISCOVERABLESUMMARY
                where ID=@PKID
            end
            commit transaction t1