public FindEmployeeTaskHoursByEmployeeIDDataSet FindEmployeeTaskHoursByEmployeeID(int intEmployeeID, DateTime datStartDate, DateTime datEndDate)
{
try
{
aFindEmployeeTaskHoursByEmployeeIDDataSet = new FindEmployeeTaskHoursByEmployeeIDDataSet();
aFindEmployeeTaskHoursByEmployeeIDTableAdapter = new FindEmployeeTaskHoursByEmployeeIDDataSetTableAdapters.FindEmployeeTaskHoursByEmployeeIDTableAdapter();
aFindEmployeeTaskHoursByEmployeeIDTableAdapter.Fill(aFindEmployeeTaskHoursByEmployeeIDDataSet.FindEmployeeTaskHoursByEmployeeID, intEmployeeID, datStartDate, datEndDate);
}
catch (Exception Ex)
{
TheEventLogClass.InsertEventLogEntry(DateTime.Now, "Employee Project Assignment Class // Find Employee Task Hours By Employee ID " + Ex.Message);
}
return(aFindEmployeeTaskHoursByEmployeeIDDataSet);
}
private void Window_Loaded(object sender, RoutedEventArgs e)
{
//setting local variables
int intCounter;
int intNumberOfRecords;
int intProjectID = 0;
int intTaskID = 0;
decimal decTotalFootage = 0;
string strWorkTask = "";
string strAssignedProjectID = "";
bool blnItemFound;
int intSummaryCounter;
decimal decHours;
int intSecondCounter;
int intSecondNumberOfRecords;
PleaseWait PleaseWait = new PleaseWait();
PleaseWait.Show();
gdecTotalHours = 0;
try
{
TheFindEmployeeByEmployeeIDDataSet = TheEmployeeClass.FindEmployeeByEmployeeID(MainWindow.gintEmployeeID);
MainWindow.gstrFirstName = TheFindEmployeeByEmployeeIDDataSet.FindEmployeeByEmployeeID[0].FirstName;
MainWindow.gstrLastName = TheFindEmployeeByEmployeeIDDataSet.FindEmployeeByEmployeeID[0].LastName;
TheFindEmployeeTaskHoursByEmployeeIDDataSet = TheEmployeeProjectAssignmentClass.FindEmployeeTaskHoursByEmployeeID(MainWindow.gintEmployeeID, MainWindow.gdatStartDate, MainWindow.gdatEndDate);
intNumberOfRecords = TheFindEmployeeTaskHoursByEmployeeIDDataSet.FindEmployeeTaskHoursByEmployeeID.Rows.Count - 1;
gintSummaryCounter = 0;
gintSummaryNumberOfRecords = 0;
for (intCounter = 0; intCounter <= intNumberOfRecords; intCounter++)
{
gdecTotalHours += TheFindEmployeeTaskHoursByEmployeeIDDataSet.FindEmployeeTaskHoursByEmployeeID[intCounter].EmployeeTotalHours;
intProjectID = TheFindEmployeeTaskHoursByEmployeeIDDataSet.FindEmployeeTaskHoursByEmployeeID[intCounter].ProjectID;
intTaskID = TheFindEmployeeTaskHoursByEmployeeIDDataSet.FindEmployeeTaskHoursByEmployeeID[intCounter].TaskID;
decHours = TheFindEmployeeTaskHoursByEmployeeIDDataSet.FindEmployeeTaskHoursByEmployeeID[intCounter].EmployeeTotalHours;
blnItemFound = false;
TheFindProjectByProjectIDDataSet = TheProjectClass.FindProjectByProjectID(intProjectID);
strAssignedProjectID = TheFindProjectByProjectIDDataSet.FindProjectByProjectID[0].AssignedProjectID;
TheFindWorkTaskByTaskIDDataSet = TheWorkTaskClass.FindWorkTaskByWorkTaskID(intTaskID);
strWorkTask = TheFindWorkTaskByTaskIDDataSet.FindWorkTaskByWorkTaskID[0].WorkTask;
if (gintSummaryCounter > 0)
{
for (intSummaryCounter = 0; intSummaryCounter <= gintSummaryNumberOfRecords; intSummaryCounter++)
{
if (strAssignedProjectID == TheEmployeeProjectSummaryDataSet.projectsummary[intSummaryCounter].AssignedProjectID)
{
if (strWorkTask == TheEmployeeProjectSummaryDataSet.projectsummary[intSummaryCounter].WorkTask)
{
TheEmployeeProjectSummaryDataSet.projectsummary[intSummaryCounter].TotalHours += decHours;
blnItemFound = true;
}
}
}
}
if (blnItemFound == false)
{
EmployeeProjectSummaryDataSet.projectsummaryRow NewTaskRow = TheEmployeeProjectSummaryDataSet.projectsummary.NewprojectsummaryRow();
NewTaskRow.AssignedProjectID = strAssignedProjectID;
NewTaskRow.TotalFootagePieces = decTotalFootage;
NewTaskRow.TotalHours = decHours;
NewTaskRow.WorkTask = strWorkTask;
NewTaskRow.TaskID = intTaskID;
NewTaskRow.ProjectID = intProjectID;
TheEmployeeProjectSummaryDataSet.projectsummary.Rows.Add(NewTaskRow);
gintSummaryNumberOfRecords = gintSummaryCounter;
gintSummaryCounter++;
}
}
intNumberOfRecords = TheEmployeeProjectSummaryDataSet.projectsummary.Rows.Count - 1;
for (intCounter = 0; intCounter <= intNumberOfRecords; intCounter++)
{
intProjectID = TheEmployeeProjectSummaryDataSet.projectsummary[intCounter].ProjectID;
intTaskID = TheEmployeeProjectSummaryDataSet.projectsummary[intCounter].TaskID;
decTotalFootage = 0;
TheFindProjectTaskEmployeeStatsDataSet = TheEmployeeProductivityStatsClass.FindProjectTaskEmployeeStats(MainWindow.gintEmployeeID, intProjectID, MainWindow.gdatStartDate, MainWindow.gdatEndDate);
intSecondNumberOfRecords = TheFindProjectTaskEmployeeStatsDataSet.FindProjectTaskEmployeeStats.Rows.Count - 1;
if (intSecondNumberOfRecords > -1)
{
for (intSecondCounter = 0; intSecondCounter <= intSecondNumberOfRecords; intSecondCounter++)
{
if (intTaskID == TheFindProjectTaskEmployeeStatsDataSet.FindProjectTaskEmployeeStats[intSecondCounter].WorkTaskID)
{
decTotalFootage += TheFindProjectTaskEmployeeStatsDataSet.FindProjectTaskEmployeeStats[intSecondCounter].FootagePieces;
}
}
}
TheEmployeeProjectSummaryDataSet.projectsummary[intCounter].TotalFootagePieces = decTotalFootage;
}
txtTotalHours.Text = Convert.ToString(gdecTotalHours);
dgrResults.ItemsSource = TheEmployeeProjectSummaryDataSet.projectsummary;
}
catch (Exception Ex)
{
TheEventLogClass.InsertEventLogEntry(DateTime.Now, "Blue Jay ERP // Find Employee Hours // Generate Report Menu Item " + Ex.Message);
TheMessagesClass.ErrorMessage(Ex.ToString());
}
PleaseWait.Close();
}
