spAddUpdate_ECardTemplate

Parameters

Parameter	Parameter Type	Mode
@PKID	int	INOUT
@ClientSitesID	int	IN
@Name	nvarchar(256)	IN
@Caption	nvarchar(256)	IN
@SubjectLine	nvarchar(255)	IN
@Type	int	IN
@PreviewImage	image	IN
@PreviewImageType	nvarchar(50)	IN
@Categories	ntext	IN
@HtmlContent	ntext	IN
@OwnerID	int	IN
Definition

Copy


                    CREATE procedure [dbo].[spAddUpdate_ECardTemplate]
                (
                    @PKID int output,
                    @ClientSitesID int,
                    @Name nvarchar(256),
                    @Caption nvarchar(256),
                    @SubjectLine nvarchar(255),
                    @Type int,
                    @PreviewImage image,
                    @PreviewImageType nvarchar(50),
                    @Categories ntext,
                    @HtmlContent ntext,
                    @OwnerID int
                )
                AS
                    set nocount on;
                    DECLARE @Error int;
                    SET @Error = 0;

                    BEGIN TRANSACTION spAddUpdate_ECardTemplate;

                    IF @PKID <= 0 BEGIN
                        INSERT INTO dbo.ECardTemplate (
                            ClientSitesID,
                            Name,
                            Caption,
                            SubjectLine,
                            Type,
                            PreviewImage,
                            PreviewImageType,
                            PreviewImageModified,
                            HtmlContent,
                            OwnerID
                        ) VALUES (
                            @ClientSitesID,
                            @Name,
                            @Caption,
                            @SubjectLine,
                            @Type,
                            @PreviewImage,
                            @PreviewImageType,
                            getutcdate(),
                            @HtmlContent,
                            @OwnerID
                        );

                        SET @Error = @@ERROR;
                        SET @PKID = @@IDENTITY;
                    END ELSE BEGIN        
                        UPDATE dbo.ECardTemplate SET
                            Name = @Name,
                            ClientSitesID = @ClientSitesID,
                            Caption = @Caption,
                            SubjectLine = @SubjectLine,
                            Type = @Type,
                            PreviewImage = @PreviewImage,
                            PreviewImageType = @PreviewImageType,
                            PreviewImageModified = getutcdate(),
                            HtmlContent = @HtmlContent
                        WHERE ID = @PKID;

                        SET @Error = @@ERROR;
                    END

                    IF @Error = 0 BEGIN
                        EXEC spAddUpdate_ECardTemplateFolder @PKID, @Categories;
                        SET @Error = @@ERROR;
                    END

                    IF @Error = 0
                        COMMIT TRANSACTION spAddUpdate_ECardTemplate;
                    ELSE
                        ROLLBACK TRANSACTION spAddUpdate_ECardTemplate;