Cannot create convert to JSON

Question

I want a make some chart, based on class Result (i use CodeFirst)

I have class Results.cs

namespace PersonalArea.DAL.Models
{
    public class Result
    {
        public string Id { get; set; }

        public string PatientId { get; set; }

        public string GameName { get; set; }

        public string Time { get; set; }

        public int Score { get; set; }

        public int Level { get; set; }

        public DateTime FirstEnter { get; set; }

        public DateTime DateEnter { get; set; }

        public DateTime DateExit { get; set; }

        public string DifficultLevel { get; set; }

        public virtual Patient Patient { get; set; }
    }
}

And method in controller

[HttpGet]
        public async Task<IActionResult> Results(string id)
        {
            if (string.IsNullOrEmpty(id))
            {
                return NotFound();
            }
            Patient patient = await _userManager.FindByIdAsync(id) as Patient;
            if (patient == null)
            {
                return NotFound();
            }
            List<IGrouping<string, Result>> results = _context.Results.Where(x => x.PatientId == id).GroupBy(z => z.GameName).ToList();
            ViewBag.Test = JsonConvert.SerializeObject(results);
            return View(results);
        }

My ViewModel

using PersonalArea.DAL.Models;
using System;
using System.Collections.Generic;
using System.Linq;
using System.Threading.Tasks;

namespace PersonalArea.WebUI.ViewModels
{
    public class ResultChartModel
    {
        public string Surname { get; set; }

        public IQueryable<IGrouping<string, Result>> Results { get; set; }
    }
}

And my View.cshtml

window.onload = function ()
        {
            var test = @Html.Raw(JsonConvert.DeserializeObject(ViewBag.test));
            var datapoints = [];

            for (var i = 0; i < test.length; i++)
            {
                var str_array = test[i].Score;

                for (var j = 0; j < str_array.length; j++)
                {
                    datapoints.push({ y: str_array[j], x: str_array[j], label: test[i].GameName });
                }
            }

And i have a error

JsonSerializationException: Self referencing loop detected with type 'PersonalArea.DAL.Models.Result'. Path '[0][0].patient.results'.

On

ViewBag.Test = JsonConvert.SerializeObject(results);

Please, help my resolve this error

Ashiquzzaman · Answer 1 · 2018-03-14T03:14:21.580

0

In your Model change like:

   public class ResultChartModel
    {
        public string Surname { get; set; }

        public List<Result> Results { get; set; }
    }

In your controller :

replace

    List<IGrouping<string, Result>> results = _context.Results.Where(x => x.PatientId == id).GroupBy(z => z.GameName).ToList();
    ViewBag.Test = JsonConvert.SerializeObject(results);

by

    List<Result> results = _context.Results.Where(x => x.PatientId == id).OrderBy(z => z.GameName).ThenBy(z => z.DateExit).ToList();
  ViewBag.Test = JsonConvert.SerializeObject(results);

Then Your View :

Change

var test = @Html.Raw(ViewBag.test);

To

var test = @Html.Raw(JsonConvert.DeserializeObject(ViewBag.Test));

JS:

    for (var i = 0; i < test.length; i++) {  

        datapoints.push({ y: test[i].Score x: test[i].DateExit, label: test[i].GameName });

 }

Hopefully it's help you.

edited Mar 14 '18 at 03:14

answered Mar 13 '18 at 06:00

Ashiquzzaman

5,129
3
27
38

He don't understand this new JavaScriptSerializer() – Travis Bincle Mar 13 '18 at 06:36
How i make resolve it? – Travis Bincle Mar 13 '18 at 06:36
@TravisBincle .Sorry for my grate mistake. It's ASP.NET MVC not ASP.NET CORE. so I Update my answer. and use `Newtonsoft.Json`.https://stackoverflow.com/questions/29841503/json-serialization-deserialization-in-asp-net-core – Ashiquzzaman Mar 13 '18 at 06:41
Thanks, error is gone, but my page is empty. Why it can be? I updated my view page, maybe there problem? – Travis Bincle Mar 13 '18 at 07:04
Oh, that my fail, i put extra parenthesis, thank you very much! – Travis Bincle Mar 13 '18 at 07:42
Oh, wait, i have a question - chart show only first data, how can show all data? – Travis Bincle Mar 13 '18 at 07:51
check your `List`. is it only one item or not? if yes. then think about your Group By statement according your business. – Ashiquzzaman Mar 13 '18 at 08:42
No, there is a three and many data. So, GroupBy i used, because want to devide scores to GameName. In a table i can do it, but in chart i can show only last of first data. How i can to avoid this? – Travis Bincle Mar 13 '18 at 08:53
If you want to take last item then `results.OrderByDescending(a => a.XXX).Take(1).` OR `results.OrderByDescending(a => a.XXX).FirstOrDefault().` – Ashiquzzaman Mar 13 '18 at 09:01
No, no, i need take all items, not last or first – Travis Bincle Mar 13 '18 at 09:11
Please,help my choose all items of this List. – Travis Bincle Mar 13 '18 at 09:50
Is `datapoints` has all item of `results` item? – Ashiquzzaman Mar 13 '18 at 09:57
Table Results have 3 or more items. For example: GameName "Stars" have Scores 10, 3, 11, 15. GameName "Cars" have Scores 5, 9. But on Chart i can see only: GameName "Stars" -15 scores and GameName "Cars" - 9 scores. How i can show in graph ALL scores. It is possible? – Travis Bincle Mar 13 '18 at 10:02
all scores are coma separated or list item? – Ashiquzzaman Mar 13 '18 at 10:05
list item. But Chart show only last item – Travis Bincle Mar 13 '18 at 10:15
@TravisBincle I update my answer. Please inform your status. – Ashiquzzaman Mar 13 '18 at 10:32
Ok, i inform you when i get to the computer and change my code! – Travis Bincle Mar 13 '18 at 11:39
i change my code on yours, but counts on chart is gone. What me doing? I updated my code, when you can see my changed (x and y i I decided designated how score) – Travis Bincle Mar 13 '18 at 12:27
Let me show my database, what you seen how i placed my scores http://oi64.tinypic.com/qo926x.jpg – Travis Bincle Mar 13 '18 at 12:55
@TravisBincle you don't need grouping any more. I update my full answer. – Ashiquzzaman Mar 13 '18 at 13:39
Thanks you, i checked tommorrow, and i inform my status. Thanks! – Travis Bincle Mar 13 '18 at 16:18
Hello. My system have a error "JsonSerializationException: Self referencing loop detected with type 'PersonalArea.DAL.Models.Result'. Path '[0].Patient.Results'." What me doing? – Travis Bincle Mar 14 '18 at 04:57
Okey, i fixed this problem. Thank you very much! – Travis Bincle Mar 14 '18 at 07:03

Cannot create convert to JSON

1 Answers1