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