using System;

namespace FrameworkDAL.Query.EIPConversation.EIPActionRegistry
{
    public static class EIPActionRegistryQB
    {
        public const string GET_EIPACTIONREGISTRY = @"
            SELECT
                A.ACTIONID        AS ActionId,
                A.ACTIONCODE      AS ActionCode,
                A.ACTIONNAME      AS Name,
                A.ASSEMBLYNAME    AS ImplementationClass,
                A.TENANTID        AS TenantId,
                A.CREATEDBYID     AS CreatedById,
                CB.EMPLOYEENAME   AS CreatedByName,
                A.CREATEDON       AS CreatedOn,
                A.MODIFIEDBYID    AS ModifiedById,
                MB.EMPLOYEENAME   AS ModifiedByName,
                A.MODIFIEDON      AS ModifiedOn,
                A.STATUS          AS Status,
                A.VERSION         AS Version
            FROM MEIPACTIONREGISTRY A
            LEFT JOIN MEMPLOYEE CB ON A.CREATEDBYID  = CB.EMPLOYEEID
            LEFT JOIN MEMPLOYEE MB ON A.MODIFIEDBYID = MB.EMPLOYEEID
            WHERE A.ACTIONID = @ActionId
              AND A.TENANTID = @TenantId;";


        public const string GET_SELECTLIST_EIPACTIONREGISTRY = @"
            SELECT
                ACTIONID   AS Id,
                ACTIONCODE AS Code,
                ACTIONNAME AS Name
            FROM MEIPACTIONREGISTRY
            WHERE TENANTID = @TenantId;";


        public const string SAVE_EIPACTIONREGISTRY = @"
            INSERT INTO MEIPACTIONREGISTRY (
                ACTIONID,
                ACTIONCODE,
                ACTIONNAME,
                ASSEMBLYNAME,
                TENANTID,
                STATUS,
                VERSION,
                CREATEDBYID,
                CREATEDON,
                MODIFIEDBYID,
                MODIFIEDON
            )
            VALUES (
                @ActionId,
                @ActionCode,
                @ActionName,
                @ImplementationClass,
                @TenantId,
                @Status,
                @Version,
                @CreatedById,
                @CreatedOn,
                @ModifiedById,
                @ModifiedOn
            );";


        public const string UPDATE_EIPACTIONREGISTRY = @"
            UPDATE MEIPACTIONREGISTRY
            SET
                ACTIONCODE   = @ActionCode,
                ACTIONNAME   = @ActionName,
                ASSEMBLYNAME = @ImplementationClass,
                STATUS       = @Status,
                VERSION      = @Version,
                MODIFIEDBYID = @ModifiedById,
                MODIFIEDON   = @ModifiedOn
            WHERE ACTIONID = @ActionId
              AND TENANTID = @TenantId;";


        public const string DELETE_EIPACTIONREGISTRY = @"
            DELETE FROM MEIPACTIONREGISTRY
            WHERE ACTIONID = @ActionId
              AND TENANTID = @TenantId;";
    }
}