CREATE PROCEDURE dbo.con_AddEngagementStep_6 @WorkflowId INT,
@WorkflowStepType INT,
@Title NVARCHAR(50),
@ParentWorkflowStepId INT,
@WorkSpaceId INT,
@CreatorId INT,
@YesStepId INT = NULL,
@NoStepId INT = NULL,
@STATUS NVARCHAR(200) = NULL,
@DATE DATETIME = NULL,
@TIME TIME = NULL,
@EmailName NVARCHAR(200) = NULL,
@AssignedTo INT = NULL,
@EmailId INT = NULL,
@Hours INT = NULL,
@Minutes INT = NULL,
@Days INT = NULL,
@Weeks INT = NULL,
@Subject NVARCHAR(200) = NULL,
@QuestionField NVARCHAR(200) = NULL,
@IsQuestionStepYes BIT = NULL,
@StageId INT = NULL,
@OpportunityName NVARCHAR(2000) = NULL,
@MoveToStepId INT = NULL,
@IsRepeatable BIT = NULL,
@INTERVAL NVARCHAR(50) = NULL,
@IsConsent BIT = NULL,
@UseDate BIT = NULL,
@EmailType TINYINT = 2,
@OpportunityAmount DECIMAL(18, 2) = NULL,
@OpportunityCurrency NVARCHAR(200) = N'GBP',
@OpportunityStepType TINYINT = NULL,
@AIID INT = NULL,
@EngagementId INT = NULL,
@TaskAssignedToId INT = NULL,
@TaskDescription NVARCHAR(MAX) = NULL,
@TaskScheduledDate DATETIME = NULL,
@TaskSubject NVARCHAR(100) = NULL,
@MeetingAssignedToId INT = NULL,
@MeetingDescription NVARCHAR(MAX) = NULL,
@MeetingScheduledDate DATETIME = NULL,
@MeetingPurpose NVARCHAR(50) = NULL,
@MeetingDuration INT = NULL

AS
BEGIN
  DECLARE @NewRecId BIGINT
         ,@stepId INT;

  EXEC con_getNextRecId1 @newRecId OUTPUT;

  INSERT INTO WorkflowSteps (WorkflowId, EngagementStepType, Title, ParentWorkflowStepId, WorkspaceId, CreatorId, recId,
  [STATUS], [DATE], [TIME], EmailToSendId, EmailName, AssignTo, [Hours], [Minutes], [Days], Weeks, Subject, QuestionField, QuestionYesOrNo, StageId, OpportunityName, MoveToStepId,
  IsRepeatable, INTERVAL, IsConsent, UseDate, EmailType, OpportunityAmount, OpportunityCurrency, OpportunityStepType, AIID, TaskAssignedToId, TaskDescription, TaskScheduledDate, TaskSubject, MeetingAssignedToId, MeetingDescription, MeetingScheduledDate, MeetingPurpose, MeetingDuration)
  OUTPUT INSERTED.Id
    VALUES (@WorkflowId, @WorkflowStepType, @Title, @ParentWorkflowStepId, @WorkspaceId, @CreatorId, @NewRecId, @STATUS, @DATE, @TIME, @EmailId, @EmailName, @AssignedTo, @Hours, @Minutes, @Days, @Weeks, @Subject, @QuestionField, @IsQuestionStepYes, @StageId, @OpportunityName, @MoveToStepId, @IsRepeatable, @INTERVAL, @IsConsent, @UseDate, @EmailType, @OpportunityAmount, @OpportunityCurrency, @OpportunityStepType, @AIID, @TaskAssignedToId, @TaskDescription, @TaskScheduledDate, @TaskSubject, @MeetingAssignedToId, @MeetingDescription, @MeetingScheduledDate, @MeetingPurpose, @MeetingDuration);

  SET @stepId = SCOPE_IDENTITY();

  UPDATE WorkflowSteps
  SET ParentWorkflowStepId = @stepId
  WHERE ParentWorkflowStepId = @ParentWorkflowStepId
  AND Id <> @stepId
  AND WorkflowId = @WorkflowId;


  IF ((ISNULL(@AIID, 0) != 0)
    AND (ISNULL(@EngagementId, 0) != 0))
  BEGIN
    UPDATE AI
    SET ForwardToEngagementId = @EngagementId
    WHERE Id = @AIID;
  END

  IF (@WorkflowStepType = 7
    AND @Title IS NULL)
  BEGIN
    SET @Title = @OpportunityName;
  END

  EXEC con_AddWorkflowHistory @Title
                             ,@WorkflowId
                             ,@CreatorId
                             ,'Added'
                             ,@WorkflowStepType;
END
GO