create procedure sp_insertCategory
(
	@idParent int = null ,
	@name varchar(150) ,
	@is_active bit = null
)
as
set nocount on
begin

	if ( @idParent is null )
	begin
		if ( exists(select id from _category where idParent is null and name = @name) )
		begin
		
			raiserror 50005 'The category '+ @name +' already exists'
			return
			
		end
	end else begin
		if ( exists(select id from _category where idParent = @idParent and name = @name) )
		begin
		
			raiserror 50005 'That category '+ @name +' already exists'
			return
		
		end
	end
	
	if ( @is_active is null )
		set @is_active = 0

	insert into _category ( idParent , name , is_active ) values ( @idParent , @name , @is_active )
	
	return @@identity

end

go