Edwin Romero's questions

I had a problem with an API that had time type variables, I connect to a database with a Time field and of course the JSON returns something like "HoraTimeSpan": { "ticks": 0, "days": 0, "hours ": 0, "milliseconds": 0, "minutes": 0, "seconds": 0, "totalDays": 0, "totalHours": 0, "totalMilliseconds": 0, "totalMinutes": 0, "totalSeconds": 0 },

When I want to assign it to a TimeSpan, or use it, it displays the serialization error, at least it happened to me in 3.x and 5 Core, so how can I correct the problem?

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.

This is a problem that has been talked about for a long time and at least those of us who have been working with asp mvc since 2010 have had it.

And now in ASP Core 3.x it has not been the difference, now that I am developing a web application from scratch I ran into this old enemy.

And what's the problem? Well, it doesn't matter if you're using American regional comma(,) for thousands and dot(.) for decimals or European dot(.) for thousands and comma(,) for decimals, jquery always triggers the error when validating the field. .

The error is not from asp core, it is actually from jquery that always expects the number to be 2500.25 if with an American decimal point, which makes it a problem for those of us who work with applications that are used in both America and Spain.

I normally use this notation to define my tables

namespace domain.Entities
{
     [Table("seg_modulos")]
     public class modulo
     {
          [Column("modID")]
          [Key]
          public int modID { get; set; }

          [Column("modulo")]
          public string modname { get; set; }
     }
}

but the ContextBase requires me for some unknown reason that I have a [KEY] to be able to do the dbset

  public DbSet<modulo> modulo { get; set; }

For security purposes in my system I want to call a view, it will only make queries, is there a tag like TABLE in DataAnotation, View does not work for me, does anyone know what it is or an alternative way to do it?

thanks if I find out before I post the answer greetings to the community

Hi everyone, I'm a novice with asp core 3 and I'm developing a system from scratch, the system has custom security for issues that I won't go into detail about, what happens is that I want to use Claims but I'm stuck and I can't find anything in the network on how to use claims, I have this: To put them in context this is the custom security database schema

To assign the users I want to use Claims and this is what I have first in the startup.cs in the configure services section

       #region Implementacion de Claims

       services.AddAuthentication(CookieAuthenticationDefaults.AuthenticationScheme)
               .AddCookie();
       services.Configure<CookiePolicyOptions>(opt =>
       {
            opt.MinimumSameSitePolicy = SameSiteMode.None;
       });
       #endregion

and in the always configure section in the startup.cs I have this:

       app.UseAuthentication();
       app.UseAuthorization();
       app.UseCookiePolicy();

       app.UseEndpoints(endpoints =>
       {
            endpoints.MapControllerRoute(
             name: "default",
             pattern: "{controller=Home}/{action=Index}/{id?}");
            endpoints.MapRazorPages();
       });

in the controller I have this:

[HttpPost]
          [ValidateAntiForgeryToken]
          public async Task<ActionResult> Login(UsuarioModel Entidad)
          {
               var eData = await _iUser.ObtenerPorEmail(Entidad.email);

               //Si no encuentra el correo no esta registrado el user
               if (eData == null)
               {
                    TempData["Titulo"] = "Error";
                    TempData["Mensaje"] = "El usuario con que intenta conectar no existe, pongase en contacto con el admnistrador del sistema";
                    return RedirectToAction("Mensaje", "Home");
               }
               //Si llega hasta aquí y es primera vez permite generar el password
               if (eData.firsttime)
               {
                    return RedirectToAction("SavePassword", eData);
               }
               else
               {
                    //Si no es primera vez verifica si es correcto el pass y se conecta
                    if (eData.ComparePass(Entidad.passmain, eData.salt, eData.password))
                    {
                         //Aqui codigo de claims
                         return RedirectToAction("Index", "Home");
                    }

                    TempData["Titulo"] = "Error";
                    TempData["Mensaje"] = "El password esta equivocado";
                    return RedirectToAction("Mensaje", "Home");
               }

          }

Well I've reached the point where I have to implement the claims but I don't know how: 1) Create the claims with the data at that moment? 2) How do I reuse the claim to validate if I connected? 3) How can I get the claims to reuse it and disable it in the options menu? 4) How do I destroy them when I close the session?

I know there are a lot of questions :(, but if someone has a place where I can see a clear example and can read more about this I would appreciate it or if you can put an example it would be great, thanks in advance to the community.

Hello, I would like you to help me with something I am doing, I have read but I have not understood something because I do not make it work, I put them in context:

I need to call a % of a table and since it is running I want to do a get in the controller I have this:

      public async Task<JsonResult> GetTaxPercen(int id)
      {
           try
           { 
                impuesto Item = await _iImp.ObtenerPorId(id);

                return Json(Item);
           }
           catch(Exception e)
           {
                return Json(e.Message);
           }
      }

Incidentally, "Item" has 5 records and has data. I try to call this function with an Ajax in Jquery:

function getImpuesto(id) {
var iUrl = "/Mov/GetTaxPercen?id=" + id;

$.ajax({
    url: iUrl,
    type: 'GET',
    data: '{}',
    dataType: 'json',
    contentType: "application/json; charset=utf-8",
    asyn: true,
    success: function (result) {
        if (result != null) {
            return result.porcentaje;
        }
    },
    error: function () {
        return result.responseText;
    }
});

};

This is called from another jquery function:

$("#neto").on("change keyup paste", function () {
if ($.isNumeric($("#neto").val())) {

    var pimp = self.getImpuesto(3);

    if (pimp > 0) {
        pimp = pimp / 100;

        if ($("#neto").val() > 0) {
            $("#iva").val(parseFloat($("#neto").val() * pimp).toFixed(2));
            $("#monto").val(parseFloat(parseFloat($("#neto").val()) + parseFloat($("#iva").val())).toFixed(2));
        }
    }

}
else { DesplegarModal('Advertencia Error', 'Necesita ingresar un valor númerico valido'); }

});

The problem is that the ajax does return the value but I don't know how to handle the asynchrony in jqueryu and it returns me undefined, how can I make it wait to assign the values?

Thank you if you have any example to read I would appreciate it