spAddUpdate_ATHLETICS_EECOACHES

Parameters

Parameter	Parameter Type	Mode
@ID	int	INOUT
@TeamID	int	IN
@EA7RecordID	int	IN
@FirstName	nvarchar(256)	IN
@LastName	nvarchar(256)	IN
@Type	uniqueidentifier	IN
@HideContactInfo	bit	IN

Definition

Copy


      CREATE PROCEDURE [dbo].[spAddUpdate_ATHLETICS_EECOACHES]

          @ID int output,
          @TeamID int,
          @EA7RecordID int,
          @FirstName nvarchar(256),
          @LastName nvarchar(256),
          @Type uniqueidentifier,
          @HideContactInfo bit
      AS
      SET NOCOUNT ON
      IF @ID = 0 BEGIN
          INSERT INTO ATHLETICS_EECOACHES(
              [TeamID],
              [CoachEEID],
              [FirstName],
              [LastName],
              [Type],
              [HideContactInfo]
          )
          VALUES (
              @TeamID,
              @EA7RecordID,
              @FirstName,
              @LastName,
              @Type,
              @HideContactInfo
          )
          set @ID = @@Identity;
      END
      ELSE BEGIN
          UPDATE ATHLETICS_EECOACHES SET 
              [TeamID] = @TeamID,
              [CoachEEID] = @EA7RecordID,
              [FirstName] = @FirstName,
              [LastName] = @LastName,
              [Type] = @Type,
              [HideContactInfo] = @HideContactInfo
          WHERE [ID] = @ID

      END