﻿USE [AIADatabaseV5]
GO
/****** Object:  StoredProcedure [dbo].[usp_UpdateUserId]    Script Date: 5/22/2018 4:48:14 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
      
ALTER 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,ModifiedDate=getdate() 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 


