USE [AIADatabaseV5]
GO
/****** Object:  StoredProcedure [dbo].[usp_UpdateUserId]    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_UpdateUserId]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[usp_UpdateUserId]
GO
      
CREATE PROCEDURE [dbo].[usp_UpdateUserId]--6,'aiaonline1','aiaonline',0      
 -- Add the parameters for the stored procedure here      
 @Id int,      
 @UserId VARCHAR(50),    
 @olduserId varchar(50),      
 @Status int out      
AS      
BEGIN      
 -- SET NOCOUNT ON added to prevent extra result sets from      
 -- interfering with SELECT statements.      
 SET NOCOUNT ON;      
      
 set @Status = 0;      
 BEGIN TRY      
      
      
   if ((Select count(*) from AIAUser Where LoginId=@UserId)=1)    
   begin    
   -- Already exists    
   set @Status = 2;     
   --select '2'    
   end    
   else    
   begin    
     BEGIN TRANSACTION    
   UPDATE AIAUser SET LoginId= @UserId where Id = @Id and LoginId=@olduserId;     
   set @Status = 1;    
   COMMIT TRANSACTION      
   --select '1'    
   end    
       
       
 END TRY      
 BEGIN CATCH      
  IF @@TRANCOUNT > 0      
   ROLLBACK TRANSACTION      
 END CATCH      
      
END 


GO