USP_WPSOCIALIMAGE_ADD

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	INOUT
@CHANGEAGENTID	uniqueidentifier	IN
@CURRENTAPPUSERID	uniqueidentifier	IN
@WPSOCIALID	uniqueidentifier	IN
@IMAGEURL	nvarchar(4000)	IN
@IMAGE	varbinary	IN
@IMAGETHUMBNAIL	varbinary	IN
@EMAIL	nvarchar(200)	IN
@SEQUENCE	int	IN

Definition

Copy



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


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

  begin try

        declare @CURRENTDATE datetime;
        set @CURRENTDATE = getdate();

        --Get any existing ID

        select 
            @ID = ID 
        from 
            dbo.WPSOCIALIMAGE
        where 
            WPSOCIALID=@WPSOCIALID and
      IMAGEURL=@IMAGEURL;

        -- Only add new images

        if @ID is null 
        begin
      set @ID = newid();

      insert into dbo.WPSOCIALIMAGE (
          ID,
        WPSOCIALID,
          ADDEDBYID,
          CHANGEDBYID,
          DATEADDED, 
          DATECHANGED,
        EMAIL,
        IMAGEURL,
        IMAGE,
        IMAGETHUMBNAIL
      ) values
      (
          @ID,
        @WPSOCIALID,
          @CHANGEAGENTID,
          @CHANGEAGENTID,
          @CURRENTDATE, 
          @CURRENTDATE,
        @EMAIL,
        @IMAGEURL,
        @IMAGE,
        @IMAGETHUMBNAIL
        )
    end

  end try
  begin catch
    exec dbo.USP_RAISE_ERROR;
  end catch

end