﻿USE [AIADatabaseV5]
GO
/****** Object:  StoredProcedure [dbo].[InsertIncorrectLoginAttempt]    Script Date: 2/1/2018 12:15:55 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[InsertIncorrectLoginAttempt]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[InsertIncorrectLoginAttempt]
GO

CREATE PROCEDURE [dbo].[InsertIncorrectLoginAttempt] 
	-- Add the parameters for the stored procedure here
	-- User Id is  mandatory
	@iUserId int
AS
BEGIN

	DECLARE @dtLoginTime DATETIME 
	--DECLARE @cLoginAttempt CURSOR
	DECLARE @iCount INT;
	CREATE TABLE #tmpTable
	(
		RowReturn INT DEFAULT 1
	)
	SET @iCount = 0
	SET @dtLoginTime = getdate()
INSERT INTO IncorrectLoginAttempts (UserId, LoginTime, CntIncorrectLogins)
			VALUES(@iUserId,@dtLoginTime,1) 
SELECT @iCount = SCOPE_IDENTITY()
/*
	SET @cLoginAttempt = CURSOR FAST_FORWARD 
	FOR
	SELECT 1 
	FROM IncorrectLoginAttempts WHERE IncorrectLoginAttempts.UserId =  @iUserId  
	
	OPEN @cLoginAttempt 
		FETCH NEXT FROM @cLoginAttempt INTO @iCount
		-- start of while loop

		IF @iCount = 0
		BEGIN
			INSERT INTO IncorrectLoginAttempts (UserId, LoginTime, CntIncorrectLogins)
			VALUES(@iUserId,@dtLoginTime,1)   
		END	
		ELSE
		BEGIN
			UPDATE IncorrectLoginAttempts SET LoginTime=@dtLoginTime, CntIncorrectLogins = CntIncorrectLogins+1 
			WHERE UserId = @iUserId 
		END
	INSERT INTO #tmpTable values(1)*/
	 
END

GO
