public FindSortedManagersHourlyEmployeesDataSet FindSortedManagersHourlyEmployees(int intManagerID) { try { aFindSortedManagersHourlyEmployeesDataSet = new FindSortedManagersHourlyEmployeesDataSet(); aFindSortedManagersHourlyEmployeesTableAdapter = new FindSortedManagersHourlyEmployeesDataSetTableAdapters.FindSortedManagersHourlyEmployeesTableAdapter(); aFindSortedManagersHourlyEmployeesTableAdapter.Fill(aFindSortedManagersHourlyEmployeesDataSet.FindSortedManagersHourlyEmployees, intManagerID); } catch (Exception Ex) { TheEventLogClass.InsertEventLogEntry(DateTime.Now, "Employee Class // Find Sorted Managers Hourly Employees " + Ex.Message); } return(aFindSortedManagersHourlyEmployeesDataSet); }
private void cboSelectManager_SelectionChanged(object sender, SelectionChangedEventArgs e) { int intSelectedIndex; bool blnFatalError = false; bool blnThereIsAProblem = false; string strErrorMessage = ""; string strValueForValidation; DateTime datTransactionDate; DateTime datLimitingDate; string strFirstName; string strLastName; decimal decProductivityHours; double douPunchedHours; decimal decLaborRate; decimal decPunchedHours; int intEmployeeID; int intCounter; int intNumberOfRecords; int intRecordsReturned; decimal decStraightHours = 0; decimal decOverTimeHours = 0; decimal decStraightCost = 0; decimal decOverTimeCosts = 0; decimal decOverTimeRate = 0; double douTotalLaborCost = 0; decimal decHourVariance = 0; try { intSelectedIndex = cboSelectManager.SelectedIndex - 1; TheEmployeePunchesProductivityDataSet.employeepunchesproductivity.Rows.Clear(); if (intSelectedIndex > -1) { strValueForValidation = txtStartDate.Text; blnThereIsAProblem = TheDataValidationClass.VerifyDateData(strValueForValidation); if (blnThereIsAProblem == true) { blnFatalError = true; strErrorMessage += "The Start Date is not a Date\n"; } else { gdatStartDate = Convert.ToDateTime(strValueForValidation); } strValueForValidation = txtEndDate.Text; blnThereIsAProblem = TheDataValidationClass.VerifyDateData(strValueForValidation); if (blnThereIsAProblem == true) { blnFatalError = true; strErrorMessage += "The End Date is not a Date\n"; } else { gdatEndDate = Convert.ToDateTime(strValueForValidation); } if (blnFatalError == true) { TheMessagesClass.ErrorMessage(strErrorMessage); return; } else { blnFatalError = TheDataValidationClass.verifyDateRange(gdatStartDate, gdatEndDate); if (blnFatalError == true) { TheMessagesClass.ErrorMessage("The Start Date is after the End Date"); return; } } gintManagerID = TheFindProductionManagersDataSet.FindProductionManagers[intSelectedIndex].EmployeeID; TheFindSortedManagerHourlyemployeesDataSet = TheEmployeeClass.FindSortedManagersHourlyEmployees(gintManagerID); intNumberOfRecords = TheFindSortedManagerHourlyemployeesDataSet.FindSortedManagersHourlyEmployees.Rows.Count - 1; datTransactionDate = gdatStartDate; datLimitingDate = TheDateSearchClass.AddingDays(datTransactionDate, 1); datLimitingDate = datLimitingDate.AddSeconds(-1); while (datLimitingDate <= gdatEndDate) { for (intCounter = 0; intCounter <= intNumberOfRecords; intCounter++) { intEmployeeID = TheFindSortedManagerHourlyemployeesDataSet.FindSortedManagersHourlyEmployees[intCounter].EmployeeID; TheFindEmployeeProductionHoursOverPayPeriodDataSet = TheEmployeeProjectAssignmentClass.FindEmployeeProductionHoursOverPayPeriodDataSet(intEmployeeID, datTransactionDate, datTransactionDate); intRecordsReturned = TheFindEmployeeProductionHoursOverPayPeriodDataSet.FindEmployeeProductionHoursOverPayPeriod.Rows.Count; if (intRecordsReturned < 1) { decProductivityHours = 0; } else { decProductivityHours = TheFindEmployeeProductionHoursOverPayPeriodDataSet.FindEmployeeProductionHoursOverPayPeriod[0].ProductionHours; } TheFindAlohaEmployeeHoursOverDateRangeDataSet = TheEmployeePunchedHoursClass.FindAlohaEmployeeHoursOverDateRange(intEmployeeID, datTransactionDate, datLimitingDate); intRecordsReturned = TheFindAlohaEmployeeHoursOverDateRangeDataSet.FindAlohaEmployeeHoursOverDateRange.Rows.Count; if (intRecordsReturned > 0) { decPunchedHours = TheFindAlohaEmployeeHoursOverDateRangeDataSet.FindAlohaEmployeeHoursOverDateRange[0].TotalHours; if (decPunchedHours > 8) { decStraightHours = 8; decOverTimeHours = decPunchedHours - 8; } else { decStraightHours = decPunchedHours; decOverTimeHours = 0; } TheFindEmployeeLaborRateDataSet = TheEmployeeLaborRateClass.FindEmployeeLaborRate(intEmployeeID); decLaborRate = TheFindEmployeeLaborRateDataSet.FindEmployeeLaborRate[0].PayRate; decStraightCost = decStraightHours * decLaborRate; decOverTimeRate = decLaborRate * Convert.ToDecimal(1.5); decOverTimeCosts = decOverTimeHours * decOverTimeRate; strFirstName = TheFindSortedManagerHourlyemployeesDataSet.FindSortedManagersHourlyEmployees[intCounter].FirstName; strLastName = TheFindSortedManagerHourlyemployeesDataSet.FindSortedManagersHourlyEmployees[intCounter].LastName; douTotalLaborCost = Math.Round(Convert.ToDouble(decStraightCost + decOverTimeCosts), 2); if (decPunchedHours != 0) { decHourVariance = decProductivityHours - decPunchedHours; EmployeePunchesProductivityDataSet.employeepunchesproductivityRow NewProductivityRow = TheEmployeePunchesProductivityDataSet.employeepunchesproductivity.NewemployeepunchesproductivityRow(); NewProductivityRow.Date = datTransactionDate; NewProductivityRow.FirstName = strFirstName; NewProductivityRow.LastName = strLastName; NewProductivityRow.TotalLaborCost = Convert.ToDecimal(douTotalLaborCost); NewProductivityRow.HoursProductive = decProductivityHours; NewProductivityRow.HoursPunched = decPunchedHours; NewProductivityRow.HourVariance = decHourVariance; TheEmployeePunchesProductivityDataSet.employeepunchesproductivity.Rows.Add(NewProductivityRow); } } } datTransactionDate = datLimitingDate.AddSeconds(1); datLimitingDate = TheDateSearchClass.AddingDays(datLimitingDate, 1); } dgrResults.ItemsSource = TheEmployeePunchesProductivityDataSet.employeepunchesproductivity; } } catch (Exception Ex) { TheEventLogClass.InsertEventLogEntry(DateTime.Now, "New Blue Jay ERP // Manager Hourly Daily Report // Manager Selection " + Ex.Message); TheMessagesClass.ErrorMessage(Ex.ToString()); } }