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