public FindDriveTimeForVoidingDataSet FindDriveTimeForVoiding(DateTime datTransactionDate, int intEmployeeID, int intProjectID) { try { aFindDriveTimeForVoidingDataSet = new FindDriveTimeForVoidingDataSet(); aFindDriveTimeForVoidingTableAdapter = new FindDriveTimeForVoidingDataSetTableAdapters.FindDriveTimeForVoidingTableAdapter(); aFindDriveTimeForVoidingTableAdapter.Fill(aFindDriveTimeForVoidingDataSet.FindDriveTimeForVoiding, datTransactionDate, intEmployeeID, intProjectID); } catch (Exception Ex) { TheEventLogClass.InsertEventLogEntry(DateTime.Now, "Employee Project Assignment Class // Find Drive Time For Voiding " + Ex.Message); } return(aFindDriveTimeForVoidingDataSet); }
private void expFindItems_Expanded(object sender, RoutedEventArgs e) { bool blnThereIsAProblem = false; bool blnFatalError = false; string strErrorMessage = ""; string strValueForValidation; string strProjectID; DateTime datTransactionDate = DateTime.Now; int intRecordsReturned; int intProjectID = 0; int intCounter; int intNumberForRecords; try { expFindItems.IsExpanded = false; TheDriveTimeForVoidingDataSet.drivetimeforvoiding.Rows.Clear(); if (cboSelectEmployee.SelectedIndex < 1) { blnFatalError = true; strErrorMessage += "The Employee Has Not Been Selected\n"; } strProjectID = txtProjectID.Text; if (strProjectID.Length < 4) { blnFatalError = true; strErrorMessage += "The Project ID Is Not Long Enough\n"; } else { TheFindProjectMatrixByCustomerProjectIDDataSet = TheProjectMatrixClass.FindProjectMatrixByCustomerProjectID(strProjectID); intRecordsReturned = TheFindProjectMatrixByCustomerProjectIDDataSet.FindProjectMatrixByCustomerProjectID.Rows.Count; if (intRecordsReturned > 0) { intProjectID = TheFindProjectMatrixByCustomerProjectIDDataSet.FindProjectMatrixByCustomerProjectID[0].ProjectID; } else if (intRecordsReturned < 1) { TheFindProjectMatrixByAssignedProjectIDDataSet = TheProjectMatrixClass.FindProjectMatrixByAssignedProjectID(strProjectID); intRecordsReturned = TheFindProjectMatrixByAssignedProjectIDDataSet.FindProjectMatrixByAssignedProjectID.Rows.Count; if (intRecordsReturned > 0) { intProjectID = TheFindProjectMatrixByAssignedProjectIDDataSet.FindProjectMatrixByAssignedProjectID[0].ProjectID; } else if (intRecordsReturned < 1) { strErrorMessage += "The Project Was Not Found\n"; } } } strValueForValidation = txtDate.Text; blnThereIsAProblem = TheDataValidationClass.VerifyDateData(strValueForValidation); if (blnThereIsAProblem == true) { blnFatalError = true; strErrorMessage += "The Date Entered is not a Date\n"; } else { datTransactionDate = Convert.ToDateTime(strValueForValidation); } if (blnFatalError == true) { TheMessagesClass.ErrorMessage(strErrorMessage); return; } TheFindDriveTimeForVoidingDataSet = TheEmployeeProjectAssignmentClass.FindDriveTimeForVoiding(datTransactionDate, MainWindow.gintEmployeeID, intProjectID); intNumberForRecords = TheFindDriveTimeForVoidingDataSet.FindDriveTimeForVoiding.Rows.Count; if (intNumberForRecords > 0) { for (intCounter = 0; intCounter < intNumberForRecords; intCounter++) { DriveTimeForVoidingDataSet.drivetimeforvoidingRow NewDriveTime = TheDriveTimeForVoidingDataSet.drivetimeforvoiding.NewdrivetimeforvoidingRow(); NewDriveTime.FirstName = TheFindDriveTimeForVoidingDataSet.FindDriveTimeForVoiding[intCounter].FirstName; NewDriveTime.LastName = TheFindDriveTimeForVoidingDataSet.FindDriveTimeForVoiding[intCounter].LastName; NewDriveTime.ProjectID = TheFindDriveTimeForVoidingDataSet.FindDriveTimeForVoiding[intCounter].CustomerAssignedID; NewDriveTime.TransactionDate = TheFindDriveTimeForVoidingDataSet.FindDriveTimeForVoiding[intCounter].TransactionDate; NewDriveTime.TransactionID = TheFindDriveTimeForVoidingDataSet.FindDriveTimeForVoiding[intCounter].TransactionID; NewDriveTime.VoidTransactions = false; NewDriveTime.WorkTask = TheFindDriveTimeForVoidingDataSet.FindDriveTimeForVoiding[intCounter].WorkTask; TheDriveTimeForVoidingDataSet.drivetimeforvoiding.Rows.Add(NewDriveTime); } } dgrResults.ItemsSource = TheDriveTimeForVoidingDataSet.drivetimeforvoiding; } catch (Exception Ex) { TheEventLogClass.InsertEventLogEntry(DateTime.Now, "New Blue Jay ERP // Void Drive Time // Find Items Expander " + Ex.Message); TheMessagesClass.ErrorMessage(Ex.ToString()); } }