using System;

namespace FrameworkDAL.Query.EIPConversation.EIPFlow
{
    public static class EIPFlowQB
    {
        // =========================================================
        // Get Flow by FlowCode (USED IN ENGINE)
        // =========================================================
        public const string GET_EIPFLOW = @"
            SELECT
                F.FLOWDEFINITIONID AS FlowDefinitionId,
                F.FLOWCODE         AS FlowCode,
                F.JSONDEFINITION   AS JsonDefinition,

                F.TENANTID         AS TenantId,

                F.FLOWVERSION      AS FlowVersion,
                F.FLOWSTATUS       AS FlowStatus,
                F.VERSION          AS Version,
                F.STATUS           AS Status,

                F.CREATEDBYID      AS CreatedById,
                CB.EMPLOYEENAME    AS CreatedByName,
                F.CREATEDON        AS CreatedOn,

                F.MODIFIEDBYID     AS ModifiedById,
                MB.EMPLOYEENAME    AS ModifiedByName,
                F.MODIFIEDON       AS ModifiedOn

            FROM MEIPFLOWDEFINITION F

            LEFT JOIN MEMPLOYEE CB 
                ON F.CREATEDBYID = CB.EMPLOYEEID

            LEFT JOIN MEMPLOYEE MB 
                ON F.MODIFIEDBYID = MB.EMPLOYEEID

            WHERE 
                F.FLOWCODE = @FlowCode
                AND F.TENANTID = @TenantId
                AND F.STATUS = 1;";


        // =========================================================
        // Select List
        // =========================================================
        public const string GET_SELECTLIST_EIPFLOW = @"
            SELECT
                FLOWDEFINITIONID AS Id,
                FLOWCODE         AS Code,
                FLOWCODE         AS Name
            FROM MEIPFLOWDEFINITION
            WHERE 
                TENANTID = @TenantId
                AND STATUS = 1;";


        // =========================================================
        // Insert
        // =========================================================
        public const string SAVE_EIPFLOW = @"
            INSERT INTO MEIPFLOWDEFINITION (
                FLOWDEFINITIONID,
                TENANTID,
                FLOWCODE,
                FLOWVERSION,
                FLOWSTATUS,
                JSONDEFINITION,
                VERSION,
                STATUS,
                SORTORDER,
                CREATEDBYID,
                CREATEDON,
                MODIFIEDBYID,
                MODIFIEDON,
                SOURCETYPE
            )
            VALUES (
                @FlowDefinitionId,
                @TenantId,
                @FlowCode,
                @FlowVersion,
                @FlowStatus,
                @JsonDefinition,
                @Version,
                @Status,
                @SortOrder,
                @CreatedById,
                @CreatedOn,
                @ModifiedById,
                @ModifiedOn,
                @SourceType
            );";


        // =========================================================
        // Update
        // =========================================================
        public const string UPDATE_EIPFLOW = @"
            UPDATE MEIPFLOWDEFINITION
            SET
                FLOWCODE        = @FlowCode,
                FLOWVERSION     = @FlowVersion,
                FLOWSTATUS      = @FlowStatus,
                JSONDEFINITION  = @JsonDefinition,
                VERSION         = @Version,
                STATUS          = @Status,
                SORTORDER       = @SortOrder,
                MODIFIEDBYID    = @ModifiedById,
                MODIFIEDON      = @ModifiedOn
            WHERE
                FLOWDEFINITIONID = @FlowDefinitionId
                AND TENANTID = @TenantId;";


        // =========================================================
        // Delete
        // =========================================================
        public const string DELETE_EIPFLOW = @"
            DELETE FROM MEIPFLOWDEFINITION
            WHERE 
                FLOWDEFINITIONID = @FlowDefinitionId
                AND TENANTID = @TenantId;";
    }
}