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