public FindProjectTaskForProductivityReportDataSet FindProjectTaskForProductivityReport(int intEmployeeID, int intProjectID, DateTime datTransactionDate) { try { aFindProjectTaskForProductivityReportDataSet = new FindProjectTaskForProductivityReportDataSet(); aFindProjectTaskForProductivityReportTableAdapter = new FindProjectTaskForProductivityReportDataSetTableAdapters.FindProjectTaskForProductivityReportTableAdapter(); aFindProjectTaskForProductivityReportTableAdapter.Fill(aFindProjectTaskForProductivityReportDataSet.FindProjectTaskForProductivityReport, intEmployeeID, intProjectID, datTransactionDate); } catch (Exception Ex) { TheEventLogClass.InsertEventLogEntry(DateTime.Now, "Project Task Class // Find Project Task For Productivity Report " + Ex.Message); } return(aFindProjectTaskForProductivityReportDataSet); }
private void cboSelectCrew_SelectionChanged(object sender, SelectionChangedEventArgs e) { //setting local variables int intSelectedIndex; string strCrewID; int intEmployeeCounter; int intEmployeeID; int intProjectID; int intCounter; int intNumberOfRecords; int intSecondCounter; int intSecondNumberOfRecords; DateTime datTransactionDate; try { intSelectedIndex = cboSelectCrew.SelectedIndex - 1; if (intSelectedIndex > -1) { strCrewID = TheFindEmployeeCrewAssignmentComboBoxDataSet.FindEmployeeCrewAssignmentComboBox[intSelectedIndex].CrewID; TheFindDetailedEmployeeCrewAssignmentByCrewIDDataSet = TheEmployeeCrewAssignmentClass.FindDetailedEmployeeCrewAssignmentByCrewID(strCrewID, gdatStartDate, gdatEndDate); intNumberOfRecords = TheFindDetailedEmployeeCrewAssignmentByCrewIDDataSet.FindDetailedEmployeeCrewAssignmentByCrewID.Rows.Count - 1; gintEmployeeCounter = TheCompareCrewEmployeesDataSet.employees.Rows.Count; gintEmployeeUpperLimit = gintEmployeeCounter - 1; if (intNumberOfRecords > -1) { for (intCounter = 0; intCounter <= intNumberOfRecords; intCounter++) { intEmployeeID = TheFindDetailedEmployeeCrewAssignmentByCrewIDDataSet.FindDetailedEmployeeCrewAssignmentByCrewID[intCounter].EmployeeID; intProjectID = TheFindDetailedEmployeeCrewAssignmentByCrewIDDataSet.FindDetailedEmployeeCrewAssignmentByCrewID[intCounter].ProjectID; datTransactionDate = TheFindDetailedEmployeeCrewAssignmentByCrewIDDataSet.FindDetailedEmployeeCrewAssignmentByCrewID[intCounter].TransactionDate; TheFindProjectTaskForProductivityReportDataSet = TheProjectTaskClass.FindProjectTaskForProductivityReport(intEmployeeID, intProjectID, datTransactionDate); intSecondNumberOfRecords = TheFindProjectTaskForProductivityReportDataSet.FindProjectTaskForProductivityReport.Rows.Count; for (intSecondCounter = 0; intSecondCounter < intSecondNumberOfRecords; intSecondCounter++) { CompareCrewEmployeesDataSet.employeesRow NewEmployeeRow = TheCompareCrewEmployeesDataSet.employees.NewemployeesRow(); NewEmployeeRow.AssignedProjectID = TheFindDetailedEmployeeCrewAssignmentByCrewIDDataSet.FindDetailedEmployeeCrewAssignmentByCrewID[intCounter].AssignedProjectID; NewEmployeeRow.Date = TheFindDetailedEmployeeCrewAssignmentByCrewIDDataSet.FindDetailedEmployeeCrewAssignmentByCrewID[intCounter].TransactionDate; NewEmployeeRow.FirstName = TheFindDetailedEmployeeCrewAssignmentByCrewIDDataSet.FindDetailedEmployeeCrewAssignmentByCrewID[intCounter].FirstName; NewEmployeeRow.HomeOffice = TheFindDetailedEmployeeCrewAssignmentByCrewIDDataSet.FindDetailedEmployeeCrewAssignmentByCrewID[intCounter].HomeOffice; NewEmployeeRow.LastName = TheFindDetailedEmployeeCrewAssignmentByCrewIDDataSet.FindDetailedEmployeeCrewAssignmentByCrewID[intCounter].LastName; NewEmployeeRow.CrewID = strCrewID; NewEmployeeRow.WorkTask = TheFindProjectTaskForProductivityReportDataSet.FindProjectTaskForProductivityReport[intSecondCounter].WorkTask; NewEmployeeRow.TaskFootage = TheFindProjectTaskForProductivityReportDataSet.FindProjectTaskForProductivityReport[intSecondCounter].FootagePieces; TheCompareCrewEmployeesDataSet.employees.Rows.Add(NewEmployeeRow); gintEmployeeUpperLimit = gintEmployeeCounter; gintEmployeeCounter++; } } } dgrCrews.ItemsSource = TheCompareCrewEmployeesDataSet.employees; } } catch (Exception Ex) { TheEventLogClass.InsertEventLogEntry(DateTime.Now, "New Blue Jay ERP // Compare Crews // Select Crew Combo Box " + Ex.Message); TheMessagesClass.ErrorMessage(Ex.ToString()); } }