public FindProjectsByDateRangeDataSet FindProjectsByDateRange(DateTime datStartDate, DateTime datEndDate) { try { aFindProjectsByDateRangeDataSet = new FindProjectsByDateRangeDataSet(); aFindProjectsByDateRangeTableAdapter = new FindProjectsByDateRangeDataSetTableAdapters.FindProjectsByDateRangeTableAdapter(); aFindProjectsByDateRangeTableAdapter.Fill(aFindProjectsByDateRangeDataSet.FindProjectsByDateRange, datStartDate, datEndDate); } catch (Exception Ex) { TheEventLogClass.InsertEventLogEntry(DateTime.Now, "Projects Class // Find Projects By Date Range " + Ex.Message); } return(aFindProjectsByDateRangeDataSet); }
private void mitSearchForProjects_Click(object sender, RoutedEventArgs e) { //setting local variables string strValueForValidation; bool blnFatalError; DateTime datStartDate = DateTime.Now; DateTime datEndDate = DateTime.Now; int intRecordsReturned; try { strValueForValidation = txtEnterDate.Text; blnFatalError = TheDataValidationClass.VerifyDateData(strValueForValidation); if (blnFatalError == true) { TheMessagesClass.ErrorMessage("The Date Entered is not a Date"); return; } else { datStartDate = Convert.ToDateTime(strValueForValidation); } datStartDate = TheDateSearchClass.RemoveTime(datStartDate); datEndDate = TheDateSearchClass.AddingDays(datStartDate, 1); TheFindProjectsByDateRangeDataSet = TheProjectsClass.FindProjectsByDateRange(datStartDate, datEndDate); intRecordsReturned = TheFindProjectsByDateRangeDataSet.FindProjectsByDateRange.Rows.Count; if (intRecordsReturned == 0) { TheMessagesClass.InformationMessage("No Projects Were Found For That Date"); } dgrResults.ItemsSource = TheFindProjectsByDateRangeDataSet.FindProjectsByDateRange; } catch (Exception Ex) { TheEventLogClass.InsertEventLogEntry(DateTime.Now, "Blue Jay ERP \\ Project Date Search \\ Search For Projects Menu Item " + Ex.Message); TheMessagesClass.ErrorMessage(Ex.ToString()); } }