====== dbo.spCCPSetSocialNetworkInfo ======

Object type: Stored Procedure (MS-SQL)\\
Parent: [[internal:dbsql:customerdbsql:start|CustomerDBSQL]]

===== 4/3/2024 =====
<code sql>
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

-- =============================================
-- Author:	www.allshore.us, Radu Butarascu
-- Last update: 9/8/2011, 3/25/2024, 4/3/2024
-- Description:	This procedure saves social media and contact links in CCP legacy.
-- Pages that use this are SocialNetworkingLinks.aspx and AppSocialNetworking.aspx
-- =============================================

ALTER PROCEDURE [dbo].[spCCPSetSocialNetworkInfo]
(
	@CallLtr	varchar(40),
	@SocialNetworkFacebook	varchar(255),
	@SocialNetworkTwitter	varchar(255),
	@SocialNetworkYouTube	varchar(255),
	@SocialNetworkInstagram	varchar(255),
    @SocialNetworkSnapchat	varchar(255),
    @SocialNetworkTikTok	varchar(255),
	@RequestEmail varchar(255),
	@ContactPhone varchar(15)
)
AS
BEGIN
	
	UPDATE Stations
	SET	SocialNetworkFacebook = @SocialNetworkFacebook,
		SocialNetworkTwitter = @SocialNetworkTwitter,
		SocialNetworkYouTube = @SocialNetworkYouTube,
		SocialNetworkInstagram = @SocialNetworkInstagram,
        SocialNetworkSnapchat = @SocialNetworkSnapchat,
        SocialNetworkTikTok = @SocialNetworkTikTok,
        RequestEmail = @RequestEmail,
        ContactPhone = @ContactPhone
	WHERE [CALL LTR] = @CallLtr
			
	SELECT @@ROWCOUNT

END
GO
</code>

===== 3/25/2024 =====

<code sql>
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

-- =============================================
-- Author:	www.allshore.us, Radu Butarascu
-- Last update: 9/8/2011, 3/25/2024
-- Description:	This procedure saves social media and contact links in CCP legacy.
-- Pages that use this are SocialNetworkingLinks.aspx and AppSocialNetworking.aspx
-- =============================================

ALTER Procedure [dbo].[spCCPSetSocialNetworkInfo]
(
	@CallLtr	varchar(40),
	@SocialNetworkFacebook	varchar(255),
	@SocialNetworkTwitter	varchar(255),
	@SocialNetworkYouTube	varchar(255),
	@SocialNetworkInstagram	varchar(255),
    @SocialNetworkSnapchat	varchar(255),
    @SocialNetworkTikTok	varchar(255),
	@RequestEmail varchar(255),
	@ContactPhone varchar(15)
)
as
begin
	
	update Stations
	set	SocialNetworkFacebook = @SocialNetworkFacebook,
		SocialNetworkTwitter = @SocialNetworkTwitter,
		SocialNetworkYouTube = @SocialNetworkYouTube,
		SocialNetworkInstagram = @SocialNetworkInstagram,
        SocialNetworkSnapchat = @SocialNetworkSnapchat,
        SocialNetworkTikTok = @SocialNetworkTikTok
	where [CALL LTR] = @CallLtr
	
	update player
	set RequestEmail = @RequestEmail
	where [Call LTR] = @CallLtr
	
	-- added 2015-07-08 by RADU
	DECLARE @mpID INT
	SET @mpID = (SELECT id FROM MobilePlayer WHERE [CallLTR] = @CallLtr)
	IF @mpID IS NULL
		BEGIN
			INSERT INTO MobilePlayer (CallLTR, ContactPhone)
				VALUES (@CallLtr, @ContactPhone)
		END
	ELSE
		BEGIN
			UPDATE MobilePlayer
			SET ContactPhone = @ContactPhone
				WHERE [CallLTR] = @CallLtr
		END
		
	Select @@ROWCOUNT

end
GO
</code>
===== 9/8/2011 =====

<code sql>
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

-- =============================================
-- Author:		www.allshore.us
-- Last update: 9/8/2011
-- Description:	This procedure will return the User Information based upon [Call ltr]
-- =============================================

CREATE Procedure [dbo].[spCCPSetSocialNetworkInfo]
(
	@CallLtr	varchar(40),
	@SocialNetworkFacebook	varchar(255),
	@SocialNetworkTwitter	varchar(255),
	@SocialNetworkYouTube	varchar(255),
	@SocialNetworkInstagram	varchar(255),
	@RequestEmail varchar(255),
	@ContactPhone varchar(15)
)
as
begin
declare @SocialNetworkFacebookEnabled	as bit
declare @SocialNetworkTwitterEnabled	as bit
declare @SocialNetworkYouTubeEnabled	as bit
declare @SocialNetworkInstagramEnabled	as bit
declare @RequestEmailOnPlayer	as bit

if(len(@SocialNetworkFacebook) <> 0)
	set @SocialNetworkFacebookEnabled = 1
	else
	set	@SocialNetworkFacebookEnabled = 0
	
if(len(@SocialNetworkTwitter) <> 0)
	set @SocialNetworkTwitterEnabled = 1
	else
	set	@SocialNetworkTwitterEnabled = 0

if(len(@SocialNetworkYouTube) <> 0)
	set @SocialNetworkYouTubeEnabled = 1
	else
	set	@SocialNetworkYouTubeEnabled = 0
	
if(len(@SocialNetworkInstagram) <> 0)
	set @SocialNetworkInstagramEnabled = 1
	else
	set	@SocialNetworkInstagramEnabled = 0
	
if(len(@RequestEmail) <> 0)
	set @RequestEmailOnPlayer = 1
	else
	set	@RequestEmailOnPlayer = 0
	
	update Stations
	set	SocialNetworkFacebook = @SocialNetworkFacebook,
		SocialNetworkFacebookEnabled = @SocialNetworkFacebookEnabled,
		SocialNetworkTwitter = @SocialNetworkTwitter,
		SocialNetworkTwitterEnabled = @SocialNetworkTwitterEnabled,
		SocialNetworkYouTube = @SocialNetworkYouTube,
		SocialNetworkYouTubeEnabled = @SocialNetworkYouTubeEnabled,
		SocialNetworkInstagram = @SocialNetworkInstagram,
		SocialNetworkInstagramEnabled = @SocialNetworkInstagramEnabled
	where [CALL LTR] = @CallLtr
	
	update player
	set RequestEmail = @RequestEmail,
		RequestEmailOnPlayer = @RequestEmailOnPlayer
	where [Call LTR] = @CallLtr
	
	-- added 2015-07-08 by RADU
	DECLARE @mpID INT
	SET @mpID = (SELECT id FROM MobilePlayer WHERE [CallLTR] = @CallLtr)
	IF @mpID IS NULL
		BEGIN
			INSERT INTO MobilePlayer (CallLTR, ContactPhone)
				VALUES (@CallLtr, @ContactPhone)
		END
	ELSE
		BEGIN
			UPDATE MobilePlayer
			SET ContactPhone = @ContactPhone
				WHERE [CallLTR] = @CallLtr
		END
		
	Select @@ROWCOUNT

end
GO
</code>