spAddUpdate_NewsReaders

Parameters

Parameter	Parameter Type	Mode
@PKID	int	INOUT
@NewsReaderURL	nvarchar(2048)	IN
@Guid	uniqueidentifier	IN
@SiteContentID	int	IN
@ShowDate	bit	IN
@ShowGraphic	bit	IN
@MaxHeadlines	int	IN
@HeadlineOnly	bit	IN
@ArticlesPerPage	int	IN
@PagedOutput	bit	IN
@NewsReaderAuthType	int	IN
@NewsReaderUsername	nvarchar(100)	IN
@NewsReaderPassword	nvarchar(50)	IN
Definition

Copy



            CREATE  PROCEDURE [dbo].[spAddUpdate_NewsReaders]
            (
                @PKID                   int output,
                @NewsReaderURL          nvarchar(2048),
                @Guid                   uniqueidentifier,
                @SiteContentID          int,             
                @ShowDate               bit,
                @ShowGraphic            bit,
                @MaxHeadlines           int,
                @HeadlineOnly           bit,
                @ArticlesPerPage        int,
                @PagedOutput            bit,
                @NewsReaderAuthType     int,                
                @NewsReaderUsername     nvarchar(100),
                @NewsReaderPassword     nvarchar(50)
            )
            AS
            begin transaction
            BEGIN TRY
                EXEC dbo.USP_GET_KEY_ACCESS 
                set @NewsReaderUsername = EncryptByKey(Key_GUID('sym_BBInfinity'), @NewsReaderUsername)
                set @NewsReaderPassword = EncryptByKey(Key_GUID('sym_BBInfinity'), @NewsReaderPassword)                
            END TRY        
            BEGIN CATCH
                EXEC dbo.USP_RAISE_ERROR;
                CLOSE symmetric key sym_BBInfinity;                
            END CATCH
            if (@PKID <= 0)
            begin
                INSERT INTO NewsReaders
                (
                NewsReaderURL,
                Guid,
                SiteContentID,
                ShowDate,
                ShowGraphic,
                MaxHeadlines,
                HeadlineOnly,
                ArticlesPerPage,
                PagedOutput,
                NewsReaderAuthType,
                NewsReaderUsername,
                NewsReaderPassword
                )
                VALUES
                (
                @NewsReaderURL,
                @Guid,
                @SiteContentID,
                @ShowDate,
                @ShowGraphic,
                @MaxHeadlines,
                @HeadlineOnly,
                @ArticlesPerPage,
                @PagedOutput,
                @NewsReaderAuthType,
                @NewsReaderUsername,
                @NewsReaderPassword
                )
                SELECT @PKID = @@Identity
            end 
            else 
            begin
                UPDATE NewsReaders SET
                    NewsReaderURL           = @NewsReaderURL,
                    Guid                    = @Guid,
                    SiteContentID           = @SiteContentID,    
                    ShowDate                = @ShowDate,
                    ShowGraphic             = @ShowGraphic,
                    MaxHeadlines            = @MaxHeadlines,
                    HeadlineOnly            = @HeadlineOnly,
                    ArticlesPerPage         = @ArticlesPerPage,
                    PagedOutput             = @PagedOutput,
                    NewsReaderAuthType      = @NewsReaderAuthType,
                    NewsReaderUsername      = @NewsReaderUsername,
                    NewsReaderPassword      = @NewsReaderPassword
                WHERE ID = @PKID

            end

            commit transaction