public static Series CreateNewChart(string gebied, string Data_type)
{
Series series = new Series();
series.Name = Data_type;
series.ChartType = SeriesChartType.Line;
string table_name = DictionairContainer.ChangeName(Data_type);
string echtegebied = DictionairContainer.getAreaName(gebied.ToLower());
double data06 = double.Parse((DatabaseRequester.getDataFromYear(table_name, echtegebied, "2006")), CultureInfo.GetCultureInfo("de-DE"));
double data07 = double.Parse((DatabaseRequester.getDataFromYear(table_name, echtegebied, "2007")), CultureInfo.GetCultureInfo("de-DE"));
double data08 = double.Parse((DatabaseRequester.getDataFromYear(table_name, echtegebied, "2008")), CultureInfo.GetCultureInfo("de-DE"));
double data09 = double.Parse((DatabaseRequester.getDataFromYear(table_name, echtegebied, "2009")), CultureInfo.GetCultureInfo("de-DE"));
double data11 = double.Parse((DatabaseRequester.getDataFromYear(table_name, echtegebied, "2011")), CultureInfo.GetCultureInfo("de-DE"));
series.Points.DataBindXY(new[] { 2006, 2007, 2008, 2009, 2011 }, new[] { data06, data07, data08, data09, data11 });
return(series);
}
//The dropdown menu for year
private void DropdownYear_SelectedIndexChanged(object sender, EventArgs e)
{
object LocationIndex = DropdownYear.SelectedItem;
MapFunctions.Clear(gmap);
if (DropdownCrime.SelectedIndex != -1 && DropdownYear.SelectedIndex != -1 && (manual2.Checked || manualdeel.Checked))
{
AreaFunctions.DrawAreas(gmap, checkedListBox1, RotterdamInstance, testbox, Deel, manual2, manualdeel, Heatmaps, DictionairContainer.ChangeName(DropdownCrime.SelectedItem.ToString()), DropdownYear.SelectedItem.ToString());
}
else if ((DropdownCrime.SelectedIndex != -1 && DropdownYear.SelectedIndex != -1))
{
AreaFunctions.CheckAll(gmap, RotterdamInstance, testbox, Deel, Heatmaps, DictionairContainer.ChangeName(DropdownCrime.SelectedItem.ToString()), DropdownYear.SelectedItem.ToString());
}
}
//The checklistbox where you can choose manual areas or manual borough
private void checkedListBox1_SelectedIndexChanged(object sender, EventArgs e)
{
if (manual2.Checked == false && (testbox.Checked == false || testbox.Checked == true) && (Deel.Checked == false || Deel.Checked == true) && manualdeel.Checked == false)
{
if (checkedListBox1.CheckedIndices.Count > 0)
{
manual2.Checked = true;
testbox.Checked = false;
Deel.Checked = false;
}
}
MapFunctions.Clear(gmap);
AreaFunctions.DrawAreas(gmap, checkedListBox1, RotterdamInstance, testbox, Deel, manual2, manualdeel, Heatmaps, DictionairContainer.ChangeName(DropdownCrime.SelectedItem.ToString()), DropdownYear.SelectedItem.ToString());
}
//The all borough checkbox
private void Deel_CheckedChanged(object sender, EventArgs e)
{
MapFunctions.Clear(gmap);
Heatmaps.Clear();
if (Deel.Checked)
{
foreach (int i in checkedListBox1.CheckedIndices)
{
checkedListBox1.SetItemCheckState(i, CheckState.Unchecked);
}
manualdeel.Checked = false;
manual2.Checked = false;
testbox.Checked = false;
AreaFunctions.CheckAll(gmap, RotterdamInstance, testbox, Deel, Heatmaps, DictionairContainer.ChangeName(DropdownCrime.SelectedItem.ToString()), DropdownYear.SelectedItem.ToString());
}
}
private void comboBox2_SelectedIndexChanged(object sender, EventArgs e)
{
Deel.Checked = false;
manual2.Checked = true;
testbox.Checked = false;
manualdeel.Checked = false;
if (DropdownCrime.SelectedIndex != -1 && DropdownYear.SelectedIndex != -1)
{
MapFunctions.Warp(gmap, comboBox2.SelectedItem, RotterdamInstance, Heatmaps, DictionairContainer.ChangeName(DropdownCrime.SelectedItem.ToString()), DropdownYear.SelectedItem.ToString());
}
}
