spAddUpdate_DataSourcesByImportListID

Parameters

Parameter	Parameter Type	Mode
@DataSourceID	int	INOUT
@ImportListID	int	IN
@Name	nvarchar(255)	IN
@TypeNamespace	nvarchar(255)	IN
@TypeName	nvarchar(255)	IN
@IsEmailListSource	bit	IN
@BackOfficeSystemId	int	IN
@Available	bit	IN
@SubscriberProviderForSystemID	int	IN
@UploadOrigin	int	IN

Definition

Copy





    CREATE  PROCEDURE [dbo].spAddUpdate_DataSourcesByImportListID
        @DataSourceID int OUTPUT,
        @ImportListID int,
        @Name nvarchar(255),
        @TypeNamespace nvarchar(255),
        @TypeName nvarchar(255),
        @IsEmailListSource bit,
        @BackOfficeSystemId int,
        @Available bit,
        @SubscriberProviderForSystemID int,
        @UploadOrigin int


    as

    IF NOT EXISTS(SELECT DataSourceID FROM DataSources WHERE ImportListID = @ImportListID)
        BEGIN


            select @DataSourceID=coalesce(max([DataSourceID])+1, 1001) from DataSources where [DataSourceID]>1000

            INSERT INTO [dbo].[DataSources]
                       ([DataSourceID]
                       ,[Name]
                       ,[TypeNamespace]
                       ,[TypeName]
                       ,[IsEmailListSource]
                       ,[BackOfficeSystemId]
                       ,[Available]
                       ,[SubscriberProviderForSystemID]
                       ,[ImportListID]
                       ,[UploadOrigin])
                 VALUES
                       (@DataSourceID
                       ,@Name
                       ,@TypeNamespace
                       ,@TypeName
                       ,@IsEmailListSource
                       ,@BackOfficeSystemId
                       ,@Available
                       ,@SubscriberProviderForSystemID
                       ,@ImportListID
                       ,@UploadOrigin)

        END
    ELSE
        BEGIN
            UPDATE [dbo].[DataSources]
               SET [Name] = @Name
                  ,[TypeNamespace] = @TypeNamespace
                  ,[TypeName] = @TypeName
                  ,[IsEmailListSource] = @IsEmailListSource
                  ,[BackOfficeSystemId] = @BackOfficeSystemId
                  ,[Available] = @Available
                  ,[SubscriberProviderForSystemID] = @SubscriberProviderForSystemID
                  ,DataSourceID = @DataSourceID
                  ,UploadOrigin = @UploadOrigin
             WHERE [ImportListID] = @ImportListiD
        END