public FindWorkTaskDepartmentByLOBDepartmentDataSet FindWorkTaskDepartmentByLOBDepartment(int intBusinessLineID, int intDepartmentID) { try { aFindWorkTaskDepartmentByLOBDepartmentDataSet = new FindWorkTaskDepartmentByLOBDepartmentDataSet(); aFindWorkTaskDepartmentByLOBDepartmentTableAdapter = new FindWorkTaskDepartmentByLOBDepartmentDataSetTableAdapters.FindWorkTaskDepartmentByLOBDepartmentTableAdapter(); aFindWorkTaskDepartmentByLOBDepartmentTableAdapter.Fill(aFindWorkTaskDepartmentByLOBDepartmentDataSet.FindWorkTaskDepartmentByLOBDepartment, intBusinessLineID, intDepartmentID); } catch (Exception Ex) { TheEventLogClass.InsertEventLogEntry(DateTime.Now, "Work Task Class // Find Work Task Department By LOB Department " + Ex.Message); } return(aFindWorkTaskDepartmentByLOBDepartmentDataSet); }
private void UpdateGrid() { int intCounter; int intNumberOfRecords; DateTime datTransactionDate; int intWorkTaskID; decimal decTotalCount; decimal decTaskCount = 0; decimal decPercentage; int intGreaterThan; int intRecordsReturned; PleaseWait PleaseWait = new PleaseWait(); PleaseWait.Show(); try { TheProductionTasksForSheetsDataSet.productiontasks.Rows.Clear(); datTransactionDate = DateTime.Now; datTransactionDate = TheDateSearchClass.SubtractingDays(datTransactionDate, 90); TheFindWorkTaskIDTotalCountByDateDataSet = TheWorkTaskClass.FindWorkTaskIDTotalCountByDate(datTransactionDate); TheFindWorkTaskDepartmentByLOBDepartmentDataSet = TheWorkTaskClass.FindWorkTaskDepartmentByLOBDepartment(gintBusinessLineID, gintDepartmentID); decTotalCount = Convert.ToDecimal(TheFindWorkTaskIDTotalCountByDateDataSet.FindWorkTaskIDTotalCountByDate[0].TotalCount); intNumberOfRecords = TheFindWorkTaskDepartmentByLOBDepartmentDataSet.FindWorkTaskDepartmentByLOBDepartment.Rows.Count; if (intNumberOfRecords > 0) { for (intCounter = 0; intCounter < intNumberOfRecords; intCounter++) { intWorkTaskID = TheFindWorkTaskDepartmentByLOBDepartmentDataSet.FindWorkTaskDepartmentByLOBDepartment[intCounter].WorkTaskID; TheFindWorkTaskUsageByDateTaskDataSet = TheWorkTaskClass.FindWorkTaskUsageByDateTask(datTransactionDate, intWorkTaskID); intRecordsReturned = TheFindWorkTaskUsageByDateTaskDataSet.FindWorkTaskUsageByDateTask.Rows.Count; if (intRecordsReturned < 1) { decTaskCount = 0; } else if (intRecordsReturned > 0) { decTaskCount = Convert.ToDecimal(TheFindWorkTaskUsageByDateTaskDataSet.FindWorkTaskUsageByDateTask[0].TotalCount); } decPercentage = decTaskCount / decTotalCount; ProductionTasksForSheetsDataSet.productiontasksRow NewProductionCode = TheProductionTasksForSheetsDataSet.productiontasks.NewproductiontasksRow(); NewProductionCode.WorkTask = TheFindWorkTaskDepartmentByLOBDepartmentDataSet.FindWorkTaskDepartmentByLOBDepartment[intCounter].WorkTask; intGreaterThan = decimal.Compare(decPercentage, Convert.ToDecimal(.001)); if (intGreaterThan < 0) { NewProductionCode.UseCode = false; } else if (intGreaterThan > -1) { NewProductionCode.UseCode = true; } TheProductionTasksForSheetsDataSet.productiontasks.Rows.Add(NewProductionCode); } } dgrProductionCodes.ItemsSource = TheProductionTasksForSheetsDataSet.productiontasks; } catch (Exception Ex) { TheEventLogClass.InsertEventLogEntry(DateTime.Now, "New Blue Jay ERP // Create Production Sheet // Update Grid " + Ex.Message); TheMessagesClass.ErrorMessage(Ex.ToString()); } PleaseWait.Close(); }