spAddUpdate_ClientUserMailForwarding

Parameters

Parameter	Parameter Type	Mode
@PKID	int	INOUT
@CurrentUsersID	int	IN
@ClientUsersID	int	IN
@ClientsID	int	IN
@IncomingAddress	nvarchar(510)	IN
@ForwardingAddress	nvarchar(510)	IN
@OptedIn	bit	IN
@Enabled	bit	IN
@Quota	int	IN
@MailerServiceGUID	uniqueidentifier	IN
@GUID	uniqueidentifier	INOUT

Definition

Copy



CREATE   PROCEDURE [dbo].[spAddUpdate_ClientUserMailForwarding]
(
    @PKID int output,
    @CurrentUsersID    int,
    @ClientUsersID int,
    @ClientsID int,
    @IncomingAddress nvarchar(510),
    @ForwardingAddress nvarchar(510),
    @OptedIn bit,
    @Enabled bit,
    @Quota int,
    @MailerServiceGUID uniqueidentifier,
    @GUID uniqueidentifier output
)
AS
BEGIN
    set nocount on

    declare @UserID int
    if @UserID > 0
        set @UserID = @CurrentUsersID
    else
        set @UserID = null

IF (@PKID<=0) BEGIN
    INSERT INTO ClientUserMailForwarding
    (
    ClientUsersID,
    ClientsID,
    IncomingAddress,
    ForwardingAddress,
    OptedIn,
    Enabled,
    Quota,
    MailerServiceGUID,
    CreateID,
    UpdateID
    )
    VALUES
    (
    @ClientUsersID,
    @ClientsID,
    @IncomingAddress,
    @ForwardingAddress,
    @OptedIn,
    @Enabled,
    @Quota,
    @MailerServiceGUID,
    @UserID,
    @UserID
    )

    SELECT @PKID = @@IDENTITY
    SELECT @GUID = [GUID] FROM ClientUserMailForwarding WHERE [ID] = @PKID

    EXEC spAuditThis @CurrentUsersID, 1, @GUID, 19
    END
ELSE
    BEGIN
    UPDATE ClientUserMailForwarding SET
    ClientUsersID=@ClientUsersID,
    ClientsID=@ClientsID,
    IncomingAddress=@IncomingAddress,
    ForwardingAddress=@ForwardingAddress,
    OptedIn=@OptedIn,
    Enabled=@Enabled,
    Quota=@Quota,
    MailerServiceGUID=@MailerServiceGUID,
    UpdateID = @UserID,
    UpdateDate = getutcdate()
    WHERE ID=@PKID

    SELECT @GUID = [GUID] FROM ClientUserMailForwarding WHERE [ID] = @PKID
    EXEC spAuditThis @CurrentUsersID, 2, @GUID, 19
END
END