spAddUpdate_ATHLETICS_TEAMS

Parameters

Parameter	Parameter Type	Mode
@ID	int	INOUT
@Sport	uniqueidentifier	IN
@Season	uniqueidentifier	IN
@Division	uniqueidentifier	IN
@Gender	uniqueidentifier	IN
@PageCreatorClientUsersID	int	IN
@ClientSitesID	int	IN
@Notes	nvarchar(2048)	IN

Definition

Copy


CREATE PROCEDURE [dbo].[spAddUpdate_ATHLETICS_TEAMS]
(
  @ID int output,
  @Sport uniqueidentifier,
  @Season uniqueidentifier,
  @Division uniqueidentifier,
  @Gender uniqueidentifier,
  @PageCreatorClientUsersID int,
  @ClientSitesID int,
  @Notes nvarchar(2048)
)
AS
  SET NOCOUNT ON

  IF @PageCreatorClientUsersID <=0
      SET @PageCreatorClientUsersID=null

  IF @ID = 0 BEGIN
    -- If the exact athletic team exists, just return the existing team ID.
    SELECT @ID = [ID]
    FROM ATHLETICS_TEAMS
    WHERE
      [Sport] = @Sport AND
      [Season] = @Season AND
      [Division] = @Division AND
      [Gender] = @Gender AND
      [Notes] = @Notes AND
      [ClientSitesID] = @ClientSitesID AND
      (
        ([PageCreatorClientUsersID] is null and (@PageCreatorClientUsersID is null or @PageCreatorClientUsersID < 0))
        OR
        [PageCreatorClientUsersID] = @PageCreatorClientUsersID
      )

    IF @ID = 0 BEGIN
      INSERT INTO ATHLETICS_TEAMS (
      [Sport],
      [Season],
      [Division],
      [Gender],
      [Notes],
      [ClientSitesID],
      [PageCreatorClientUsersID]
      )
      VALUES (
      @Sport,
      @Season,
      @Division,
      @Gender,
      @Notes,
      @ClientSitesID,
      @PageCreatorClientUsersID
      )
      set @ID = @@Identity;
    END
  END
  ELSE BEGIN
    UPDATE ATHLETICS_TEAMS SET
    [Sport] = @Sport,
    [Season] = @Season,
    [Division] = @Division,
    [Gender] = @Gender,
    [Notes] = @Notes,
    [ClientSitesID] = @ClientSitesID,
    [PageCreatorClientUsersID] = @PageCreatorClientUsersID
    WHERE [ID] = @ID
  END