public JsonResult PieChartIndex() { var nostart = _dataSheetService.GetDataSheetCities(); var istanbul = nostart.Where(k => k.CityId == 34).Count(); var denizli = nostart.Where(k => k.CityId == 20).Count(); var izmir = nostart.Where(k => k.CityId == 35).Count(); var diger = nostart.Where(k => k.CityId != 34 && k.CityId != 20 && k.CityId != 35).Count(); List <PieChart> pieCharts = new List <PieChart>(); if (istanbul > 0) { pieCharts.Add(new PieChart { Color = "rgba(0, 86, 133, 1)", Highlight = "rgba(169, 3, 41, 0.7)", Result = istanbul, Label = "İstanbul" }); } if (denizli > 0) { pieCharts.Add(new PieChart { Color = "rgba(194, 68, 0, 1)", Highlight = "rgba(151,187,205,0.8)", Result = denizli, Label = "Denizli" }); } if (izmir > 0) { pieCharts.Add(new PieChart { Color = "rgba(104, 95, 90, 1)", Highlight = "rgba(151,187,205,0.8)", Result = izmir, Label = "İzmir" }); } if (diger > 0) { pieCharts.Add(new PieChart { Color = "rgba(151,187,205,1)", Highlight = "rgba(151,187,205,0.8)", Result = diger, Label = "Diğer" }); } return(Json(pieCharts)); }