public ActionResult PrzystankiRaport() { var przystankiRaport = new List<PrzystankiRaport>(from a in db.PrzystankiRaport orderby a.Wystapienia descending select a); var model = new LinieRaportViewModel(); var data = ""; var suma = (from a in przystankiRaport select a.Wystapienia).Sum(); foreach (var a in przystankiRaport) { double w = Math.Round(((double)a.Wystapienia / (double)suma) * 1000000.0, 0); data += "{ center: new google.maps.LatLng(" + a.Przystanki.X.ToString().Replace(",", ".") + "," + a.Przystanki.Y.ToString().Replace(",",".") + "), Ilosc: " + w + "},"; } model.data = data; model.data.Substring(0, model.data.Length - 1); return View(model); }
public ActionResult LinieRaport() { var linieRaport = new List<LinieRaport>(from a in db.LinieRaport orderby a.Wystapienia descending select a); var model = new LinieRaportViewModel(); var labels = ""; var data = ""; var suma = (from a in linieRaport select a.Wystapienia).Sum(); foreach(var a in linieRaport) { labels += "'Linia " + a.Linie.Symbol + "'" + ","; double w = Math.Round(((double)a.Wystapienia/(double)suma)*100.0, 2); data += w.ToString().Replace(",",".") + ","; } model.labels = labels; model.data = data; model.labels.Substring(0, model.labels.Length - 1); model.data.Substring(0, model.data.Length - 1); return View(model); }