Formating decimal JsonResult ASP MVC 5

Question

I'm working with ASP MVC 5 and DataTables plugin and I'm having some problems formating my decimals.

I need to format numbers with dot as thousand separator and comma as decimal separator.

I'm trying to do it with DisplayFormat, but since i'm returning the data as Json, it just not applying

This is a little example of my problem

public class MyClass
{
   [DisplayFormat(DataFormatString = "{0:0.##}")]
   decimal MyDecimal {get;set;}
}

In the controller

public JsonResult LoadDataTables()
{    
    using(var db = new ExampleContext())
    {
        var data = db.MyRepository.Select(x => new MyClass
        {
            MyDecimal = x.mydecimal
        }).ToList();
        //i'm ignoring a lot of processing to create a short snippet
        return Json(new { draw = draw, recordsFiltered = recordsTotal, recordsTotal = recordsTotal, data = data });
    }
}

Then, in the front end, the json arrives with comma for thousands and dot for decimal separation

How can i deal with it? Some way to apply CultureInfo or manually set the conversion?

Edit: In my view, this is how i'm loading the data

var table = $('#myTabla').DataTable({
                    processing: true,
                    serverSide: true,
                    filter: true,
                    orderMulti: false,
                    paging: true,
                    pageLength: 10,
                    ajax: {
                        "url": '@Url.Action("LoadDataTables")',
                        "type": "POST",
                        "datatype": "json",
                    });

Thanks!

Here is the documentation for ToString() output format : https://learn.microsoft.com/en-us/dotnet/standard/base-types/custom-numeric-format-strings . You can apply CultureInfo for output. — Shim-Sao, Nov 28 '18 at 13:26
@Tomato32 Addeded how i load the data, my view is only one table and that script basically — Juan Salvador Portugal, Nov 28 '18 at 13:31
@Shim-Sao the problem is where must i apply that? the `DisplayFormat` annotation never happen — Juan Salvador Portugal, Nov 28 '18 at 13:32
@JuanSalvadorPortugal your JSON is just fine. Using dots *is* the defacto standard for numbers in JSON. It's you *DataTable* configuration that should specify how that decimal field gets displayed — Panagiotis Kanavos, Nov 28 '18 at 14:48
@PanagiotisKanavos that was my idea, but DataTables language settings (specify thousand and decimal) didn't work when you use server side processing :s — Juan Salvador Portugal, Nov 28 '18 at 14:51
@Tomato32 I opted to convert decimals to string, at least for now, I did not answer the question because I think it is not a real solution — Juan Salvador Portugal, Nov 28 '18 at 18:09
@JuanSalvadorPortugal: Sorry for late response. There is a solution to this. If you need, I can post a sample :)) — Tomato32, Nov 28 '18 at 18:12
@JuanSalvadorPortugal: I posted it. Hope to help, my friend :)) — Tomato32, Nov 28 '18 at 18:33

score 1 · Answer 1 · edited Nov 28 '18 at 13:46

1

You need to set custom culture:

System.Globalization.CultureInfo customCulture = (System.Globalization.CultureInfo)
System.Threading.Thread.CurrentThread.CurrentCulture.Clone();
customCulture.NumberFormat.NumberDecimalSeparator = ",";

System.Threading.Thread.CurrentThread.CurrentCulture = customCulture;

Thank you.

edited Nov 28 '18 at 13:46

Vishal Parmar

524
7
27

answered Nov 28 '18 at 13:26

Sonal Borkar

531
1
6
12

Hi, thanks for answer! i try it, but the result is the same :( – Juan Salvador Portugal Nov 28 '18 at 13:32
Have you removed the attribute [DisplayFormat(DataFormatString = "{0:0.##}")]? – Sonal Borkar Nov 28 '18 at 13:44
Yes i'm, i already had the culture configured, my problem is, for some reason its not get applyed to the Json conversion – Juan Salvador Portugal Nov 28 '18 at 13:52
1

Read this post https://stackoverflow.com/questions/35709595/why-would-you-use-a-string-in-json-to-represent-a-decimal-number – Sonal Borkar Nov 28 '18 at 13:57

score 1 · Answer 2 · answered Nov 28 '18 at 14:41

1 - You can do it in another way like this :

public class MyClass
{
   MyNumber MyDecimal {get;set;}
}

struct MyNumber
{
    decimal Value {get;set;}

    ToString()
    {
        // Adapt number Format and CultureInfo as wanted
        return value.ToString("0:0.##", MyCultureInfo);
    }
}

uses :

decimal d = MyNumber.Value

string s = (string)MyNumber; or MyNumber.ToString();

2 - Or on client side :

// Invert . and ,
// 1.22222.5689,56
// to 1,22222,5689.56
String.prototype.formatNumber = function(number)
{
    return number.replace(',', ';').replace('.', ',').replace(';', '.');
}

3 - My best choice to manipulate JSon in C# is : https://www.newtonsoft.com/json

You can serialize and deserialize json and creating custom conversion.

score 1 · Accepted Answer · answered Nov 28 '18 at 18:33

You can use Number helper for this. You can visit this link to refer more: https://datatables.net/manual/data/renderers#Number-helper

Here is a sample. Hope to help, my friend :))

//Code in Controller

public class Test
    {
        public int Id { get; set; }
        public string Name { get; set; }
        public decimal Currency  { get; set; }
    }

private List<Test> Data()
        {
            var data = new List<Test>
            {
                new Test{ Id = 1, Name = "A1", Currency = 1000000.00M},
                new Test{ Id = 2, Name = "A2", Currency= 50000000.12M},
                new Test{ Id = 3, Name = "A3", Currency = 3000000.45M},
                new Test{ Id = 4, Name = "A4", Currency = 20000}
            };
            return data;
        }

        [HttpPost]
        public JsonResult LoadDataTables()
        {
            var data = Data();
            var recordsTotal = Data().Count;
            var recordsFiltered = Data().Count();
            string draw = Request.Form.GetValues("draw")[0];
            return Json(new { draw = Convert.ToInt32(draw), recordsTotal = recordsTotal, recordsFiltered = recordsFiltered, data = data }, JsonRequestBehavior.AllowGet);
        }

//View

<table id="myTable" >
    <thead>
        <tr>
            <td >Id</td>
            <td >Name</td>
            <td>Currency</td>
        </tr>
    </thead>
    <tbody>
    </tbody>
</table>

    var table = $('#myTable').DataTable({
                    processing: true,
                    serverSide: true,
                    filter: true,
                    orderMulti: false,
                    paging: true,
                    pageLength: 10,
                    ajax: {
                            "url": '@Url.Action("LoadDataTables", "Home")',
                            "type": "POST",
                            "datatype": "json",
                    },
                    "columns": [
                        {
                            "data": "Id"
                        }, {
                            "data": "Name"
                        }, {
                            "data": "Currency",
                            render: $.fn.dataTable.render.number('.', ',', 2, '')
                        }
                    ]
                });

Formating decimal JsonResult ASP MVC 5

3 Answers3