public FindProjectHoursDataSet FindProjectHours(int intProjectID, DateTime datStartDate) { try { aFindProjectHoursDataSet = new FindProjectHoursDataSet(); aFindProjectHoursTableAdapter = new FindProjectHoursDataSetTableAdapters.FindProjectHoursTableAdapter(); aFindProjectHoursTableAdapter.Fill(aFindProjectHoursDataSet.FindProjectHours, intProjectID, datStartDate); } catch (Exception Ex) { TheEventLogClass.InsertEventLogEntry(DateTime.Now, "Employee Project Assignment Class // Find Project Hours " + Ex.Message); } return(aFindProjectHoursDataSet); }
private void mitGenerateReport_Click(object sender, RoutedEventArgs e) { //setting local variables string strProjectID; int intRecordsReturned; int intCounter; int intNumberOfRecords; DateTime datTransactionDate; string strWorkTask; int intSecondCounter; int intSecondNumberOfRecords; bool blnItemFound; int intFootage; int intSummaryCounter; decimal decHours; decimal decLaborCosts; DateTime datStartDate = DateTime.Now; PleaseWait PleaseWait = new PleaseWait(); PleaseWait.Show(); try { strProjectID = txtEnterProjectID.Text; TheCompleteProjectInfoDataSet.projectinfo.Rows.Clear(); TheProjectWorkSummaryDataSet.worksummary.Rows.Clear(); gintSummaryCounter = 0; gintSummaryUpperLimit = 0; gdecTotalHours = 0; gdecLaborCosts = 0; TheFindProjectByAssignedProjectIDDataSet = TheProjectClass.FindProjectByAssignedProjectID(strProjectID); intRecordsReturned = TheFindProjectByAssignedProjectIDDataSet.FindProjectByAssignedProjectID.Rows.Count; if (intRecordsReturned == 0) { TheMessagesClass.ErrorMessage("Project Not Found"); return; } MainWindow.gintProjectID = TheFindProjectByAssignedProjectIDDataSet.FindProjectByAssignedProjectID[0].ProjectID; datStartDate = TheDateSearchClass.SubtractingDays(datStartDate, 1500); TheFindProjectHoursDataSet = TheEmployeeProjectAssignmentClass.FindProjectHours(MainWindow.gintProjectID, datStartDate); intNumberOfRecords = TheFindProjectHoursDataSet.FindProjectHours.Rows.Count - 1; intSecondNumberOfRecords = 0; if (intNumberOfRecords > -1) { for (intCounter = 0; intCounter <= intNumberOfRecords; intCounter++) { blnItemFound = false; gdecTotalHours += TheFindProjectHoursDataSet.FindProjectHours[intCounter].TotalHours; gdecLaborCosts += TheFindProjectHoursDataSet.FindProjectHours[intCounter].TotalEmployeeCost; datTransactionDate = TheFindProjectHoursDataSet.FindProjectHours[intCounter].TransactionDate; strWorkTask = TheFindProjectHoursDataSet.FindProjectHours[intCounter].WorkTask; decHours = TheFindProjectHoursDataSet.FindProjectHours[intCounter].TotalHours; decLaborCosts = TheFindProjectHoursDataSet.FindProjectHours[intCounter].TotalEmployeeCost; if (intSecondNumberOfRecords > 0) { for (intSecondCounter = 0; intSecondCounter < intSecondNumberOfRecords; intSecondCounter++) { if (strWorkTask == TheCompleteProjectInfoDataSet.projectinfo[intSecondCounter].WorkTask) { if (datTransactionDate == TheCompleteProjectInfoDataSet.projectinfo[intSecondCounter].TransactionDate) { TheCompleteProjectInfoDataSet.projectinfo[intSecondCounter].Hours += decHours; TheCompleteProjectInfoDataSet.projectinfo[intSecondCounter].LaborCosts += decLaborCosts; blnItemFound = true; } } } } if (blnItemFound == false) { CompleteProjectInfoDataSet.projectinfoRow NewTaskRow = TheCompleteProjectInfoDataSet.projectinfo.NewprojectinfoRow(); NewTaskRow.FootagePieces = 0; NewTaskRow.TransactionDate = datTransactionDate; NewTaskRow.WorkTask = strWorkTask; NewTaskRow.Hours = decHours; NewTaskRow.LaborCosts = decLaborCosts; TheCompleteProjectInfoDataSet.projectinfo.Rows.Add(NewTaskRow); intSecondNumberOfRecords++; } } } intNumberOfRecords = TheCompleteProjectInfoDataSet.projectinfo.Rows.Count - 1; for (intCounter = 0; intCounter <= intNumberOfRecords; intCounter++) { intFootage = 0; strWorkTask = TheCompleteProjectInfoDataSet.projectinfo[intCounter].WorkTask; datTransactionDate = TheCompleteProjectInfoDataSet.projectinfo[intCounter].TransactionDate; TheFindWorkTaskByWorkTaskDataSet = TheWorkTaskClass.FindWorkTaskByWorkTask(strWorkTask); MainWindow.gintWorkTaskID = TheFindWorkTaskByWorkTaskDataSet.FindWorkTaskByWorkTask[0].WorkTaskID; TheFindSpecificProjectWorkTaskDataSet = TheProjectTaskClass.FindSpecificProjectWorkTask(MainWindow.gintProjectID, MainWindow.gintWorkTaskID); intSecondNumberOfRecords = TheFindSpecificProjectWorkTaskDataSet.FindSpecificProjectWorkTask.Rows.Count - 1; for (intSecondCounter = 0; intSecondCounter <= intSecondNumberOfRecords; intSecondCounter++) { if (TheCompleteProjectInfoDataSet.projectinfo[intCounter].FootagePieces == 0) { if (datTransactionDate == TheFindSpecificProjectWorkTaskDataSet.FindSpecificProjectWorkTask[intSecondCounter].TransactionDate) { intFootage = Convert.ToInt32(TheFindSpecificProjectWorkTaskDataSet.FindSpecificProjectWorkTask[intSecondCounter].FootagePieces); TheCompleteProjectInfoDataSet.projectinfo[intCounter].FootagePieces = intFootage; } } } } intNumberOfRecords = TheCompleteProjectInfoDataSet.projectinfo.Rows.Count - 1; for (intCounter = 0; intCounter <= intNumberOfRecords; intCounter++) { blnItemFound = false; strWorkTask = TheCompleteProjectInfoDataSet.projectinfo[intCounter].WorkTask; if (gintSummaryCounter > 0) { for (intSummaryCounter = 0; intSummaryCounter <= gintSummaryUpperLimit; intSummaryCounter++) { if (strWorkTask == TheProjectWorkSummaryDataSet.worksummary[intSummaryCounter].WorkTask) { TheProjectWorkSummaryDataSet.worksummary[intSummaryCounter].FootagePieces += TheCompleteProjectInfoDataSet.projectinfo[intCounter].FootagePieces; TheProjectWorkSummaryDataSet.worksummary[intSummaryCounter].Hours += TheCompleteProjectInfoDataSet.projectinfo[intCounter].Hours; blnItemFound = true; } } } if (blnItemFound == false) { ProjectWorkSummaryDataSet.worksummaryRow NewTaskRow = TheProjectWorkSummaryDataSet.worksummary.NewworksummaryRow(); NewTaskRow.FootagePieces = TheCompleteProjectInfoDataSet.projectinfo[intCounter].FootagePieces; NewTaskRow.WorkTask = strWorkTask; NewTaskRow.Hours = TheCompleteProjectInfoDataSet.projectinfo[intCounter].Hours; NewTaskRow.LaborCosts = TheCompleteProjectInfoDataSet.projectinfo[intCounter].LaborCosts; TheProjectWorkSummaryDataSet.worksummary.Rows.Add(NewTaskRow); gintSummaryUpperLimit = gintSummaryCounter; gintSummaryCounter++; } } dgrResults.ItemsSource = TheProjectWorkSummaryDataSet.worksummary; txtTotalHours.Text = Convert.ToString(gdecTotalHours); txtLaborCosts.Text = Convert.ToString(gdecLaborCosts); PleaseWait.Close(); } catch (Exception Ex) { PleaseWait.Close(); TheEventLogClass.InsertEventLogEntry(DateTime.Now, "Blue Jay ERP // Find Project Hours // Generate Report Menu Item " + Ex.Message); TheMessagesClass.ErrorMessage(Ex.ToString()); } }
private void Window_Loaded(object sender, RoutedEventArgs e) { //setting up the local variables int intCounter; int intNumberOfRecords; int intProjectID; DateTime datTransactionDate = DateTime.Now; try { datTransactionDate = TheDateSearchClass.RemoveTime(datTransactionDate); datTransactionDate = TheDateSearchClass.SubtractingDays(datTransactionDate, 31); TheFindProjectByAssignedProjectIDDataSet = TheProjectClass.FindProjectByAssignedProjectID("SHOP"); intProjectID = TheFindProjectByAssignedProjectIDDataSet.FindProjectByAssignedProjectID[0].ProjectID; TheFindProjectHoursDataSet = TheEmployeeProjectAssignmentClass.FindProjectHours(intProjectID, datTransactionDate); TheFindProjectStatsDataSet = TheEmployeeProductivityStatsClass.FindProjectStats(intProjectID); intNumberOfRecords = TheFindProjectHoursDataSet.FindProjectHours.Rows.Count - 1; gdecMean = TheFindProjectStatsDataSet.FindProjectStats[0].AveHours; gdecStandDeviation = Convert.ToDecimal(TheFindProjectStatsDataSet.FindProjectStats[0].HoursSTDev); gdecVariance = Convert.ToDecimal(TheFindProjectStatsDataSet.FindProjectStats[0].HoursVariance); gdecTotalHours = Convert.ToDecimal(TheFindProjectStatsDataSet.FindProjectStats[0].TotalHours); gdecMean = Math.Round(gdecMean, 4); txtAverageHours.Text = Convert.ToString(gdecMean); gdecVariance = Math.Round(gdecVariance, 4); gdecStandDeviation = Math.Round(gdecStandDeviation, 4); gdecUpperBound = gdecMean + gdecStandDeviation; txtUpperBound.Text = Convert.ToString(gdecUpperBound); for (intCounter = 0; intCounter <= intNumberOfRecords; intCounter++) { if (TheFindProjectHoursDataSet.FindProjectHours[intCounter].TransactionDate > datTransactionDate) { if (TheFindProjectHoursDataSet.FindProjectHours[intCounter].TotalHours > gdecUpperBound) { ShopViolatorDataSet.violatorRow NewViolatorRow = TheShopViolatorDataSet.violator.NewviolatorRow(); NewViolatorRow.FirstName = TheFindProjectHoursDataSet.FindProjectHours[intCounter].FirstName; NewViolatorRow.LastName = TheFindProjectHoursDataSet.FindProjectHours[intCounter].LastName; NewViolatorRow.Hours = TheFindProjectHoursDataSet.FindProjectHours[intCounter].TotalHours; NewViolatorRow.TransactionDate = TheFindProjectHoursDataSet.FindProjectHours[intCounter].TransactionDate; NewViolatorRow.HomeOffice = TheFindProjectHoursDataSet.FindProjectHours[intCounter].HomeOffice; TheShopViolatorDataSet.violator.Rows.Add(NewViolatorRow); } } } dgrResults.ItemsSource = TheShopViolatorDataSet.violator; gdecProjectHours = gdecMean * 5 * 52; txtProjectHours.Text = Convert.ToString(gdecProjectHours); gdecProjectCost = gdecProjectHours * 12; txtProjectedCost.Text = Convert.ToString(gdecProjectCost); } catch (Exception Ex) { TheEventLogClass.InsertEventLogEntry(DateTime.Now, "Blue Jay ERP // Shop Hours Analysis // Window Loaded " + Ex.Message); TheMessagesClass.ErrorMessage(Ex.ToString()); } }
private void mitGenerateReport_Click(object sender, RoutedEventArgs e) { string strProjectID; int intRecordsReturned; int intCounter; int intNumberOfRecords; string strFirstName; string strLastName; DateTime datTransactionDate; string strWorkTask; int intSecondCounter; int intSecondNumberOfRecords; bool blnItemFound; int intTaskCounter; DateTime datStartDate = DateTime.Now; PleaseWait PleaseWait = new PleaseWait(); PleaseWait.Show(); try { TheProjectDailyTaskDataSet.projecttask.Rows.Clear(); TheProjectEmployeeHoursDataSet.employees.Rows.Clear(); strProjectID = txtEnterProjectID.Text; if (strProjectID == "") { TheMessagesClass.ErrorMessage("Project ID Was Not Entered"); PleaseWait.Close(); return; } gdecTotalHours = 0; TheEmployeeCrewDataSet.employeework.Rows.Clear(); TheFindProjectByAssignedProjectIDDataSet = TheProjectClass.FindProjectByAssignedProjectID(strProjectID); intRecordsReturned = TheFindProjectByAssignedProjectIDDataSet.FindProjectByAssignedProjectID.Rows.Count; if (intRecordsReturned == 0) { TheMessagesClass.InformationMessage("Project Was Not Found"); PleaseWait.Close(); return; } MainWindow.gintProjectID = TheFindProjectByAssignedProjectIDDataSet.FindProjectByAssignedProjectID[0].ProjectID; TheFindProjectTaskHoursByAssignedProjectIDDataSet = TheProjectTaskClass.FindProjectTaskHoursByAssignedProjectID(strProjectID); datStartDate = TheDataSearchClass.SubtractingDays(datStartDate, 1200); TheFindProjectHoursDataSet = TheEmployeeProjectAssignmentClass.FindProjectHours(MainWindow.gintProjectID, datStartDate); intNumberOfRecords = TheFindProjectHoursDataSet.FindProjectHours.Rows.Count - 1; intSecondNumberOfRecords = 0; for (intCounter = 0; intCounter <= intNumberOfRecords; intCounter++) { strFirstName = TheFindProjectHoursDataSet.FindProjectHours[intCounter].FirstName; strLastName = TheFindProjectHoursDataSet.FindProjectHours[intCounter].LastName; strWorkTask = TheFindProjectHoursDataSet.FindProjectHours[intCounter].WorkTask; datTransactionDate = TheFindProjectHoursDataSet.FindProjectHours[intCounter].TransactionDate; blnItemFound = false; gdecTotalHours += TheFindProjectHoursDataSet.FindProjectHours[intCounter].TotalHours; if (intSecondNumberOfRecords > 0) { for (intSecondCounter = 0; intSecondCounter < intSecondNumberOfRecords; intSecondCounter++) { if (datTransactionDate == TheEmployeeCrewDataSet.employeework[intSecondCounter].TransactionDate) { if (strFirstName == TheEmployeeCrewDataSet.employeework[intSecondCounter].FirstName) { if (strLastName == TheEmployeeCrewDataSet.employeework[intSecondCounter].LastName) { if (strWorkTask == TheEmployeeCrewDataSet.employeework[intSecondCounter].WorkTask) { blnItemFound = true; TheEmployeeCrewDataSet.employeework[intSecondCounter].Hours += TheFindProjectHoursDataSet.FindProjectHours[intCounter].TotalHours; } } } } } } if (blnItemFound == false) { EmployeeCrewDataSet.employeeworkRow NewEmployeeRow = TheEmployeeCrewDataSet.employeework.NewemployeeworkRow(); NewEmployeeRow.AssignedProjectID = TheFindProjectByAssignedProjectIDDataSet.FindProjectByAssignedProjectID[0].AssignedProjectID; NewEmployeeRow.Crew = ""; NewEmployeeRow.FirstName = strFirstName; NewEmployeeRow.FootagePieces = 0; NewEmployeeRow.Hours = TheFindProjectHoursDataSet.FindProjectHours[intCounter].TotalHours; NewEmployeeRow.LastName = strLastName; NewEmployeeRow.ProjectName = TheFindProjectByAssignedProjectIDDataSet.FindProjectByAssignedProjectID[0].ProjectName; NewEmployeeRow.TransactionDate = datTransactionDate; NewEmployeeRow.WorkTask = strWorkTask; TheEmployeeCrewDataSet.employeework.Rows.Add(NewEmployeeRow); intSecondNumberOfRecords++; } } intNumberOfRecords = intSecondNumberOfRecords - 1; for (intCounter = 0; intCounter <= intNumberOfRecords; intCounter++) { strFirstName = TheEmployeeCrewDataSet.employeework[intCounter].FirstName; strLastName = TheEmployeeCrewDataSet.employeework[intCounter].LastName; strWorkTask = TheEmployeeCrewDataSet.employeework[intCounter].WorkTask; datTransactionDate = TheEmployeeCrewDataSet.employeework[intCounter].TransactionDate; TheFindWorkTaskByWorkTaskDataSet = TheWorkTaskClass.FindWorkTaskByWorkTask(strWorkTask); MainWindow.gintWorkTaskID = TheFindWorkTaskByWorkTaskDataSet.FindWorkTaskByWorkTask[0].WorkTaskID; MainWindow.gintEmployeeID = FindEmployeeID(strFirstName, strLastName); if (MainWindow.gintEmployeeID == -1) { throw new Exception(); } TheFindProjectWorkTaskDataSet = TheProjectTaskClass.FindProjectWorkTask(MainWindow.gintProjectID, MainWindow.gintEmployeeID, MainWindow.gintWorkTaskID, datTransactionDate, datTransactionDate); intSecondNumberOfRecords = TheFindProjectWorkTaskDataSet.FindProjectWorkTask.Rows.Count - 1; for (intSecondCounter = 0; intSecondCounter <= intSecondNumberOfRecords; intSecondCounter++) { TheEmployeeCrewDataSet.employeework[intCounter].FootagePieces += TheFindProjectWorkTaskDataSet.FindProjectWorkTask[intSecondCounter].FootagePieces; } TheFindEmployeeCrewAssignmentByDateRange = TheEmployeeCrewAssignmentClass.FindEmployeeCrewAssignmentByDateRange(MainWindow.gintEmployeeID, datTransactionDate, datTransactionDate); intSecondNumberOfRecords = TheFindEmployeeCrewAssignmentByDateRange.FindEmployeeCrewAssignmentByDateRange.Rows.Count - 1; for (intSecondCounter = 0; intSecondCounter <= intSecondNumberOfRecords; intSecondCounter++) { if (strProjectID == TheFindEmployeeCrewAssignmentByDateRange.FindEmployeeCrewAssignmentByDateRange[intSecondCounter].AssignedProjectID) { TheEmployeeCrewDataSet.employeework[intCounter].Crew = TheFindEmployeeCrewAssignmentByDateRange.FindEmployeeCrewAssignmentByDateRange[intSecondCounter].CrewID; } } } intNumberOfRecords = TheEmployeeCrewDataSet.employeework.Rows.Count - 1; gintTaskCounter = 0; gintTaskUIpperLimit = 0; for (intCounter = 0; intCounter <= intNumberOfRecords; intCounter++) { blnItemFound = false; strWorkTask = TheEmployeeCrewDataSet.employeework[intCounter].WorkTask; datTransactionDate = TheEmployeeCrewDataSet.employeework[intCounter].TransactionDate; if (gintTaskCounter > 0) { for (intTaskCounter = 0; intTaskCounter <= gintTaskUIpperLimit; intTaskCounter++) { if (datTransactionDate == TheProjectDailyTaskDataSet.projecttask[intTaskCounter].TransactionDate) { if (strWorkTask == TheProjectDailyTaskDataSet.projecttask[intTaskCounter].WorkTask) { TheProjectDailyTaskDataSet.projecttask[intTaskCounter].Hours += TheEmployeeCrewDataSet.employeework[intCounter].Hours; blnItemFound = true; if (TheProjectDailyTaskDataSet.projecttask[intTaskCounter].Footage == 0) { TheProjectDailyTaskDataSet.projecttask[intTaskCounter].Footage = TheEmployeeCrewDataSet.employeework[intCounter].FootagePieces; } } } } } if (blnItemFound == false) { ProjectDailyTaskDataSet.projecttaskRow NewTaskRow = TheProjectDailyTaskDataSet.projecttask.NewprojecttaskRow(); NewTaskRow.Crew = TheEmployeeCrewDataSet.employeework[intCounter].Crew; NewTaskRow.Footage = TheEmployeeCrewDataSet.employeework[intCounter].FootagePieces; NewTaskRow.Hours = TheEmployeeCrewDataSet.employeework[intCounter].Hours; NewTaskRow.TransactionDate = TheEmployeeCrewDataSet.employeework[intCounter].TransactionDate; NewTaskRow.WorkTask = TheEmployeeCrewDataSet.employeework[intCounter].WorkTask; TheProjectDailyTaskDataSet.projecttask.Rows.Add(NewTaskRow); gintTaskUIpperLimit = gintTaskCounter; gintTaskCounter++; } } txtTotalHours.Text = Convert.ToString(gdecTotalHours); intNumberOfRecords = TheFindProjectTaskHoursByAssignedProjectIDDataSet.FindProjectTaskHoursByAssignedProjectID.Rows.Count - 1; for (intCounter = 0; intCounter <= intNumberOfRecords; intCounter++) { MainWindow.gintWorkTaskID = TheFindProjectTaskHoursByAssignedProjectIDDataSet.FindProjectTaskHoursByAssignedProjectID[intCounter].TaskID; MainWindow.gintEmployeeID = TheFindProjectTaskHoursByAssignedProjectIDDataSet.FindProjectTaskHoursByAssignedProjectID[intCounter].EmployeeID; TheFindEmployeeByEmployeeIDDataSet = TheEmployeeClass.FindEmployeeByEmployeeID(MainWindow.gintEmployeeID); TheFindWorkTaskByTaskIDDataSet = TheWorkTaskClass.FindWorkTaskByWorkTaskID(MainWindow.gintWorkTaskID); ProjectEmployeeHoursDataSet.employeesRow NewEmployeeRow = TheProjectEmployeeHoursDataSet.employees.NewemployeesRow(); NewEmployeeRow.FirstName = TheFindEmployeeByEmployeeIDDataSet.FindEmployeeByEmployeeID[0].FirstName; NewEmployeeRow.LastName = TheFindEmployeeByEmployeeIDDataSet.FindEmployeeByEmployeeID[0].LastName; NewEmployeeRow.TotalHours = TheFindProjectTaskHoursByAssignedProjectIDDataSet.FindProjectTaskHoursByAssignedProjectID[intCounter].EmployeeTotalHours; NewEmployeeRow.TransactionDate = TheFindProjectTaskHoursByAssignedProjectIDDataSet.FindProjectTaskHoursByAssignedProjectID[intCounter].TransactionDate; NewEmployeeRow.WorkTask = TheFindWorkTaskByTaskIDDataSet.FindWorkTaskByWorkTaskID[0].WorkTask; TheProjectEmployeeHoursDataSet.employees.Rows.Add(NewEmployeeRow); } dgrResults.ItemsSource = TheProjectDailyTaskDataSet.projecttask; dgrEmployees.ItemsSource = TheProjectEmployeeHoursDataSet.employees; bool blnFatalError = TheEmployeeDateEntryClass.InsertIntoEmployeeDateEntry(MainWindow.TheVerifyLogonDataSet.VerifyLogon[0].EmployeeID, "Blue Jay ERP // Find Project Employee Hours // Generate Report Menu Item "); } catch (Exception Ex) { PleaseWait.Close(); TheEventLogClass.InsertEventLogEntry(DateTime.Now, "Blue Jay ERP // Find Project Employee Hours // Generate Report Menu Item " + Ex.Message); TheMessagesClass.ErrorMessage(Ex.ToString()); } PleaseWait.Close(); }