namespace FrameworkDAL.Query.EIPConversation.EIPStepExecutionLog
{
    public static class EIPStepExecutionLogQB
    {
        public const string INSERT = @"
            INSERT INTO TEIPSTEPEXECUTION
                (STEPEXECUTIONID, INTERACTIONSESSIONID, SLNO, STEPCODE, STEPTYPE, STEPSTATUS,
                 STARTEDON, COMPLETEDON, DURATIONMS, INPUTVALUE, DECISIONCODE, ERRORMESSAGE)
            SELECT
                @StepExecutionId, @InteractionSessionId,
                ISNULL((SELECT MAX(SLNO) FROM TEIPSTEPEXECUTION WHERE INTERACTIONSESSIONID = @InteractionSessionId), 0) + 1,
                @StepCode, @StepType, @StepStatus,
                DATEADD(millisecond, -@DurationMs, GETDATE()), GETDATE(), @DurationMs,
                @InputValue, @DecisionCode, @ErrorMessage;";
    }
}