private void cboSelectCrew_SelectionChanged(object sender, SelectionChangedEventArgs e)
{
//setting local variables
int intSelectedIndex;
int intCounter;
int intNumberOfRecords;
int intTaskCounter;
bool blnItemFound;
string strProjectID;
string strWorkTask;
int intEmployeeID;
int intProjectID;
int intSecondCounter;
int intSecondNumberOfRecords;
try
{
intSelectedIndex = cboSelectCrew.SelectedIndex;
TheCrewSummaryDataSet.crewsummary.Rows.Clear();
gdecTotalHours = 0;
if (intSelectedIndex > 0)
{
gstrCrewID = cboSelectCrew.SelectedItem.ToString();
TheFindEmployeeCrewByCrewIDDataSet = TheEmployeeCrewAssignmentClass.FindEmployeeCrewByCrewID(gstrCrewID, gdatStartDate, gdatEndDate);
intNumberOfRecords = TheFindEmployeeCrewByCrewIDDataSet.FindEmployeeCrewByCrewID.Rows.Count - 1;
gintTaskCounter = 0;
gintTaskUpperLimit = 0;
if (intNumberOfRecords > -1)
{
for (intCounter = 0; intCounter <= intNumberOfRecords; intCounter++)
{
intEmployeeID = TheFindEmployeeCrewByCrewIDDataSet.FindEmployeeCrewByCrewID[intCounter].EmployeeID;
intProjectID = TheFindEmployeeCrewByCrewIDDataSet.FindEmployeeCrewByCrewID[intCounter].ProjectID;
TheFindEmployeeProjectHourDateRangeSummaryDataSet = TheEmployeeProductivityStatsClass.FindEmployeeProjectHourDateRangeSummary(intEmployeeID, intProjectID, gdatStartDate, gdatEndDate);
gdecTotalHours += TheFindEmployeeProjectHourDateRangeSummaryDataSet.FindEmployeeProjectHourDateRangeSummary[0].TotalHours;
TheFindProjectTaskEmployeeStatsDataSet = TheEmployeeProductivityStatsClass.FindProjectTaskEmployeeStats(intEmployeeID, intProjectID, gdatStartDate, gdatEndDate);
intSecondNumberOfRecords = TheFindProjectTaskEmployeeStatsDataSet.FindProjectTaskEmployeeStats.Rows.Count - 1;
for (intSecondCounter = 0; intSecondCounter <= intSecondNumberOfRecords; intSecondCounter++)
{
blnItemFound = false;
strProjectID = TheFindProjectTaskEmployeeStatsDataSet.FindProjectTaskEmployeeStats[intSecondCounter].AssignedProjectID;
strWorkTask = TheFindProjectTaskEmployeeStatsDataSet.FindProjectTaskEmployeeStats[intSecondCounter].WorkTask;
if (gintTaskCounter > 0)
{
for (intTaskCounter = 0; intTaskCounter <= gintTaskUpperLimit; intTaskCounter++)
{
if (strProjectID == TheCrewSummaryDataSet.crewsummary[intTaskCounter].AssignedProjectID)
{
if (strWorkTask == TheCrewSummaryDataSet.crewsummary[intTaskCounter].WorkTask)
{
blnItemFound = true;
}
}
}
}
if (blnItemFound == false)
{
CrewSummaryDataSet.crewsummaryRow NewCrewRow = TheCrewSummaryDataSet.crewsummary.NewcrewsummaryRow();
NewCrewRow.AssignedProjectID = strProjectID;
NewCrewRow.CrewID = gstrCrewID;
NewCrewRow.FootagePieces = TheFindProjectTaskEmployeeStatsDataSet.FindProjectTaskEmployeeStats[intSecondCounter].FootagePieces;
NewCrewRow.HomeOffice = TheFindProjectTaskEmployeeStatsDataSet.FindProjectTaskEmployeeStats[intSecondCounter].HomeOffice;
NewCrewRow.WorkTask = strWorkTask;
TheCrewSummaryDataSet.crewsummary.Rows.Add(NewCrewRow);
gintTaskUpperLimit = gintTaskCounter;
gintTaskCounter++;
}
}
}
}
dgrResults.ItemsSource = TheCrewSummaryDataSet.crewsummary;
txtTotalHours.Text = Convert.ToString(gdecTotalHours);
}
}
catch (Exception Ex)
{
TheEventLogClass.InsertEventLogEntry(DateTime.Now, "Blue Jay ERP // Employee Crew Summary // Select Crew Combo Box " + Ex.Message);
TheMessagesClass.ErrorMessage(Ex.Message);
}
}
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();
}
