Fix Blob Trigger Error

[Tonewall]

Fixing the issue in #9385
Http trigger apps are running into the error:
The Flex Consumption SKU only supports EventGrid as the source for BlobTrigger functions. Please update function 'SimpleHttpRequest' to use EventGrid. For more information see https://aka.ms/blob-trigger-eg.

Issue seems like the check is defaulting to true which runs for all triggers

Issue describing the changes in this PR

resolves #9386

Pull request checklist

• My changes do not require documentation changes
  • Otherwise: Documentation issue linked to PR
• My changes should not be added to the release notes for the next release
  • Otherwise: I've added my notes to release_notes.md
• My changes do not need to be backported to a previous version
  • Otherwise: Backport tracked by issue/PR #issue_or_pr
• My changes do not require diagnostic events changes
  • Otherwise: I have added/updated all related diagnostic events and their documentation (Documentation issue linked to PR)
• I have added all required tests (Unit tests, E2E tests)

[pragnagopa]

@Tonewall - Please see unit tests added in https://github.com/Azure/azure-functions-host/pull/9385/files - increase the test converage to include:

1. Other triggers that are not blob - EventHubTrigger
2. HttpTrigger + Blob Input + BlobOutput

[pragnagopa]

Update tests

[CooperLink]

Cherry-picked MyGet removal

[alrod]

The fix looks good to me.

Not sure why we changed the dependances in EndToEndTestFixture.cs

[Tonewall]

Update tests

Added test to cover http triggers to not have the error thrown