spAddUpdate_NetAccount

Parameters

Parameter	Parameter Type	Mode
@PKID	int	INOUT
@DisplayName	nvarchar(255)	IN
@EmailAddress	nvarchar(255)	IN
@ClientUsersID	int	IN
@LockedOut	bit	IN
@LockedDate	datetime	IN
@LockedUserID	int	IN
@Deleted	bit	IN
@DeletedDate	datetime	IN
@DeletedUserID	int	IN
@EmailForwardingEnabled	bit	IN
@UserPageURL	nvarchar(255)	IN
@OnlineStatus	int	IN
@OnlineStatusPreferenceType	int	IN
@OnlineStatusUpdateDate	datetime	IN
@ProfileImageID	int	IN
Definition

Copy



        CREATE PROCEDURE [dbo].[spAddUpdate_NetAccount]
        (
            @PKID int output,
            @DisplayName nvarchar(255),
            @EmailAddress nvarchar (255),
            @ClientUsersID int,
            @LockedOut bit,
            @LockedDate datetime,
            @LockedUserID int,
            @Deleted bit,
            @DeletedDate datetime,
            @DeletedUserID int,
            @EmailForwardingEnabled bit,
            @UserPageURL nvarchar(255),
            @OnlineStatus int,
            @OnlineStatusPreferenceType int,    
            @OnlineStatusUpdateDate datetime,
            @ProfileImageID int

        )
            AS
            BEGIN
                IF (@PKID<=0) 
                BEGIN
                    INSERT INTO [NetAccount]
                    (
                    DisplayName,
                    EmailAddress,
                    ClientUsersID,
                    LockedOut,
                    LockedDate,
                    LockedUserID,
                    Deleted,
                    DeletedDate,
                    DeletedUserID,
                    EmailForwardingEnabled,
                    UserPageURL,
                    OnlineStatus,
                    OnlineStatusPreferenceType,
                    OnlineStatusUpdateDate ,
                    ProfileImageID
                    )
                    VALUES
                    (
                    @DisplayName,
                    @EmailAddress,
                    @ClientUsersID,
                    @LockedOut,
                    @LockedDate,
                    @LockedUserID,
                    @Deleted,
                    @DeletedDate,
                    @DeletedUserID,
                    @EmailForwardingEnabled,
                    @UserPageURL,
                    @OnlineStatus,
                    @OnlineStatusPreferenceType,
                    @OnlineStatusUpdateDate ,
                    @ProfileImageID
                    )

                    SELECT @PKID = @@Identity

                END
                ELSE 

                    UPDATE [NetAccount] SET
                    DisplayName = @DisplayName,
                    EmailAddress = @EmailAddress,
                    ClientUsersID = @ClientUsersID,
                    UpdateDate = getUTCDate(),
                    LockedOut = @LockedOut,
                    LockedDate = @LockedDate,
                    LockedUserID = @LockedUserID,
                    Deleted = @Deleted ,
                    DeletedDate = @DeletedDate,
                    DeletedUserID = @DeletedUserID,
                    EmailForwardingEnabled = @EmailForwardingEnabled,
                    UserPageURL = @UserPageURL ,
                    OnlineStatusPreferenceType = @OnlineStatusPreferenceType,
                    ProfileImageID = @ProfileImageID
                    WHERE [ID]=@PKID

                    UPDATE [NetAccount] SET
                    OnlineStatus = @OnlineStatus, 
                    OnlineStatusUpdateDate  = @OnlineStatusUpdateDate 
                    WHERE ID = @PKID AND @OnlineStatusUpdateDate > OnlineStatusUpdateDate  

            END