Decimal net core

Reply

developer.ch...

None

0 Points

7 Posts

Decimal net core

Jul 24, 2019 07:10 PM|developer.chiapas|LINK

I have a project in net core 2.2.

In a form, I have one row type decimal, it is defined with decimal(18,2), when save data to server (windows server 2016 and sql server 2017) the row is desajust, p.e. I send 5907.50 and save 590750.00

I have doing proof in different windows server, in a one it work fine but in the production not.

Any idea from this error.

Help me!!

Reply

mgebhard

All-Star

43841 Points

18766 Posts

Re: Decimal net core

Jul 24, 2019 07:35 PM|mgebhard|LINK

It looks like the the decimal is missing when the form is submitted. This can be due to culture settings. You'll need to debug. Otherwise, post code that reproduces this issue.

Reply

developer.ch...

None

0 Points

7 Posts

Re: Decimal net core

Jul 24, 2019 07:49 PM|developer.chiapas|LINK

Hi, thanks for response.

When you speak of culture settings it is refered to server or cliente when i fill form?

Because, in other server work fine.

Reply

mgebhard

All-Star

43841 Points

18766 Posts

Re: Decimal net core

Jul 24, 2019 08:20 PM|mgebhard|LINK

developer.chiapas
When you speak of culture settings it is refered to server or cliente when i fill form?

HTTP is a text based protocol. ASP.NET Core provides model binding which automatically converts text inputs into proper types like a decimal value. Your description indicates the decimal is lost or ignored causing 5907.50 to become 590750. Culture setting affect how numbers and dates are formatted which can affect the model binding.

But I'm just guessing because I cannot see your code or reproduce this issue. Can you shared the code or a sample that reproduces this issue?

developer.chiapas
Because, in other server work fine.

Everyone on the forum makes this statement.

Reply

developer.ch...

None

0 Points

7 Posts

Re: Decimal net core

Jul 24, 2019 08:57 PM|developer.chiapas|LINK

The model is:

class Pago {

[Display(Name = "Monto")]
[Column(TypeName = "decimal(18, 2)")]
public decimal monto { get; set; }

}

In the View has the follow code:

<div class="col-md-2 mb-3">
<label asp-for="Pagos[0].monto" class="control-label"></label>
<input asp-for="Pagos[0].monto" id="monto" class="form-control" />
<span asp-validation-for="Pagos[0].monto" class="text-danger"></span>
</div>

I use jquery for send via ajax to controller:

Inside function registrarCobro get value for monto with:

var monto = $("#monto").val();

//Fill object pago for send to controller
 if (!$('#fechaBaucher').is(':disabled')) {
        //alert("esta habilitado");
        pagos.push({
            "PagoId": 0, "VentaId": 0, "anio": fecha_actual.getFullYear(), "fecha_captura": fecha_registro,
            "numero_ficha": numero_ficha, "monto": monto, "monto_adeudo": adeudo, "fecha_baucher": fecha_baucher, "banco": banco, "fecha_devuelta": new Date('0001-01-01').toJSON(),
            "observacion_devuelta": "", "NoFolio": 0, "creado_por": usuario, "fecha_registro": fecha_registro,
            "modificado_por": usuario, "fecha_modificacion": fecha_registro, "monto_extra": 0
        });
    }

$.ajax({
type: "POST",
url: '/Ventas/registrarCobro',
data: {
venta
},

success: (response) => {
console.log("Hola");
console.log(response);

if (parseInt(response[0].Code) > 0 || response[0].Code === null) {
window.location.href = '/Estudiantes/success/' + response[0].Code;
}

else {

$('#response').html("<div class=\"alert alert-danger alert-dismissible\" role =\"alert\" >" +
"<button type=\"button\" class=\"close\" data-dismiss=\"alert\" aria-label=\"Close\"><span aria-hidden=\"true\">&times;</span></button>" +
response[0].Description +
"</div>");
}
}
});



//Send data via ajax

And, in the controller i have follow code:

public async Task<List<IdentityError>> registrarCobro(Venta venta)
        {
            var errorList = new List<IdentityError>();
            var ficha = "";
            string errores = string.Empty;


            if (ModelState.IsValid)
            {

                try
                {
                    //Obtener el usuario actual
                    var userId = User.FindFirstValue(ClaimTypes.NameIdentifier);
                    var pago = _context.Pago.Where(p => p.anio == DateTime.Now.Year);
                    int Folio = 0;

                    if (pago.Count() > 0)
                    {
                        Folio = pago.Max(c => c.NoFolio);
                    }

                    //Validar algunos campos                 

                    if (venta.Pagos.Count > 0)
                    {
                        ficha = venta.Pagos[0].numero_ficha;
                        venta.Pagos[0].creado_por = userId;
                        venta.Pagos[0].NoFolio = Folio + 1;

                        if (FichaPagoExiste(ficha))
                        {
                            errorList.Add(new IdentityError
                            {
                                Code = "0",
                                Description = "Ya existe un pago con este número de ficha"
                            });

                            return errorList;
                        }
                    }


                    venta.creado_por = userId;
                    venta.modificado_por = userId;

                    _context.Add(venta);
                    await _context.SaveChangesAsync();

                    string id_pago = "0";

                    if (venta.Pagos.Count > 0)
                    {
                        id_pago = venta.Pagos[0].PagoId.ToString();
                    }

                    else
                    {
                        id_pago = null;
                    }


                    errorList.Add(new IdentityError
                    {
                        Code = id_pago,
                        Description = "Registro guardado exitosamente"
                    });
                }

                catch (Exception ex)
                {
                    errorList.Add(new IdentityError
                    {
                        Code = "0",
                        Description = ex.ToString()
                    });

                }
            }

            else
            {
                foreach (var modelState in ViewData.ModelState.Values)
                {
                    foreach (var error in modelState.Errors)
                    {
                        errores = errores +" "+ error.ErrorMessage;
                    }
                }

                errorList.Add(new IdentityError
                {
                    Code = "0",
                    Description = errores
                });
            }

                return errorList;
            

        }

Reply

mgebhard

All-Star

43841 Points

18766 Posts

Re: Decimal net core

Jul 24, 2019 09:08 PM|mgebhard|LINK

What is the class definition for Venta?

Reply

developer.ch...

None

0 Points

7 Posts

Re: Decimal net core

Jul 24, 2019 09:17 PM|developer.chiapas|LINK

public class Venta
    {
        public int VentaId { get; set; }

        public int? GrupoListaId { get; set; }

        public GrupoLista Lista { get; set; }

        public string serie { get; set; }

        public string folio { get; set; }

        public DateTime fecha { get; set; }

        [Display(Name = "Forma de pago")]
        public string  FormaPago { get; set; }

        [Display(Name = "Condiciones de pago")]
        public string condicionesPago { get; set; }

        [Display(Name = "Subtotal")]
        [Column(TypeName = "decimal(18, 2)")]
        public decimal subtotal { get; set; }

        [Display(Name = "Descuento")]
        [Column(TypeName = "decimal(18, 2)")]
        public decimal descuento { get; set; }

        [Display(Name = "Moneda")]
        public string moneda { get; set; }

        [Display(Name = "Tipo de cambio")]
        [Column(TypeName = "decimal(18, 2)")]
        public decimal tipo_cambio { get; set; }
        
        [Display(Name = "Total")]
        [Column(TypeName = "decimal(18, 2)")]
        public decimal total { get; set; }

        [Display(Name ="Tipo")]
        public string tipoVenta { get; set; }

        [Display(Name = "Metodo de pago")]
        public string metodo_pago { get; set; }

        [Display(Name = "Lugar de expedicion")]
        public string lugar_expedicion { get; set; }

        [Display(Name = "Estatus")]
        public string estatus { get; set; }

        public string creado_por { get; set; }

        public DateTime fecha_registro { get; set; }

        public string modificado_por { get; set; }

        public DateTime fecha_modificacion { get; set; }

        [Display(Name = "Porcentaje descuento")]
        [Column(TypeName = "decimal(18, 2)")]
        public decimal porcentaje_descuento { get; set; }

        [Display(Name = "Monto extra")]
        [Column(TypeName = "decimal(18, 2)")]
        public decimal total_extra { get; set; }

        public Boolean tiene_prorroga { get; set; }

        public IList<Concepto> Conceptos { get; set; }

        public IList<Pago> Pagos { get; set; }
    }

Reply

mgebhard

All-Star

43841 Points

18766 Posts

Re: Decimal net core

Jul 24, 2019 09:26 PM|mgebhard|LINK

Where is the IList<Pagos> populated?

I think you need to take a closer look at your code. The code shared to this point has far too many potential problems. It looks like the View has many Pago records but moto is always going to be the first #moto found in the DOM.

Reply

developer.ch...

None

0 Points

7 Posts

Re: Decimal net core

Jul 24, 2019 10:14 PM|developer.chiapas|LINK

Venta is a class with other classes, this contain class for Pago, Concepto etc.

But, in th view I send only a regiter of Pago, is in this when monto is desajust. For this, Pago[0].monto is declared, because always send one Pago in this place. The problem is that desajust the value monto, p.e. 1950.50 change to 195050.00, but it is an error.

Reply

developer.ch...

None

0 Points

7 Posts

Re: Decimal net core

Jul 25, 2019 01:55 AM|developer.chiapas|LINK

tests done so far, with jquery:

monto=5907.50

parseFloat(monto) ----> save the value 59075.00

parseFloat(monto).toFixed(2) --> save the value 590750.00

Reply

developer.ch...

None

0 Points

7 Posts

Re: Decimal net core

Jul 25, 2019 04:22 AM|developer.chiapas|LINK

I solucioned the problem, after of test many times, i used the follow code in jquery:

parseFloat($("#monto").val()).toFixed(2).replace('.', ',');

applicate a mask :)

Decimal net core [Answered]RSS

10 replies

Shortcuts

Related Links

Decimal net core

Re: Decimal net core

Re: Decimal net core

Re: Decimal net core

developer.chiapas

developer.chiapas

Re: Decimal net core

Re: Decimal net core

Re: Decimal net core

Re: Decimal net core

Re: Decimal net core

Re: Decimal net core

Re: Decimal net core