spAddUpdate_ClientUserProfile

Parameters

Parameter	Parameter Type	Mode
@PKID	int	IN
@UserID	int	IN
@CurrentUsersID	int	IN
@ProfileXML	ntext	IN
@Guid	uniqueidentifier	IN

Definition

Copy



CREATE        PROCEDURE dbo.spAddUpdate_ClientUserProfile
(
         @PKID int,
     @UserID int,
         @CurrentUsersID int,
     @ProfileXML ntext,
     @Guid uniqueidentifier
)
AS

if (@PKID<=0) begin

    INSERT INTO ClientUserProfile
    (
      UserID,
      UserProfileXML
     )

    VALUES
    (
      @UserID,    
      @ProfileXML
     )

    --SELECT @PKID = @@Identity

    select @Guid = Guid from ClientUserProfile where UserID = @UserID

    exec spAuditThis @CurrentUsersID, 1, @Guid, 6

    end 

else 

    begin

    UPDATE ClientUserProfile SET
        UserProfileXML = @ProfileXML
    WHERE UserID=@UserID

    select @Guid = Guid from ClientUserProfile where UserID = @UserID

    exec spAuditThis @CurrentUsersID, 2, @Guid, 6

end