private void endDateDatePicker_SelectedDateChanged(object sender, SelectionChangedEventArgs e)
{
int item = wasteTrackerStationsComboBox.SelectedIndex;
DateTime?StartDate = startDateDatePicker.SelectedDate;
DateTime?EndDate = endDateDatePicker.SelectedDate;
if (EndDate < StartDate)
{
BIMessageBox.Show("Please Select an End Date That is After the Start Date.");
}
else
{
FillData(StartDate, EndDate, item);
}
}
public void FillData(DateTime?start, DateTime?end, int item)
{
SandboxDataSet ds = ((SandboxDataSet)(FindResource("sandboxDataSet")));
SandboxDataSetTableAdapters.WasteTrackerDBTableAdapter da = new SandboxDataSetTableAdapters.WasteTrackerDBTableAdapter();
string startdate = start.ToString();
string enddate = end.ToString();
if (startdate == null)
{
BIMessageBox.Show("Please Select a Date");
return;
}
else
{
da.FillByDateRange(ds.WasteTrackerDB, item, startdate, enddate);
}
}
public PageViewReports()
{
InitializeComponent();
try
{
//Load database
SandboxDataSet ds = ((SandboxDataSet)(FindResource("sandboxDataSet")));
//Load combobox of stations
CollectionViewSource stViewSource = ((CollectionViewSource)(FindResource("wasteTrackerStationsViewSource")));
SandboxDataSetTableAdapters.WasteTrackerStationsTableAdapter sbda = new SandboxDataSetTableAdapters.WasteTrackerStationsTableAdapter();
sbda.Fill(ds.WasteTrackerStations);
}
catch (Exception ex)
{
BIMessageBox.Show("Oops there was a problem, please contact Business Intelligence \n" + ex);
}
}
private void startDateDatePicker_SelectedDateChanged(object sender, SelectionChangedEventArgs e)
{
int item = wasteTrackerStationsComboBox.SelectedIndex;
DateTime?StartDate = startDateDatePicker.SelectedDate;
DateTime?EndDate = endDateDatePicker.SelectedDate;
if (StartDate > EndDate)
{
BIMessageBox.Show("Please Select a Start Date That is Before the End Date.");
}
else
{
if (EndDate == null)
{
return;
}
else
{
FillData(StartDate, EndDate, item);
}
}
}