private void mitExit_Click(object sender, RoutedEventArgs e) { txtEnterStartDate.Text = ""; txtEnterEndDate.Text = ""; TheFindLaborHoursByDateRangeDataSet = TheEmployeeProjectAssignmentClass.FindLaborHoursByDateRange(DateTime.Now, DateTime.Now); dgvResults.ItemsSource = TheFindLaborHoursByDateRangeDataSet.FindLaborHoursByDateRange; Visibility = Visibility.Hidden; }
private void mitFindTransactions_Click(object sender, RoutedEventArgs e) { //setting local variables string strValueForValidation; bool blnThereIsAProblem = false; bool blnFatalError = false; string strErrorMessage = ""; strValueForValidation = txtEnterStartDate.Text; blnThereIsAProblem = TheDataValidationClass.VerifyDateData(strValueForValidation); if (blnThereIsAProblem == true) { blnFatalError = true; strErrorMessage += "The Start Date is not a Date\n"; } else { MainWindow.gdatStartDate = Convert.ToDateTime(strValueForValidation); } strValueForValidation = txtEnterEndDate.Text; blnThereIsAProblem = TheDataValidationClass.VerifyDateData(strValueForValidation); if (blnThereIsAProblem == true) { blnFatalError = true; strErrorMessage += "The End Date is not a Date\n"; } else { MainWindow.gdatEndDate = Convert.ToDateTime(strValueForValidation); } if (blnFatalError == true) { TheMessagesClass.ErrorMessage(strErrorMessage); return; } else { blnFatalError = TheDataValidationClass.verifyDateRange(MainWindow.gdatStartDate, MainWindow.gdatEndDate); if (blnFatalError == true) { TheMessagesClass.ErrorMessage("The Start Date is after the End Date"); return; } } TheFindLaborHoursByDateRangeDataSet = TheEmployeeProjectAssignmentClass.FindLaborHoursByDateRange(MainWindow.gdatStartDate, MainWindow.gdatEndDate); dgvResults.ItemsSource = TheFindLaborHoursByDateRangeDataSet.FindLaborHoursByDateRange; }
public FindLaborHoursByDateRangeDataSet FindLaborHoursByDateRange(DateTime datStartDate, DateTime datEndDate) { try { aFindLaborHoursByDateRangeDataSet = new FindLaborHoursByDateRangeDataSet(); aFindLaborHoursByDateRangeTableAdapter = new FindLaborHoursByDateRangeDataSetTableAdapters.FindLaborHoursByDateRangeTableAdapter(); aFindLaborHoursByDateRangeTableAdapter.Fill(aFindLaborHoursByDateRangeDataSet.FindLaborHoursByDateRange, datStartDate, datEndDate); } catch (Exception Ex) { TheEventLogClass.InsertEventLogEntry(DateTime.Now, "Employee Project Assignment Class // Find Labor Hours By Date Range " + Ex.Message); } return(aFindLaborHoursByDateRangeDataSet); }
private void dgvResults_SelectionChanged(object sender, SelectionChangedEventArgs e) { DataGrid dataGrid; DataGridRow selectedRow; DataGridCell TransactionID; string strTransactionID; try { if (dgvResults.SelectedIndex > -1) { //setting local variable dataGrid = dgvResults; selectedRow = (DataGridRow)dataGrid.ItemContainerGenerator.ContainerFromIndex(dataGrid.SelectedIndex); TransactionID = (DataGridCell)dataGrid.Columns[0].GetCellContent(selectedRow).Parent; strTransactionID = ((TextBlock)TransactionID.Content).Text; TheEventLogClass.InsertEventLogEntry(DateTime.Now, "Has Selected A Transaction to Be Editted"); //find the record MainWindow.gintTransactionID = Convert.ToInt32(strTransactionID); EditSelectedLaborTransaction EditSelectedLaborTransaction = new EditSelectedLaborTransaction(); EditSelectedLaborTransaction.ShowDialog(); TheFindLaborHoursByDateRangeDataSet = TheEmployeeProjectAssignmentClass.FindLaborHoursByDateRange(MainWindow.gdatStartDate, MainWindow.gdatEndDate); dgvResults.ItemsSource = TheFindLaborHoursByDateRangeDataSet.FindLaborHoursByDateRange; } } catch (Exception Ex) { TheEventLogClass.InsertEventLogEntry(DateTime.Now, "Blue Jay ERP // Edit Project Labor // Grid Selection " + Ex.Message); TheMessagesClass.ErrorMessage(Ex.ToString()); } }
public bool UpdateWorkTaskStatsTable() { bool blnFatalError = false; DateTime datStartDate = DateTime.Now; DateTime datEndDate = DateTime.Now; int intCounter; int intNumberOfRecords; double douHours; int intTaskCounter; bool blnItemFound; int intWorkTaskID; decimal decMean; decimal decVariance; decimal dectotalHours; int intItems; string strWorkTask; double douTaskHours; decimal decStandardDeviation; int intRecordsReturned; decimal decLimiter; try { TheWorkStatsDataSet.workstats.Rows.Clear(); datEndDate = TheDateSearchClass.RemoveTime(datEndDate); datStartDate = TheDateSearchClass.SubtractingDays(datEndDate, 900); gintCounter = 0; gdecTotal = 0; gdecVariance = 0; gintTaskUpperLimit = 0; TheFindLaborHoursByDateRangeDataSet = TheEmployeeProjectAssignmentClass.FindLaborHoursByDateRange(datStartDate, datEndDate); intNumberOfRecords = TheFindLaborHoursByDateRangeDataSet.FindLaborHoursByDateRange.Rows.Count - 1; for (intCounter = 0; intCounter <= intNumberOfRecords; intCounter++) { if (TheFindLaborHoursByDateRangeDataSet.FindLaborHoursByDateRange[intCounter].TotalHours > 0) { intWorkTaskID = TheFindLaborHoursByDateRangeDataSet.FindLaborHoursByDateRange[intCounter].WorkTaskID; blnItemFound = false; if (gintTaskUpperLimit > 0) { for (intTaskCounter = 0; intTaskCounter < gintTaskUpperLimit; intTaskCounter++) { if (intWorkTaskID == TheWorkStatsDataSet.workstats[intTaskCounter].WorkTaskID) { blnItemFound = true; TheWorkStatsDataSet.workstats[intTaskCounter].HoursPerTask += TheFindLaborHoursByDateRangeDataSet.FindLaborHoursByDateRange[intCounter].TotalHours; TheWorkStatsDataSet.workstats[intTaskCounter].ItemCounter++; } } } gdecTotal += TheFindLaborHoursByDateRangeDataSet.FindLaborHoursByDateRange[intCounter].TotalHours; gintCounter++; if (blnItemFound == false) { WorkStatsDataSet.workstatsRow NewTaskRow = TheWorkStatsDataSet.workstats.NewworkstatsRow(); NewTaskRow.HoursPerTask = TheFindLaborHoursByDateRangeDataSet.FindLaborHoursByDateRange[intCounter].TotalHours; NewTaskRow.ItemCounter = 1; NewTaskRow.Limiter = 0; NewTaskRow.Mean = 0; NewTaskRow.StandardDeviation = 0; NewTaskRow.Variance = 0; NewTaskRow.WorkTask = TheFindLaborHoursByDateRangeDataSet.FindLaborHoursByDateRange[intCounter].WorkTask; NewTaskRow.WorkTaskID = TheFindLaborHoursByDateRangeDataSet.FindLaborHoursByDateRange[intCounter].WorkTaskID; TheWorkStatsDataSet.workstats.Rows.Add(NewTaskRow); gintTaskUpperLimit++; } } } decVariance = 0; for (intTaskCounter = 0; intTaskCounter < gintTaskUpperLimit; intTaskCounter++) { intItems = TheWorkStatsDataSet.workstats[intTaskCounter].ItemCounter; dectotalHours = TheWorkStatsDataSet.workstats[intTaskCounter].HoursPerTask; intWorkTaskID = TheWorkStatsDataSet.workstats[intTaskCounter].WorkTaskID; strWorkTask = TheWorkStatsDataSet.workstats[intTaskCounter].WorkTask; decMean = dectotalHours / intItems; decMean = Math.Round(decMean, 4); TheWorkStatsDataSet.workstats[intTaskCounter].Mean = decMean; TheFindWorkTaskHoursDataSet = TheWorkTaskClass.FindWorkTaskHours(strWorkTask, datStartDate, datEndDate); intNumberOfRecords = TheFindWorkTaskHoursDataSet.FindWorkTaskHours.Rows.Count - 1; for (intCounter = 0; intCounter <= intNumberOfRecords; intCounter++) { if (TheFindWorkTaskHoursDataSet.FindWorkTaskHours[intCounter].TotalHours > 0) { douTaskHours = Convert.ToDouble(TheFindWorkTaskHoursDataSet.FindWorkTaskHours[intCounter].TotalHours - decMean); decVariance += Convert.ToDecimal(Math.Pow(douTaskHours, 2)); } } decVariance = decVariance / intItems; decVariance = Math.Round(decVariance, 4); decStandardDeviation = Math.Round(Convert.ToDecimal(Math.Sqrt(Convert.ToDouble(decVariance))), 4); TheWorkStatsDataSet.workstats[intTaskCounter].Variance = decVariance; TheWorkStatsDataSet.workstats[intTaskCounter].StandardDeviation = decStandardDeviation; TheWorkStatsDataSet.workstats[intTaskCounter].Limiter = decMean + (5 * decStandardDeviation); } gdecMean = gdecTotal / gintCounter; gdecMean = Math.Round(gdecMean, 4); intNumberOfRecords = TheFindLaborHoursByDateRangeDataSet.FindLaborHoursByDateRange.Rows.Count - 1; for (intCounter = 0; intCounter <= intNumberOfRecords; intCounter++) { if (TheFindLaborHoursByDateRangeDataSet.FindLaborHoursByDateRange[intCounter].TotalHours > 0) { douHours = Convert.ToDouble(TheFindLaborHoursByDateRangeDataSet.FindLaborHoursByDateRange[intCounter].TotalHours - gdecMean); gdecVariance += Convert.ToDecimal(Math.Pow(douHours, 2)); } } gdecVariance = gdecVariance / gintCounter; gdecStandardDeviation = Convert.ToDecimal(Math.Sqrt(Convert.ToDouble(gdecVariance))); gdecStandardDeviation = Math.Round(gdecStandardDeviation, 4); gdecLimiter = gdecMean + (gdecStandardDeviation * 5); //adding to the table intNumberOfRecords = TheWorkStatsDataSet.workstats.Rows.Count - 1; for (intCounter = 0; intCounter <= intNumberOfRecords; intCounter++) { intWorkTaskID = TheWorkStatsDataSet.workstats[intCounter].WorkTaskID; decMean = TheWorkStatsDataSet.workstats[intCounter].Mean; decVariance = TheWorkStatsDataSet.workstats[intCounter].Variance; decStandardDeviation = TheWorkStatsDataSet.workstats[intCounter].StandardDeviation; decLimiter = TheWorkStatsDataSet.workstats[intCounter].Limiter; TheFindWorkTaskStatsByTaskIDDataSet = TheWorkTaskStatsClass.FindWorkTaskStatsByTaskID(intWorkTaskID); intRecordsReturned = TheFindWorkTaskStatsByTaskIDDataSet.FindWorkTaskStatsByWorkTaskID.Rows.Count; if (intRecordsReturned > 0) { blnFatalError = TheWorkTaskStatsClass.UpdatetWorkTaskStats(intWorkTaskID, decMean, decVariance, decStandardDeviation, decLimiter); if (blnFatalError == true) { throw new Exception(); } } if (intRecordsReturned == 0) { blnFatalError = TheWorkTaskStatsClass.InsertWorkTaskStats(intWorkTaskID, decMean, decVariance, decStandardDeviation, decLimiter); if (blnFatalError == true) { throw new Exception(); } } } } catch (Exception Ex) { TheEventLogClass.InsertEventLogEntry(DateTime.Now, "Event Log Tracker // Update Work Task Stats Class // Update Work Task Stats Table " + Ex.Message); TheMessagesClass.ErrorMessage(Ex.ToString()); blnFatalError = true; } return(blnFatalError); }
private void mitGenerateReport_Click(object sender, RoutedEventArgs e) { //setting local viarables string strValueForValidation; string strErrorMessage = ""; bool blnThereIsAProblem = false; bool blnFatalError = false; int intLaborCounter; int intLaborNumberOfRecords; int intEmployeeCounter; int intEmployeeNumberOfRecords; int intEmployeeID; decimal decHours; bool blnItemFound; PleaseWait PleaseWait = new PleaseWait(); PleaseWait.Show(); try { TheTotalHoursDataSet.totalhours.Rows.Clear(); strValueForValidation = txtEnterStartDate.Text; blnThereIsAProblem = TheDataValidationClass.VerifyDateData(strValueForValidation); if (blnThereIsAProblem == true) { blnFatalError = true; strErrorMessage += "The Start Date is not a Date\n"; } else { MainWindow.gdatStartDate = Convert.ToDateTime(strValueForValidation); } strValueForValidation = txtEnterEndDate.Text; blnThereIsAProblem = TheDataValidationClass.VerifyDateData(strValueForValidation); if (blnThereIsAProblem == true) { blnFatalError = true; strErrorMessage += "The End Date is not a Date\n"; } else { MainWindow.gdatEndDate = Convert.ToDateTime(strValueForValidation); } if (blnFatalError == true) { TheMessagesClass.ErrorMessage(strErrorMessage); PleaseWait.Close(); return; } else { blnFatalError = TheDataValidationClass.verifyDateRange(MainWindow.gdatStartDate, MainWindow.gdatEndDate); if (blnFatalError == true) { TheMessagesClass.ErrorMessage("The Start Date is after the End Date"); PleaseWait.Close(); return; } } TheFindLaborHoursByDateRangeDataSet = TheEmployeeProjectAssignmentClass.FindLaborHoursByDateRange(MainWindow.gdatStartDate, MainWindow.gdatEndDate); intLaborNumberOfRecords = TheFindLaborHoursByDateRangeDataSet.FindLaborHoursByDateRange.Rows.Count - 1; intEmployeeNumberOfRecords = 0; for (intLaborCounter = 0; intLaborCounter <= intLaborNumberOfRecords; intLaborCounter++) { intEmployeeID = TheFindLaborHoursByDateRangeDataSet.FindLaborHoursByDateRange[intLaborCounter].EmployeeID; decHours = TheFindLaborHoursByDateRangeDataSet.FindLaborHoursByDateRange[intLaborCounter].TotalHours; blnItemFound = false; if (intEmployeeNumberOfRecords > 0) { for (intEmployeeCounter = 0; intEmployeeCounter < intEmployeeNumberOfRecords; intEmployeeCounter++) { if (intEmployeeID == TheTotalHoursDataSet.totalhours[intEmployeeCounter].EmployeeID) { blnItemFound = true; TheTotalHoursDataSet.totalhours[intEmployeeCounter].TotalHours += decHours; } } } if (blnItemFound == false) { TheFindEmployeeByEmployeeIDDataSet = TheEmployeeClass.FindEmployeeByEmployeeID(intEmployeeID); TotalHoursDataSet.totalhoursRow NewEmployeeRow = TheTotalHoursDataSet.totalhours.NewtotalhoursRow(); NewEmployeeRow.EmployeeID = intEmployeeID; NewEmployeeRow.EmployeeType = TheFindEmployeeByEmployeeIDDataSet.FindEmployeeByEmployeeID[0].EmployeeType; NewEmployeeRow.FirstName = TheFindEmployeeByEmployeeIDDataSet.FindEmployeeByEmployeeID[0].FirstName; NewEmployeeRow.HomeOffice = TheFindEmployeeByEmployeeIDDataSet.FindEmployeeByEmployeeID[0].HomeOffice; NewEmployeeRow.LastName = TheFindEmployeeByEmployeeIDDataSet.FindEmployeeByEmployeeID[0].LastName; NewEmployeeRow.TotalHours = decHours; TheTotalHoursDataSet.totalhours.Rows.Add(NewEmployeeRow); intEmployeeNumberOfRecords++; } } TheTotalHoursDataSet.totalhours.DefaultView.Sort = "TotalHours DESC"; dgrResults.ItemsSource = TheTotalHoursDataSet.totalhours; } catch (Exception Ex) { TheEventLogClass.InsertEventLogEntry(DateTime.Now, "Blue Jay ERP // Find Labor Hours // Generate Report Menu Item " + Ex.Message); TheMessagesClass.ErrorMessage(Ex.ToString()); } PleaseWait.Close(); }