public DisplayFare()
{
InitializeComponent();
dtpFDateFilter.SelectedDate = DateTime.Now;
dgFareHistory.ItemsSource = DBGuide.RetrieveFareRecordFromDatabase().DefaultView; //How to fill datagrid using datatable: https://stackoverflow.com/questions/20770438/how-to-bind-datatable-to-datagrid
tbxTotalFare.Text = string.Format("S{0:C}", DBGuide.FareHistoryTotalCollected()); //Total Fare Computed
}
private void Button_Click(object sender, RoutedEventArgs e)
{
try
{
DateTime dateFilter = dtpFDateFilter.SelectedDate.Value;
dgFareHistory.ItemsSource = null; //How to clear datagrid https://stackoverflow.com/questions/14472894/clear-datagrid-values-in-wpf
dgFareHistory.Items.Refresh(); //refresh Datagrid
dgFareHistory.ItemsSource = DBGuide.RetrieveFareRecordFromDatabase(dateFilter).DefaultView;
tbxTotalFare.Text = string.Format("S{0:C}", DBGuide.FareHistoryTotalCollected(dateFilter));
}
catch (Exception ex) //catch exception error
{
MessageBox.Show("Please select a date");
}
}