cabal get is not project-file aware

[michaelpj]

Describe the bug
cabal get cannot get packages from repositories defined in the local project file.

To Reproduce

1. Put this in a cabal.project

repository cardano-haskell-packages
  url: https://input-output-hk.github.io/cardano-haskell-packages
  secure: True
  root-keys:
    3e0cce471cf09815f930210f7827266fd09045445d65923e6d0238a6cd15126f
    443abb7fb497a134c343faf52f0b659bd7999bc06b7f63fa76dc99d631f9bea1
    a86a1f6ce86c449c46666bda44268677abf29b5b2d2eb5ec7af903ec2f117a82
    bcec67e8e99cabfa7764d75ad9b158d72bfacf70ca1d0ec8bc6b4406d1bf8413
    c00aae8461a256275598500ea0e187588c35a5d5d7454fb57eac18d9edb86a56
    d4a35cd3121aa00d18544bb0ac01c3e1691d618f462c46129271bccf39f7e8ee

2. cabal update
3. cabal get cardano-crypto-class

Error: cabal: There is no package named 'cardano-crypto-class'.
You may need to run 'cabal update' to get the latest list of available
packages.

Expected behavior
I'd expect cabal get to work like other cabal commands and pick up information from the project file.

System information

• cabal-3.8.1.0

Additional context
I suspect in the past it was reasonably assumed that project files were irrelevant to cabal get, but since they can have extra repositories I think that's not true any more.

[ulysses4ever]

Dup of #8584 but with additional motivation.

[michaelpj]

Ah I failed to find that. Happy to close and copy over the information to that ticket if desired.

[ulysses4ever]

@michaelpj that would be very welcome, thank you!