SET QUOTED_IDENTIFIER ON 
GO
SET ANSI_NULLS ON 
GO

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


-- =============================================      
-- Author:  <Author,,Name>      
-- Create date: <3-Jan-2018>      
-- Description: <Description,,>      
-- =============================================      
CREATE PROCEDURE [dbo].[usp_UpdateblockedUser]--6,'aiaonline1','aiaonline',0      
 -- Add the parameters for the stored procedure here      
  @Id int,
  @Status int out  
AS      
BEGIN      
 -- SET NOCOUNT ON added to prevent extra result sets from      
 -- interfering with SELECT statements.      
 SET NOCOUNT ON;      
          
 BEGIN TRY      
      
      
    
     BEGIN TRANSACTION    
   DELETE  from IncorrectLoginAttempts where UserId =@Id  
   set @Status = 1;        
   COMMIT TRANSACTION      
   --select '1'    
     
       
       
 END TRY      
 BEGIN CATCH      
  IF @@TRANCOUNT > 0      
   ROLLBACK TRANSACTION      
 END CATCH      
      
END 

GO
SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS ON 
GO