ALTER proc [dbo].[spRaces]
	@UpdateType as char(6),
	@RaceID as int = null,
	@SectionID as smallint = null,
	@Race as varchar(50) = null,
	@RaceDescription as varchar(MAX) = null
as
set nocount on
set xact_abort on
set arithabort on
declare @ErrorNum int

begin transaction

--Process a new race
if (@UpdateType = 'Insert')
begin
	insert into dbo.Races (SectionID, Race, RaceDescription) values (@SectionID, @Race, @RaceDescription);
	
	select @ErrorNum = @@ERROR;
	
	if (@ErrorNum = 0)
	begin
		exec @ErrorNum = dbo.spSubMenuItems @SectionID, 'Information', 'Races', 'Races', 'Races';
	end 
end
else
--Process an updated race
if (@UpdateType = 'Update')
begin
	update dbo.Races
	set SectionID = coalesce(@SectionID, SectionID), Race = coalesce(@Race, Race), RaceDescription =  coalesce(@RaceDescription, RaceDescription)
	where ID = @RaceID;
	
	select @ErrorNum = @@ERROR;
end
else
--Process a race removal
if (@UpdateType = 'Delete')
begin
	delete dbo.Races where ID = @RaceID;
	select @ErrorNum = @@ERROR;
end

if (@ErrorNum = 0)
begin
 	insert into dbo.SiteUpdates (SectionIDUpdated, SubSectionName, UpdatedItemName, UpdateType)
	values (@SectionID, 'Races', @Race, @UpdateType);
	
	select @ErrorNum = @@ERROR;
end
if (@ErrorNum = 0)
begin
	commit
end
else
begin
	rollback
end

return @ErrorNum;

ALTER proc [dbo].[spSubMenuItems]
@SectionID as smallint,
@MenuTitle as char(11),
@FileName as varchar(50),
@LinkTitle as varchar(50),
@LinkName as varchar(50)
as
set nocount on
set xact_abort on
set arithabort on
declare @ErrorNum int

begin transaction

if not exists (select 1 from dbo.SectionMenu where SectionID = @SectionID and MenuTitle = @MenuTitle)
begin
	insert into dbo.SectionMenu (SectionID, MenuTitle, FileName, LinkTitle, LinkName)
	values (@SectionID, @MenuTitle, @FileName, @LinkTitle, @LinkName);
	
	set @ErrorNum = @@Error;
end

if (@ErrorNum = 0)
begin
	commit
end
else
begin
	rollback
end

return @ErrorNum