How to pass a floating point value using json from mvc controller to jquery without truncating zero

Question

I have function to calculate price as follows:

public ActionResult updatePrice(int pageCount,int detid ,int spec)
        {
            double amt = 0.00;

            double final = 0.00;
            using(APM context = new APM())
            {
                var lst = (from s in context.M_Spec
                           join p in context.M_SpecDetails on s.ID equals p.SpecID

                           where p.SpecificationID == spec && p.SpecID == detid
                           select new
                           {
                              amount = (double) p.Rate
                           }).ToList();


                foreach( var s in lst)
                {
                    amt = (pageCount - 10) * (s.amount) ;
                }

                var def = (from s in context.M_Spec where s.ID == detid 
                           select new
                           {
                               defamt = (double)s.DefaultCost
                           }).ToList();


                foreach (var s in def)
                {
                    final =  (s.defamt) + amt;
                }             

            }

            return Json(new { success = true, Amount = final});
        }

Finally get the answer like final = 2130.0 and I passed it to the ajax success using json as above and I get the result at ajax success as 2130.How can I overcome this problem?

2130.0 == 2130, so you are getting 2130.0. Ideally you should format the resulting value on the UI. — fdomn-m
– fdomn-m, Commented Jul 8, 2016 at 9:58

Karolis Kajenas · Accepted Answer · 2016-07-08 09:39:33Z

1

When you pass in a value type it contains only meaningful digits, zeros after decimal point are being dropped. Also for value types, .NET has cultural based formatting. The way you can get your wanted result by either passing a plain string or forwarding string format a long side with value.

answered Jul 8, 2016 at 9:39

Karolis Kajenas

1,5431 gold badge15 silver badges24 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Utkarsh Kaushik · Accepted Answer · 2016-07-08 10:19:37Z

1

The zeroes after decimal 2130.0 are considered insignificant while the JSON conversion here, therefore are dropped off, but the significant figures other than zeroes will remain preserved i.e- 2130.05 will remain 2130.05.

If you want to preserve the format pass it as a string. It will work.

Hope it helps..

answered Jul 8, 2016 at 10:19

Utkarsh Kaushik

9711 gold badge7 silver badges14 bronze badges

Collectives™ on Stack Overflow

How to pass a floating point value using json from mvc controller to jquery without truncating zero

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related