public FindProjectProductivityByDateRangeDataSet FindProjectProductivityByDateRange(DateTime datStartDate, DateTime datEndDate) { try { aFindProjectProductivityByDateRangeDataSet = new FindProjectProductivityByDateRangeDataSet(); aFindProjectProductivityByDateRangeTableAdapter = new FindProjectProductivityByDateRangeDataSetTableAdapters.FindProjectProductivityTotalsByDateRangeTableAdapter(); aFindProjectProductivityByDateRangeTableAdapter.Fill(aFindProjectProductivityByDateRangeDataSet.FindProjectProductivityTotalsByDateRange, datStartDate, datEndDate); } catch (Exception Ex) { TheEventLogClass.InsertEventLogEntry(DateTime.Now, "Project Productivity Reports Class // Find Project Productivity By Date Range " + Ex.Message); } return(aFindProjectProductivityByDateRangeDataSet); }
private void btnSearch_Click(object sender, RoutedEventArgs e) { int intCounter; int intSecondCounter; int intNumberForRecords; int intSecondNumberForRecords; string strValueForValidation; bool blnFatalError = false; bool blnThereIsAProblem = false; DateTime datStartDate = DateTime.Now; DateTime datEndDate = DateTime.Now; string strFirstProject = ""; string strSecondProject = ""; string strErrorMessage = ""; bool blnItemFound; string strProjectID; string strProjectName; decimal decTotalHours; try { //clearing the dataset TheProjectProductivityReportDataSet.projectproductivityreport.Rows.Clear(); //beginning data validation strValueForValidation = txtStartDate.Text; blnThereIsAProblem = TheDataValidationClass.VerifyDateData(strValueForValidation); if (blnThereIsAProblem == true) { blnFatalError = true; strErrorMessage += "The Start Date is not a Date\n"; } else { datStartDate = 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 { datEndDate = Convert.ToDateTime(strValueForValidation); } if (gblnAllProjects == false) { strFirstProject = txtFirstProject.Text; if (strFirstProject == "") { blnFatalError = true; strErrorMessage += "The First Project ID is not Entered\n"; } strSecondProject = txtSecondProject.Text; if (strSecondProject == "") { blnFatalError = true; strErrorMessage += "The Second Project ID is not Entered\n"; } } if (blnFatalError == true) { TheMessagesClass.ErrorMessage(strErrorMessage); return; } else { blnFatalError = TheDataValidationClass.verifyDateRange(datStartDate, datEndDate); if (blnFatalError == true) { TheMessagesClass.ErrorMessage("The Start Date is after the End Date"); return; } } if (gblnAllProjects == true) { TheFindProjectProductivityByDateRangeDataSet = TheProjectProductivityReportsClass.FindProjectProductivityByDateRange(datStartDate, datEndDate); intNumberForRecords = TheFindProjectProductivityByDateRangeDataSet.FindProjectProductivityTotalsByDateRange.Rows.Count - 1; if (intNumberForRecords > -1) { for (intCounter = 0; intCounter <= intNumberForRecords; intCounter++) { ProjectProductivityReportDataSet.projectproductivityreportRow NewProjectRow = TheProjectProductivityReportDataSet.projectproductivityreport.NewprojectproductivityreportRow(); NewProjectRow.AssignedProjectID = TheFindProjectProductivityByDateRangeDataSet.FindProjectProductivityTotalsByDateRange[intCounter].AssignedProjectID; NewProjectRow.ProjectName = TheFindProjectProductivityByDateRangeDataSet.FindProjectProductivityTotalsByDateRange[intCounter].ProjectName; NewProjectRow.TotalHours = TheFindProjectProductivityByDateRangeDataSet.FindProjectProductivityTotalsByDateRange[intCounter].TotalHours; TheProjectProductivityReportDataSet.projectproductivityreport.Rows.Add(NewProjectRow); } } //adding design productivity TheFindDesignProjectProductivityByDateRangeDataSet = TheProjectProductivityReportsClass.FindDesignProjectProductivityByDateRange(datStartDate, datEndDate); intNumberForRecords = TheFindDesignProjectProductivityByDateRangeDataSet.FindDesignProjectProductivityByDateRange.Rows.Count - 1; intSecondNumberForRecords = TheProjectProductivityReportDataSet.projectproductivityreport.Rows.Count - 1; if (intNumberForRecords > -1) { for (intCounter = 0; intCounter <= intNumberForRecords; intCounter++) { blnItemFound = false; strProjectID = TheFindDesignProjectProductivityByDateRangeDataSet.FindDesignProjectProductivityByDateRange[intCounter].AssignedProjectID; strProjectName = TheFindDesignProjectProductivityByDateRangeDataSet.FindDesignProjectProductivityByDateRange[intCounter].ProjectName; decTotalHours = TheFindDesignProjectProductivityByDateRangeDataSet.FindDesignProjectProductivityByDateRange[intCounter].TotalHours; if (intSecondNumberForRecords > -1) { for (intSecondCounter = 0; intSecondCounter <= intSecondNumberForRecords; intSecondCounter++) { if (strProjectID == TheProjectProductivityReportDataSet.projectproductivityreport[intSecondCounter].AssignedProjectID) { TheProjectProductivityReportDataSet.projectproductivityreport[intSecondCounter].TotalHours += decTotalHours; blnItemFound = true; } } } if (blnItemFound == false) { ProjectProductivityReportDataSet.projectproductivityreportRow NewProjectRow = TheProjectProductivityReportDataSet.projectproductivityreport.NewprojectproductivityreportRow(); NewProjectRow.AssignedProjectID = strProjectID; NewProjectRow.ProjectName = strProjectName; NewProjectRow.TotalHours = decTotalHours; TheProjectProductivityReportDataSet.projectproductivityreport.Rows.Add(NewProjectRow); } } } } else if (gblnAllProjects == false) { TheFindPrivateProjectProductivityDateRangeDataSet = TheProjectProductivityReportsClass.FindPrivateProjectProductivityDateRange(strFirstProject, strSecondProject, datStartDate, datEndDate); intNumberForRecords = TheFindPrivateProjectProductivityDateRangeDataSet.FindPrivateProjectProductivityDateRange.Rows.Count - 1; if (intNumberForRecords > -1) { for (intCounter = 0; intCounter <= intNumberForRecords; intCounter++) { ProjectProductivityReportDataSet.projectproductivityreportRow NewProjectRow = TheProjectProductivityReportDataSet.projectproductivityreport.NewprojectproductivityreportRow(); NewProjectRow.AssignedProjectID = TheFindPrivateProjectProductivityDateRangeDataSet.FindPrivateProjectProductivityDateRange[intCounter].AssignedProjectID; NewProjectRow.ProjectName = TheFindPrivateProjectProductivityDateRangeDataSet.FindPrivateProjectProductivityDateRange[intCounter].ProjectName; NewProjectRow.TotalHours = TheFindPrivateProjectProductivityDateRangeDataSet.FindPrivateProjectProductivityDateRange[intCounter].TotalHours; TheProjectProductivityReportDataSet.projectproductivityreport.Rows.Add(NewProjectRow); } } //adding design productivity TheFindDesignPrivateProjectProductivityDateRangeDataSet = TheProjectProductivityReportsClass.FindDesignPrivateProjectProductivityDateRange(strFirstProject, strSecondProject, datStartDate, datEndDate); intNumberForRecords = TheFindDesignPrivateProjectProductivityDateRangeDataSet.FindDesignPrivateProjectProductivityDateRange.Rows.Count - 1; intSecondNumberForRecords = TheProjectProductivityReportDataSet.projectproductivityreport.Rows.Count - 1; if (intNumberForRecords > -1) { for (intCounter = 0; intCounter <= intNumberForRecords; intCounter++) { blnItemFound = false; strProjectID = TheFindDesignPrivateProjectProductivityDateRangeDataSet.FindDesignPrivateProjectProductivityDateRange[intCounter].AssignedProjectID; strProjectName = TheFindDesignPrivateProjectProductivityDateRangeDataSet.FindDesignPrivateProjectProductivityDateRange[intCounter].ProjectName; decTotalHours = TheFindDesignPrivateProjectProductivityDateRangeDataSet.FindDesignPrivateProjectProductivityDateRange[intCounter].TotalHours; if (intSecondNumberForRecords > -1) { for (intSecondCounter = 0; intSecondCounter <= intSecondNumberForRecords; intSecondCounter++) { if (strProjectID == TheProjectProductivityReportDataSet.projectproductivityreport[intSecondCounter].AssignedProjectID) { TheProjectProductivityReportDataSet.projectproductivityreport[intSecondCounter].TotalHours += decTotalHours; blnItemFound = true; } } } if (blnItemFound == false) { ProjectProductivityReportDataSet.projectproductivityreportRow NewProjectRow = TheProjectProductivityReportDataSet.projectproductivityreport.NewprojectproductivityreportRow(); NewProjectRow.AssignedProjectID = strProjectID; NewProjectRow.ProjectName = strProjectName; NewProjectRow.TotalHours = decTotalHours; TheProjectProductivityReportDataSet.projectproductivityreport.Rows.Add(NewProjectRow); } } } } dgrResults.ItemsSource = TheProjectProductivityReportDataSet.projectproductivityreport; } catch (Exception Ex) { TheEventLogClass.InsertEventLogEntry(DateTime.Now, "New Blue Jay ERP // Project Productivity Report // Search Button " + Ex.Message); TheMessagesClass.ErrorMessage(Ex.ToString()); } }