spAddUpdate_ClientUserImages

Parameters

Parameter	Parameter Type	Mode
@PKID	int	INOUT
@CurrentUsersID	int	IN
@ClientUsersID	int	IN
@Name	nvarchar(256)	IN
@Caption	nvarchar(256)	IN
@Category	nvarchar(256)	IN
@Sequence	int	IN
@Editable	bit	IN
@UploadFileName	nvarchar(256)	IN
@ImageType	nvarchar(50)	IN
@ImageSize	int	IN
@ImageContent	image	IN
@Approved	bit	IN
@Private	bit	IN
@Guid	uniqueidentifier	IN

Definition

Copy




CREATE PROCEDURE dbo.spAddUpdate_ClientUserImages
(
        @PKID        int output,
        @CurrentUsersID    int,        
    @ClientUsersID       int,
    @Name             nvarchar(256),
    @Caption          nvarchar(256),
    @Category          nvarchar(256),
    @Sequence        int,
    @Editable      bit,
    @UploadFileName    nvarchar(256),
    @ImageType        nvarchar(50),
    @ImageSize        int,
    @ImageContent   image,
    @Approved    bit,
    @Private    bit,
    @Guid            uniqueidentifier
)
AS

if (@PKID<=0) begin

    INSERT INTO ClientUserImages
    (
        ClientUsersID,
        [Name],
        Caption,
        UploadFileName,
        Sequence,
        Editable,
        ImageType,
        ImageSize,
        ImageContent,
        Approved,
        Private,
        OwnerID,
        Category,
        Guid
    )

    VALUES
    (
        @ClientUsersID,
        @Name,
        @Caption,
        @UploadFileName,
        @Sequence,
        @Editable,
        @ImageType,
        @ImageSize,
        @ImageContent,
        @Approved,
        @Private,
        @CurrentUsersID,
        @Category,
        @guid
    )

    SELECT @PKID = @@Identity

    exec spAuditThis @CurrentUsersID, 1, @Guid, 11

end else begin

    if (@ImageSize=0)

        update ClientUserImages
        set 
            Caption       = @Caption,
            [Name]           = @Name,
            Sequence    = @Sequence,
                Editable    = @editable,
            approved    = @approved,
            Private        = @Private,
            Category    = @Category

        where ID = @PKID

    else

        update ClientUserImages
        set
            Caption      = @Caption,
            [Name]            = @Name,
            UploadFileName = @UploadFileName,
            Sequence    = @Sequence,
                Editable    = @editable,
            ImageContent  = @ImageContent,
            ImageType     = @ImageType,
            ImageSize     = @ImageSize,
            Approved    =@approved,
            Private        =@Private,
            Category     =@Category
        where ID = @PKID

    select @Guid = Guid from ClientUserImages where ID = @PKID

    exec spAuditThis @CurrentUsersID, 2, @Guid, 11

end