server {
  listen      80;
  listen      [::]:80;
  server_name salonmlsarajevo.com;
  return      301 https://salonmlsarajevo.com$request_uri;
}

server {
  listen 443 ssl http2;
  listen [::]:443 ssl http2;

  ssl_certificate /etc/letsencrypt/live/salonmlsarajevo.com/fullchain.pem;
  ssl_certificate_key /etc/letsencrypt/live/salonmlsarajevo.com/privkey.pem;

  server_name salonmlsarajevo.com;

  try_files $uri $uri/ /index.html @proxy;

  location @proxy {
    proxy_pass http://127.0.0.1:83;
  }

  root /var/www/SalonML/;
  index index.html;
  autoindex off;
}

server {
  listen      80;
  listen      [::]:80;
  server_name salonmlsarajevo.com;
  return      301 https://salonmlsarajevo.com$request_uri;
}

server {
  listen 443 ssl http2;
  listen [::]:443 ssl http2;

  ssl_certificate /etc/letsencrypt/live/salonmlsarajevo.com/fullchain.pem;
  ssl_certificate_key /etc/letsencrypt/live/salonmlsarajevo.com/privkey.pem;

  server_name salonmlsarajevo.com;

  try_files $uri $uri/ /index.html @proxy;

  location @proxy {
    proxy_pass http://127.0.0.1:83;
  }

  root /var/www/SalonML/;
  index index.html;
  autoindex off;
}

server {
  listen      80;
  listen      [::]:80;
  server_name api.salonmlsarajevo.com;
  return      301 https://api.salonmlsarajevo.com$request_uri;
}
server {
  listen 443 ssl http2;
  listen [::]:443 ssl http2;

  ssl_certificate /etc/letsencrypt/live/salonmlsarajevo.com/fullchain.pem;
  ssl_certificate_key /etc/letsencrypt/live/salonmlsarajevo.com/privkey.pem;

  server_name api.salonmlsarajevo.com;

  root /var/www/SalonML_API/;
  index index.html;
  autoindex off;

  location / {
    proxy_pass http://localhost:5000;
    proxy_http_version 1.1;

    proxy_cache_bypass $http_upgrade;

    proxy_set_header Connection $http_connection;
    proxy_set_header Host $host;
    proxy_set_header Upgrade $http_upgrade;
    proxy_set_header X-Forwarded-For $proxy_add_x_forwarded_for;
    proxy_set_header X-Forwarded-Host $host:$server_port;
    proxy_set_header X-Forwarded-Proto $scheme;
    proxy_set_header X-Forwarded-Server $host;
  }
}

server {
  listen      80;
  listen      [::]:80;
  server_name api.salonmlsarajevo.com;
  return      301 https://api.salonmlsarajevo.com$request_uri;
}
server {
  listen 443 ssl http2;
  listen [::]:443 ssl http2;

  ssl_certificate /etc/letsencrypt/live/salonmlsarajevo.com/fullchain.pem;
  ssl_certificate_key /etc/letsencrypt/live/salonmlsarajevo.com/privkey.pem;

  server_name api.salonmlsarajevo.com;

  root /var/www/SalonML_API/;
  index index.html;
  autoindex off;

  location / {
    proxy_pass http://localhost:5000;
    proxy_http_version 1.1;

    proxy_cache_bypass $http_upgrade;

    proxy_set_header Connection $http_connection;
    proxy_set_header Host $host;
    proxy_set_header Upgrade $http_upgrade;
    proxy_set_header X-Forwarded-For $proxy_add_x_forwarded_for;
    proxy_set_header X-Forwarded-Host $host:$server_port;
    proxy_set_header X-Forwarded-Proto $scheme;
    proxy_set_header X-Forwarded-Server $host;
  }
}

System.InvalidOperationException: The LINQ expression 's => EntityShaperExpression: 
    SalonML_API.Data.Models.DynamicContent
    ValueBufferExpression: 
        ProjectionBindingExpression: EmptyProjectionMember
    IsNullable: False
.Name.Contains(s)' could not be translated. Either rewrite the query in a form that can be translated, or switch to client evaluation explicitly by inserting a call to 'AsEnumerable', 'AsAsyncEnumerable', 'ToList', or 'ToListAsync'. See https://go.microsoft.com/fwlink/?linkid=2101038 for more information.
   at Microsoft.EntityFrameworkCore.Query.RelationalSqlTranslatingExpressionVisitor.VisitLambda[T](Expression`1 lambdaExpression)

System.InvalidOperationException: The LINQ expression 's => EntityShaperExpression: 
    SalonML_API.Data.Models.DynamicContent
    ValueBufferExpression: 
        ProjectionBindingExpression: EmptyProjectionMember
    IsNullable: False
.Name.Contains(s)' could not be translated. Either rewrite the query in a form that can be translated, or switch to client evaluation explicitly by inserting a call to 'AsEnumerable', 'AsAsyncEnumerable', 'ToList', or 'ToListAsync'. See https://go.microsoft.com/fwlink/?linkid=2101038 for more information.
   at Microsoft.EntityFrameworkCore.Query.RelationalSqlTranslatingExpressionVisitor.VisitLambda[T](Expression`1 lambdaExpression)

[HttpGet]
public async Task<IActionResult> GetContent([FromQuery] string[]? strArray)
{
    // ** todo get this to order by OrderIndex **
    List<DynamicContentDTO> dynContentList;

    if (strArray == null)
        dynContentList = await _context.DynamicContents
         .OrderBy(x => x.OrderIndex)
         .Select(d => new DynamicContentDTO(d))
         .ToListAsync();
    else
        dynContentList = await _context.DynamicContents
         .OrderBy(x => x.OrderIndex)
         .Where(i => strArray.Any(s => i.Name.Contains(s)))
         //.Where(i => i.Name.Contains(substring[0]))
         .Select(d => new DynamicContentDTO(d))
         .ToListAsync();

    return Ok(dynContentList);
}

[HttpGet]
public async Task<IActionResult> GetContent([FromQuery] string[]? strArray)
{
    // ** todo get this to order by OrderIndex **
    List<DynamicContentDTO> dynContentList;

    if (strArray == null)
        dynContentList = await _context.DynamicContents
         .OrderBy(x => x.OrderIndex)
         .Select(d => new DynamicContentDTO(d))
         .ToListAsync();
    else
        dynContentList = await _context.DynamicContents
         .OrderBy(x => x.OrderIndex)
         .Where(i => strArray.Any(s => i.Name.Contains(s)))
         //.Where(i => i.Name.Contains(substring[0]))
         .Select(d => new DynamicContentDTO(d))
         .ToListAsync();

    return Ok(dynContentList);
}

if (builder.Environment.IsProduction())
{
    builder.Configuration.AddAzureKeyVault(
        new Uri($"https://{builder.Configuration["KeyVaultName"]}.vault.azure.net/"),
        new DefaultAzureCredential());
}

if (builder.Environment.IsProduction())
{
    builder.Configuration.AddAzureKeyVault(
        new Uri($"https://{builder.Configuration["KeyVaultName"]}.vault.azure.net/"),
        new DefaultAzureCredential());
}

var dynContentList = await _context.DynamicContents
                .OrderByDescending(x => x.OrderIndex)
                .Select(d => new DynamicContentDTO(d))
                .GroupBy(x => x.Name)
                .ToListAsync();

var dynContentList = await _context.DynamicContents
                .OrderByDescending(x => x.OrderIndex)
                .Select(d => new DynamicContentDTO(d))
                .GroupBy(x => x.Name)
                .ToListAsync();

System.InvalidOperationException: The LINQ expression 'DbSet<DynamicContent>()
    .OrderByDescending(x => x.OrderIndex)
    .Select(d => new DynamicContentDTO(d))
    .GroupBy(x => x.Name)' could not be translated. Either rewrite the query in a form that can be translated, or switch to client evaluation explicitly by inserting a call to 'AsEnumerable', 'AsAsyncEnumerable', 'ToList', or 'ToListAsync'. See https://go.microsoft.com/fwlink/?linkid=2101038 for more information.

System.InvalidOperationException: The LINQ expression 'DbSet<DynamicContent>()
    .OrderByDescending(x => x.OrderIndex)
    .Select(d => new DynamicContentDTO(d))
    .GroupBy(x => x.Name)' could not be translated. Either rewrite the query in a form that can be translated, or switch to client evaluation explicitly by inserting a call to 'AsEnumerable', 'AsAsyncEnumerable', 'ToList', or 'ToListAsync'. See https://go.microsoft.com/fwlink/?linkid=2101038 for more information.