CREATE PROCEDURE dbo.db_InsertQuestion
	@msg varchar(250),
	@Uid int,
	@ViewId int,
	@ChatRoomID int	
AS

	BEGIN TRANSACTION

		DECLARE @sendMessages int

		INSERT INTO 
			Questions
				(msg,
				Uid,
				ViewId)
			VALUES
				(@msg,
				@Uid,
				@ViewId)
		
		-- update user's message count
		SELECT @sendMessages = sendMessages FROM Chatters WHERE id = @Uid AND Chatid = @ChatRoomID
		-- increment count
		SET @sendMessages = @sendMessages + 1

		UPDATE Chatters SET lastAction = getdate(), sendMessages = @sendMessages WHERE id = @Uid AND Chatid = @ChatRoomID

		IF @@Error > 0 
			BEGIN
				ROLLBACK TRANSACTION
				RETURN
			END

	COMMIT TRANSACTION

CREATE PROCEDURE dbo.db_InsertQuestion
	@msg varchar(250),
	@Uid int,
	@ViewId int,
	@ChatRoomID int	
AS
SET NOCOUNT ON

DECLARE @err int ; SET @err = 0
DECLARE @cnt int ; SET @cnt = 0

BEGIN TRANSACTION

	INSERT INTO 
		dbo.Questions
			(msg,
			Uid,
			ViewId)
		VALUES
			(@msg,
			@Uid,
			@ViewId)
	SELECT @err=@@ERROR,@cnt=@@ROWCOUNT

	IF @err<>0 OR @cnt=0
		BEGIN
                        RAISERROR('Insert failed',16,1)
			ROLLBACK TRANSACTION
			RETURN 1
		END
	
        -- update user's message count
	UPDATE Chatters 
        SET lastAction = getdate(), sendMessages = (sendMessages+1)
        FROM Chatters
        WHERE id = @Uid AND Chatid = @ChatRoomID
        SELECT @err=@@ERROR,@cnt=@@ROWCOUNT

	IF @err<>0 OR @cnt=0
		BEGIN
                        RAISERROR('Update failed',16,1)
			ROLLBACK TRANSACTION
			RETURN 1
		END

COMMIT TRANSACTION

RETURN