private void CreateButtonsParkingGarages()
{
int i = 0;
foreach (var garagaName in MainDBContext.GetAllParkingGarageName())
{
Panel newBtn = new Panel();
newBtn.Width = 250;
newBtn.Height = 35;
newBtn.Visible = true;
newBtn.BackgroundImage = panel1.BackgroundImage;
newBtn.BackColor = Color.Transparent;
newBtn.BackgroundImageLayout = ImageLayout.Zoom;
Point p = new Point(0, 50 + i * 40);
newBtn.Text = garagaName;
newBtn.Location = p;
//newBtn.Click += new EventHandler(button_Click);
Label newLabel = new Label();
newLabel.Text = garagaName;
newLabel.Width = 230;
newLabel.Location = new Point(20, 7);
newLabel.ForeColor = Color.White;
newLabel.BringToFront();
newLabel.Click += new EventHandler(label_Click);
newBtn.Controls.Add(newLabel);
this.tabPage1.Controls.Add(newBtn);
i++;
}
}
public static ParkingGarageModel GetGarageModel(string parkingName, string date, string time)
{
using (MainDBContext context = new MainDBContext())
{
var allParkingGarages = context.ParkingGarageModel;
var parkingGaragesByDate = allParkingGarages.OrderBy(p => p.Date);
foreach (var parkingModel in parkingGaragesByDate)
{
if (parkingModel.Name == parkingName)
{ // && (parkingModel.Date == selectedDateTime)
var dateToCheck = parkingModel.Date.ToString().Split(' ');
if (dateToCheck[0].ToString() == date)
{
var checkDateTime = dateToCheck[1].Split(':');
string checkTime = (checkDateTime[0] + ":00");
if (time == checkTime)
{
return(parkingModel);
}
}
}
}
}
return(null);
}
public static List <String> GetGarageModelAll(string date, string time, bool open)
{
List <string> allReturnGarageModel = new List <string>();
using (MainDBContext context = new MainDBContext())
{
var allParkingGarages = context.ParkingGarageModel;
var parkingGaragesByDate = allParkingGarages.OrderBy(p => p.Date);
foreach (var parkingModel in parkingGaragesByDate)
{
var dateToCheck = parkingModel.Date.ToString().Split(' ');
if (dateToCheck[0].ToString() == date)
{
var checkDateTime = dateToCheck[1].Split(':');
string checkTime = (checkDateTime[0] + ":00");
if (time == checkTime)
{
if (open)
{
allReturnGarageModel.Add(parkingModel.ParkingCapacity.ToString());
}
else
{
allReturnGarageModel.Add(parkingModel.VacantSpaces.ToString());
}
}
}
}
}
return(allReturnGarageModel);
}
public static List <BicycleTheftModel> GetBicycleTheftsByTemperature(float minTemperature, float maxTemperature)
{
List <BicycleTheftModel> filteredBicycleThefts = new List <BicycleTheftModel>();
List <WeatherModel> filteredWeatherModels = new List <WeatherModel>();
using (MainDBContext context = new MainDBContext())
{
foreach (var weatherModel in context.WeatherModels)
{
if (weatherModel.DayAverageTemperature >= minTemperature && weatherModel.DayAverageTemperature <= maxTemperature)
{
filteredWeatherModels.Add(weatherModel);
}
}
foreach (var theft in context.BicycleThefts)
{
foreach (var weather in filteredWeatherModels)
{
if (theft.Date == weather.Date)
{
filteredBicycleThefts.Add(theft);
break;
}
}
}
}
return(filteredBicycleThefts);
}
public static List <BicycleTheftModel> GetBicycleTheftsByWindSpeed(float minWindspeed, float maxWindspeed)
{
List <BicycleTheftModel> filteredBicycleThefts = new List <BicycleTheftModel>();
List <WeatherModel> filteredWeatherModels = new List <WeatherModel>();
using (MainDBContext context = new MainDBContext())
{
foreach (var weatherModel in context.WeatherModels)
{
if (weatherModel.DayAverageWindspeed >= minWindspeed && weatherModel.DayAverageWindspeed <= maxWindspeed)
{
filteredWeatherModels.Add(weatherModel);
}
}
foreach (var theft in context.BicycleThefts)
{
foreach (var weather in filteredWeatherModels)
{
if (theft.Date == weather.Date)
{
filteredBicycleThefts.Add(theft);
break;
}
}
}
}
return(filteredBicycleThefts);
}
public static List <string> GetAllDatesForParkingGarage(string name)
{
List <string> allDates = new List <string>();
using (MainDBContext context = new MainDBContext())
{
var allParkingGarages = context.ParkingGarageModel;
var parkingGaragesByDate = allParkingGarages.OrderBy(p => p.Date);
foreach (var parkingGarage in parkingGaragesByDate)
{
if (parkingGarage.Name == name || name == "All parking garages")
{
string[] newdate = parkingGarage.Date.ToString().Split(' ');
if (allDates.Contains(newdate[0]) == false)
{
allDates.Add(newdate[0]);
}
// de data ziet er uit als 00/00/0000 00:00:00
// c# heeft een split functie je kan de string splitten op de " " [spatie]
// vervolgends kan je de contain functie op de index[0] van het split resultaat.
}
}
}
return(allDates);
}
public static List <BicycleTheftModel> GetBicycleTheftsByRainfall(float minRainfall, float maxRainfall)
{
List <BicycleTheftModel> filteredBicycleThefts = new List <BicycleTheftModel>();
List <WeatherModel> filteredWeatherModels = new List <WeatherModel>();
using (MainDBContext context = new MainDBContext())
{
foreach (var weatherModel in context.WeatherModels)
{
if (weatherModel.RainfallDaySum >= minRainfall && weatherModel.RainfallDaySum <= maxRainfall)
{
filteredWeatherModels.Add(weatherModel);
}
}
foreach (var theft in context.BicycleThefts)
{
foreach (var weather in filteredWeatherModels)
{
if (theft.Date == weather.Date)
{
filteredBicycleThefts.Add(theft);
break;
}
}
}
}
return(filteredBicycleThefts);
}
private void comboBox1_SelectedIndexChanged(object sender, EventArgs e)
{
//Console.WriteLine(comboBox1.Text);
comboBox2.Items.Clear();
foreach (var item in MainDBContext.GetAlltimesForParkingGarage(selectParkingGaragename, comboBox1.Text))
{
comboBox2.Items.Add(item);
}
}
public static List <int> GetGarageModelByTemp(string parkingName, string tempString, string time, bool open)
{
tempString = tempString.Replace(',', '.');
float temp = float.Parse(tempString, System.Globalization.CultureInfo.InvariantCulture);
float maxTemp = temp + 0.5f;
float minTemp = temp - 0.5f;
List <String> AllDates = new List <String>();
List <int> allReturnGarageModel = new List <int>();
using (MainDBContext context = new MainDBContext())
{
var AllWheterModel = context.WeatherModels;
foreach (var info in AllWheterModel)
{
string WirdTempFloat = info.DayAverageTemperature.ToString().Replace(',', '.');
float tempNormal = float.Parse(WirdTempFloat, System.Globalization.CultureInfo.InvariantCulture);
if (tempNormal < maxTemp && tempNormal > minTemp)
{
var date = info.Date.ToString().Split(' ');
AllDates.Add(date[0]);
}
}
var allParkinggarageModels = context.ParkingGarageModel;
foreach (var itemDate in AllDates)
{
foreach (var itemGarage in allParkinggarageModels)
{
var date = itemGarage.Date.ToString().Split(' ');
if (itemDate == date[0])
{
var checkDateTime = date[1].Split(':');
string checkTime = (checkDateTime[0] + ":00");
if (time == checkTime)
{
if (parkingName == itemGarage.Name || parkingName == "All parking garages")
{
if (open)
{
allReturnGarageModel.Add(itemGarage.ParkingCapacity);
}
else
{
allReturnGarageModel.Add(itemGarage.VacantSpaces);
}
}
}
}
}
}
}
return(allReturnGarageModel);
}
private List <BicycleTheftModel> GetBicycleTheftsByKeywordsFromCheckBoxes()
{
//TODO: First check if any of the bicycle checkboxes are selected if not dont get stuff from the database
List <BicycleTheftModel> allBicycleThefts = new List <BicycleTheftModel>();
List <BicycleTheftModel> listToReturn = new List <BicycleTheftModel>();
if (!(checkDamesFiets.Checked || checkHerenFiets.Checked || checkKinderFiets.Checked || checkOpoeFiets.Checked || checkSportFiets.Checked || checkOverigeFietsen.Checked))
{
System.Windows.Forms.MessageBox.Show("Selecteer een fietsmerk.");
return(new List <BicycleTheftModel>());
}
using (MainDBContext context = new MainDBContext())
{
allBicycleThefts.AddRange(context.BicycleThefts);
}
if (checkDamesFiets.Checked)
{
listToReturn.AddRange(allBicycleThefts.Where(b => b.Keyword == "DAMES"));
}
if (checkHerenFiets.Checked)
{
listToReturn.AddRange(allBicycleThefts.Where(b => b.Keyword == "HEREN"));
}
if (checkKinderFiets.Checked)
{
listToReturn.AddRange(allBicycleThefts.Where(b => b.Keyword == "KINDER"));
}
if (checkOpoeFiets.Checked)
{
listToReturn.AddRange(allBicycleThefts.Where(b => b.Keyword == "OPOE"));
}
if (checkSportFiets.Checked)
{
listToReturn.AddRange(allBicycleThefts.Where(b => b.Keyword == "SPORT"));
}
if (checkOverigeFietsen.Checked)
{
listToReturn.AddRange(allBicycleThefts.Where(b => b.Keyword != "DAMES" && b.Keyword != "HEREN" && b.Keyword != "KINDER" && b.Keyword != "OPOE" && b.Keyword != "SPORT"));
}
return(listToReturn);
}
private async void button1_Click(object sender, EventArgs e)
{
List <BicycleTheftModel> bicycleTheftModels = GetBicycleTheftsFromCSV();
List <ParkingGarageModel> parkingModels = GetParkingModelsFromTxtFiles();
List <WeatherModel> weatherModels = GetWeatherFromTextFile();
using (MainDBContext dbContext = new MainDBContext())
{
//dbContext.BicycleThefts.AddRange(bicycleTheftModels);
//dbContext.ParkingGarageModel.AddRange(parkingModels);
dbContext.WeatherModels.AddRange(weatherModels);
await dbContext.SaveChangesAsync();
}
}
public static String GetAvrTempDay(string date)
{
using (MainDBContext context = new MainDBContext())
{
foreach (var weatherModel in context.WeatherModels)
{
var selectDate = weatherModel.Date.ToString().Split(' ');
if (selectDate[0] == date)
{
return(weatherModel.DayAverageTemperature.ToString());
}
}
}
return(null);
}
public static List <string> GetAllParkingGarageName()
{
List <string> allParkingGarageNames = new List <string>();
using (MainDBContext context = new MainDBContext())
{
foreach (var parkingGaragaModel in context.ParkingGarageModel)
{
if (!allParkingGarageNames.Contains(parkingGaragaModel.Name))
{
allParkingGarageNames.Add(parkingGaragaModel.Name);
}
}
}
allParkingGarageNames.Add("All parking garages");
return(allParkingGarageNames);
}
protected void label_Click(object sender, EventArgs e)
{
var button = sender as Label;
comboBox1.Items.Clear();
selectParkingGaragename = button.Text;
foreach (var item in MainDBContext.GetAllDatesForParkingGarage(button.Text))
{
//Console.WriteLine(item); // write all dates
comboBox1.Items.Add(item);
}
garageSelection.Text = "Selected parking Garage : " + button.Text;
//Console.WriteLine(button.Text); // write button text (name of the parking garage)
// Make new view!
}
public static List <string> GetAlltimesForParkingGarage(string name, string date)
{
List <string> allTimes = new List <string>();
using (MainDBContext context = new MainDBContext())
{
var allParkingGarages = context.ParkingGarageModel;
var parkingGaragesByDate = allParkingGarages.OrderBy(p => p.Date);
foreach (var parkingGarage in parkingGaragesByDate)
{
if (parkingGarage.Name == name || name == "All parking garages")
{
string[] newdate = parkingGarage.Date.ToString().Split(' ');
string[] fixDate = newdate[1].Split(':');
if (allTimes.Contains(fixDate[0] + ":00") == false && newdate[0] == date)
{
allTimes.Add(fixDate[0] + ":00");
}
}
}
}
return(allTimes);
}
private void FilterBicycleTheftsByRainFallSumCheckBoxes(ref List <BicycleTheftModel> listToFilter)
{
List <WeatherModel> filteredWeatherModels = new List <WeatherModel>();
List <WeatherModel> allWeatherModels = new List <WeatherModel>();
using (var context = new MainDBContext())
{
allWeatherModels.AddRange(context.WeatherModels);
}
if (checkRainfall0And3.Checked)
{
filteredWeatherModels.AddRange(allWeatherModels.Where(w => w.RainfallDaySum >= 0 && w.RainfallDaySum < 3));
}
if (checkRainfall3And6.Checked)
{
filteredWeatherModels.AddRange(allWeatherModels.Where(w => w.RainfallDaySum >= 3 && w.RainfallDaySum < 6));
}
if (checkRainfall6And9.Checked)
{
filteredWeatherModels.AddRange(allWeatherModels.Where(w => w.RainfallDaySum >= 6 && w.RainfallDaySum < 9));
}
if (checkRainfall9And12.Checked)
{
filteredWeatherModels.AddRange(allWeatherModels.Where(w => w.RainfallDaySum >= 9 && w.RainfallDaySum < 12));
}
if (checkRainfall12And15.Checked)
{
filteredWeatherModels.AddRange(allWeatherModels.Where(w => w.RainfallDaySum >= 12 && w.RainfallDaySum < 15));
}
if (checkRainfall15And18.Checked)
{
filteredWeatherModels.AddRange(allWeatherModels.Where(w => w.RainfallDaySum >= 15 && w.RainfallDaySum < 18));
}
if (checkRainfall18And21.Checked)
{
filteredWeatherModels.AddRange(allWeatherModels.Where(w => w.RainfallDaySum >= 18 && w.RainfallDaySum < 21));
}
if (checkRainfall21And24.Checked)
{
filteredWeatherModels.AddRange(allWeatherModels.Where(w => w.RainfallDaySum >= 21 && w.RainfallDaySum < 24));
}
if (checkRainfall24And27.Checked)
{
filteredWeatherModels.AddRange(allWeatherModels.Where(w => w.RainfallDaySum >= 24 && w.RainfallDaySum < 27));
}
if (checkRainfall27And30.Checked)
{
filteredWeatherModels.AddRange(allWeatherModels.Where(w => w.RainfallDaySum >= 27 && w.RainfallDaySum < 30));
}
if (checkRainfall30And33.Checked)
{
filteredWeatherModels.AddRange(allWeatherModels.Where(w => w.RainfallDaySum >= 30 && w.RainfallDaySum < 33));
}
List <BicycleTheftModel> filteredBicycleThefts = new List <BicycleTheftModel>();
foreach (var theft in listToFilter)
{
foreach (var weather in filteredWeatherModels)
{
if (theft.Date == weather.Date)
{
filteredBicycleThefts.Add(theft);
break;
}
}
}
if (filteredBicycleThefts.Count > 0)
{
listToFilter = new List <BicycleTheftModel>(filteredBicycleThefts);
}
}
private void FilterBicycleTheftsByTemperatureCheckBoxes(ref List <BicycleTheftModel> listToFilter)
{
List <WeatherModel> filteredWeatherModels = new List <WeatherModel>();
List <WeatherModel> allWeatherModels = new List <WeatherModel>();
using (var context = new MainDBContext())
{
allWeatherModels.AddRange(context.WeatherModels);
}
if (checkTemperatureMin10AndMin5.Checked)
{
filteredWeatherModels.AddRange(allWeatherModels.Where(w => w.DayAverageTemperature >= -10 && w.DayAverageTemperature < -5));
}
if (checkTemperatureMin5And0.Checked)
{
filteredWeatherModels.AddRange(allWeatherModels.Where(w => w.DayAverageTemperature >= -5 && w.DayAverageTemperature < 0));
}
if (checkTemperature0And5.Checked)
{
filteredWeatherModels.AddRange(allWeatherModels.Where(w => w.DayAverageTemperature >= 0 && w.DayAverageTemperature < 5));
}
if (checkTemperature5And10.Checked)
{
filteredWeatherModels.AddRange(allWeatherModels.Where(w => w.DayAverageTemperature >= 5 && w.DayAverageTemperature < 10));
}
if (checkTemperature10And15.Checked)
{
filteredWeatherModels.AddRange(allWeatherModels.Where(w => w.DayAverageTemperature >= 10 && w.DayAverageTemperature < 15));
}
if (checkTemperature15And20.Checked)
{
filteredWeatherModels.AddRange(allWeatherModels.Where(w => w.DayAverageTemperature >= 15 && w.DayAverageTemperature < 20));
}
if (checkTemperature20And25.Checked)
{
filteredWeatherModels.AddRange(allWeatherModels.Where(w => w.DayAverageTemperature >= 20 && w.DayAverageTemperature < 25));
}
if (checkTemperature25And30.Checked)
{
filteredWeatherModels.AddRange(allWeatherModels.Where(w => w.DayAverageTemperature >= 25 && w.DayAverageTemperature < 30));
}
if (checkTemperature30And35.Checked)
{
filteredWeatherModels.AddRange(allWeatherModels.Where(w => w.DayAverageTemperature >= 30 && w.DayAverageTemperature < 35));
}
List <BicycleTheftModel> filteredBicycleThefts = new List <BicycleTheftModel>();
foreach (var theft in listToFilter)
{
foreach (var weather in filteredWeatherModels)
{
if (theft.Date == weather.Date)
{
filteredBicycleThefts.Add(theft);
break;
}
}
}
if (filteredBicycleThefts.Count > 0)
{
listToFilter = new List <BicycleTheftModel>(filteredBicycleThefts);
}
}
private void FilterBicycleTheftsByWindspeedCheckBoxes(ref List <BicycleTheftModel> listToFilter)
{
List <WeatherModel> filteredWeatherModels = new List <WeatherModel>();
List <WeatherModel> allWeatherModels = new List <WeatherModel>();
using (var context = new MainDBContext())
{
allWeatherModels.AddRange(context.WeatherModels);
}
if (checkWindspeed0And1.Checked)
{
filteredWeatherModels.AddRange(allWeatherModels.Where(w => w.DayAverageWindspeed >= 0 && w.DayAverageWindspeed < 1));
}
if (checkWindspeed1And2.Checked)
{
filteredWeatherModels.AddRange(allWeatherModels.Where(w => w.DayAverageWindspeed >= 1 && w.DayAverageWindspeed < 2));
}
if (checkWindspeed2And3.Checked)
{
filteredWeatherModels.AddRange(allWeatherModels.Where(w => w.DayAverageWindspeed >= 2 && w.DayAverageWindspeed < 3));
}
if (checkWindspeed3And4.Checked)
{
filteredWeatherModels.AddRange(allWeatherModels.Where(w => w.DayAverageWindspeed >= 3 && w.DayAverageWindspeed < 4));
}
if (checkWindspeed4And5.Checked)
{
filteredWeatherModels.AddRange(allWeatherModels.Where(w => w.DayAverageWindspeed >= 4 && w.DayAverageWindspeed < 5));
}
if (checkWindspeed5And6.Checked)
{
filteredWeatherModels.AddRange(allWeatherModels.Where(w => w.DayAverageWindspeed >= 5 && w.DayAverageWindspeed < 6));
}
if (checkWindspeed6And7.Checked)
{
filteredWeatherModels.AddRange(allWeatherModels.Where(w => w.DayAverageWindspeed >= 6 && w.DayAverageWindspeed < 7));
}
if (checkWindspeed7And8.Checked)
{
filteredWeatherModels.AddRange(allWeatherModels.Where(w => w.DayAverageWindspeed >= 7 && w.DayAverageWindspeed < 8));
}
if (checkWindspeed8And9.Checked)
{
filteredWeatherModels.AddRange(allWeatherModels.Where(w => w.DayAverageWindspeed >= 8 && w.DayAverageWindspeed < 9));
}
if (checkWindspeed9And10.Checked)
{
filteredWeatherModels.AddRange(allWeatherModels.Where(w => w.DayAverageWindspeed >= 9 && w.DayAverageWindspeed < 10));
}
if (checkWindspeed10And11.Checked)
{
filteredWeatherModels.AddRange(allWeatherModels.Where(w => w.DayAverageWindspeed >= 10 && w.DayAverageWindspeed < 11));
}
List <BicycleTheftModel> filteredBicycleThefts = new List <BicycleTheftModel>();
foreach (var theft in listToFilter)
{
foreach (var weather in filteredWeatherModels)
{
if (theft.Date == weather.Date)
{
filteredBicycleThefts.Add(theft);
break;
}
}
}
if (filteredBicycleThefts.Count > 0)
{
listToFilter = new List <BicycleTheftModel>(filteredBicycleThefts);
}
}
private void create_parking_chart_SelectedIndexChanged(object sender, EventArgs e)
{
if ((comboBox1.Text != "Select date") && (comboBox2.Text != "Select time"))
{
if (selectParkingGaragename == "All parking garages")
{
var ParkingCapacity = MainDBContext.GetGarageModelAll(comboBox1.Text, comboBox2.Text, true);
var VacantSpaces = MainDBContext.GetGarageModelAll(comboBox1.Text, comboBox2.Text, false);
int DevideCapacity = 1;
int countCapacity = 0;
int dump = 0;
foreach (string item in ParkingCapacity)
{
if (int.TryParse(item, out dump))
{
countCapacity = countCapacity + Int32.Parse(item);
DevideCapacity++;
}
}
int DevideVacantSpaces = 1;
int countVacantSpaces = 0;
foreach (string item in VacantSpaces)
{
//Console.WriteLine(item);
if (int.TryParse(item, out dump))
{
countVacantSpaces = DevideVacantSpaces + Int32.Parse(item);
DevideVacantSpaces++;
}
}
parkingChart.Series[0].Points.Clear();
parkingChart.Series[0].Points.AddXY("Bezet", (countCapacity / DevideCapacity));
parkingChart.Series[0].Points.AddXY("Leeg", (countVacantSpaces / DevideVacantSpaces));
parkingChart.DataBind();
}
else
{
var garageRequest = MainDBContext.GetGarageModel(selectParkingGaragename, comboBox1.Text, comboBox2.Text);
if (garageRequest != null)
{
//Console.WriteLine("werkt");
var ParkingCapacity = garageRequest.ParkingCapacity;
var VacantSpaces = garageRequest.VacantSpaces;
parkingChart.Series[0].Points.Clear();
parkingChart.Series[0].Points.AddXY("Bezet", ParkingCapacity);
parkingChart.Series[0].Points.AddXY("Leeg", VacantSpaces);
parkingChart.DataBind();
//Console.WriteLine("ParkingCapacity:" + ParkingCapacity);
//Console.WriteLine("VacantSpaces:" + VacantSpaces);
}
}
string avrTemp = MainDBContext.GetAvrTempDay(comboBox1.Text);
dayAvrTempLabel.Text = "The Average Tempereture this day was : " + avrTemp.ToString() + "°C";
var ParkingCapacityAll = MainDBContext.GetGarageModelByTemp(selectParkingGaragename, avrTemp, comboBox2.Text, true);
var VacantSpacesAll = MainDBContext.GetGarageModelByTemp(selectParkingGaragename, avrTemp, comboBox2.Text, false);
int DevideCapacityAll = 1;
float countCapacityAll = 0;
foreach (float item in ParkingCapacityAll)
{
countCapacityAll = countCapacityAll + item;
DevideCapacityAll++;
}
int DevideVacantSpacesAll = 1;
float countVacantSpacesAll = 0;
foreach (float item in VacantSpacesAll)
{
//Console.WriteLine(item);
countVacantSpacesAll = DevideVacantSpacesAll + item;
DevideVacantSpacesAll++;
}
parkingChart2.Series[0].Points.Clear();
parkingChart2.Series[0].Points.AddXY("Bezet", (countCapacityAll / DevideCapacityAll));
parkingChart2.Series[0].Points.AddXY("Leeg", (countVacantSpacesAll / DevideVacantSpacesAll));
parkingChart2.DataBind();
Panel2Label.Text = "This is the Average for this temperature and time ";
}
}
