USE [RICHSNBD]
GO
/****** Object: StoredProcedure [dbo].[UpdateUser_viewcount] Script Date: 11/24/2008 15:57:24 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
/* *****************************************************************************
Procedure : [UpdateUser_viewcount]
Function / Purpose : To update viewcount column of particular table
Trigger : No
Name of Author(s) : Ambikapathi
Start Date : Nov/22/2008
Tables involved : SubscriberLevel
Table Name : T_SubscriberLevel
#No. Modified By Modification Date :
Purpose :
*****************************************************************************
*/
CREATE PROCEDURE [dbo].[UpdateUser_viewcount]
@UserID UNIQUEIDENTIFIER
AS
DECLARE @Msg nvarchar(100)
DECLARE @RowCount int
DECLARE @Error int
DECLARE @view_count int
-- First check the user id is valid --
-- select view count from --
SELECT @view_count=view_count
FROM T_SubscriberLevel
where UserID=@UserID and
SubscriptionLevel=7
SELECT @Error = @@ERROR, @RowCount = @@ROWCOUNT
IF @Error != 0 OR @RowCount = 0
BEGIN
SET @Msg = ''
RAISERROR(@Msg,16,1)
RETURN 0
END
-- Have a valid User Id, so Update User Details -
UPDATE T_SubscriberLevel
SET view_count = @view_count+1
WHERE UserID = @UserID
SELECT @Error = @@ERROR, @RowCount = @@ROWCOUNT
IF @Error != 0 OR @RowCount = 0
BEGIN
SET @Msg = 'Unable to update user view count detail'
RAISERROR(@Msg,16,1)
RETURN 0
END
SELECT view_count
FROM T_SubscriberLevel
WHERE UserID = @UserID
RETURN 1
-- EXEC UpdateUser_viewcount 'e49273fd-7832-4365-b3ce-02221f58ebf4'
