C Aldair's questions

good night to all community, please I need a lot of help, I need to convert this query into a SP, several tables are being selected and I asked for a lot of help to be able to do it, now I need to convert it into a SP and then consume it I would greatly appreciate it

select nt.CUN,
       rb2.IdRubro,
       rb2.DescripcionRubro,
       rb1.IdRubro,
       rb1.DescripcionRubro,
       nt.TotalMoneda1,
       nt.TotalMoneda2,
       cosn.IdRubro2,
       cosn.DescripcionRubro2,
       cosn.TotalMoneda1,
       cosn.TotalMoneda2
from pwt.Nota nt
inner join pwt.CargaDetalle cd
on nt.IdCargaDetalle = cd.IdCargaDetalle 
inner join pwt.Rubro rb1
on nt.IdRubro = rb1.IdRubro
inner join pwt.Rubro rb2
on cd.IdRubro = rb2.IdRubro 
left join (
    select csli.CUN as CUN,
          cni.IdRubro as IdRubro1,
          ru2.DescripcionRubro as DescripcionRubro1,
          csli.IdRubro as IdRubro2,
          ru1.DescripcionRubro as DescripcionRubro2,
          csli.TotalMoneda1 as TotalMoneda1,
          csli.TotalMoneda2 as TotalMoneda2
    from pwt.ConsolidadoSubLineaIndividual csli
    inner join pwt.ConsolidadoNotaIndividual cni
    on csli.IdConsolidadoNo = cni.IdConsolidadoNo
    inner join pwt.ConsolidadoIndividual ci
    on cni.IdConsolidadoIn = ci.IdConsolidadoIn
    inner join pwt.Rubro ru1
    on csli.IdRubro = ru1.IdRubro
    inner join pwt.Rubro ru2
    on cni.IdRubro = ru2.IdRubro
    where ci.IdCabecera = 928
) as cosn 
on nt.IdRubro = cosn.IdRubro1
where cd.IdCabecera IN (928,929) 
order by CUN 

Hello everyone, community, I have a problem that I get a list of objects, but when I want to update the same list of objects that I get, it is giving me an error, I am going through the list with foreach so that it reads each object from the list, but it does not It is recognizing, the input variable is the model of the RolPermiso class and it is a post method and I send the list of objects as json, what is my error?

this is my repository

 public string updateRolPermiso(RolPermiso rp)
        {
            string rpta = "";
            List<RolPermiso> rolPermiso = _condominioContext.RolPermiso.Where(x => x.RolPerCod.Equals(rp.RolPerCod)).ToList();

            foreach (var item in rolPermiso)
            {
                item.RolPerCod = rp.RolPerCod;
                item.RolPerCodRol = rp.RolPerCodRol;
                item.RolPerCodPer = rp.RolPerCodPer;
                item.RolPerEst = rp.RolPerEst;
                item.RolPerFecCre = rp.RolPerFecCre;
                item.RolPerUsuCre = rp.RolPerUsuCre;
                item.RolPerFecMod = rp.RolPerFecMod;
                item.RolPerUsuMod = rp.RolPerUsuMod;
            }
            _condominioContext.SaveChanges();
            rpta = "Los permisos se actualizaron correctamente";
            return rpta;
              
        }

this is my controller

[HttpPost("actualizarRolPer")]
        public ActionResult actualizarRolPer([FromBody] RolPermiso rolPermiso)
        {
            IActionResult result = Unauthorized();
            string rpta = _adminService.updateRolPermiso(rolPermiso);
            try
            {
                if (rpta.Equals("Los permisos se actualizaron correctamente"))
                {
                    result = Ok(new { messaje = rpta, error = false, data = new { permisos = rolPermiso } });
                }
                else
                {
                    result = Ok(new { messaje = "No se pudo actualizar los permisos", error = true });
                }
            }
            catch
            {
                result = Ok(new { messaje = "Sé origino un error en el proceso", error = true });
            }
            return Ok(result);
        }

the json that I send

[
    {
        "rolPerCod": 1,
        "rolPerCodRol": 1,
        "rolPerCodPer": 1,
        "rolPerEst": "0",
        "rolPerFecCre": "2021-05-28T09:59:03.82",
        "rolPerUsuCre": "",
        "rolPerFecMod": null,
        "rolPerUsuMod": null
    },
    {
        "rolPerCod": 2,
        "rolPerCodRol": 1,
        "rolPerCodPer": 1,
        "rolPerEst": "0",
        "rolPerFecCre": "2021-05-28T10:04:59.387",
        "rolPerUsuCre": "",
        "rolPerFecMod": null,
        "rolPerUsuMod": null
    }
]

in postman it throws me this error

{
    "type": "https://tools.ietf.org/html/rfc7231#section-6.5.1",
    "title": "One or more validation errors occurred.",
    "status": 400,
    "traceId": "00-d3cfa013ca4db34ca0d4ec28609d5e22-a89c280de6967a4a-00",
    "errors": {
        "$": [
            "The JSON value could not be converted to Condominios.Models.RolPermiso. Path: $ | LineNumber: 0 | BytePositionInLine: 1."
        ]
    }
}

I am trying to enter a list of objects in a datatable in ASP.NET Core, I am joining two tables, the tables are user and role, which I am taking fields from both tables, I use linq to join the fields, it gives me a list of objects and those objects I want to be added to a datatable and to be able to show the list of objects, when sending in postman it gives me an error I want you to show me the users who have the same sap code, but also to show me the name of the role and that field is in the role table, it will return several users

this is my repository

        public DataTable buscarUsuario(string cod_sap)
        {
            DataTable dt = new DataTable("listaUsuariosXrol");
            DataColumn usu_nom_ape = new DataColumn("nombre");
            DataColumn usu_usu = new DataColumn("usuario");
            DataColumn usu_cla = new DataColumn("clave");
            DataColumn usu_cor = new DataColumn("correo");
            DataColumn usu_cod_sap = new DataColumn("cod_sap");
            DataColumn usu_est = new DataColumn("estado");
            DataColumn usu_cod_rol = new DataColumn("rol");
            DataColumn rol_nom = new DataColumn("nombre_rol");

            dt.Columns.Add(usu_nom_ape);
            dt.Columns.Add(usu_usu);
            dt.Columns.Add(usu_cla);
            dt.Columns.Add(usu_cor);
            dt.Columns.Add(usu_cod_sap);
            dt.Columns.Add(usu_est);
            dt.Columns.Add(usu_cod_rol);
            dt.Columns.Add(rol_nom);

            var usuario = (from usu in _quimpacContext.Usuarios
                           join r in _quimpacContext.Rol
                           on usu.usu_cod_rol equals r.rol_cod
                           where usu.usu_cod_sap.Equals(cod_sap)
                           select new
                           {
                               usu.usu_nom_ape,
                               usu.usu_usu,
                               usu.usu_cla,
                               usu.usu_cor,
                               usu.usu_cod_sap,
                               usu.usu_est,
                               usu.usu_cod_rol,
                               r.rol_nom
                           }).ToList();
            foreach (var item in usuario)
            {
                //creas una nueva row
                DataRow row = dt.NewRow();
                //asignas el dato a cada columna de la row
                row["nombre"] = item.usu_nom_ape;
                row["usuario"] = item.usu_usu;
                row["clave"] = item.usu_cla;
                row["correo"] = item.usu_cor;
                row["cod_sap"] = item.usu_cod_sap;
                row["estado"] = item.usu_est;
                row["rol"] = item.usu_cod_rol;
                row["nombre_rol"] = item.rol_nom;

                dt.Rows.Add(row);
            } 
                return dt;
        }

the error it gives me is the following

System.NotSupportedException: Serialization and deserialization of 'System.Type' instances are not supported and should be avoided since they can lead to security issues. Path: $.Columns.DataType.
 ---> System.NotSupportedException: Serialization and deserialization of 'System.Type' instances are not supported and should be avoided since they can lead to security issues.
   at System.Text.Json.Serialization.Converters.TypeConverter.Write(Utf8JsonWriter writer, Type value, JsonSerializerOptions options)
   at System.Text.Json.Serialization.JsonConverter`1.TryWrite(Utf8JsonWriter writer, T& value, JsonSerializerOptions options, WriteStack& state)
   at System.Text.Json.JsonPropertyInfo`1.GetMemberAndWriteJson(Object obj, WriteStack& state, Utf8JsonWriter writer)
   at System.Text.Json.Serialization.Converters.ObjectDefaultConverter`1.OnTryWrite(Utf8JsonWriter writer, T value, JsonSerializerOptions options, WriteStack& state)
   at System.Text.Json.Serialization.JsonConverter`1.TryWrite(Utf8JsonWriter writer, T& value, JsonSerializerOptions options, WriteStack& state)
   at System.Text.Json.Serialization.JsonConverter`1.TryWriteAsObject(Utf8JsonWriter writer, Object value, JsonSerializerOptions options, WriteStack& state)
   at System.Text.Json.Serialization.JsonConverter`1.TryWrite(Utf8JsonWriter writer, T& value, JsonSerializerOptions options, WriteStack& state)
   at System.Text.Json.Serialization.Converters.IEnumerableConverter`1.OnWriteResume(Utf8JsonWriter writer, TCollection value, JsonSerializerOptions options, WriteStack& state)
   at System.Text.Json.Serialization.Converters.IEnumerableDefaultConverter`2.OnTryWrite(Utf8JsonWriter writer, TCollection value, JsonSerializerOptions options, WriteStack& state)
   at System.Text.Json.Serialization.JsonConverter`1.TryWrite(Utf8JsonWriter writer, T& value, JsonSerializerOptions options, WriteStack& state)
   at System.Text.Json.JsonPropertyInfo`1.GetMemberAndWriteJson(Object obj, WriteStack& state, Utf8JsonWriter writer)
   at System.Text.Json.Serialization.Converters.ObjectDefaultConverter`1.OnTryWrite(Utf8JsonWriter writer, T value, JsonSerializerOptions options, WriteStack& state)
   at System.Text.Json.Serialization.JsonConverter`1.TryWrite(Utf8JsonWriter writer, T& value, JsonSerializerOptions options, WriteStack& state)
   at System.Text.Json.Serialization.JsonConverter`1.WriteCore(Utf8JsonWriter writer, T& value, JsonSerializerOptions options, WriteStack& state)
   --- End of inner exception stack trace ---
   at System.Text.Json.ThrowHelper.ThrowNotSupportedException(WriteStack& state, NotSupportedException ex)
   at System.Text.Json.Serialization.JsonConverter`1.WriteCore(Utf8JsonWriter writer, T& value, JsonSerializerOptions options, WriteStack& state)
   at System.Text.Json.Serialization.JsonConverter`1.WriteCoreAsObject(Utf8JsonWriter writer, Object value, JsonSerializerOptions options, WriteStack& state)
   at System.Text.Json.JsonSerializer.WriteCore[TValue](JsonConverter jsonConverter, Utf8JsonWriter writer, TValue& value, JsonSerializerOptions options, WriteStack& state)
   at System.Text.Json.JsonSerializer.WriteAsyncCore[TValue](Stream utf8Json, TValue value, Type inputType, JsonSerializerOptions options, CancellationToken cancellationToken)
   at Microsoft.AspNetCore.Mvc.Formatters.SystemTextJsonOutputFormatter.WriteResponseBodyAsync(OutputFormatterWriteContext context, Encoding selectedEncoding)
   at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.<InvokeResultAsync>g__Logged|21_0(ResourceInvoker invoker, IActionResult result)
   at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.<InvokeNextResultFilterAsync>g__Awaited|29_0[TFilter,TFilterAsync](ResourceInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted)
   at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.Rethrow(ResultExecutedContextSealed context)
   at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.ResultNext[TFilter,TFilterAsync](State& next, Scope& scope, Object& state, Boolean& isCompleted)
   at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.InvokeResultFilters()
--- End of stack trace from previous location ---
   at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.<InvokeFilterPipelineAsync>g__Awaited|19_0(ResourceInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted)
   at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.<InvokeAsync>g__Logged|17_1(ResourceInvoker invoker)
   at Microsoft.AspNetCore.Routing.EndpointMiddleware.<Invoke>g__AwaitRequestTask|6_0(Endpoint endpoint, Task requestTask, ILogger logger)
   at Microsoft.AspNetCore.Authorization.AuthorizationMiddleware.Invoke(HttpContext context)
   at Microsoft.AspNetCore.Authentication.AuthenticationMiddleware.Invoke(HttpContext context)
   at Microsoft.AspNetCore.Diagnostics.DeveloperExceptionPageMiddleware.Invoke(HttpContext context)

I want the following to return

[
    {
        "usu_nom_ape": "Christian Espinoza ",
        "usu_usu": "cespinoza",
        "usu_cla": "123456",
        "usu_cor": "[email protected]",
        "usu_cod_sap": "0000105680",
        "usu_est": "1",
        "usu_cod_rol": 1,
        "usu_cod_cli": 1,
        "rol_nom": "Administrador"
    },
    {
        "usu_nom_ape": "Joel Torres",
        "usu_usu": "jtorre",
        "usu_cla": "123456",
        "usu_cor": "[email protected]",
        "usu_cod_sap": "0000105680",
        "usu_est": "1",
        "usu_cod_rol": 35,
        "usu_cod_cli": 1,
        "rol_nom": "Vendedor"
    },
    {
        "usu_nom_ape": "Lucia Campos",
        "usu_usu": "clucia",
        "usu_cla": "123456",
        "usu_cor": "[email protected]",
        "usu_cod_sap": "0000105680",
        "usu_est": "1",
        "usu_cod_rol": 43,
        "usu_cod_cli": 1,
        "rol_nom": "Cliente"
    }
]

I am trying to convert a string to date format in .net Core but it gives me an error when converting it, I am implementing the Convert.ToDateTime(string) in both fields, one in my input variable and another in my ity attribute since it is also a string . What I want is to be able to convert it to a datetime so I can do a date filter from - to and be able to list the dates from that range

this is my code

public List<Stock_Cliente> visualizarMov(StockClienteFil stk)
        {
            DateTime fechaDesde = Convert.ToDateTime(stk.fec_mov_des);
            DateTime fechaHasta = Convert.ToDateTime(stk.fec_mov_has);

            var visualizarMov = _quimpacContex.Stock_Cliente.Where(x => x.stk_cli_des_alm.Contains(stk.des_alm) && x.stk_cli_des_mat.Contains(stk.des_mat)
             && x.stk_cli_num_lot.Contains(stk.num_lot) && x.stk_cli_ser_pre.Contains(stk.ser_pre) && x.stk_cli_buq.Contains(stk.cli_buq)
             && Convert.ToDateTime(x.stk_cli_fec_mov) >= fechaDesde && Convert.ToDateTime(x.stk_cli_fec_mov) >= fechaHasta).ToList();   
            return visualizarMov;
        }

this is my Stock_Customer class

public class Stock_Cliente
    {
        [Key]
        public int stk_cli_cod { get; set; }
        public string stk_cli_cod_cen { get; set; }
        public string stk_cli_des_cen { get; set; }
        public string stk_cli_cod_cli { get; set; }
        public string stk_cli_des_cli { get; set; }
        public string stk_cli_cod_alm { get; set; }
        public string stk_cli_des_alm { get; set; }
        public string stk_cli_num_mat { get; set; }
        public string stk_cli_des_mat { get; set; }
        public string stk_cli_uni_med { get; set; }
        public string stk_cli_num_lot { get; set; }
        public string stk_cli_fec_mov { get; set; }
        public string stk_cli_ser_pre { get; set; }
        public decimal stk_cli_can { get; set; }
        public string stk_cli_buq { get; set; }
        public string stk_cli_fec_lle { get; set; }
        public string stk_cli_hor_lle { get; set; }
        public string stk_cli_fec_sal { get; set; }
        public string stk_cli_hor_sal { get; set; }
        public string stk_cli_est { get; set; }
        public DateTime? stk_cli_fec_cre { get; set; }
        public string? stk_cli_usu_cre_sap { get; set; }
        public DateTime? stk_cli_fec_mod { get; set; }
        public string? stk_cli_usu_mod_sap { get; set; }
    }

this is the json i send you

{
    "des_alm":"Tanque TKG13",
    "des_mat":"ACEITE",
    "num_lot":"CN-S",
    "ser_pre":"Despacho",
    "cli_buq":"PAB4168",
    "fec_mov_des":"20/12/2019",
    "fec_mov_has":"25/03/2019"
}

this is the error that generates me

System.InvalidOperationException: 'The LINQ expression 'DbSet<Stock_Cliente>()
.Where(s => s.stk_cli_des_alm.Contains(__stk_des_alm_0) && 
s.stk_cli_des_mat.Contains(__stk_des_mat_1) && 
s.stk_cli_num_lot.Contains(__stk_num_lot_2) && 
s.stk_cli_ser_pre.Contains(__stk_ser_pre_3) && 
s.stk_cli_buq.Contains(__stk_cli_buq_4) && 
Convert.ToDateTime(s.stk_cli_fec_mov) >= __fechaDesde_5 && 
Convert.ToDateTime(s.stk_cli_fec_mov) >= __fechaHasta_6)'
could not be translated. Additional information: 
Translation of method 'System.Convert.ToDateTime' failed. If this method can be mapped to your custom function, see https://go.microsoft.com/fwlink/?linkid=2132413 for more information.
Translation of method 'System.Convert.ToDateTime' failed. If this method can be mapped to your custom function, see https://go.microsoft.com/fwlink/?linkid=2132413 for more information. 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.'

this is my table in my bd

I have created an ASP.NET Core project in web API, in my controller I am trying to list my users but it gives me an error, the list of users is in my controller I have only added two users, what am I failing in? is it ok to create my user list in my controller?

this is my controller

using Microsoft.AspNetCore.Mvc;
using Project001.Models;
using System;
using System.Collections.Generic;
using System.Linq;
using System.Threading.Tasks;

// For more information on enabling Web API for empty projects, visit https://go.microsoft.com/fwlink/?LinkID=397860

namespace Project001.Controllers
{
    [Route("api/[controller]")]
    [ApiController]
    public class UserController : ControllerBase
    {
        // GET: api/<UserController>
        [HttpGet("lista")]
        public ActionResult listaUsuarios(int id)
        {
            var usuarios = from user in users()
                           where user.id.Equals(id)
                           select user;
            return (ActionResult)usuarios;
        }

        [NonAction]
        public List<User> users()
        {
            return new List<User>
            {
                new User
                {
                    id=1,
                    nombre="juan",
                    apellido="torres",
                    numero=12345
                },
                new User
                {
                    id=2,
                    nombre="pepe",
                    apellido="luna",
                    numero=678910
                }
            };
        }
    }
}

this is the error i get

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 am implementing a service in ASP.NET Core but it gives me a procedure error, as I understand it is because of the type of variable that I am entering and I sent a string instead of int , I changed it but I still get the same error, what else should I do implement or change so that it works for me and stops that error. Also, as I would return several returns in my postman, I mean that it executes several queries in a single service, one by one. Thanks for your help beforehand.

this is my controller

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;

// For more information on enabling Web API for empty projects, visit https://go.microsoft.com/fwlink/?LinkID=397860

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;
        public LoginController(IConfiguration config, SVMcontext context,IFechaService fechaService,ILambSelLiquidacionService amb_Sel_LiquidacionService)
        {
            _config = config;
            _context = context;
            _fechaService = fechaService;
            _iamb_Sel_Liquidacion = amb_Sel_LiquidacionService;
        }

        [HttpGet("liqui/{celular}/{cod_liquidacion}")]
        public ActionResult liqui()
        {
            var liqui = _iamb_Sel_Liquidacion.liquidacion();
            return Ok(liqui);
        }
    }
}

this is my repository

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

namespace Salesws.Service.Interfaces
{
    public interface ILambSelLiquidacionRepository
    {
        int liquidacion();
    }
}

this my service

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

namespace Salesws.Service.Interfaces
{
    public interface ILambSelLiquidacionService
    {
        int liquidacion();
    }
}

I implement my service

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

namespace Salesws.Service
{
    public class AmbSelLiquidacionService:ILambSelLiquidacionService
    {
        private ILambSelLiquidacionRepository _liqui;
        public AmbSelLiquidacionService(ILambSelLiquidacionRepository liqui)
        {
            _liqui = liqui;
        }


        int ILambSelLiquidacionService.liquidacion()
        {
            return _liqui.liquidacion();
        }
    }
}

implement the procedure

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.Models
{
    public class AmbSelLiquidacionRepository:ILambSelLiquidacionRepository
    {
        private readonly SVMcontext _context;


        public AmbSelLiquidacionRepository(SVMcontext context)
        {
            _context = context;
        }

        public int liquidacion()
        {
            int liqui = 0;
            using (DbCommand command = _context.Database.GetDbConnection().CreateCommand())
            {
                command.CommandText = "dbo.amb_sel_liquidacion";
                command.CommandType = CommandType.StoredProcedure;
                _context.Database.OpenConnection();
                using (var resultado = command.ExecuteReader())
                {
                    while (resultado.Read())
                    {
                        liqui = (int)resultado[0];
                    }
                }
                _context.Database.CloseConnection();
            }
            return liqui;
        }
    }
}

This is the error

How can I convert this procedure in linQ, I am learning and I would like an example of how to convert it and be able to guide me so I can start practicing on my own, I was looking for examples but they only give the basics, this procedure handles joins and has 2 inputs, I want to pass it to ASP.NET Core

this is the procedure

USE [SVMQAS]
GO
/****** Object:  StoredProcedure [dbo].[ugv_sp_pin_validation]    Script Date: 10/12/2020 11:57:59 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER procedure [dbo].[ugv_sp_pin_validation] 
@IMEI varchar(25),
@PIN varchar(15)

as
BEGIN
  -- date: 31/07/2020
  declare @cod_persona varchar(110)
  declare @es_reparto bit = 0

    select @cod_persona = p.cod_persona
    from afcma_persona p
      join afcma_vendedor v on v.cod_vendedor = p.cod_persona
    where p.IMEI = @IMEI and p.cod_clave=@PIN

  if @cod_persona is null
    begin
      select @cod_persona = cod_persona, @es_reparto = 1
      from afcma_persona
      where imei2 = @IMEI and cod_clave=@PIN
    end

    select p.cod_persona,
           p.cod_tipo_persona,
           iif(@es_reparto = 0, p.dsc_razon_social, concat('REPARTO DE ', p.dsc_razon_social)) dsc_razon_social,
           p.dsc_nombre_comercial,
           p.num_ruc,
           p.num_doc_identidad,
           p.flg_afecto_percepcion,
           p.cod_clave,
           p.IMEI,
           p.PERNR,
           p.fch_ultima_venta,
           p.imp_ultima_venta,
           iif(@es_reparto = 1, cast(1 as bit), v.iti_reparto) iti_reparto,
           iif(@es_reparto = 1, cast(0 as bit), v.iti_preventista) iti_preventista,
           p.cod_repartidor,
           p.imei2
    from afcma_persona p
      join afcma_vendedor v on v.cod_vendedor = p.cod_persona
    where p.cod_persona = @cod_persona

END

I am implementing Jwt in my webApi and it generates an error when calling the route, in my controller is the code that generates the token and also the other services with the Authorize in each one until I generate the token that allows me to use the services, what would be my mistake that I am committing? Why does it give me that error in postman? I also don't know whether to create another controller and then put the code of the token and the other services in another controller with Authorize, will there be no problem?

this is the error i get in postman

System.InvalidOperationException: Multiple constructors accepting all given argument types have been found in type 'AjiPu.Controllers.ClienteController'. There should only be one applicable constructor.
   at Microsoft.Extensions.DependencyInjection.ActivatorUtilities.TryFindMatchingConstructor(Type instanceType, Type[] argumentTypes, ConstructorInfo& matchingConstructor, Nullable`1[]& parameterMap)
   at Microsoft.Extensions.DependencyInjection.ActivatorUtilities.FindApplicableConstructor(Type instanceType, Type[] argumentTypes, ConstructorInfo& matchingConstructor, Nullable`1[]& matchingParameterMap)
   at Microsoft.Extensions.DependencyInjection.ActivatorUtilities.CreateFactory(Type instanceType, Type[] argumentTypes)
   at Microsoft.AspNetCore.Mvc.Controllers.ControllerActivatorProvider.CreateActivator(ControllerActionDescriptor descriptor)
   at Microsoft.AspNetCore.Mvc.Controllers.ControllerFactoryProvider.CreateControllerFactory(ControllerActionDescriptor descriptor)
   at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvokerCache.GetCachedResult(ControllerContext controllerContext)
   at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvokerProvider.OnProvidersExecuting(ActionInvokerProviderContext context)
   at Microsoft.AspNetCore.Mvc.Infrastructure.ActionInvokerFactory.CreateInvoker(ActionContext actionContext)
   at Microsoft.AspNetCore.Mvc.Routing.ActionEndpointFactory.<>c__DisplayClass7_0.<CreateRequestDelegate>b__0(HttpContext context)
   at Microsoft.AspNetCore.Routing.EndpointMiddleware.Invoke(HttpContext httpContext)
--- End of stack trace from previous location ---
   at Microsoft.AspNetCore.Authorization.AuthorizationMiddleware.Invoke(HttpContext context)
   at Swashbuckle.AspNetCore.SwaggerUI.SwaggerUIMiddleware.Invoke(HttpContext httpContext)
   at Swashbuckle.AspNetCore.Swagger.SwaggerMiddleware.Invoke(HttpContext httpContext, ISwaggerProvider swaggerProvider)
   at Microsoft.AspNetCore.Diagnostics.DeveloperExceptionPageMiddleware.Invoke(HttpContext context)

HEADERS
=======
Accept: */*
Accept-Encoding: gzip, deflate, br
Connection: keep-alive
Content-Length: 51
Content-Type: application/json
Host: localhost:44397
User-Agent: PostmanRuntime/7.26.8
Postman-Token: fd759aab-b1d9-46ea-b627-50908eb97c40

this is my controller

using AjiPu.Data;
using AjiPu.Models;
using JWTAuthDemo.Models;
using Microsoft.AspNetCore.Authorization;
using Microsoft.AspNetCore.Mvc;
using Microsoft.Extensions.Configuration;
using Microsoft.IdentityModel.Tokens;
using System;
using System.Collections.Generic;
using System.IdentityModel.Tokens.Jwt;
using System.Linq;
using System.Security.Claims;
using System.Text;
using System.Threading.Tasks;

// For more information on enabling Web API for empty projects, visit https://go.microsoft.com/fwlink/?LinkID=397860

namespace AjiPu.Controllers
{
    [Route("api/[controller]")]
    [ApiController]
    public class ClienteController : ControllerBase
    {
        //context de la base de datos
        private readonly SVMQASContext _context;
        public ClienteController(SVMQASContext context)
        {
            _context = context;
        }

        private IConfiguration _config;

        //llamamos al configuration
        public ClienteController(IConfiguration config)
        {
            _config = config;
        }

        //Login que genera el token 
        [HttpPost]
        public IActionResult Login([FromBody] UserModel login)
        {
            IActionResult response = Unauthorized();

            var user = AuthenticateUser(login);

            if (user != null)
            {
                var tokenStr = GenerateJSONWebToken(user);
                response = Ok(new { token = tokenStr });
            }

            return response;
        }

        private UserModel AuthenticateUser(UserModel login)
        {
            UserModel user = null;
            if (login.UserName == "123" && login.Password == "123")
            {
                user = new UserModel { UserName = "AshprogHelp", EmailAddres = "[email protected]", Password = "123" };

            }
            return user;

        }

        private string GenerateJSONWebToken(UserModel userinfo)
        {
            var securutyKey = new SymmetricSecurityKey(Encoding.UTF8.GetBytes(_config["Jwt:Key"]));
            var credentials = new SigningCredentials(securutyKey, SecurityAlgorithms.HmacSha256);

            var claims = new[]
            {
                new Claim(JwtRegisteredClaimNames.Sub,userinfo.UserName),
                new Claim(JwtRegisteredClaimNames.Email,userinfo.EmailAddres),
                new Claim(JwtRegisteredClaimNames.Jti,Guid.NewGuid().ToString())
            };

            var token = new JwtSecurityToken(

                issuer: _config["Jwt:Issuer"],
                audience: _config["Jwt:Issuer"],
                claims,
                expires: DateTime.Now.AddMinutes(120),
                signingCredentials: credentials);

            var encodetoken = new JwtSecurityTokenHandler().WriteToken(token);
            return encodetoken;
        }

        // GET: api/<ClienteController>
        [Authorize]
        [HttpGet]
        [Route("listaCliente")]
        public ActionResult Get()
        {
            var data = from clientes in _context.UgvmaPerfilClientes select clientes;
            return Ok(data);
            //return Ok(_context.UgvmaPerfilClientes.ToList());
        }

        // GET api/<ClienteController>/5
        //[Route("buscarCliente")]

        [Authorize]
        [HttpGet("buscar/{id}")]
        public ActionResult Get(int id)
        {
            var data = from cliente in _context.UgvmaPerfilClientes
                       where cliente.Id.Equals(id)
                       select cliente;
            return Ok(data);
        }

        // PUT api/<ClienteController>/5
        [HttpPut("{id}")]
        public void Put(int id, [FromBody] string value)
        {
        }

        // DELETE api/<ClienteController>/5
        [HttpDelete("{id}")]
        public void Delete(int id)
        {
        }
    }
}

I am trying to authenticate my username and password with Jwt in ASP.NET Core but it gives me an error when executing it with Postman , I already created my connection string and called it in my startup , I also created my UserModel model and my LoginController controller in which This is all my method, where am I failing? What mistake am I making? I would like to test so that I can later connect it with my database and test with real data

this is my connection string

{
  "Logging": {
    "LogLevel": {
      "Default": "Information",
      "Microsoft": "Warning",
      "Microsoft.Hosting.Lifetime": "Information"
    }
  },
  "AllowedHosts": "*",

  "Jwt": {
    "Key": "AshProgHelpSecretKey",
    "Issuer": "ashproghelp.com"
  }
}

this is my startup

using Microsoft.AspNetCore.Authentication.JwtBearer;
using Microsoft.AspNetCore.Builder;
using Microsoft.AspNetCore.Hosting;
using Microsoft.AspNetCore.HttpsPolicy;
using Microsoft.AspNetCore.Mvc;
using Microsoft.Extensions.Configuration;
using Microsoft.Extensions.DependencyInjection;
using Microsoft.Extensions.Hosting;
using Microsoft.Extensions.Logging;
using Microsoft.IdentityModel.Tokens;
using Microsoft.OpenApi.Models;
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace JwtPrueba
{
    public class Startup
    {
        public Startup(IConfiguration configuration)
        {
            Configuration = configuration;
        }

        public IConfiguration Configuration { get; }

        // This method gets called by the runtime. Use this method to add services to the container.
        public void ConfigureServices(IServiceCollection services)
        {

            services.AddControllers();
            services.AddSwaggerGen(c =>
            {
                c.SwaggerDoc("v1", new OpenApiInfo { Title = "JwtPrueba", Version = "v1" });
            });
            services.AddCors(options =>
            {
                options.AddPolicy("CorsPolicy", builder => builder.AllowAnyOrigin().AllowAnyMethod().AllowAnyHeader().AllowCredentials().Build());
            });

            services.AddControllers();

            services.AddAuthentication(JwtBearerDefaults.AuthenticationScheme)
                .AddJwtBearer(options =>
                {
                    options.TokenValidationParameters = new TokenValidationParameters
                    {
                        ValidateIssuer = true,
                        ValidateAudience = true,
                        ValidateLifetime = true,
                        ValidateIssuerSigningKey = true,
                        ValidIssuer = Configuration["Jwt:Issuer"],
                        ValidAudience = Configuration["Jwt:Issuer"],
                        IssuerSigningKey = new SymmetricSecurityKey(Encoding.UTF8.GetBytes(Configuration["Jwt:Key"]))
                    };
                });
        }

        // This method gets called by the runtime. Use this method to configure the HTTP request pipeline.
        public void Configure(IApplicationBuilder app, IWebHostEnvironment env)
        {
            if (env.IsDevelopment())
            {
                app.UseDeveloperExceptionPage();
                app.UseSwagger();
                app.UseSwaggerUI(c => c.SwaggerEndpoint("/swagger/v1/swagger.json", "JwtPrueba v1"));
            }

            app.UseHttpsRedirection();

            app.UseRouting();

            app.UseAuthentication();

            app.UseAuthorization();

            app.UseEndpoints(endpoints =>
            {
                endpoints.MapControllers();
            });
        }
    }
}

this is my model

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

namespace JWTAuthDemo.Models
{
    public class UserModel
    {
        public string UserName { get; set; }
        public string Password { get; set; }
        public string EmailAddres { get; set; }
    }
}

this is my controller

using JWTAuthDemo.Models;
using Microsoft.AspNetCore.Authorization;
using Microsoft.AspNetCore.Http;
using Microsoft.AspNetCore.Mvc;
using Microsoft.Extensions.Configuration;
using Microsoft.IdentityModel.Tokens;
using System;
using System.Collections.Generic;
using System.IdentityModel.Tokens.Jwt;
using System.Linq;
using System.Security.Claims;
using System.Text;
using System.Threading.Tasks;

namespace JWTAuthDemo.Controllers
{
    [Route("api/[controller]")]
    [ApiController]
    public class LoginController : ControllerBase
    {
        private IConfiguration _config;

        public LoginController (IConfiguration config)
        {
            _config = config;
        }
        [HttpGet]
        public IActionResult Login(string username,string pass)
        {
            UserModel login = new UserModel();
            login.UserName = username;
            login.Password = pass;
            IActionResult response = Unauthorized();

            var user = AuthenticateUser(login);

            if(user !=null)
            {
                var tokenStr = GenerateJSONWebToken(user);
                response = Ok(new { token = tokenStr });
            }

            return response;
        }
        private UserModel AuthenticateUser(UserModel login)
        {
            UserModel user = null;
            if(login.UserName=="ashproghelp" && login.Password == "123")
            {
                user = new UserModel { UserName = "AshprogHelp", EmailAddres = "[email protected]", Password = "123" };
            }
            return user;
        }

        private string GenerateJSONWebToken(UserModel userinfo)
        {
            var securutyKey = new SymmetricSecurityKey(Encoding.UTF8.GetBytes(_config["Jwt:Key"]));
            var credentials = new SigningCredentials(securutyKey, SecurityAlgorithms.HmacSha256);

            var claims = new[]
            {
                new Claim(JwtRegisteredClaimNames.Sub,userinfo.UserName),
                new Claim(JwtRegisteredClaimNames.Email,userinfo.EmailAddres),
                new Claim(JwtRegisteredClaimNames.Jti,Guid.NewGuid().ToString())
            };

            var token = new JwtSecurityToken(

                issuer: _config["Jwt:Issuer"],
                audience: _config["Jwt:Issuer"],
                claims,
                expires: DateTime.Now.AddMinutes(120),
                signingCredentials: credentials);

            var encodetoken = new JwtSecurityTokenHandler().WriteToken(token);
            return encodetoken;
        }

        [Authorize]
        [HttpPost("Post")]
        public string Post()
        {
            var identity = HttpContext.User.Identity as ClaimsIdentity;
            IList<Claim> claim = identity.Claims.ToList();
            var userName = claim[0].Value;
            return "BInevenido :" + userName;
        }

        [Authorize]
        [HttpGet("GetValue")]
        public ActionResult<IEnumerable<string>> Get()
        {
            return new string[] { "value1", "value2", "value3" };
        }
    }
}

error generated in postman

{
    "type": "https://tools.ietf.org/html/rfc7235#section-3.1",
    "title": "Unauthorized",
    "status": 401,
    "traceId": "00-e5297a6378850547b2d1f6b413649999-bec907f814c9bb4d-00"
}

post man image

I am trying to unite Angular with Spring Boot but I have problems and it is not loading my data from my database in my html, it is throwing me this error in my front-end, I am using CORS ; I implemented the listUser service in the Spring part and I want to show it in a table; What mistake am I making? Thanks for your help I would appreciate it.

ERROR Error: Cannot find a differ supporting object '[object Object]' of type 'object'. NgFor only supports binding to Iterables such as Arrays.
    at NgForOf.ngDoCheck (common.js:3193)
    at callHook (core.js:3285)
    at callHooks (core.js:3251)
    at executeCheckHooks (core.js:3184)
    at refreshView (core.js:7335)
    at refreshComponent (core.js:8473)
    at refreshChildComponents (core.js:7132)
    at refreshView (core.js:7376)
    at refreshEmbeddedViews (core.js:8427)
    at refreshView (core.js:7350)

this is the code in spring, there is the Angular route and the main route which is the RequestMapping and the list route

@RestController
@CrossOrigin(origins = {"http://localhost:4200"})
@RequestMapping("/api/usu")
public class UsuarioRestControlador {
    
    @Autowired
    private UsuarioServicio usuarioServicio;
    
    @GetMapping("/listarUsuario")
    public Map<String,Object> listarUsuario(){
        Map<String,Object> rpta= new HashMap<String,Object>();
        List<Usuario> listaUsuario = usuarioServicio.listarUsuario();
        rpta.put("listado",listaUsuario);
        return rpta;
    }

this is the code in angular: this is the service, this is the path of my localhost , I am also importing my User class

import {Injectable} from '@angular/core';
import {USUARIO} from '../usuario/usuario.json';
import {Usuario} from './usuario'
import {Observable} from 'rxjs';
import {of} from 'rxjs';
import {HttpClient} from '@angular/common/http';

@Injectable()
export class UsuarioService{
    
    private url : string = 'http://localhost:8080/api/usu/listarUsuario';

    constructor(private http:HttpClient){
    }

    getUsuarios():Observable<Usuario[]>{

        return this.http.get<Usuario[]>(this.url);
    }
}

this is the Json that returns in Spring

{"listado":[{"fec_REG_USUARIO":"2020-10-22T11:38:14.383","contra_USUARIO":"1234","usu_USUARIO":"local2","nom_USUARIO":"carlos aldair","fec_NAC":null,"id_USUARIO":2,"apell_USUARIO":"zavala"},{"fec_REG_USUARIO":"2020-10-26T13:52:35.253","contra_USUARIO":"1234","usu_USUARIO":"local2","nom_USUARIO":"juan","fec_NAC":null,"id_USUARIO":3,"apell_USUARIO":"zavala tomayro"},{"fec_REG_USUARIO":"2020-10-26T13:53:20.477","contra_USUARIO":"123","usu_USUARIO":"local2","nom_USUARIO":"matias","fec_NAC":null,"id_USUARIO":4,"apell_USUARIO":"tomayro"},{"fec_REG_USUARIO":"2020-10-26T15:27:07.103","contra_USUARIO":"123","usu_USUARIO":"local2","nom_USUARIO":"carlos","fec_NAC":null,"id_USUARIO":5,"apell_USUARIO":"tomayro"},{"fec_REG_USUARIO":"2020-10-26T15:57:55.697","contra_USUARIO":"contrasena","usu_USUARIO":"usuario","nom_USUARIO":"nombre","fec_NAC":null,"id_USUARIO":6,"apell_USUARIO":"apellido"},{"fec_REG_USUARIO":"2020-10-26T16:04:21.93","contra_USUARIO":"123","usu_USUARIO":"123","nom_USUARIO":"mati","fec_NAC":null,"id_USUARIO":7,"apell_USUARIO":"casas"},{"fec_REG_USUARIO":"2020-10-26T16:05:36.33","contra_USUARIO":"123","usu_USUARIO":"123","nom_USUARIO":"cristian","fec_NAC":null,"id_USUARIO":8,"apell_USUARIO":"quispe"},{"fec_REG_USUARIO":"2020-10-26T16:06:35.517","contra_USUARIO":"123","usu_USUARIO":"123","nom_USUARIO":"manolo","fec_NAC":null,"id_USUARIO":9,"apell_USUARIO":"cazt"},{"fec_REG_USUARIO":"2020-10-27T11:34:56.797","contra_USUARIO":"1234","usu_USUARIO":"1234","nom_USUARIO":"juan carlos","fec_NAC":null,"id_USUARIO":12,"apell_USUARIO":"carballo"},{"fec_REG_USUARIO":"2020-10-27T16:49:44.233","contra_USUARIO":"8778","usu_USUARIO":"54+","nom_USUARIO":"guty","fec_NAC":null,"id_USUARIO":13,"apell_USUARIO":"quispe arias"},{"fec_REG_USUARIO":"2020-10-30T19:08:53.773","contra_USUARIO":"48878","usu_USUARIO":"yayito","nom_USUARIO":"yayito lucas","fec_NAC":"2017-06-13T05:00:00.000+00:00","id_USUARIO":15,"apell_USUARIO":"husto"},{"fec_REG_USUARIO":"2020-11-10T16:19:01.49","contra_USUARIO":"1234","usu_USUARIO":"local2","nom_USUARIO":"aldair","fec_NAC":"0024-12-15T05:00:00.000+00:00","id_USUARIO":16,"apell_USUARIO":"zavala"},{"fec_REG_USUARIO":"2020-11-10T16:19:45.577","contra_USUARIO":"1234","usu_USUARIO":"local2","nom_USUARIO":"aldair","fec_NAC":"0024-12-15T05:00:00.000+00:00","id_USUARIO":17,"apell_USUARIO":"zavala"},{"fec_REG_USUARIO":"2020-11-10T16:20:02.04","contra_USUARIO":"1234","usu_USUARIO":"local2","nom_USUARIO":"pepito","fec_NAC":"0024-12-15T05:00:00.000+00:00","id_USUARIO":18,"apell_USUARIO":"casas"},{"fec_REG_USUARIO":"2020-11-10T16:20:51.72","contra_USUARIO":"1234","usu_USUARIO":"local2","nom_USUARIO":"patito","fec_NAC":"1995-07-19T05:00:00.000+00:00","id_USUARIO":19,"apell_USUARIO":"casas"}]}

here I receive the service

import { Component, OnInit } from '@angular/core';
import {Usuario} from '../usuario/usuario';
import {UsuarioService} from '../usuario/usuario.service';

@Component({
  selector: 'app-listar',
  templateUrl: './listar.component.html',
  styleUrls: ['./listar.component.css']
})
export class ListarComponent implements OnInit {

  usuarios:Usuario[];

  constructor(private usuarioService:UsuarioService) { }

  ngOnInit(): void {
    this.usuarioService.getUsuarios().subscribe(

       usuarios =>this.usuarios = usuarios

    );
  }

}

this is the html

<div class="container">

    <table class="table table-bordered table-striped contenedor">
        <thead>
            <tr>
                <th>nombre</th>
                <th>apellido</th>
                <th>usuario</th>
                <th>contaseña</th>
            </tr>
        </thead>
        <tbody>
            <tr *ngFor="let usuario of usuarios">
                <td>{{usuario.nombre}}</td>
                <td>{{usuario.apellido}}</td>
                <td>{{usuario.usuario}}</td>
                <td>{{usuario.contra}}</td>
            </tr>
        </tbody>
    </table>

</div>

I'm having problems when trying to separate a JSON into different values, how can I separate the json to save them in variables and be able to display them in an html input? I am using Axis.

this is the json i get;

    obtenerUsuario:
       apell_USUARIO: "pumbaa"
       contra_USUARIO: "1234"
       fec_REG_USUARIO: "2020-10-22T11:38:14.383"
       id_USUARIO: 2
       nom_USUARIO: "timon"
       usu_USUARIO: "local2"

this is the jquery axios, the data is stored in rpta and that is where I want to separate it

function fnObtener(){
var id= $('#txtId').val();
axios.post('http://localhost:8080/api/usu/obtenerUsuario', {
"ID_USUARIO": id
}, {
headers: {
'Content-Type': 'application/json',
}
}, {
}).then((response) => {
fnRespuestaObtener(response.data);
})
}

function fnRespuestaObtener(rpta){

  var id= $('#txtId').val();
  var nombre=$('#txtNombres').val();
  var apellido=$('#txtApellidos').val();
  var usuario=$('#txtUsuario').val();
  var contrasea=$('#txtContrasena').val();

  if(id=="ID_USUARIO"){
    nombre.text=nom_USUARIO;
    apellido.text=apell_USUARIO;
    usuario.text=usu_USUARIO;
    contrasea.text=contra_USUARIO;
  }
}

I would like to add a button in the navigation drawer menu, I was trying to create a new item in the nav_header_main and giving it the property of a button but it did not work, how would I add a button in my dropdown menu?

something like that

add a new item

<item
    android:id="@+id/salir"
    android:title=""
    android:actionLayout="@layout/button_salir"
    app:showAsAction="ifRoom"/>

I created an xml button but when adding it to the item it doesn't show me the button

<Button xmlns:android="http://schemas.android.com/apk/res/android"
android:orientation="vertical"
android:layout_marginStart="8dp"
android:layout_marginEnd="8dp"
android:layout_width="match_parent"
android:text="Login"
android:layout_height="50dp"/>

and where would your code go. Thanks for the help :)