public FindProjectTaskForVoidingDataSet FindProjectTaskForVoiding(int intEmployeeID, DateTime datTransactionDate) { try { aFindProjectTaskForVoidingDataSet = new FindProjectTaskForVoidingDataSet(); aFindProjectTaskForVoidingTableAdapter = new FindProjectTaskForVoidingDataSetTableAdapters.FindProjectTaskForVoidingTableAdapter(); aFindProjectTaskForVoidingTableAdapter.Fill(aFindProjectTaskForVoidingDataSet.FindProjectTaskForVoiding, intEmployeeID, datTransactionDate); } catch (Exception Ex) { TheEventLogClass.InsertEventLogEntry(DateTime.Now, "Project Task Class // Find Project Task For Voiding " + Ex.Message); } return(aFindProjectTaskForVoidingDataSet); }
private void expFindTransactions_Expanded(object sender, RoutedEventArgs e) { bool blnFatalError = false; int intCounter; int intNumberOfRecords; string strValueForValidation; string strErrorMessage = ""; bool blnThereIsAProblem = false; int intProjectID; int intTaskID; int intSecondCounter; int intSecondNumberOfRecords; try { //data validation expFindTransactions.IsExpanded = false; if (cboSelectEmployee.SelectedIndex < 1) { blnFatalError = true; strErrorMessage += "The Employee Was Not Selected\n"; } strValueForValidation = txtEnterDate.Text; blnThereIsAProblem = TheDataValidationClass.VerifyDateData(strValueForValidation); if (blnThereIsAProblem == true) { blnFatalError = true; strErrorMessage += "The Date Entered is not a Date\n"; } else { gdatTransactionDate = Convert.ToDateTime(strValueForValidation); } if (blnFatalError == true) { TheMessagesClass.ErrorMessage(strErrorMessage); return; } TheFindEmployeeProjectAssignmentForVoidingDataSet = TheEmployeeProjectAssignmentClass.FindEmployeeProjectAssignmentForVoiding(gintEmployeeID, gdatTransactionDate); intNumberOfRecords = TheFindEmployeeProjectAssignmentForVoidingDataSet.FindEmployeeProjectAssignmentForVoiding.Rows.Count; for (intCounter = 0; intCounter < intNumberOfRecords; intCounter++) { ProjectsForVoidingDataSet.projectsforvoidingRow NewProjectRow = TheProjectsForVoidingDataSet.projectsforvoiding.NewprojectsforvoidingRow(); NewProjectRow.AssignedProjectID = TheFindEmployeeProjectAssignmentForVoidingDataSet.FindEmployeeProjectAssignmentForVoiding[intCounter].AssignedProjectID; NewProjectRow.AssignmentTransactionID = TheFindEmployeeProjectAssignmentForVoidingDataSet.FindEmployeeProjectAssignmentForVoiding[intCounter].TransactionID; NewProjectRow.CustomerProjectID = TheFindEmployeeProjectAssignmentForVoidingDataSet.FindEmployeeProjectAssignmentForVoiding[intCounter].CustomerAssignedID; NewProjectRow.Footage = 0; NewProjectRow.ProjectID = TheFindEmployeeProjectAssignmentForVoidingDataSet.FindEmployeeProjectAssignmentForVoiding[intCounter].ProjectID; NewProjectRow.TaskTransactionID = -1; NewProjectRow.TotalHours = TheFindEmployeeProjectAssignmentForVoidingDataSet.FindEmployeeProjectAssignmentForVoiding[intCounter].TotalHours; NewProjectRow.WorkTask = TheFindEmployeeProjectAssignmentForVoidingDataSet.FindEmployeeProjectAssignmentForVoiding[intCounter].WorkTask; NewProjectRow.WorkTaskID = TheFindEmployeeProjectAssignmentForVoidingDataSet.FindEmployeeProjectAssignmentForVoiding[intCounter].TaskID; TheProjectsForVoidingDataSet.projectsforvoiding.Rows.Add(NewProjectRow); } TheFindProjectTaskForVoidingDataSet = TheProjectTaskClass.FindProjectTaskForVoiding(gintEmployeeID, gdatTransactionDate); intNumberOfRecords = TheProjectsForVoidingDataSet.projectsforvoiding.Rows.Count; intSecondNumberOfRecords = TheFindProjectTaskForVoidingDataSet.FindProjectTaskForVoiding.Rows.Count; if (intNumberOfRecords > 0) { for (intCounter = 0; intCounter < intNumberOfRecords; intCounter++) { intTaskID = TheProjectsForVoidingDataSet.projectsforvoiding[intCounter].WorkTaskID; intProjectID = TheProjectsForVoidingDataSet.projectsforvoiding[intCounter].ProjectID; if (intSecondNumberOfRecords > 0) { for (intSecondCounter = 0; intSecondCounter < intSecondNumberOfRecords; intSecondCounter++) { if (intTaskID == TheFindProjectTaskForVoidingDataSet.FindProjectTaskForVoiding[intSecondCounter].WorkTaskID) { if (intProjectID == TheFindProjectTaskForVoidingDataSet.FindProjectTaskForVoiding[intSecondCounter].ProjectID) { TheProjectsForVoidingDataSet.projectsforvoiding[intCounter].TaskTransactionID = TheFindProjectTaskForVoidingDataSet.FindProjectTaskForVoiding[intSecondCounter].TransactionID; TheProjectsForVoidingDataSet.projectsforvoiding[intCounter].Footage = TheFindProjectTaskForVoidingDataSet.FindProjectTaskForVoiding[intSecondCounter].FootagePieces; } } } } } } dgrResults.ItemsSource = TheProjectsForVoidingDataSet.projectsforvoiding; } catch (Exception Ex) { TheEventLogClass.InsertEventLogEntry(DateTime.Now, "New Blue Jay Erp // Void Productivity Sheet // Find Transactions Expander " + Ex.Message); TheMessagesClass.ErrorMessage(Ex.ToString()); } }