spAddUpdate_UserImport

Parameters

Parameter	Parameter Type	Mode
@PKID	int	INOUT
@SiteClientsID	int	IN
@Name	nvarchar(50)	IN
@Description	nvarchar(150)	IN
@FileContents	image	IN
@FileName	nvarchar(256)	IN
@FileSize	int	IN
@FieldMap	ntext	IN
@ProcessOn	datetime	IN
@NeedToProcessList	bit	IN
@EmailTemplate	int	IN
@FileFieldNames	ntext	IN
@UserNameOption	nvarchar(256)	IN
@CurrentStep	tinyint	IN
@Status	tinyint	IN
@DeferProcess	bit	IN
@OwnerID	int	IN
@EmailListID	int	IN
@EmailID	int	IN
@EmailStatus	ntext	IN
@ClientSitesID	int	IN

Definition

Copy


CREATE PROCEDURE [dbo].[spAddUpdate_UserImport]
(
    @PKID            int output,
    @SiteClientsID    int,
    @Name             nvarchar(50),
    @Description    nvarchar(150),
    @FileContents    image,
    @FileName        nvarchar(256),
    @FileSize        int,
    @FieldMap        ntext,
    @ProcessOn        datetime,
    @NeedToProcessList        bit,
    @EmailTemplate    int,
    @FileFieldNames ntext,
    @UserNameOption    nvarchar(256),
    @CurrentStep    tinyint,
    @Status         tinyint,
    @DeferProcess   bit,
    @OwnerID        int,
    @EmailListID    int,        
    @EmailID        int,
    @EmailStatus    ntext,
    @ClientSitesID  int = null
)
AS
if (@PKID<=0) begin
    INSERT INTO [UserImport]
    (    [SiteClientsID], 
        [Name], 
        [Description],
        [FileContents], 
        [FileName], 
        [FileSize], 
        [FieldMap],
        [ProcessOn],
        [NeedToProcessList],
        [EmailTemplate],
        [FileFieldNames],
        [UserNameOption],
        [DeferProcess],
        [OwnerID],
        [CurrentStep],
        [EmailListID],
        [EmailID],
        [EmailStatus],
        [ClientSitesID]
    ) 
    VALUES 
    (    @SiteClientsID,
        @Name,
        @Description,
        @FileContents,
        @FileName,
        @FileSize,
        @FieldMap,
        @ProcessOn,
        @NeedToProcessList,
        @EmailTemplate,
        @FileFieldNames,
        @UserNameOption,
        @DeferProcess,
        @OwnerID,
        @CurrentStep,
        @EmailListID,
        @EmailID,
        @EmailStatus,
        @ClientSitesID
    )

    SELECT @PKID = @@Identity
    end
else begin
    UPDATE [dbo].[UserImport]
    SET 
        [Name]            = @Name, 
        [Description]    = @Description,
        [FieldMap]        = @FieldMap,
        [ProcessOn]        = @ProcessOn,
        [NeedToProcessList]    = @NeedToProcessList,
        [EmailTemplate]    = @EmailTemplate,
        [UserNameOption]= @UserNameOption,
        [CurrentStep]    = @CurrentStep,
        [DeferProcess]  = @DeferProcess,
        [Status]        = @Status,
        [EmailListID]    = @EmailListID,
        [EmailID]       = @EmailID,
        [EmailStatus]   = @EmailStatus,
        [ClientSitesID] = @ClientSitesID
    WHERE ID=@PKID                
-- only hit filecontent cols if passing up a file        
    if (@FileSize > 0) begin
        UPDATE [dbo].[UserImport] 
            set [FileContents] = @FileContents,
            [FileSize] = @FileSize,
            [FileName] = @FileName,
            [FileFieldNames] = @FileFieldNames
            where [id]=@PKID
    end
end