CREATE PROCEDURE dbo.db_InsertPrivateMessage
	@msg varchar(250),
	@FromUid int,
	@ToUid int,
	@ViewId int,
	@ChatRoomID int
AS

	BEGIN TRANSACTION

		DECLARE @sendMessages int, @CT int

		SELECT     @CT = Count(*)
		FROM         dbo.Questions INNER JOIN
		                    dbo.Chatters ON dbo.Questions.Uid = dbo.Chatters.id
		WHERE    msg = @msg AND Uid = @FromUid AND ViewID = @ViewID 

		-- If no records already exists
		IF @CT = 0
			BEGIN			
					
				INSERT INTO 
					Questions
						(msg,
						Uid,
						ReceiverID,
						isPrivate,
						ViewId)
					VALUES
						(@msg,
						@FromUid,
						@ToUid,
						'True',
						@ViewID)

		
				-- update user's message count
				SELECT @sendMessages = sendMessages FROM Chatters WHERE id = @FromUid AND Chatid = @ChatRoomID
				-- increment count
				SET @sendMessages = @sendMessages + 1
				-- update user table
				UPDATE Chatters SET lastAction = getdate(), sendMessages = @sendMessages WHERE id = @FromUid AND Chatid = @ChatRoomID
	
				IF @@Error > 0 
					BEGIN
						ROLLBACK TRANSACTION
						RETURN
					END
			END

	COMMIT TRANSACTION
GO