USE [SCAR]
GO
/****** Object:  StoredProcedure [dbo].[SaveTeamRoster]    Script Date: 02/01/2016 16:14:01 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

ALTER PROCEDURE [dbo].[SaveTeamRoster]   	
	@SCARID varchar(50),
	@Name nvarchar(255),
	@Organisation nvarchar(255) ,
	@Title nvarchar(255),
	@IsChampion bit ,
	@PhoneNo varchar(128) ,
	@Email nvarchar(255) ,
	@CreatedBy varchar(128)		
	AS 
	SET NOCOUNT ON 

IF EXISTS(SELECT * FROM [dbo].[TeamRoster] WHERE [SCARID] = @SCARID)
    BEGIN 
       UPDATE [SCAR].[dbo].[TeamRoster]  SET
      [Name] = @Name,
      [Organisation] = @Organisation,
      [Title] = @Title,
      [IsChampion] =@IsChampion,
      [PhoneNo] = @PhoneNo,
      [Email] = @Email,            
      [LastUpdatedBy] = @CreatedBy,
      [LastUpdatedDateTime] = GETDATE()
 WHERE [SCARID] = @SCARID
       
       
    END
ELSE 
    BEGIN
        INSERT INTO [dbo].[Verification]
        (
            [SCARID]
           ,[AssignedTo]
           ,[Method]
           ,[VerificationType]
           ,[DueDate]
           ,[Result]
           ,[CreatedBy]
           ,[CreatedDateTime]
           ,[LastUpdatedBy]
           ,[LastUpdatedDateTime]
          )
          VALUES 
            ( 
				@SCARID ,
				@Name ,
				@Organisation ,
				@Title ,
				@IsChampion  ,
				@PhoneNo ,
				@Email ,
				@CreatedBy ,
				GETDATE() ,
				@CreatedBy ,
				GETDATE()				
            )       
    END


select * from Verification