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


-- =============================================      
-- Author:  <Author,,Name>      
-- Create date: <3-Jan-2018>      
-- Description: <Description,,>      
-- ============================================= 

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
     
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
