USP_DATAFORMTEMPLATE_VIEW_SOCIALMEDIASUMMARY

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	IN
@SOCIALMEDIAIMAGES	xml	INOUT
@DATALOADED	bit	INOUT
@SOURCE	nvarchar(100)	INOUT
@FULLNAME	nvarchar(600)	INOUT
@GENDER	nvarchar(14)	INOUT
@LOCATION	nvarchar(2048)	INOUT
@OCCUPATION	nvarchar(1024)	INOUT
@COMPANY	nvarchar(2048)	INOUT
@PROFILECOUNT	tinyint	INOUT
@CURRENTIMAGEID	uniqueidentifier	INOUT
@CONSTITUENTNAME	nvarchar(600)	INOUT
@SHOWSOCIAL	bit	INOUT
@NEWDETAILS	bit	INOUT
@HASPROFILEIMAGE	bit	INOUT

Definition

Copy



                    CREATE procedure dbo.[USP_DATAFORMTEMPLATE_VIEW_SOCIALMEDIASUMMARY]
                    (
                        @ID                       uniqueidentifier,
              @SOCIALMEDIAIMAGES        xml = null output,
                        @DATALOADED               bit = 0 output,
            @SOURCE                   nvarchar(100) = null output,
            @FULLNAME                 nvarchar(600) = null output,
            @GENDER                   nvarchar(14) = null output,
            @LOCATION                 nvarchar(2048) = null output,
            @OCCUPATION               nvarchar(1024) = null output,
            @COMPANY                  nvarchar(2048) = null output,
            @PROFILECOUNT             tinyint = null output,
            @CURRENTIMAGEID           uniqueidentifier = null output,
            @CONSTITUENTNAME          nvarchar(600) = null output,
              @SHOWSOCIAL               bit = null output,
            @NEWDETAILS               bit = null output,
            @HASPROFILEIMAGE          bit = null output
                    )
                    as
                        set NOCOUNT on;
                        set @DATALOADED = 0;
            set @SHOWSOCIAL = 0;

            set @SOCIALMEDIAIMAGES = dbo.UFN_WEALTHPOINT_SOCIALIMAGES_TOITEMLISTXML(@ID);

            select 
              @SOURCE = SOURCE,
              @FULLNAME = FULLNAME,
              @GENDER = GENDER,
              @LOCATION = LOCATION,
              @OCCUPATION = OCCUPATION,
              @COMPANY = COMPANY,
              @SHOWSOCIAL = 1
            from dbo.WPSOCIAL
            where ID = @ID;

            select
              @CONSTITUENTNAME = NAME,
              @HASPROFILEIMAGE = case when PICTURE is null then 0 else 1 end
            from dbo.CONSTITUENT
            where ID = @ID;

            select 
              @PROFILECOUNT = COUNT(ID)
            from dbo.WPSOCIALPROFILE where WPSOCIALID = @ID;

            set @NEWDETAILS = 0;
            if exists(select top 1 1 from dbo.WPSOCIALPROFILE where WPSOCIALID = @ID and ISNEW = 1)
            begin
              set @NEWDETAILS = 1;

              update dbo.WPSOCIALPROFILE
              set ISNEW = 0
              where WPSOCIALID = @ID
            end

                        set @DATALOADED = 1;

            return 0;