namespace FrameworkDAL.Query.EIPConversation.EIPConversationLog
{
    public static class EIPConversationLogQB
    {
        public const string GET_BY_INTERACTIONSESSIONID = @"
            SELECT TOP 1
                CONVERSATIONID       AS ConversationId,
                TENANTID             AS TenantId,
                INTERACTIONSESSIONID AS InteractionSessionId,
                CHANNELTYPE          AS ChannelType,
                SESSIONTOKEN         AS SessionToken
            FROM TEIPCONVERSATION
            WHERE INTERACTIONSESSIONID = @InteractionSessionId
            ORDER BY CONVERSATIONID DESC;";

        public const string INSERT_HEADER = @"
            INSERT INTO TEIPCONVERSATION
                (CONVERSATIONID, TENANTID, INTERACTIONSESSIONID, CHANNELTYPE, SESSIONTOKEN, LASTACTIVITYON,
                 VERSION, STATUS, SORTORDER, SOURCETYPE, CREATEDBYID, CREATEDON, MODIFIEDBYID, MODIFIEDON)
            VALUES
                (@ConversationId, @TenantId, @InteractionSessionId, @ChannelType, @SessionToken, GETDATE(),
                 0, 1, 9999, 5, @CreatedById, GETDATE(), @ModifiedById, GETDATE());";

        public const string TOUCH_LAST_ACTIVITY = @"
            UPDATE TEIPCONVERSATION
            SET    LASTACTIVITYON = GETDATE()
            WHERE  CONVERSATIONID = @ConversationId;";

        public const string INSERT_DETAIL = @"
            INSERT INTO TEIPCONVERSATIONDETAIL
                (CONVERSATIONDETAILID, CONVERSATIONID, SLNO, DIRECTION, MESSAGE, MESSAGESTATUS, CREATEDON)
            SELECT
                @ConversationDetailId, @ConversationId,
                ISNULL((SELECT MAX(SLNO) FROM TEIPCONVERSATIONDETAIL WHERE CONVERSATIONID = @ConversationId), 0) + 1,
                @Direction, @Message, 1, GETDATE();";
    }
}