SET QUOTED_IDENTIFIER ON 
GO
SET ANSI_NULLS ON 
GO

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

-- ====================================================  
-- Author:  Magic Software  
-- Create date: 12-Feb-2018  
-- Description: To insert or update a user group of a license
-- ====================================================  
create PROCEDURE [dbo].[usp_InsertUpdateLicenseUserGroup] 
	-- Add the parameters for the stored procedure here
	@Id int, @LicenseId int, @Title varchar(100), @CreationDate datetime, @ModifiedDate datetime, @IsActive bit, @Status bit out
AS
BEGIN

	SET NOCOUNT ON;  
 set @Status = 0;  
 BEGIN TRY  
  BEGIN TRANSACTION  
  if(@Id = 0)
  begin
	insert into UserGroup(LicenseId, Title, CreationDate, ModifiedDate, IsActive) values(@LicenseId, @Title, @CreationDate, @ModifiedDate, @IsActive);
  end
  else
  begin
   update UserGroup set Title = @Title, CreationDate = @CreationDate, ModifiedDate = @ModifiedDate, @IsActive = @IsActive where Id = @Id;
  end
  COMMIT TRANSACTION  
  set @Status = 1;  
 END TRY  
 BEGIN CATCH  
  IF @@TRANCOUNT > 0  
   ROLLBACK TRANSACTION  
 END CATCH  
  
END  

GO
SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS ON 
GO