Questions[asp.net-core]

Although there is information on the net that gives you a guide to answer this question, it is normally in English and is distributed in several documents, so I have decided to publish it so that others who are looking for information in Spanish have an idea.

I assume that we know how to relate the entities via the entity framework and what we are going to deal with here is how to retrieve all the information.

problem I have a class structure like this

As I anticipated, we have the entity configured in the ContextBase in such a way that they are related, but I have the problem that I do not know how to retrieve several levels, that is, retrieving master - detail is a piece of cake (there are only 2 levels) but in this case there are 5 levels. How can i do this then?

When reading documentation it said that it was not possible, but it is possible and we will see it later. This Solution has been tested with EF Core 3.1 and 5.0.

I am creating a scheduled task with Quartz.Net in Asp.Net Core 5.0, I had already done it in later versions and all is well with this example from the following link:

https://andrewlock.net/creating-a-quartz-net-hosted-service-with-asp-net-core/

But now it gives me the following error the moment the task is invoked:

Cannot resolve 'IntegracionDocu.Commons.QuartzDescargaProgramada' from root provider because it requires scoped service 'Microsoft.AspNetCore.Identity.UserManager`1[Microsoft.AspNetCore.Identity.IdentityUser]'.

(“I understand that I must create a scoped service for the singleton to consume”) I DON'T KNOW HOW TO DO IT??

I found this that should go in the QuartzDownloadScheduled class but I don't know where theIScopedService

 public Task Execute(IJobExecutionContext context)
    {
        // Create a new scope
        using(var scope = _provider.CreateScope())
        {
            // Resolve the Scoped service
            var service = scope.ServiceProvider.GetService<IScopedService>();
            _logger.LogInformation("Ejecutandose!");
        }

        return Task.CompletedTask;
    }
}

My code

Startup.cs

  public void ConfigureServices(IServiceCollection services)
        {
            // Agregamos servicio  Quartz
            services.AddSingleton<IJobFactory, SingletonJobFactory>();
            services.AddSingleton<ISchedulerFactory, StdSchedulerFactory>();
            // Agregamos nuestro trabajo programado
            services.AddSingleton<QuartzDescargaProgramada>();
            services.AddSingleton(new JobSchedule(jobType: typeof(QuartzDescargaProgramada), cronExpression: "0 54 22 ? * *"));
            services.AddHostedService<QuartzHostedService>();
         
        }

Good afternoon everyone, I am creating a service to show my user's profile data stored in my database, I am using Linq to do the procedure, but it is not returning the data of the registered user and it returns an error, I created my interfaces repository and service to be able to call the function in my controller and be able to have everything more ordered, only in the controller I am calling the function that is in my repository

this is my service

using Microsoft.AspNetCore.Authorization;
using Microsoft.AspNetCore.Mvc;
using Microsoft.Data.SqlClient;
using Microsoft.EntityFrameworkCore;
using Microsoft.Extensions.Configuration;
using Microsoft.IdentityModel.Tokens;
using Salesws.Context;
using Salesws.Models;
using Salesws.Service;
using Salesws.Service.Interfaces;
using System;
using System.Collections.Generic;
using System.Data;
using System.IdentityModel.Tokens.Jwt;
using System.Linq;
using System.Security.Claims;
using System.Text;
using System.Threading.Tasks;


namespace Salesws.RestControllers
{
    [Route("api/[controller]")]
    [ApiController]
    public class LoginController : ControllerBase
    {

        private IConfiguration _config;
        //Contexto de la base de datos SVM
        private readonly SVMcontext _context;
        private readonly IFechaService _fechaService;
        private readonly ILambSelLiquidacionService _iamb_Sel_Liquidacion;
        private readonly IPokectCargaService _pokectService;
        public LoginController(IConfiguration config, SVMcontext context,IFechaService fechaService,ILambSelLiquidacionService amb_Sel_LiquidacionService,IPokectCargaService pokectService)
        {
            _config = config;
            _context = context;
            _fechaService = fechaService;
            _iamb_Sel_Liquidacion = amb_Sel_LiquidacionService;
            //pokectservice
            _pokectService = pokectService;
            
        }

        //buscar Usuario por id 
        //servicio buscar perfil
        //[Authorize]
        [HttpGet("ugv_GetSetDSyncPerfil/{id}")]
        public ActionResult ugv_GetSetDSyncPerfil(string id)
        {
            var usuario = _pokectService.getDSCargaPerfil(id);
            return Ok(usuario);
        }
    }
}

this is my repository interface

using System;
using System.Collections.Generic;
using System.Linq;
using System.Threading.Tasks;

namespace Salesws.Service.Interfaces
{
    public interface IPokectCargaRepository
    {
        public string getDSCargaPerfil(string id);

    }
}

this is my service interface

using System;
using System.Collections.Generic;
using System.Linq;
using System.Threading.Tasks;

namespace Salesws.Service.Interfaces
{
    public interface IPokectCargaService
    {
        public string getDSCargaPerfil(string id);
    }
}

this is my service

using Salesws.Service.Interfaces;
using System;
using System.Collections.Generic;
using System.Linq;
using System.Threading.Tasks;

namespace Salesws.Service
{
    public class PokectCargaService : IPokectCargaService
    {
        private readonly IPokectCargaRepository _pokectRepository;
        public PokectCargaService(IPokectCargaRepository pokectRepository)
        {
            _pokectRepository = pokectRepository;
        }

        public string getDSCargaPerfil(string id)
        {
            return _pokectRepository.getDSCargaPerfil(id);
        }
    }
}

this is my repository

using Microsoft.EntityFrameworkCore;
using Salesws.Context;
using Salesws.Service.Interfaces;
using System;
using System.Collections.Generic;
using System.Data;
using System.Data.Common;
using System.Linq;
using System.Threading.Tasks;

namespace Salesws.Repository
{
    public class PokectCargaRepository :IPokectCargaRepository
    {
        private readonly SVMcontext _context;
        public PokectCargaRepository(SVMcontext context)
        {
            _context = context;
        }

        public string getDSCargaPerfil(string id)
        {
            var data = "{}";
            try
            {
                var qry = from usuario in _context.AfcmaPersonas
                          where usuario.CodUsuario.Equals(id)
                          select usuario;

                return qry.ToString();
            }
            catch (Exception e)
            {

            }
            return data;
        }

    }
}

this is the error that I get in the postman, it gives me ok but it does not show me the user data

I have been trying to configure a .net 5 (aspnet core) service when I try to upload the service using Nginx as a reverse proxy the GET and POST requests work but the wss (WebSocket) type requests fail.

I have the following configuration in the nginx configuration file:

location / {
        proxy_pass https://localhost:5001;
        proxy_http_version 1.1;
        proxy_set_header Upgrade $http_upgrade;
        proxy_set_header Connection keep-alive;
        proxy_set_header Host $host;
        proxy_cache_bypass $http_upgrade;
        proxy_set_header X-Forwarded-For $proxy_add_x_forwarded_for;
        proxy_set_header X-Forwarded-Proto $scheme;
}

Do you have any suggestions?

Hi, I'm new to using ASP.NET and I'm having trouble collecting the data:

In a view I show several elements in a table and in the last column there is a text box to be filled in by the user. The problem is that I don't know how to collect all the text strings of each of the forms in the Post controller. I would appreciate if someone could help me with this. Thanks in advance.

@if (Model.Habitaciones.Count == 0)
            {
                <tr><td colsapn="3">No hay habitaciones disponibles</td></tr>
            }
            else
            {
                foreach (Habitacion hab in Model.Habitaciones)
                {
                    <tr>
                        <td>
                            @Html.DisplayFor(modelItem => hab.NHabitacion)
                        </td>

                        <td>
                            @Html.DisplayFor(modelItem => hab.Tipo.NombreTipo)
                        </td>

                        <td>
                            @Html.DisplayFor(modelItem => hab.Precio)
                        </td>

                        <td>
                            <input type="text" name="Coments" value="Observacion" class="w-50"/>

                        </td>
                    </tr>
                }
            }