Help with Decimal . Net Core 2.2 recording

Question

I have a system in .NET CORE 2.2 where I am facing a problem in recording decimal numbers in the database MySQL.

Using as an example the decimal 19.99:

• By MAC writes correctly;
• By Windows writes incorrectly the value: 1999.00;

I did a lot of research on some solutions, but none worked for me...

I believe it may be some kind of culture problem.

VIEW

<div class="form-group col-md-2">
  <label>Valor</label>
  <input asp-for="Valor" type="text" class="form-control" id="decimal" value="@try{ @ViewBag.Chamado.Valor} catch{}">
</div>

MODEL

public decimal Valor { get; set; }
public void Gravar()
{
    DAL objDAL = new DAL();
    string sql = string.Empty;
    if (Id != null)
    {
        sql = $"UPDATE chamados SET titulo='{Titulo}', descricao='{Descricao}', pa_id='{PA}', equipamento_id='{Equipamento}', valor='{Valor}', status_id='{Status}' WHERE id='{Id}'";
    }
    else
    {
        string Data_Abertura = DateTime.Now.ToString("yyyy/MM/dd");
        sql = "INSERT INTO chamados (titulo, descricao, pa_id, equipamento_id, data_abertura, valor, status_id)" + $" VALUES ('{Titulo}', '{Descricao}', '{PA}', '{Equipamento}', '{Data_Abertura}', '{Valor}', '{Status}')";
    }
    objDAL.ExecutarComandoSQL(sql);
}

CONTROLLER

[HttpGet]
public IActionResult NovoChamado(int? id )
{     
    if (id != null)
    {
        ViewBag.Chamado = new ChamadosModel().RetornarChamado(id);
    }
    CarregarDados();
        return View();
    }

    [HttpPost]
    [SuppressMessage("ReSharper", "Mvc.ViewNotResolved")]
    public IActionResult NovoChamado(ChamadosModel chamado)
    {
        if (ModelState.IsValid)
        {
            CarregarDados();
            chamado.Gravar();
            return RedirectToAction("Index");
        }    
        return View();
    }
    private void CarregarDados()
    {
        ViewBag.ListaEquipamentos = new ChamadosModel().RetornarListaEquipamentos(); 
        ViewBag.ListaPA = new PAModel().ListarTodosPA();  
        ViewBag.ListaStatus = new StatusModel().ListarTodosStatus(); 
    }
}

SETANDO CULTURA

 // Definindo a cultura padrão: pt-BR
 var supportedCultures = new[] { new CultureInfo("pt-BR") };
 app.UseRequestLocalization(new RequestLocalizationOptions
 {
       DefaultRequestCulture = new RequestCulture(culture: "pt-BR", uiCulture: "pt-BR"),
       SupportedCultures = supportedCultures,
       SupportedUICultures = supportedCultures
 });

Answer 1

The problem seems to be that your input type is text, when actually it should be number, with the Steps attribute:

<input asp-for="Valor" type="number" step="any">