internal/functions/test-aaduserind365fo.ps1

function Test-AadUserInD365FO ($SqlCommand, $SignInName) {


    $commandText = get-content "$script:PSModuleRoot\internal\sql\Test-AadUserInD365FO.sql"
  
    $sqlCommand.CommandText = $commandText

    $null = $sqlCommand.Parameters.Add("@Email", $SignInName)
      
    $NumFound = $sqlCommand.ExecuteScalar()

    Write-Verbose "Number of user rows found in database $NumFound"

    $SqlCommand.Parameters.Clear()

    return $NumFound -ne 0

}