USP_SOCIALPROFILE_ADD

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	INOUT
@CHANGEAGENTID	uniqueidentifier	IN
@CURRENTAPPUSERID	uniqueidentifier	IN
@WPSOCIALID	uniqueidentifier	IN
@LOCATION	nvarchar(4000)	IN
@OCCUPATION	nvarchar(2048)	IN
@COMPANY	nvarchar(4000)	IN
@PROFILEFULLHASH	nvarchar(32)	IN
@EMAIL	nvarchar(200)	IN
@SEQUENCE	int	IN
@IMAGEURL	nvarchar(4000)	IN
@IMAGE	varbinary	IN
@IMAGETHUMBNAIL	varbinary	IN

Definition

Copy



create procedure dbo.USP_SOCIALPROFILE_ADD (
                @ID uniqueidentifier = null output,
                @CHANGEAGENTID uniqueidentifier = null,
                @CURRENTAPPUSERID uniqueidentifier = null,
                @WPSOCIALID uniqueidentifier,
        @LOCATION nvarchar(4000) = '',
        @OCCUPATION nvarchar(2048) = '',
        @COMPANY nvarchar(4000) = '',
        @PROFILEFULLHASH nvarchar(32) = '',
        @EMAIL nvarchar(200) = '',
        @SEQUENCE int = 0,
        @IMAGEURL nvarchar(4000) = '',
        @IMAGE varbinary(max) = null,
        @IMAGETHUMBNAIL varbinary(max) = null
            )
as
begin
    -- do work


  if @CHANGEAGENTID is null
    exec dbo.USP_CHANGEAGENT_GETORCREATECHANGEAGENT @CHANGEAGENTID output

  declare @WPSOCIALPROFILEID uniqueidentifier;
  declare @WPSOCIALIMAGEID uniqueidentifier;

  begin try
    exec dbo.USP_WPSOCIALPROFILE_ADD 
      @ID = @WPSOCIALPROFILEID output,
      @CHANGEAGENTID=@CHANGEAGENTID,
      @CURRENTAPPUSERID=@CURRENTAPPUSERID,
      @WPSOCIALID=@WPSOCIALID,
      @LOCATION=@LOCATION,
      @OCCUPATION=@OCCUPATION,
      @PROFILEFULLHASH = @PROFILEFULLHASH,
      @COMPANY=@COMPANY,
      @EMAIL=@EMAIL,
      @SEQUENCE=@SEQUENCE;
  end try
  begin catch
    exec dbo.USP_RAISE_ERROR;
  end catch


  if isnull(@IMAGEURL,'') <> ''
  begin
    begin try
      exec dbo.USP_WPSOCIALIMAGE_ADD 
        @ID = @WPSOCIALIMAGEID output,
        @CHANGEAGENTID=@CHANGEAGENTID,
        @CURRENTAPPUSERID=@CURRENTAPPUSERID,
        @WPSOCIALID=@WPSOCIALID,
        @EMAIL=@EMAIL,
        @SEQUENCE=@SEQUENCE,      
        @IMAGEURL=@IMAGEURL,
        @IMAGE=@IMAGE,
        @IMAGETHUMBNAIL=@IMAGETHUMBNAIL;
    end try
    begin catch
      exec dbo.USP_RAISE_ERROR;
    end catch
  end
end