namespace FrameworkDAL.Query.EIPConversation.EIPTenant
{
    // MEIPTENANT does not exist in this schema — tenant identity is MCLIENT.
    // GET_TENANT reads from MCLIENT; SAVE_TENANT is a non-operational stub because
    // MCLIENT rows are created through client-onboarding, not through the EIP API.
    public static class EIPTenantQB
    {
        public const string GET_TENANT = @"
            SELECT
                CLIENTID   AS TenantId,
                CLIENTNAME AS TenantName,
                STATUS
            FROM MCLIENT
            WHERE CLIENTID = @tenantid
              AND STATUS   = 1;";


        // MCLIENT onboarding is managed separately — this statement must not be executed.
        // EIPTenantDAL.SaveTenantAsync should be redesigned to use the client provisioning flow.
        public const string SAVE_TENANT = @"
            SELECT 0; -- STUB: MCLIENT insert is handled by client onboarding, not EIP tenant API";
    }
}