spAddUpdate_ClientSites

Parameters

Parameter	Parameter Type	Mode
@PKID	int	INOUT
@CurrentUsersID	int	IN
@Name	nvarchar(255)	IN
@Deleted	bit	IN
@ClientsID	int	IN
@Guid	uniqueidentifier	INOUT
@SiteTrackingScript	nvarchar(max)	IN
@ParentSiteID	int	IN
@FavIconImageID	int	IN
Definition

Copy

                CREATE PROCEDURE [dbo].[spAddUpdate_ClientSites]
                (
                @PKID        int output,
                @CurrentUsersID    int,
                @Name        nvarchar(255),
                @Deleted bit,    
                @ClientsID    int,
                @Guid uniqueidentifier output,
                @SiteTrackingScript nvarchar(max), 
                @ParentSiteID int,
                @FavIconImageID int = 0
                )
                AS
                IF @ParentSiteID = 0
                    SET @ParentSiteID = NULL;

                IF @PKID <= 0 
                BEGIN
                    INSERT INTO dbo.ClientSites
                    (
                        [Name],
                        Deleted,
                        ClientsID,
                        OwnerID,
                        SiteTrackingScript, 
                        ParentSiteID,
                        FavIconImageID
                    ) 
                    VALUES
                    (
                        @Name,
                        @Deleted,
                        @ClientsID,
                        @CurrentUsersID,
                        @SiteTrackingScript, 
                        @ParentSiteID,
                        @FavIconImageID
                    );

                    SELECT @PKID = @@Identity;

                    SELECT @Guid = Guid FROM dbo.ClientSites WHERE ID = @PKID;

                    EXEC spAuditThis @CurrentUsersID, 1, @Guid, 8;

                    EXEC spDefaultAcknowledgmentTemplateID 1, @PKID

                END
                ELSE
                BEGIN

                    UPDATE dbo.ClientSites
                    SET
                        Name = @Name,
                        Deleted = @Deleted,
                        SiteTrackingScript = @SiteTrackingScript, 
                        ParentSiteID = @ParentSiteID,
                        FavIconImageID = @FavIconImageID
                    WHERE ID = @PKID;

                    SELECT @Guid = Guid FROM dbo.ClientSites WHERE ID = @PKID;

                    EXEC spAuditThis @CurrentUsersID, 2, @Guid, 8;

                END