desenvolvedor-io / dev-store Goto Github PK

Describe the bug
When I try to use Add-Migration DbInit -context OrdersContext in project DevStore.Orders.Infra I got this error bellow:

To Reproduce
Steps to reproduce the behavior:

1. Go to 'Package Manage Console'
2. Select the project 'DevStore.Orders.Infra'
3. Run the command 'Add-Migration DbInit -context OrdersContext'
4. See error

Expected behavior
Generate migrations files

Screenshots

Desktop (please complete the following information):

• OS: Windows 11
• Visual Studio Community 2022

Additional context
Add any other context about the problem here.

The website needs Google Tag Manager to measure important analytic data

At

PedidoQuery
public async Task<PedidoDTO> ObterUltimoPedido(Guid clienteId)

It throws error if the Query return null. Usually after a successful order payment.

Describe the bug
A clear and concise description of what the bug is.

To Reproduce
Steps to reproduce the behavior:

1. Go to 'home page'
2. Select an product
3. Click on 'Add to cart'
4. See 404 error page

Expected behavior
When user click on add to cart the product should be added.

Screenshots

Describe the bug
I used to run this project without any issues for a while, to understand and learn some things. However, lately it has started to throw this error related to the encryption part. It seems like the project is not recognizing the location of the certificate, is there a way to bypass this or completely mitigate this error?

To Reproduce
Steps to reproduce the behavior:

1. Update project to latest version in main branch
2. Go to docker path
3. With cmd/terminal execute docker-compose up
4. Wait until all containers are up and running.
5. See error Interop+Crypto+OpenSslCryptographicException: error:2006D080:BIO routines:BIO_new_file:no such file

Stacktrace
devstore-web-mvc-ecommerce | Unhandled exception. Interop+Crypto+OpenSslCryptographicException: error:2006D080:BIO routines:BIO_new_file:no such file devstore-web-mvc-ecommerce | at Interop.Crypto.CheckValidOpenSslHandle(SafeHandle handle) devstore-web-mvc-ecommerce | at Internal.Cryptography.Pal.OpenSslX509CertificateReader.FromFile(String fileName, SafePasswordHandle password, X509KeyStorageFlags keyStorageFlags) devstore-web-mvc-ecommerce | at System.Security.Cryptography.X509Certificates.X509Certificate..ctor(String fileName, String password, X509KeyStorageFlags keyStorageFlags) devstore-web-mvc-ecommerce | at System.Security.Cryptography.X509Certificates.X509Certificate2..ctor(String fileName, String password) devstore-web-mvc-ecommerce | at Microsoft.AspNetCore.Server.Kestrel.Core.Internal.Certificates.CertificateConfigLoader.LoadCertificate(CertificateConfig certInfo, String endpointName) devstore-web-mvc-ecommerce | at Microsoft.AspNetCore.Server.Kestrel.KestrelConfigurationLoader.LoadDefaultCert() devstore-web-mvc-ecommerce | at Microsoft.AspNetCore.Server.Kestrel.KestrelConfigurationLoader.Reload() devstore-web-mvc-ecommerce | at Microsoft.AspNetCore.Server.Kestrel.KestrelConfigurationLoader.Load() devstore-web-mvc-ecommerce | at Microsoft.AspNetCore.Server.Kestrel.Core.KestrelServerImpl.BindAsync(CancellationToken cancellationToken) devstore-web-mvc-ecommerce | at Microsoft.AspNetCore.Server.Kestrel.Core.KestrelServerImpl.StartAsync[TContext](IHttpApplication1 application, CancellationToken cancellationToken) devstore-web-mvc-ecommerce | at Microsoft.AspNetCore.Hosting.GenericWebHostService.StartAsync(CancellationToken cancellationToken) devstore-web-mvc-ecommerce | at Microsoft.Extensions.Hosting.Internal.Host.StartAsync(CancellationToken cancellationToken) devstore-web-mvc-ecommerce | at Microsoft.Extensions.Hosting.HostingAbstractionsHostExtensions.RunAsync(IHost host, CancellationToken token) devstore-web-mvc-ecommerce | at Microsoft.Extensions.Hosting.HostingAbstractionsHostExtensions.RunAsync(IHost host, CancellationToken token) devstore-web-mvc-ecommerce | at Program.<Main>$(String[] args) in /src/web/DevStore.WebApp.MVC/Program.cs:line 22 devstore-web-mvc-ecommerce | at Program.<Main>(String[] args) devstore-web-mvc-ecommerce exited with code 139

Expected behavior
Run all services correctly and have no issues with openssl.

Screenshots

Desktop (please complete the following information):

• OS: [Win 10, Zorin OS, Win 11]

Aditional Info
I tried on several different computers and different OS's believing that it was only in my environment or if it was some wrong configuration of my docker, but on these 4 computers it gave the same error.

When generate-pfx tries to delete a file that does not exist in the certs folder, the certificate creation process is aborted.

When some anonymous user try to put some item into shopping cart receives an error.

The expected behaviour was redirect to login page.

General Description

Create a Notifications Microservice responsible to manage all notifications (such as email, WhatsApp, SMS etc.) for order status changes, password changes etc.

Some Details

• The others Microservices would communicate with this Microservice via Message Broker.
• The WebApp would not access this Microservice.
• It could use either a simple SMTP class or Send Grid.
• The email templates could be in a Resource

We need better health checker to monitor database and other api's dependencies.

To facilitate project execution, would it be better for MessageBus Connection to be without user and password in the Development Environment ?

It's currently like this:

After the change it would look like this:

When running from local machine at Sql Server on Docker some queries get broken because the TimeZone.

At PedidoAPI:

But there are items at Database:

So, sending the "DateTime.Now" from API Backend it works:

      public async Task<PedidoDTO> ObterUltimoPedido(Guid clienteId)
        {
            const string sql = @"SELECT
                                P.ID AS 'ProdutoId', P.CODIGO, P.VOUCHERUTILIZADO, P.DESCONTO, P.VALORTOTAL,P.PEDIDOSTATUS,
                                P.LOGRADOURO,P.NUMERO, P.BAIRRO, P.CEP, P.COMPLEMENTO, P.CIDADE, P.ESTADO,
                                PIT.ID AS 'ProdutoItemId',PIT.PRODUTONOME, PIT.QUANTIDADE, PIT.PRODUTOIMAGEM, PIT.VALORUNITARIO 
                                FROM PEDIDOS P 
                                INNER JOIN PEDIDOITEMS PIT ON P.ID = PIT.PEDIDOID 
                                WHERE P.CLIENTEID = @clienteId 
                                AND P.DATACADASTRO between DATEADD(minute, -30,  @Now) and @Now
                                ORDER BY P.DATACADASTRO DESC";

            var pedido = await _pedidoRepository.ObterConexao()
                .QueryAsync<dynamic>(sql, new { clienteId, Now = DateTime.Now });

            if (!pedido.Any())
                return null;

            return MapearPedido(pedido);
        }

Is your feature request related to a problem? Please describe.
No

Describe the solution you'd like
A banner to show visitors the site is just a demo and not a real store. The banner must have a link to this repository.

Why not use cancellation token on the project ?

There are some projects that are using Dapper. E.g ProductRepository.

We are seeking to replace with EF Core. To be a database agnostic.

There is a problem in docker-compose-local-light.yml compose file, that causes unable to run the app. As the image below shows the ports is the main problem.

Just remove it and it will run perfectly.