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