USP_FAF_IMAGEALBUM_ADD_EDIT

Image Album add edit for FAF Event
Parameters

Parameter	Parameter Type	Mode
@IMAGEALBUMID	int	INOUT
@CHANGEAGENTID	uniqueidentifier	IN
@NAME	varchar(50)	IN
@DESCRIPTION	varchar(255)	IN
@OWNERGUID	uniqueidentifier	IN
@OWNERTYPECODE	tinyint	IN
@OWNERUSERID	int	IN
@DELETED	bit	IN
@DELETEDDATE	datetime	IN
@DELETEDUSERID	int	IN
@IsDefault	bit	IN
@Security	int	IN
Definition

Copy


CREATE procedure dbo.USP_FAF_IMAGEALBUM_ADD_EDIT
    ( 
        @IMAGEALBUMID int = null output,
        @CHANGEAGENTID uniqueidentifier = NULL,
        @NAME varchar(50) = null,                -- required for add

        @DESCRIPTION varchar(255) = null,
        @OWNERGUID uniqueidentifier = null,        -- required for add

        @OWNERTYPECODE tinyint = null,            -- required for add

        @OWNERUSERID int = null,
        @DELETED bit = 0,
        @DELETEDDATE datetime = null,
        @DELETEDUSERID int = null,
        @IsDefault bit = 0,
        @Security int = 0
    )WITH EXECUTE AS CALLER

as
begin

    DECLARE @CURRENTDATE datetime;
    DECLARE @ID uniqueidentifier;

    IF @CHANGEAGENTID is null
        EXEC dbo.USP_CHANGEAGENT_GETORCREATECHANGEAGENT @CHANGEAGENTID output;

    SET @CURRENTDATE = getdate();

    IF ISNULL(@IMAGEALBUMID,0) <= 0
    begin
        IF ((@NAME IS NOT NULL) AND (@OWNERGUID IS NOT NULL) AND (@OWNERTYPECODE IS NOT NULL))
        begin

            SET @DESCRIPTION = ISNULL(@DESCRIPTION,'')
            SET @IMAGEALBUMID = 0

            Exec spAddUpdate_ImageAlbum 
                @PKID = @IMAGEALBUMID output, 
                @DisplayName = @NAME, 
                @Location = '', 
                @Description = @DESCRIPTION,
                @AlbumType = 3,    -- FAF albums

                @AlbumArtImageID = 0,
                @OwnerUserID = @OWNERUSERID,
                @Deleted = @DELETED,
                @DeletedDate = @DELETEDUSERID,
                @DeletedUserID = @DELETEDUSERID,
                @IsDefault = @IsDefault,
                @Security = @Security

        end

        IF ISNULL(@IMAGEALBUMID,0) > 0
        begin
            IF @ID is null
            SET @ID = newid();

            INSERT INTO IMAGEALBUMEXTENSION (ID, IMAGEALBUMID, OWNERGUID, OWNERTYPECODE, ADDEDBYID,CHANGEDBYID,DATEADDED,DATECHANGED)
            VALUES (@ID, @IMAGEALBUMID, @OWNERGUID, @OWNERTYPECODE, @CHANGEAGENTID,@CHANGEAGENTID,@CURRENTDATE,@CURRENTDATE)
        end
    end
    ELSE IF ISNULL(@IMAGEALBUMID,0) > 0
    begin
        Exec spAddUpdate_ImageAlbum 
                @PKID = @IMAGEALBUMID output, 
                @DisplayName = @NAME, 
                @Location = '', 
                @Description = @DESCRIPTION,
                @AlbumType = 3,    -- FAF albums

                @AlbumArtImageID = 0,
                @OwnerUserID = @OWNERUSERID,
                @Deleted = @DELETED,
                @DeletedDate = @DELETEDUSERID,
                @DeletedUserID = @DELETEDUSERID,
                @IsDefault = @IsDefault,
                @Security = @Security

        UPDATE IMAGEALBUMEXTENSION
            set OWNERGUID = ISNULL(@OWNERGUID,OWNERGUID),
                OWNERTYPECODE = ISNULL(@OWNERTYPECODE,OWNERTYPECODE)
            WHERE IMAGEALBUMID = @IMAGEALBUMID
    end

end