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);
}