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 cboSelectCrew_SelectionChanged(object sender, SelectionChangedEventArgs e)
{
int intSelectedIndex;
int intCounter;
int intNumberOfRecords;
int intEmployeeID;
int intProjectID;
if (gblnLoadComplete == true)
{
PleaseWait PleaseWait = new PleaseWait();
PleaseWait.Show();
try
{
intSelectedIndex = cboSelectCrew.SelectedIndex;
gdecTotalHours = 0;
TheCrewHoursDataSet.crewhours.Rows.Clear();
if (gblnLoadComplete == true)
{
gstrCrewID = cboSelectCrew.SelectedItem.ToString();
TheFindEmployeeCrewByCrewIDDataSet = TheEmployeeCrewAssignmentClass.FindEmployeeCrewByCrewID(gstrCrewID, gdatStartDate, gdatEndDate);
intNumberOfRecords = TheFindEmployeeCrewByCrewIDDataSet.FindEmployeeCrewByCrewID.Rows.Count - 1;
if (intNumberOfRecords == -1)
{
TheMessagesClass.ErrorMessage("There is a Problem with Crew Assignments");
PleaseWait.Close();
return;
}
for (intCounter = 0; intCounter <= intNumberOfRecords; intCounter++)
{
intEmployeeID = TheFindEmployeeCrewByCrewIDDataSet.FindEmployeeCrewByCrewID[intCounter].EmployeeID;
intProjectID = TheFindEmployeeCrewByCrewIDDataSet.FindEmployeeCrewByCrewID[intCounter].ProjectID;
TheFindEmployeeProjectHourDateRangeSummaryDataSet = TheEmployeeProductiivityStatsClass.FindEmployeeProjectHourDateRangeSummary(intEmployeeID, intProjectID, gdatStartDate, gdatEndDate);
CrewHoursDataSet.crewhoursRow NewHoursRow = TheCrewHoursDataSet.crewhours.NewcrewhoursRow();
NewHoursRow.AssignedProjectID = TheFindEmployeeProjectHourDateRangeSummaryDataSet.FindEmployeeProjectHourDateRangeSummary[0].AssignedProjectID;
NewHoursRow.FirstName = TheFindEmployeeProjectHourDateRangeSummaryDataSet.FindEmployeeProjectHourDateRangeSummary[0].FirstName;
NewHoursRow.LastName = TheFindEmployeeProjectHourDateRangeSummaryDataSet.FindEmployeeProjectHourDateRangeSummary[0].LastName;
NewHoursRow.ProjectName = TheFindEmployeeProjectHourDateRangeSummaryDataSet.FindEmployeeProjectHourDateRangeSummary[0].ProjectName;
NewHoursRow.Hours = TheFindEmployeeProjectHourDateRangeSummaryDataSet.FindEmployeeProjectHourDateRangeSummary[0].TotalHours;
gdecTotalHours += TheFindEmployeeProjectHourDateRangeSummaryDataSet.FindEmployeeProjectHourDateRangeSummary[0].TotalHours;
NewHoursRow.HomeOffice = TheFindEmployeeProjectHourDateRangeSummaryDataSet.FindEmployeeProjectHourDateRangeSummary[0].HomeOffice;
TheCrewHoursDataSet.crewhours.Rows.Add(NewHoursRow);
}
dgrResults.ItemsSource = TheCrewHoursDataSet.crewhours;
txtTotalHours.Text = Convert.ToString(gdecTotalHours);
}
}
catch (Exception Ex)
{
TheEventLogClass.InsertEventLogEntry(DateTime.Now, "Blue Jay ERP // Find Employee Crew Assignments // Combo Box Change Event " + Ex.Message);
TheMessagesClass.ErrorMessage(Ex.ToString());
}
PleaseWait.Close();
}
}
