Migrate from .NET 7 to .NET 8

[henriqueholtz]

What does this PR ?

• Migrating all projects from .NET 7 to .NET 8
• Updating all packages to latest versions, except:
  • Elastic.Clients.Elasticsearch
  • Serilog.AspNetCore
• Got rid some simple warning
• /scripts/infra.yml was getting an error by default. It was fixed adding the environment variable POSTGRES_PASSWORD
• README: Adding cd scripts step in the section To run the whole solution

Considerations

Some unit and integrated tests are failing even before the changes:

• PricingService.IntegrationTest.PricingControllerTest.PriceForTravelPolicyIsCorrect
• DashboardService.Test.GetSalesTrendsQueryTest.SalesTrends_All_Product_In_First_Q_2020
• DashboardService.Test.GetSalesTrendsQueryTest.SalesTrends_HSI_Product_In_First_Q_2020

Running through scripts (containers)

When running scripts/infra-run.sh + scripts/app-run.sh the container dotnet-policy-service is failing even without this PR's changes with the following error (relation "outbox_messages" does not exist):

Unhandled exception. System.AggregateException: One or more errors occurred. (could not execute query
2024-06-19 07:46:24 [ select message0_.id as id1_0_, message0_.type as type2_0_, message0_.json_payload as json3_0_ from outbox_messages message0_ order by message0_.id asc limit :p0 ]
2024-06-19 07:46:24   Name:p1 - Value:50 [Type: NHibernate.Type.Int32Type (SqlType: Int32)]

[wojteksuwala]

Great thanks for contributing.