public FindWorkTaskDepartmentWorkTaskMatchDataSet FindWorkTaskDepartmentWorkTaskMatch(int intWorkTaskID, int intBusinessLineID, int intDepartmentID) { try { aFindWorkTaskDepartmentWorkTaskMatchDataSet = new FindWorkTaskDepartmentWorkTaskMatchDataSet(); aFindWorkTaskDepartmentWorkTaskMatchTableAdapter = new FindWorkTaskDepartmentWorkTaskMatchDataSetTableAdapters.FindWorkTaskDepartmentWorkTaskMatchTableAdapter(); aFindWorkTaskDepartmentWorkTaskMatchTableAdapter.Fill(aFindWorkTaskDepartmentWorkTaskMatchDataSet.FindWorkTaskDepartmentWorkTaskMatch, intWorkTaskID, intBusinessLineID, intDepartmentID); } catch (Exception Ex) { TheEventLogClass.InsertEventLogEntry(DateTime.Now, "Work Task Class // Find Work Task Department Work Task Match " + Ex.Message); } return(aFindWorkTaskDepartmentWorkTaskMatchDataSet); }
private void expProcessImport_Expanded(object sender, RoutedEventArgs e) { int intCounter; int intNumberOfRecords; int intWorkTaskID; int intDepartmentID; int intBusinessLineID; int intEmployeeID; DateTime datTransactionDate; bool blnFatalError = false; string strWorkTask; int intRecordsReturned; try { expProcessImport.IsExpanded = false; intNumberOfRecords = TheProductionCodesForImportDataSet.productioncodes.Rows.Count; intEmployeeID = MainWindow.TheVerifyLogonDataSet.VerifyLogon[0].EmployeeID; for (intCounter = 0; intCounter < intNumberOfRecords; intCounter++) { datTransactionDate = DateTime.Now; intWorkTaskID = TheProductionCodesForImportDataSet.productioncodes[intCounter].WorkTaskID; intDepartmentID = TheProductionCodesForImportDataSet.productioncodes[intCounter].DepartmentID; intBusinessLineID = TheProductionCodesForImportDataSet.productioncodes[intCounter].BusinessLineID; if (intWorkTaskID < 0) { strWorkTask = TheProductionCodesForImportDataSet.productioncodes[intCounter].WorkTask; TheFindWorkTaskByTaskKeyWordDataSet = TheWorkTaskClass.FindWorkTaskByTaskKeyword(strWorkTask); intRecordsReturned = TheFindWorkTaskByTaskKeyWordDataSet.FindWorkTaskByTaskKeyword.Rows.Count; if (intRecordsReturned < 1) { blnFatalError = TheWorkTaskClass.InsertWorkTask(strWorkTask, 0); if (blnFatalError == true) { throw new Exception(); } TheFindWorkTaskByTaskKeyWordDataSet = TheWorkTaskClass.FindWorkTaskByTaskKeyword(strWorkTask); intWorkTaskID = TheFindWorkTaskByTaskKeyWordDataSet.FindWorkTaskByTaskKeyword[0].WorkTaskID; } else if (intRecordsReturned > 0) { intWorkTaskID = TheFindWorkTaskByTaskKeyWordDataSet.FindWorkTaskByTaskKeyword[0].WorkTaskID; } } TheFindWorkTaskDepartmentWorkTaskMatchDataSet = TheWorkTaskClass.FindWorkTaskDepartmentWorkTaskMatch(intWorkTaskID, intBusinessLineID, intDepartmentID); intRecordsReturned = TheFindWorkTaskDepartmentWorkTaskMatchDataSet.FindWorkTaskDepartmentWorkTaskMatch.Rows.Count; if (intRecordsReturned < 1) { blnFatalError = TheWorkTaskClass.InsertWorkTaskDepartment(intWorkTaskID, intBusinessLineID, intDepartmentID, intEmployeeID, datTransactionDate); if (blnFatalError == true) { throw new Exception(); } } } TheMessageClass.InformationMessage("The Codes have been Imported"); ResetControls(); } catch (Exception Ex) { TheEventLogClass.InsertEventLogEntry(DateTime.Now, "New Blue Jay ERP // Import Codes For Sheets // Process Import Expanded " + Ex.Message); TheMessageClass.ErrorMessage(Ex.ToString()); } }