public FindDesignEmployeeWOVCountDataSet FindDesignEmployeeWOVCount(int intEmployeeID, DateTime datStartDate, DateTime dateEndDate) { try { aFindDesignEmployeeWOVCountDataSet = new FindDesignEmployeeWOVCountDataSet(); aFindDesignEmployeeWOVCountTableAdapter = new FindDesignEmployeeWOVCountDataSetTableAdapters.FindDesignEmployeeWOVCountTableAdapter(); aFindDesignEmployeeWOVCountTableAdapter.Fill(aFindDesignEmployeeWOVCountDataSet.FindDesignEmployeeWOVCount, intEmployeeID, datStartDate, dateEndDate); } catch (Exception Ex) { TheEventLogClass.InsertEventLogEntry(DateTime.Now, "Design Projects Surveyor Class // Find Design Employee WOV Count " + Ex.Message); } return(aFindDesignEmployeeWOVCountDataSet); }
private void MitGenerateReport_Click(object sender, RoutedEventArgs e) { //setting local variables string strValueForValidation; bool blnFatalError = false; bool blnThereIsAProblem = false; string strErrorMessage = ""; int intCounter; int intNumberOfRecords; int intEmployeeID; int intRecordsReturned; decimal decTotalHours = 0; try { TheDesignDepartmentProductivityDataSet.designdepartmentproductivity.Rows.Clear(); TheDesignEmployeeProductivityDataSet.designemployeeproductivity.Rows.Clear(); 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 ((gstrReportType == "EMPLOYEE") || (gstrReportType == "WOV")) { if (cboSelectEmployee.SelectedIndex < 1) { blnFatalError = true; strErrorMessage += "The Employee Was Not Selected\n"; } } if (blnFatalError == true) { TheMessagesClass.ErrorMessage(strErrorMessage); return; } if (gstrReportType == "DEPARTMENT") { TheFindDesignTotalDepartmentProductivityDataSet = TheDesignProductivityClass.FindDesignTotalDepartmentProductivity(gdatStartDate, gdatEndDate); intNumberOfRecords = TheFindDesignTotalDepartmentProductivityDataSet.FindDesignTotalDepartmentProductivity.Rows.Count - 1; if (intNumberOfRecords > -1) { for (intCounter = 0; intCounter <= intNumberOfRecords; intCounter++) { decTotalHours = 0; intEmployeeID = TheFindDesignTotalDepartmentProductivityDataSet.FindDesignTotalDepartmentProductivity[intCounter].EmployeeID; TheFindEmployeeProductionHoursOverPayPeriodDataSet = TheEmployeeProjectAssignmentClass.FindEmployeeProductionHoursOverPayPeriodDataSet(intEmployeeID, gdatStartDate, gdatEndDate); intRecordsReturned = TheFindEmployeeProductionHoursOverPayPeriodDataSet.FindEmployeeProductionHoursOverPayPeriod.Rows.Count; if (intRecordsReturned > 0) { decTotalHours = TheFindEmployeeProductionHoursOverPayPeriodDataSet.FindEmployeeProductionHoursOverPayPeriod[0].ProductionHours; } decTotalHours += TheFindDesignTotalDepartmentProductivityDataSet.FindDesignTotalDepartmentProductivity[intCounter].TotalHours; DesignDepartmentProductivityDataSet.designdepartmentproductivityRow NewProductivityRow = TheDesignDepartmentProductivityDataSet.designdepartmentproductivity.NewdesigndepartmentproductivityRow(); NewProductivityRow.FirstName = TheFindDesignTotalDepartmentProductivityDataSet.FindDesignTotalDepartmentProductivity[intCounter].FirstName; NewProductivityRow.LastName = TheFindDesignTotalDepartmentProductivityDataSet.FindDesignTotalDepartmentProductivity[intCounter].LastName; NewProductivityRow.HomeOffice = TheFindDesignTotalDepartmentProductivityDataSet.FindDesignTotalDepartmentProductivity[intCounter].HomeOffice; NewProductivityRow.TotalHours = decTotalHours; TheDesignDepartmentProductivityDataSet.designdepartmentproductivity.Rows.Add(NewProductivityRow); } } dgrResults.ItemsSource = TheDesignDepartmentProductivityDataSet.designdepartmentproductivity; gblnDepartment = true; } else if (gstrReportType == "EMPLOYEE") { TheFindDesignEmployeeTotalHoursDataSet = TheDesignProductivityClass.FindDesignEmployeeTotalHours(MainWindow.gintEmployeeID, gdatStartDate, gdatEndDate); intNumberOfRecords = TheFindDesignEmployeeTotalHoursDataSet.FindDesignEmployeeTotalHours.Rows.Count - 1; if (intNumberOfRecords > -1) { for (intCounter = 0; intCounter <= intNumberOfRecords; intCounter++) { for (intCounter = 0; intCounter <= intNumberOfRecords; intCounter++) { DesignEmployeeProductivityDataSet.designemployeeproductivityRow NewProductivityRow = TheDesignEmployeeProductivityDataSet.designemployeeproductivity.NewdesignemployeeproductivityRow(); NewProductivityRow.AssignedProjectID = TheFindDesignEmployeeTotalHoursDataSet.FindDesignEmployeeTotalHours[intCounter].AssignedProjectID; NewProductivityRow.ProjectName = TheFindDesignEmployeeTotalHoursDataSet.FindDesignEmployeeTotalHours[intCounter].ProjectName; NewProductivityRow.TaskID = TheFindDesignEmployeeTotalHoursDataSet.FindDesignEmployeeTotalHours[intCounter].TaskID; NewProductivityRow.TotalHours = TheFindDesignEmployeeTotalHoursDataSet.FindDesignEmployeeTotalHours[intCounter].TotalHours; NewProductivityRow.WorkTask = TheFindDesignEmployeeTotalHoursDataSet.FindDesignEmployeeTotalHours[intCounter].WorkTask; TheDesignEmployeeProductivityDataSet.designemployeeproductivity.Rows.Add(NewProductivityRow); } } } TheFindEmployeeTaskTotalHoursDataSet = TheEmployeeProjectAssignmentClass.FindEmployeeTaskTotalHours(MainWindow.gintEmployeeID, gdatStartDate, gdatEndDate); intNumberOfRecords = TheFindEmployeeTaskTotalHoursDataSet.FindEmployeeTaskTotalHours.Rows.Count - 1; if (intNumberOfRecords > -1) { for (intCounter = 0; intCounter <= intNumberOfRecords; intCounter++) { DesignEmployeeProductivityDataSet.designemployeeproductivityRow NewProductivityRow = TheDesignEmployeeProductivityDataSet.designemployeeproductivity.NewdesignemployeeproductivityRow(); NewProductivityRow.AssignedProjectID = TheFindEmployeeTaskTotalHoursDataSet.FindEmployeeTaskTotalHours[intCounter].AssignedProjectID; NewProductivityRow.ProjectName = TheFindEmployeeTaskTotalHoursDataSet.FindEmployeeTaskTotalHours[intCounter].ProjectName; NewProductivityRow.TaskID = TheFindEmployeeTaskTotalHoursDataSet.FindEmployeeTaskTotalHours[intCounter].TaskID; NewProductivityRow.TotalHours = TheFindEmployeeTaskTotalHoursDataSet.FindEmployeeTaskTotalHours[intCounter].TotalHours; NewProductivityRow.WorkTask = TheFindEmployeeTaskTotalHoursDataSet.FindEmployeeTaskTotalHours[intCounter].WorkTask; TheDesignEmployeeProductivityDataSet.designemployeeproductivity.Rows.Add(NewProductivityRow); } } dgrResults.ItemsSource = TheDesignEmployeeProductivityDataSet.designemployeeproductivity; } else if (gstrReportType == "WOV") { TheFindDesignEmployeeWOVCountDataSet = TheDesignProjectsSurveyorClass.FindDesignEmployeeWOVCount(MainWindow.gintEmployeeID, gdatStartDate, gdatEndDate); dgrResults.ItemsSource = TheFindDesignEmployeeWOVCountDataSet.FindDesignEmployeeWOVCount; } else if (gstrReportType == "DEPARTMENTWOV") { TheFindDesignDepartmentWOVCountDataSet = TheDesignProjectsSurveyorClass.FindDesignDepartmentWOVCount(gdatStartDate, gdatEndDate); dgrResults.ItemsSource = TheFindDesignDepartmentWOVCountDataSet.FindDesignDepartmentWOVCount; } } catch (Exception Ex) { TheEventLogClass.InsertEventLogEntry(DateTime.Now, "Blue Jay ERP // Design Employee Productivity // Generate Report Button " + Ex.Message); TheMessagesClass.ErrorMessage(Ex.ToString()); } }