public List <Duodata <string, int> > BoxPNeighbourhood()
{
try
{
Table tablechain = DataprocessingInitialisation.BikeBox;
tablechain = new CountOnColumnElement("Deelgem.", tablechain);
StringTable table = tablechain.GetTable();
List <string> uniqueIDs, amounts;
uniqueIDs = table.GetColumn("Deelgem.");
amounts = table.GetColumn("Amount");
Duodata <string, int> toadd;
List <Duodata <string, int> > toreturn = new List <Duodata <string, int> >();
for (int i = 0; i < uniqueIDs.Count; i++)
{
toadd = new Duodata <string, int>(uniqueIDs[i], int.Parse(amounts[i]));
toreturn.Add(toadd);
}
return(toreturn);
}
catch (Exception e)
{
Scene.SceneManager.getAScene("TestScene").SetParaMeters(e.GetType().ToString() + "\n");
Scene.SceneManager.getAScene("TestScene").SetParaMeters(e.Message + " ... " + e.StackTrace + "\n");
List <Duodata <string, int> > temp = new List <Duodata <string, int> >();
temp.Add(new Duodata <string, int>("Error", 10));
return(temp);
}
}
public List <Duodata <string, int> > TheftPMonth()
{
Table tablechain = DataprocessingInitialisation.BikeTheft;
Scene.SceneManager.getAScene("TestScene").SetParaMeters(tablechain.GetTable().Columns["Kennisname"].Count.ToString() + " default \n");
tablechain = new MakePerMonth("Kennisname", tablechain);
Scene.SceneManager.getAScene("TestScene").SetParaMeters(tablechain.GetTable().Columns["Kennisname"].Count.ToString() + " mademonth \n");
tablechain = new CountOnColumnElement("Kennisname", tablechain);
Scene.SceneManager.getAScene("TestScene").SetParaMeters(tablechain.GetTable().Columns["Kennisname"].Count.ToString() + " countedonelement \n");
StringTable table = tablechain.GetTable();
List <string> uniqueIDs, amounts;
uniqueIDs = table.GetColumn("Kennisname");
amounts = table.GetColumn("Amount");
Duodata <string, int> toadd;
List <Duodata <string, int> > toreturn = new List <Duodata <string, int> >();
for (int i = 0; i < uniqueIDs.Count; i++)
{
toadd = new Duodata <string, int>(uniqueIDs[i], int.Parse(amounts[i]));
toreturn.Add(toadd);
}
return(toreturn);
}
//draw pie chart
public static ARGB[,] Make(List <Duodata <string, int> > aDuodataList)
{
int numberofslices = aDuodataList.Count;
int sizepiechart = 500;
ARGB[,] piechart = new ARGB[sizepiechart, sizepiechart];
double lastAngle = 0;
double newangle;
double percentage;
ARGB colortofill;
for (int x = 0; x < sizepiechart; x++)
{
for (int y = 0; y < sizepiechart; y++)
{
piechart[x, y] = new ARGB(0, 0, 0, 0);
}
}
int total = 0;
foreach (Duodata <string, int> i in aDuodataList)
{
total += i.GetAttr2();
}
for (int j = 0; j < aDuodataList.Count; j++)
{
Duodata <string, int> i = aDuodataList[j];
colortofill = ListOfColorsToUse[j];
if (i.GetAttr2() > total / 2)
{
percentage = (double)i.GetAttr2() / (double)total / 2;
newangle = lastAngle + 2 * Math.PI * percentage;
piechart = DrawSlice(piechart, lastAngle, newangle, colortofill);
lastAngle = newangle;
percentage = (double)i.GetAttr2() / (double)total / 2;
newangle = lastAngle + 2 * Math.PI * percentage;
piechart = DrawSlice(piechart, lastAngle, newangle, colortofill);
lastAngle = newangle;
}
else
{
percentage = (double)i.GetAttr2() / (double)total;
newangle = lastAngle + 2 * Math.PI * percentage;
piechart = DrawSlice(piechart, lastAngle, newangle, colortofill);
lastAngle = newangle;
}
}
return(piechart);
}
public List <Duodata <string, int> > TheftPColour()
{
Table tablechain = DataprocessingInitialisation.BikeTheft;
tablechain = new FilterOnly("object", "FIETS", tablechain);
tablechain = new CountOnColumnElement("kleur", tablechain);
StringTable table = tablechain.GetTable();
List <string> uniqueIDs, amounts;
uniqueIDs = table.GetColumn("kleur");
amounts = table.GetColumn("Amount");
Duodata <string, int> toadd;
List <Duodata <string, int> > toreturn = new List <Duodata <string, int> >();
for (int i = 0; i < uniqueIDs.Count; i++)
{
toadd = new Duodata <string, int>(uniqueIDs[i], int.Parse(amounts[i]));
toreturn.Add(toadd);
}
return(toreturn);
}
public List <Duodata <string, int> > TheftPMonthInNeighbourhood(string Neighbourhood)
{
Table tablechain = DataprocessingInitialisation.BikeTheft;
tablechain = new MakePerMonth("Kennisname", tablechain);
tablechain = new FilterOnly("Werkgebied", Neighbourhood, tablechain);
tablechain = new CountOnColumnElement("Kennisname", tablechain);
StringTable table = tablechain.GetTable();
List <string> uniqueIDs, amounts;
uniqueIDs = table.GetColumn("Kennisname");
amounts = table.GetColumn("Amount");
Duodata <string, int> toadd;
List <Duodata <string, int> > toreturn = new List <Duodata <string, int> >();
for (int i = 0; i < uniqueIDs.Count; i++)
{
toadd = new Duodata <string, int>(uniqueIDs[i], int.Parse(amounts[i]));
toreturn.Add(toadd);
}
return(toreturn);
}