private void LoadLineChartData(string startDate, string endDate)
{
Hashtable entryHash = new Hashtable();
Hashtable exitHash = new Hashtable();
double avgEntryCars = 0;
double avgEntryTime = 0;
double avgExitCars = 0;
double avgExitTime = 0;
if (objChartDba == null)
{
objChartDba = new ChartDba();
}
entryHash = objChartDba.getEntryParksData(startDate, endDate);
exitHash = objChartDba.getExitParksData(startDate, endDate);
objChartDba.getAvgEntryCarAndTime(startDate, endDate, out avgEntryCars, out avgEntryTime);
objChartDba.getAvgExitCarAndTime(startDate, endDate, out avgExitCars, out avgExitTime);
avg_entry_cars.Content = "Avg. entry cars/day: " + avgEntryCars;
avg_entry_duration.Content = "Avg. entry time: " + avgEntryTime;
avg_exit_cars.Content = "Avg. exit cars/day: " + avgExitCars;
avg_exit_duration.Content = "Avg. exit time: " + avgExitTime;
((LineSeries)mcChart.Series[0]).ItemsSource = entryHash;
((LineSeries)mcChart.Series[1]).ItemsSource = exitHash;
}
private void LoadLineChartData(string startDate, string endDate)
{
Hashtable entryHash = new Hashtable();
Hashtable exitHash = new Hashtable();
double avgEntryCars = 0;
double avgEntryTime = 0;
double avgExitCars = 0;
double avgExitTime = 0;
if (objChartDba == null)
{
objChartDba = new ChartDba();
}
// ht = new DBConnection().getEntryParksData();
entryHash = objChartDba.GetEntryPeakTimeFindView(startDate, endDate);
exitHash = objChartDba.GetExitPeakTimeFindView(startDate, endDate);
//new DBConnection().getAvgEntryCarAndTime(startDate, endDate,out avgEntryCars,out avgEntryTime);
//new DBConnection().getAvgExitCarAndTime(startDate, endDate, out avgExitCars, out avgExitTime);
//avg_entry_cars.Content = "Avg. entry cars/day: "+avgEntryCars;
//avg_entry_duration.Content = "Avg. entry time: " + avgEntryTime;
//avg_exit_cars.Content = "Avg. exit cars/day: " + avgExitCars;
//avg_exit_duration.Content = "Avg. exit time: " + avgExitTime;
//from_date.Content = startDate;
//to_date.Content = endDate;
((LineSeries)mcChart.Series[0]).ItemsSource = entryHash;
((LineSeries)mcChart.Series[1]).ItemsSource = exitHash;
}
