private void btnFind_Click(object sender, RoutedEventArgs e) { //setting the local varialbes int intRecordsReturned; gstrToolID = txtEnterToolID.Text; //getting the tool information TheFindActiveToolByToolIDDataSet = TheToolClass.FindActiveToolByToolID(gstrToolID); intRecordsReturned = TheFindActiveToolByToolIDDataSet.FindActiveToolByToolID.Rows.Count; TheImportDocumentsDataSet.documents.Rows.Clear(); dgrDocument.ItemsSource = TheImportDocumentsDataSet.documents; if (intRecordsReturned == 0) { TheMessagesClass.ErrorMessage("The Tool Was Not Found"); return; } else if (intRecordsReturned > 0) { txtCost.Text = Convert.ToString(TheFindActiveToolByToolIDDataSet.FindActiveToolByToolID[0].ToolCost); txtToolDescription.Text = TheFindActiveToolByToolIDDataSet.FindActiveToolByToolID[0].ToolDescription; MainWindow.gintToolKey = TheFindActiveToolByToolIDDataSet.FindActiveToolByToolID[0].ToolKey; } }
private void Button_Click(object sender, RoutedEventArgs e) { //setting up the variables string strToolID; int intRecordsReturned; strToolID = txtEnterToolID.Text; if (strToolID == "") { TheMessagesClass.ErrorMessage("The Tool ID Was Not Entered"); return; } TheFindActiveToolByToolIDDataSet = TheToolsClass.FindActiveToolByToolID(strToolID); intRecordsReturned = TheFindActiveToolByToolIDDataSet.FindActiveToolByToolID.Rows.Count; if (intRecordsReturned == 0) { TheMessagesClass.InformationMessage("Tool ID Was Not Found"); return; } if (TheFindActiveToolByToolIDDataSet.FindActiveToolByToolID[0].Available == true) { TheMessagesClass.InformationMessage("Tool Is Already Signed In"); return; } MainWindow.gintToolKey = TheFindActiveToolByToolIDDataSet.FindActiveToolByToolID[0].ToolKey; txtDescription.Text = TheFindActiveToolByToolIDDataSet.FindActiveToolByToolID[0].ToolDescription; txtFirstName.Text = TheFindActiveToolByToolIDDataSet.FindActiveToolByToolID[0].FirstName; txtLastName.Text = TheFindActiveToolByToolIDDataSet.FindActiveToolByToolID[0].LastName; mitSignInTool.IsEnabled = true; }
private void btnFindTool_Click(object sender, RoutedEventArgs e) { //this will find the tool string strToolID; int intRecordsReturned; int intWarehouseID; string strCategory; try { strToolID = txtToolID.Text; if (strToolID == "") { TheMessagesClass.ErrorMessage("Tool ID Not Entered"); return; } TheFindToolByToolIDDataSet = TheToolsClass.FindActiveToolByToolID(strToolID); intRecordsReturned = TheFindToolByToolIDDataSet.FindActiveToolByToolID.Rows.Count; if (intRecordsReturned == 0) { TheMessagesClass.ErrorMessage("No Tools Found"); return; } txtToolCost.Text = Convert.ToString(TheFindToolByToolIDDataSet.FindActiveToolByToolID[0].ToolCost); txtToolDescription.Text = TheFindToolByToolIDDataSet.FindActiveToolByToolID[0].ToolDescription; txtToolPartNumber.Text = TheFindToolByToolIDDataSet.FindActiveToolByToolID[0].PartNumber; txtToolNotes.Text = TheFindToolByToolIDDataSet.FindActiveToolByToolID[0].ToolNotes; MainWindow.gintToolKey = TheFindToolByToolIDDataSet.FindActiveToolByToolID[0].ToolKey; strCategory = TheFindToolByToolIDDataSet.FindActiveToolByToolID[0].ToolCategory; intWarehouseID = TheFindToolByToolIDDataSet.FindActiveToolByToolID[0].CurrentLocation; cboSelectWarehouse.IsEnabled = true; FindToolCategory(strCategory); FindWarehouse(intWarehouseID); } catch (Exception Ex) { TheEventLogClass.InsertEventLogEntry(DateTime.Now, "Blue Jay ERP // Edit Tools // Find Button " + Ex.Message); TheMessagesClass.ErrorMessage(Ex.ToString()); } }
public FindActiveToolByToolIDDataSet FindActiveToolByToolID(string strToolID) { try { aFindActiveToolByToolIDDataSet = new FindActiveToolByToolIDDataSet(); aFindActiveToolByToolIDTableAdapter = new FindActiveToolByToolIDDataSetTableAdapters.FindActiveToolByToolIDTableAdapter(); aFindActiveToolByToolIDTableAdapter.Fill(aFindActiveToolByToolIDDataSet.FindActiveToolByToolID, strToolID); } catch (Exception Ex) { TheEventLogClass.InsertEventLogEntry(DateTime.Now, "Tools Class // Find Active Tool By Tool ID " + Ex.Message); } return(aFindActiveToolByToolIDDataSet); }
private void Window_Loaded(object sender, RoutedEventArgs e) { try { TheFindActiveToolByToolIDDataSet = TheToolsClass.FindActiveToolByToolID(MainWindow.gstrToolID); MainWindow.gintToolKey = TheFindActiveToolByToolIDDataSet.FindActiveToolByToolID[0].ToolKey; txtToolID.Text = MainWindow.gstrToolID; txtDescription.Text = TheFindActiveToolByToolIDDataSet.FindActiveToolByToolID[0].ToolDescription; txtFirstName.Text = TheFindActiveToolByToolIDDataSet.FindActiveToolByToolID[0].FirstName; txtLastName.Text = TheFindActiveToolByToolIDDataSet.FindActiveToolByToolID[0].LastName; MainWindow.gblnToolSignedIn = false; } catch (Exception Ex) { TheEventLogClass.InsertEventLogEntry(DateTime.Now, "Blue Jay ERP // Sign Tool In From Form // Window Loaded " + Ex.Message); TheMessagesClass.ErrorMessage(Ex.ToString()); } }
private void btnImportExcel_Click(object sender, RoutedEventArgs e) { Excel.Application xlDropOrder; Excel.Workbook xlDropBook; Excel.Worksheet xlDropSheet; Excel.Range range; int intColumnRange = 0; int intCounter; int intNumberOfRecords; int intRecordsReturned; int intAssetID; string strAssetDescription; string strLocation; string strSerialNumber; string strAssetType; string strBJCNumber; bool blnFatalError = false; string strErrorMessage = ""; bool blnItemFound; int intTransactionID; string strModel; string strManufacturer; try { TheImportWaspToolAssetsDataSet.importassets.Rows.Clear(); Microsoft.Win32.OpenFileDialog dlg = new Microsoft.Win32.OpenFileDialog(); dlg.FileName = "Document"; // Default file name dlg.DefaultExt = ".xlsx"; // Default file extension dlg.Filter = "Excel (.xlsx)|*.xlsx"; // Filter files by extension // Show open file dialog box Nullable <bool> result = dlg.ShowDialog(); // Process open file dialog box results if (result == true) { // Open document string filename = dlg.FileName; } PleaseWait PleaseWait = new PleaseWait(); PleaseWait.Show(); strLocation = txtEnterLocation.Text; if (strLocation.Length < 2) { blnFatalError = true; strErrorMessage += "The Location is not long Enough\n"; } else { TheFindWaspAssetLocationByLocationDataSet = TheAssetClass.FindWaspAssetLocationByLocation(strLocation); intRecordsReturned = TheFindWaspAssetLocationByLocationDataSet.FindWaspAssetLocationByLocation.Rows.Count; if (intRecordsReturned < 1) { blnFatalError = true; strErrorMessage += "There is no Such Location\n"; } } if (cboSelectLocation.SelectedIndex < 1) { blnFatalError = true; strErrorMessage += "The Site Has Not Been Selected\n"; } if (blnFatalError == true) { TheMessagesClass.ErrorMessage(strErrorMessage); return; } xlDropOrder = new Excel.Application(); xlDropBook = xlDropOrder.Workbooks.Open(dlg.FileName, 0, true, 5, "", "", true, Microsoft.Office.Interop.Excel.XlPlatform.xlWindows, "\t", false, false, 0, true, 1, 0); xlDropSheet = (Excel.Worksheet)xlDropOrder.Worksheets.get_Item(1); range = xlDropSheet.UsedRange; intNumberOfRecords = range.Rows.Count; intColumnRange = range.Columns.Count; for (intCounter = 1; intCounter <= intNumberOfRecords; intCounter++) { TheWaspAssetIDDataSet = TheAssetClass.GetWaspAssetIDInfo(); intAssetID = TheWaspAssetIDDataSet.waspassetid[0].CreatedAssetID; intTransactionID = TheWaspAssetIDDataSet.waspassetid[0].TransactionID; blnFatalError = TheAssetClass.UpdateWaspAssetID(intTransactionID, intAssetID + 1); blnItemFound = false; strAssetType = "UNKNOWN"; if (((range.Cells[intCounter, 2] as Excel.Range).Value2) == null) { intCounter = intNumberOfRecords; break; } else { strAssetDescription = Convert.ToString((range.Cells[intCounter, 2] as Excel.Range).Value2).ToUpper(); if (((range.Cells[intCounter, 3] as Excel.Range).Value2) == null) { strSerialNumber = " "; } else { strSerialNumber = Convert.ToString((range.Cells[intCounter, 3] as Excel.Range).Value2).ToUpper(); } if (((range.Cells[intCounter, 4] as Excel.Range).Value2) == null) { strBJCNumber = " "; } else { strBJCNumber = Convert.ToString((range.Cells[intCounter, 4] as Excel.Range).Value2).ToUpper(); } if (strSerialNumber.Length > 2) { TheFindWaspAssetBySerialNumberDataSet = TheAssetClass.FindWaspAssetsBySerialNumber(strSerialNumber); intRecordsReturned = TheFindWaspAssetBySerialNumberDataSet.FindWaspAssetsBySerialNumber.Rows.Count; if (intRecordsReturned > 0) { blnItemFound = true; } } if (strBJCNumber.Length > 2) { TheFindWaspAssetByBJCAssetIDDataSet = TheAssetClass.FindWaspAssetByBJCAssetID(strBJCNumber); intRecordsReturned = TheFindWaspAssetByBJCAssetIDDataSet.FindWaspAssetByBJCAssetID.Rows.Count; if (intRecordsReturned > 0) { blnItemFound = true; } } } if (blnItemFound == false) { if (strBJCNumber.Length > 2) { TheFindActiveToolByToolIDDataSet = TheToolClass.FindActiveToolByToolID(strBJCNumber); intRecordsReturned = TheFindActiveToolByToolIDDataSet.FindActiveToolByToolID.Rows.Count; if (intRecordsReturned > 0) { strAssetType = TheFindActiveToolByToolIDDataSet.FindActiveToolByToolID[0].ToolCategory; strAssetDescription = TheFindActiveToolByToolIDDataSet.FindActiveToolByToolID[0].ToolDescription; } } ImportWaspToolAssetsDataSet.importassetsRow NewAssetRow = TheImportWaspToolAssetsDataSet.importassets.NewimportassetsRow(); NewAssetRow.AssetDescription = strAssetDescription; NewAssetRow.AssetID = intAssetID; NewAssetRow.AssetType = strAssetType; NewAssetRow.Location = strLocation; NewAssetRow.Manufacturer = "UNKNOWN"; NewAssetRow.Model = "UNKNOWN"; NewAssetRow.SerialNumber = strSerialNumber; NewAssetRow.Site = gstrSite; NewAssetRow.WarehouseID = MainWindow.gintWarehouseID; NewAssetRow.BJCAssetID = strBJCNumber; TheImportWaspToolAssetsDataSet.importassets.Rows.Add(NewAssetRow); } } intNumberOfRecords = TheImportWaspToolAssetsDataSet.importassets.Rows.Count; if (intNumberOfRecords > 0) { for (intCounter = 0; intCounter < intNumberOfRecords; intCounter++) { strAssetDescription = TheImportWaspToolAssetsDataSet.importassets[intCounter].AssetDescription; strAssetType = TheImportWaspToolAssetsDataSet.importassets[intCounter].AssetType; intAssetID = TheImportWaspToolAssetsDataSet.importassets[intCounter].AssetID; strBJCNumber = TheImportWaspToolAssetsDataSet.importassets[intCounter].BJCAssetID; strLocation = TheImportWaspToolAssetsDataSet.importassets[intCounter].Location; strManufacturer = TheImportWaspToolAssetsDataSet.importassets[intCounter].Manufacturer; strModel = TheImportWaspToolAssetsDataSet.importassets[intCounter].Model; strSerialNumber = TheImportWaspToolAssetsDataSet.importassets[intCounter].SerialNumber; blnFatalError = TheAssetClass.InsertWaspAssets(intAssetID, strAssetDescription, strBJCNumber, strAssetType, gstrSite, strLocation, MainWindow.gintWarehouseID, DateTime.Now, strSerialNumber, strManufacturer, strModel); if (blnFatalError == true) { throw new Exception(); } } } PleaseWait.Close(); dgrAssets.ItemsSource = TheImportWaspToolAssetsDataSet.importassets; } catch (Exception Ex) { TheEventLogClass.InsertEventLogEntry(DateTime.Now, "New Blue Jay ERP // Import Vehicle Assets // Import Excel " + Ex.Message); TheMessagesClass.ErrorMessage(Ex.ToString()); } }
private void expRemoveAsset_Expanded(object sender, RoutedEventArgs e) { bool blnFatalError = false; string strToolID; int intToolKey; int intRecordsReturned; try { const string message = "Are You Sure You Want To Remove This Asset?"; const string caption = "Are You Sure"; MessageBoxResult result = MessageBox.Show(message, caption, MessageBoxButton.YesNo, MessageBoxImage.Question); if (result == MessageBoxResult.Yes) { blnFatalError = TheAssetClass.DeleteWaspAsset(MainWindow.gintAssetID); if (blnFatalError == true) { throw new Exception(); } const string secmessage = "Are You Sure You Want To Remove This From The Tool Table?"; const string seccaption = "Are You Sure"; MessageBoxResult secresult = MessageBox.Show(secmessage, seccaption, MessageBoxButton.YesNo, MessageBoxImage.Question); if (secresult == MessageBoxResult.Yes) { strToolID = txtBJCAssetID.Text; if (strToolID.Length > 3) { TheFindActiveToolByToolIDDataSet = TheToolsClass.FindActiveToolByToolID(strToolID); intRecordsReturned = TheFindActiveToolByToolIDDataSet.FindActiveToolByToolID.Rows.Count; if (intRecordsReturned > 0) { intToolKey = TheFindActiveToolByToolIDDataSet.FindActiveToolByToolID[0].ToolKey; blnFatalError = TheToolsClass.DeleteTool(intToolKey); if (blnFatalError == true) { throw new Exception(); } } else if (intRecordsReturned < 1) { TheMessagesClass.ErrorMessage("The Tool Was Not Found"); } } } TheMessagesClass.InformationMessage("The Asset Has Been Deleted"); this.Close(); } } catch (Exception Ex) { TheEventLogClass.InsertEventLogEntry(DateTime.Now, "New Blue Jay ERP // Edit Wasp Asset // Remove Asset Expander " + Ex.Message); } }
private void btnProcess_Click(object sender, RoutedEventArgs e) { //setting up the local variables; bool blnFatalError = false; string strErrorMessage = ""; string strDescription; string strBJCAssetID; string strSerialNumber; string strManufacturer; string strModel; int intRecordsReturned; bool blnItemExists = false; int intToolKey = 0; string strPartNumber = ""; int intCurrentLocation = 0; decimal decPartCost = 0; string strToolNotes = ""; try { strDescription = txtDescription.Text; if (strDescription.Length < 6) { blnFatalError = true; strErrorMessage += "The Description is to Short\n"; } if (cboAssetCategory.SelectedIndex < 1) { blnFatalError = true; strErrorMessage += "The Category Was Not Selected\n"; } strBJCAssetID = txtBJCAssetID.Text; if (strBJCAssetID.Length < 4) { blnFatalError = true; strErrorMessage += "The BJC Asset ID is to Short\n"; } else { TheFindActiveToolByToolIDDataSet = TheToolsClass.FindActiveToolByToolID(strBJCAssetID); intRecordsReturned = TheFindActiveToolByToolIDDataSet.FindActiveToolByToolID.Rows.Count; if (intRecordsReturned > 0) { blnItemExists = true; intToolKey = TheFindActiveToolByToolIDDataSet.FindActiveToolByToolID[0].ToolKey; strPartNumber = TheFindActiveToolByToolIDDataSet.FindActiveToolByToolID[0].PartNumber; intCurrentLocation = TheFindActiveToolByToolIDDataSet.FindActiveToolByToolID[0].CurrentLocation; decPartCost = TheFindActiveToolByToolIDDataSet.FindActiveToolByToolID[0].ToolCost; strToolNotes = TheFindActiveToolByToolIDDataSet.FindActiveToolByToolID[0].ToolNotes; } } if (blnFatalError == true) { TheMessagesClass.ErrorMessage(strErrorMessage); return; } strSerialNumber = txtSerialNo.Text; strManufacturer = txtManufacturer.Text; strModel = txtModel.Text; blnFatalError = TheAssetClass.UpdateWaspAsset(MainWindow.gintAssetID, strDescription, gstrAssetCategory, strBJCAssetID, strSerialNumber, strManufacturer, strModel); if (blnFatalError == true) { throw new Exception(); } if (blnItemExists == false) { blnFatalError = TheToolsClass.InsertTools(strBJCAssetID, MainWindow.gintWarehouseID, strSerialNumber, MainWindow.gintCategoryID, strDescription, 0, MainWindow.gintWarehouseID); if (blnFatalError == true) { throw new Exception(); } } else if (blnItemExists == true) { blnFatalError = TheToolsClass.UpdateToolActive(intToolKey, true); if (blnFatalError == true) { throw new Exception(); } blnFatalError = TheToolsClass.UpdateToolCategory(intToolKey, MainWindow.gintCategoryID); if (blnFatalError == true) { throw new Exception(); } blnFatalError = TheToolsClass.UpdateToolInfo(intToolKey, strPartNumber, strDescription, intCurrentLocation, decPartCost, strToolNotes); if (blnFatalError == true) { throw new Exception(); } } TheMessagesClass.InformationMessage("The Asset has been Updated"); this.Close(); } catch (Exception Ex) { TheEventLogClass.InsertEventLogEntry(DateTime.Now, "New Blue Jay ERP // Edit Wasp Asset // Process Button " + Ex.Message); TheMessagesClass.ErrorMessage(Ex.ToString()); } }
private void cboAssetCategory_SelectionChanged(object sender, SelectionChangedEventArgs e) { //setting local variables int intSelectedIndex; int intRecordsReturned; string strToolID; bool blnToolExists; bool blnStringID; int intToolID; bool blnFatalError = false; string strBJCAssetID; try { intSelectedIndex = cboAssetCategory.SelectedIndex - 1; if ((intSelectedIndex > -1) && (gblnUploaded == true)) { strBJCAssetID = txtBJCAssetID.Text; if (strBJCAssetID.Length < 4) { MainWindow.gintCategoryID = TheFindSortedToolCategoryDataSet.FindSortedToolCategory[intSelectedIndex].CategoryID; gstrAssetCategory = TheFindSortedToolCategoryDataSet.FindSortedToolCategory[intSelectedIndex].ToolCategory; TheFindToolIDByCategoryDataSet = TheToolIDClass.FindToolIDByCategory(gstrAssetCategory); intRecordsReturned = TheFindToolIDByCategoryDataSet.FindToolIDByCategory.Rows.Count; if (intRecordsReturned > 0) { blnToolExists = true; strToolID = TheFindToolIDByCategoryDataSet.FindToolIDByCategory[0].ToolID; gintTransactionID = TheFindToolIDByCategoryDataSet.FindToolIDByCategory[0].TransactionID; blnStringID = TheDataValidationClass.VerifyIntegerData(strToolID); if (blnStringID == true) { txtBJCAssetID.Text = strToolID; } else if (blnStringID == false) { while (blnToolExists == true) { intToolID = Convert.ToInt32(strToolID); intToolID = intToolID + 1; strToolID = Convert.ToString(intToolID); blnFatalError = TheToolIDClass.UpdateToolID(gintTransactionID, strToolID); TheFindActiveToolByToolIDDataSet = TheToolsClass.FindActiveToolByToolID(strToolID); intRecordsReturned = TheFindActiveToolByToolIDDataSet.FindActiveToolByToolID.Rows.Count; if (intRecordsReturned < 1) { TheFindWaspAsssetByBJCAssetIDDataSet = TheAssetClass.FindWaspAssetByBJCAssetID(strToolID); intRecordsReturned = TheFindWaspAsssetByBJCAssetIDDataSet.FindWaspAssetByBJCAssetID.Rows.Count; if (intRecordsReturned < 1) { blnToolExists = false; } } } } txtBJCAssetID.Text = strToolID; } else { txtBJCAssetID.Text = "None Found"; TheMessagesClass.InformationMessage("There is not a Tool ID for this Tool in the Database, Please Look at Old Tool Spreadsheet"); } } else if (strBJCAssetID.Length > 3) { gstrAssetCategory = TheFindSortedToolCategoryDataSet.FindSortedToolCategory[intSelectedIndex].ToolCategory; MainWindow.gintCategoryID = TheFindSortedToolCategoryDataSet.FindSortedToolCategory[intSelectedIndex].CategoryID; } } } catch (Exception Ex) { TheEventLogClass.InsertEventLogEntry(DateTime.Now, "New Blue Jay ERP // Edit Wasp Asset // Tool Category Selection Changed " + Ex.Message); TheMessagesClass.ErrorMessage(Ex.ToString()); } }
private void cboSelectLocation_SelectionChanged(object sender, SelectionChangedEventArgs e) { Excel.Application xlDropOrder; Excel.Workbook xlDropBook; Excel.Worksheet xlDropSheet; Excel.Range range; int intColumnRange = 0; int intCounter; int intNumberOfRecords; int intRecordsReturned; int intAssetID; string strAssetDescription; string strSerialNumber; string strAssetType; string strBJCNumber; string strFirstName; string strLastName; bool blnFatalError = false; bool blnItemFound; int intTransactionID; int intSelectedIndex; int intEmployeeID; try { intSelectedIndex = cboSelectLocation.SelectedIndex - 1; if (intSelectedIndex > -1) { TheEmployeeToolAssetDataSet.employeetoolassets.Rows.Clear(); Microsoft.Win32.OpenFileDialog dlg = new Microsoft.Win32.OpenFileDialog(); dlg.FileName = "Document"; // Default file name dlg.DefaultExt = ".xlsx"; // Default file extension dlg.Filter = "Excel (.xlsx)|*.xlsx"; // Filter files by extension // Show open file dialog box Nullable <bool> result = dlg.ShowDialog(); // Process open file dialog box results if (result == true) { // Open document string filename = dlg.FileName; } PleaseWait PleaseWait = new PleaseWait(); PleaseWait.Show(); gstrLocation = TheFindSortedWaspAssetLocationsBySiteDataSet.FindSortedWaspAssetLoctionsBySite[intSelectedIndex].AssetLocation; xlDropOrder = new Excel.Application(); xlDropBook = xlDropOrder.Workbooks.Open(dlg.FileName, 0, true, 5, "", "", true, Microsoft.Office.Interop.Excel.XlPlatform.xlWindows, "\t", false, false, 0, true, 1, 0); xlDropSheet = (Excel.Worksheet)xlDropOrder.Worksheets.get_Item(1); range = xlDropSheet.UsedRange; intNumberOfRecords = range.Rows.Count; intColumnRange = range.Columns.Count; for (intCounter = 2; intCounter <= intNumberOfRecords; intCounter++) { TheWaspAssetIDDataSet = TheAssetClass.GetWaspAssetIDInfo(); intAssetID = TheWaspAssetIDDataSet.waspassetid[0].CreatedAssetID; intTransactionID = TheWaspAssetIDDataSet.waspassetid[0].TransactionID; blnFatalError = TheAssetClass.UpdateWaspAssetID(intTransactionID, intAssetID + 1); blnItemFound = false; strAssetType = "UNKNOWN"; if (((range.Cells[intCounter, 1] as Excel.Range).Value2) == null) { intCounter = intNumberOfRecords; break; } else { strAssetDescription = Convert.ToString((range.Cells[intCounter, 3] as Excel.Range).Value2).ToUpper(); if (((range.Cells[intCounter, 2] as Excel.Range).Value2) == null) { strBJCNumber = " "; } else { strBJCNumber = Convert.ToString((range.Cells[intCounter, 2] as Excel.Range).Value2).ToUpper(); } if (((range.Cells[intCounter, 5] as Excel.Range).Value2) == null) { strSerialNumber = " "; } else { strSerialNumber = Convert.ToString((range.Cells[intCounter, 5] as Excel.Range).Value2).ToUpper(); } if (((range.Cells[intCounter, 4] as Excel.Range).Value2) == null) { strAssetType = " "; } else { strAssetType = Convert.ToString((range.Cells[intCounter, 4] as Excel.Range).Value2).ToUpper(); } strFirstName = Convert.ToString((range.Cells[intCounter, 8] as Excel.Range).Value2).ToUpper(); strLastName = Convert.ToString((range.Cells[intCounter, 9] as Excel.Range).Value2).ToUpper(); if (strSerialNumber.Length > 2) { TheFindWaspAssetBySerialNumberDataSet = TheAssetClass.FindWaspAssetsBySerialNumber(strSerialNumber); intRecordsReturned = TheFindWaspAssetBySerialNumberDataSet.FindWaspAssetsBySerialNumber.Rows.Count; if (intRecordsReturned > 0) { blnItemFound = true; } } if (strBJCNumber.Length > 2) { TheFindWaspAssetByBJCAssetIDDataSet = TheAssetClass.FindWaspAssetByBJCAssetID(strBJCNumber); intRecordsReturned = TheFindWaspAssetByBJCAssetIDDataSet.FindWaspAssetByBJCAssetID.Rows.Count; if (intRecordsReturned > 0) { blnItemFound = true; } } } if (blnItemFound == false) { if (strBJCNumber.Length > 2) { TheFindActiveToolByToolIDDataSet = TheToolClass.FindActiveToolByToolID(strBJCNumber); intRecordsReturned = TheFindActiveToolByToolIDDataSet.FindActiveToolByToolID.Rows.Count; if (intRecordsReturned > 0) { strAssetType = TheFindActiveToolByToolIDDataSet.FindActiveToolByToolID[0].ToolCategory; strAssetDescription = TheFindActiveToolByToolIDDataSet.FindActiveToolByToolID[0].ToolDescription; } } } TheComboEmployeeDataSet = TheEmployeeClass.FillEmployeeComboBox(strLastName); EmployeeToolAssetDataSet.employeetoolassetsRow NewToolRow = TheEmployeeToolAssetDataSet.employeetoolassets.NewemployeetoolassetsRow(); NewToolRow.AssetID = intAssetID; NewToolRow.BJCAssetID = strBJCNumber; NewToolRow.EmployeeID = TheComboEmployeeDataSet.employees[0].EmployeeID; NewToolRow.FirstName = strFirstName; NewToolRow.LastName = strLastName; NewToolRow.Office = gstrSite; NewToolRow.ToolLocation = gstrLocation; NewToolRow.ToolCategory = strAssetType; NewToolRow.ToolDescription = strAssetDescription; TheEmployeeToolAssetDataSet.employeetoolassets.Rows.Add(NewToolRow); } xlDropOrder.Quit(); PleaseWait.Close(); } dgrAssets.ItemsSource = TheEmployeeToolAssetDataSet.employeetoolassets; } catch (Exception Ex) { TheEventLogClass.InsertEventLogEntry(DateTime.Now, "New Blue Jay ERP // Import Vehicle Assets // Import Excel " + Ex.Message); TheMessagesClass.ErrorMessage(Ex.ToString()); } }
private void mitCreateTool_Click(object sender, RoutedEventArgs e) { //creating local variables int intSelectedIndex; string strValueForValidation; string strPartNumber; string strDescription; string strToolID; decimal decToolCost = 0; string strErrorMessage = ""; bool blnThereIsAProblem = false; bool blnFatalError = false; int intRecordsReturned; try { //data validation intSelectedIndex = cboSelectWarehouse.SelectedIndex; if (intSelectedIndex < 1) { blnFatalError = true; strErrorMessage += "The Warehouse Was Not Selected\n"; } intSelectedIndex = cboToolCategory.SelectedIndex; if (intSelectedIndex < 1) { blnFatalError = true; strErrorMessage += "The Tool Category Was Not Selected\n"; } strToolID = txtToolID.Text; if (strToolID == "") { blnFatalError = true; strErrorMessage += "Tool ID Was Not Entered\n"; } else { TheFindActiveToolByToolIdDataSet = TheToolsClass.FindActiveToolByToolID(strToolID); intRecordsReturned = TheFindActiveToolByToolIdDataSet.FindActiveToolByToolID.Rows.Count; if (intRecordsReturned > 0) { blnFatalError = true; strErrorMessage += "There is Already an Active Tool With This ID\n"; } } strPartNumber = txtPartNumber.Text; if (strPartNumber == "") { blnFatalError = true; strErrorMessage += "The Tool Part Number Was Not Added\n"; } strDescription = txtDescription.Text; if (strDescription == "") { blnFatalError = true; strErrorMessage += "The Tool Description Was Not Added\n"; } strValueForValidation = txtPartCost.Text; blnThereIsAProblem = TheDataValidationClass.VerifyDoubleData(strValueForValidation); if (blnThereIsAProblem == true) { blnFatalError = true; strErrorMessage += "The Tool Cost is not Numeric\n"; } else { decToolCost = Convert.ToDecimal(strValueForValidation); } if (blnFatalError == true) { TheMessagesClass.ErrorMessage(strErrorMessage); return; } if (gblnNewToolCategory == true) { blnFatalError = TheToolIDClass.InsertNewToolIDForToolType(gintCategoryID, strToolID); if (blnFatalError == true) { throw new Exception(); } } else if (gblnNewToolCategory == false) { blnFatalError = TheToolIDClass.UpdateToolID(gintTransactionID, strToolID); if (blnFatalError == true) { throw new Exception(); } } blnFatalError = TheToolsClass.InsertTools(strToolID, gintWarehouseID, strPartNumber, gintCategoryID, strDescription, decToolCost, gintWarehouseID); if (blnFatalError == true) { throw new Exception(); } ResetControls(); TheMessagesClass.InformationMessage("The Tool Has Been Created"); } catch (Exception Ex) { TheEventLogClass.InsertEventLogEntry(DateTime.Now, "Blue Jay ERP // Create Tool // Create Tool Menu Item " + Ex.Message); TheMessagesClass.ErrorMessage(Ex.ToString()); } }
private void cboSelectToolCategory_SelectionChanged(object sender, SelectionChangedEventArgs e) { //setting local variables int intSelectedIndex; string strToolCategory; int intRecordsReturned; string strToolID; int intToolID; bool blnToolFound; try { intSelectedIndex = cboSelectToolCategory.SelectedIndex - 1; if (intSelectedIndex > -1) { MainWindow.gintCategoryID = TheFindSortedToolCategoryDataSet.FindSortedToolCategory[intSelectedIndex].CategoryID; strToolCategory = TheFindSortedToolCategoryDataSet.FindSortedToolCategory[intSelectedIndex].ToolCategory; TheFindToolIDByCategoryDataSet = TheToolIDClass.FindToolIDByCategory(strToolCategory); intRecordsReturned = TheFindToolIDByCategoryDataSet.FindToolIDByCategory.Rows.Count; if (intRecordsReturned > 0) { blnToolFound = true; while (blnToolFound == true) { strToolID = TheFindToolIDByCategoryDataSet.FindToolIDByCategory[0].ToolID; intToolID = Convert.ToInt32(strToolID); intToolID++; strToolID = Convert.ToString(intToolID); TheFindActiveToolByToolIDDataSet = TheToolsClass.FindActiveToolByToolID(strToolID); intRecordsReturned = TheFindActiveToolByToolIDDataSet.FindActiveToolByToolID.Rows.Count; if (intRecordsReturned < 1) { blnToolFound = false; } txtToolID.Text = strToolID; gintTransactionID = TheFindToolIDByCategoryDataSet.FindToolIDByCategory[0].TransactionID; gblnNewToolCategory = false; } } else { txtToolID.Text = "None Found"; TheMessagesClass.InformationMessage("There is not a Tool ID for this Tool in the Database, Please Contact IT"); gblnNewToolCategory = true; } } } catch (Exception Ex) { TheEventLogClass.InsertEventLogEntry(DateTime.Now, "New Blue Jay ERP // Add New Tool // Tool Category Selection Changed " + Ex.Message); TheSendEmailClass.SendEventLog(Ex.ToString()); TheMessagesClass.ErrorMessage(Ex.ToString()); } }
private void Window_Loaded(object sender, RoutedEventArgs e) { //this will load up the controls int intCounter; int intNumberOfRecords; int intRecordsReturned; string strCategory; try { TheFindSortedToolCategoryDataSet = TheToolCategoryClass.FindSortedToolCategory(); gblnItemEntered = false; intNumberOfRecords = TheFindSortedToolCategoryDataSet.FindSortedToolCategory.Rows.Count; cboSelectToolCategory.Items.Clear(); cboSelectToolCategory.Items.Add("Select Tool Category"); cboSelectEmployee.Items.Clear(); for (intCounter = 0; intCounter < intNumberOfRecords; intCounter++) { cboSelectToolCategory.Items.Add(TheFindSortedToolCategoryDataSet.FindSortedToolCategory[intCounter].ToolCategory); } cboSelectToolCategory.SelectedIndex = 0; txtAssetID.Text = Convert.ToString(MainWindow.gintAssetID); txtSite.Text = ImportToolSheets.gstrSite; txtLocation.Text = ImportToolSheets.gstrLocation; txtBJCAssetID.Text = ImportToolSheets.gstrBJCAssetID; txtLastName.Text = ImportToolSheets.gstrLastName; txtToolDescription.Text = ImportToolSheets.gstrToolDescription; TheFindActiveToolByToolIDDataSet = TheToolClass.FindActiveToolByToolID(ImportToolSheets.gstrBJCAssetID); intRecordsReturned = TheFindActiveToolByToolIDDataSet.FindActiveToolByToolID.Rows.Count; if (intRecordsReturned > 0) { intNumberOfRecords = TheFindSortedToolCategoryDataSet.FindSortedToolCategory.Rows.Count; for (intCounter = 0; intCounter < intNumberOfRecords; intCounter++) { strCategory = TheFindActiveToolByToolIDDataSet.FindActiveToolByToolID[0].ToolCategory; if (strCategory == TheFindSortedToolCategoryDataSet.FindSortedToolCategory[intCounter].ToolCategory) { cboSelectToolCategory.SelectedIndex = intCounter + 1; txtPartNumber.Text = "NOT NEEDED"; gblnItemEntered = true; txtToolNotes.Text = TheFindActiveToolByToolIDDataSet.FindActiveToolByToolID[0].ToolNotes; txtToolDescription.Text = TheFindActiveToolByToolIDDataSet.FindActiveToolByToolID[0].ToolDescription; MainWindow.gintToolKey = TheFindActiveToolByToolIDDataSet.FindActiveToolByToolID[0].ToolKey; } } } } catch (Exception Ex) { TheEventLogClass.InsertEventLogEntry(DateTime.Now, "New Blue Jay ERP // Assign Tool Asset // Window Loaded Method " + Ex.Message); TheMessagesClass.ErrorMessage(Ex.ToString()); } }
private void btnProcess_Click(object sender, RoutedEventArgs e) { string strPartNumber; string strSerialNumber = ""; string strToolNotes; bool blnFatalError = false; string strErrorMessage = ""; int intRecordsReturned; int intToolKey; int intEmployeeID; try { intEmployeeID = MainWindow.TheVerifyLogonDataSet.VerifyLogon[0].EmployeeID; if (cboSelectToolCategory.SelectedIndex < 1) { blnFatalError = true; strErrorMessage += "The Tool Category was not Selected\n"; } ImportToolSheets.gstrBJCAssetID = txtBJCAssetID.Text; if (ImportToolSheets.gstrBJCAssetID.Length < 4) { blnFatalError = true; strErrorMessage += "The BJC Number Was Not Assigned\n"; } ImportToolSheets.gstrToolDescription = txtToolDescription.Text; if (ImportToolSheets.gstrToolDescription.Length < 10) { blnFatalError = true; strErrorMessage += "The Tool Description was not Long Enough\n"; } if (cboSelectEmployee.SelectedIndex < 1) { blnFatalError = true; strErrorMessage += "The Employee Was Not Selected\n"; } strPartNumber = txtPartNumber.Text; if (strPartNumber.Length < 4) { strPartNumber = ""; } strToolNotes = txtToolNotes.Text; if (strToolNotes.Length < 10) { strToolNotes = "NO NOTES ENTERED"; } if (blnFatalError == true) { TheMessagesClass.ErrorMessage(strErrorMessage); return; } TheFindActiveToolByToolIDDataSet = TheToolClass.FindActiveToolByToolID(ImportToolSheets.gstrBJCAssetID); intRecordsReturned = TheFindActiveToolByToolIDDataSet.FindActiveToolByToolID.Rows.Count; if (intRecordsReturned < 1) { blnFatalError = TheToolClass.InsertTools(ImportToolSheets.gstrBJCAssetID, MainWindow.gintEmployeeID, strPartNumber, MainWindow.gintCategoryID, ImportToolSheets.gstrToolDescription, 0, MainWindow.gintWarehouseID); if (blnFatalError == true) { throw new Exception(); } TheFindActiveToolByToolIDDataSet = TheToolClass.FindActiveToolByToolID(ImportToolSheets.gstrBJCAssetID); } intToolKey = TheFindActiveToolByToolIDDataSet.FindActiveToolByToolID[0].ToolKey; blnFatalError = TheToolClass.UpdateToolSignOut(intToolKey, MainWindow.gintEmployeeID, false); if (blnFatalError == true) { throw new Exception(); } blnFatalError = TheToolHistoryClass.InsertToolHistory(intToolKey, MainWindow.gintEmployeeID, intEmployeeID, "ASSIGNED FROM TOOL SHEEET DURING WASP ASSET IMPORT"); if (blnFatalError == true) { throw new Exception(); } TheFindWaspAssetByBJCAssetIDDataSet = TheAssetClass.FindWaspAssetByBJCAssetID(ImportToolSheets.gstrBJCAssetID); intRecordsReturned = TheFindWaspAssetByBJCAssetIDDataSet.FindWaspAssetByBJCAssetID.Rows.Count; if (intRecordsReturned < 1) { blnFatalError = TheAssetClass.InsertWaspAssets(MainWindow.gintAssetID, ImportToolSheets.gstrToolDescription, ImportToolSheets.gstrBJCAssetID, ImportToolSheets.gstrToolCategory, ImportToolSheets.gstrSite, ImportToolSheets.gstrLocation, MainWindow.gintWarehouseID, DateTime.Now, strSerialNumber, " ", " "); if (blnFatalError == true) { throw new Exception(); } } TheMessagesClass.InformationMessage("The Tool Has Been Updated and Imported"); this.Close(); } catch (Exception Ex) { TheEventLogClass.InsertEventLogEntry(DateTime.Now, "New Blue Jay ERP // Assigned Tool Asset // Process Button " + Ex.Message); TheMessagesClass.ErrorMessage(Ex.ToString()); } }
private void btnFind_Click(object sender, RoutedEventArgs e) { string strValueForValidation; string strToolID = ""; bool blnFatalError = false; bool blnThereIsAProblem = false; string strErrorMessage = ""; int intCounter; int intNumberOfRecords; int intWarehouseEmployee; string strWarehouseEmployeeName; try { strValueForValidation = txtStartDate.Text; blnThereIsAProblem = TheDataValidationClass.VerifyDateData(strValueForValidation); if (blnThereIsAProblem == true) { blnFatalError = true; strErrorMessage += "The Start Date is not a Date\n"; } else { gdatStartDate = 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 { gdatEndDate = Convert.ToDateTime(strValueForValidation); gdatEndDate = TheDataSearchClass.AddingDays(gdatEndDate, 1); } if (gstrToolHistoryType == "Employee Search") { if (cboSelectEmployee.SelectedIndex == 0) { blnFatalError = true; strErrorMessage += "Employee Was Not Selected\n"; } } if (gstrToolHistoryType == "Tool ID Search") { strToolID = txtEnterLastName.Text; if (strToolID == "") { blnFatalError = true; strErrorMessage += "Tool ID Was Not Entered\n"; } } if (blnFatalError == true) { TheMessagesClass.ErrorMessage(strErrorMessage); return; } TheViewToolHistoryDataSet.toolhistory.Rows.Clear(); if (gstrToolHistoryType == "Date Range Search") { TheFindToolHistoryByDateRangeDataSet = TheToolHistoryClass.FindToolHistoryByDateRange(gdatStartDate, gdatEndDate); intNumberOfRecords = TheFindToolHistoryByDateRangeDataSet.FindToolHistoryByDateRange.Rows.Count - 1; if (intNumberOfRecords > -1) { for (intCounter = 0; intCounter <= intNumberOfRecords; intCounter++) { intWarehouseEmployee = TheFindToolHistoryByDateRangeDataSet.FindToolHistoryByDateRange[intCounter].WarehouseEmployeeID; TheFindEmployeeByEmployeeIDDataSet = TheEmployeeClass.FindEmployeeByEmployeeID(intWarehouseEmployee); strWarehouseEmployeeName = TheFindEmployeeByEmployeeIDDataSet.FindEmployeeByEmployeeID[0].FirstName + " " + TheFindEmployeeByEmployeeIDDataSet.FindEmployeeByEmployeeID[0].LastName; ViewToolHistoryDataSet.toolhistoryRow NewHistoryRow = TheViewToolHistoryDataSet.toolhistory.NewtoolhistoryRow(); NewHistoryRow.LastName = TheFindToolHistoryByDateRangeDataSet.FindToolHistoryByDateRange[intCounter].LastName; NewHistoryRow.Description = TheFindToolHistoryByDateRangeDataSet.FindToolHistoryByDateRange[intCounter].ToolDescription; NewHistoryRow.FirstName = TheFindToolHistoryByDateRangeDataSet.FindToolHistoryByDateRange[intCounter].FirstName; NewHistoryRow.ToolID = TheFindToolHistoryByDateRangeDataSet.FindToolHistoryByDateRange[intCounter].ToolID; NewHistoryRow.TransactionDate = TheFindToolHistoryByDateRangeDataSet.FindToolHistoryByDateRange[intCounter].TransactionDate; NewHistoryRow.TransactionID = TheFindToolHistoryByDateRangeDataSet.FindToolHistoryByDateRange[intCounter].TransactionID; NewHistoryRow.TransactionNotes = TheFindToolHistoryByDateRangeDataSet.FindToolHistoryByDateRange[intCounter].TransactionNotes; NewHistoryRow.WarehouseEmployee = strWarehouseEmployeeName; TheViewToolHistoryDataSet.toolhistory.Rows.Add(NewHistoryRow); } } } else if (gstrToolHistoryType == "Employee Search") { TheFindToolHistoryByEmployeeIDDataSet = TheToolHistoryClass.FindToolHistoryByEmployeeID(gdatStartDate, gdatEndDate, MainWindow.gintEmployeeID); intNumberOfRecords = TheFindToolHistoryByEmployeeIDDataSet.FindToolHistoryByEmployeeID.Rows.Count - 1; if (intNumberOfRecords > -1) { for (intCounter = 0; intCounter <= intNumberOfRecords; intCounter++) { intWarehouseEmployee = TheFindToolHistoryByEmployeeIDDataSet.FindToolHistoryByEmployeeID[intCounter].WarehouseEmployeeID; TheFindEmployeeByEmployeeIDDataSet = TheEmployeeClass.FindEmployeeByEmployeeID(intWarehouseEmployee); strWarehouseEmployeeName = TheFindEmployeeByEmployeeIDDataSet.FindEmployeeByEmployeeID[0].FirstName + " " + TheFindEmployeeByEmployeeIDDataSet.FindEmployeeByEmployeeID[0].LastName; ViewToolHistoryDataSet.toolhistoryRow NewHistoryRow = TheViewToolHistoryDataSet.toolhistory.NewtoolhistoryRow(); NewHistoryRow.LastName = TheFindToolHistoryByEmployeeIDDataSet.FindToolHistoryByEmployeeID[intCounter].LastName; NewHistoryRow.Description = TheFindToolHistoryByEmployeeIDDataSet.FindToolHistoryByEmployeeID[intCounter].ToolDescription; NewHistoryRow.FirstName = TheFindToolHistoryByEmployeeIDDataSet.FindToolHistoryByEmployeeID[intCounter].FirstName; NewHistoryRow.ToolID = TheFindToolHistoryByEmployeeIDDataSet.FindToolHistoryByEmployeeID[intCounter].ToolID; NewHistoryRow.TransactionDate = TheFindToolHistoryByEmployeeIDDataSet.FindToolHistoryByEmployeeID[intCounter].TransactionDate; NewHistoryRow.TransactionID = TheFindToolHistoryByEmployeeIDDataSet.FindToolHistoryByEmployeeID[intCounter].TransactionID; NewHistoryRow.TransactionNotes = TheFindToolHistoryByEmployeeIDDataSet.FindToolHistoryByEmployeeID[intCounter].TransactionNotes; NewHistoryRow.WarehouseEmployee = strWarehouseEmployeeName; TheViewToolHistoryDataSet.toolhistory.Rows.Add(NewHistoryRow); } } } else if (gstrToolHistoryType == "Tool ID Search") { TheFindActiveToolByToolIDDataSet = TheToolsClass.FindActiveToolByToolID(strToolID); intNumberOfRecords = TheFindActiveToolByToolIDDataSet.FindActiveToolByToolID.Rows.Count; if (intNumberOfRecords == 0) { TheMessagesClass.ErrorMessage("The Tool is not Active or Does Not Exist"); return; } MainWindow.gintToolKey = TheFindActiveToolByToolIDDataSet.FindActiveToolByToolID[0].ToolKey; TheFindToolHistoryByToolKeyDataSet = TheToolHistoryClass.FindToolHistoryByToolKey(gdatStartDate, gdatEndDate, MainWindow.gintToolKey); intNumberOfRecords = TheFindToolHistoryByToolKeyDataSet.FindToolHistoryByToolKey.Rows.Count - 1; if (intNumberOfRecords > -1) { for (intCounter = 0; intCounter <= intNumberOfRecords; intCounter++) { intWarehouseEmployee = TheFindToolHistoryByToolKeyDataSet.FindToolHistoryByToolKey[intCounter].WarehouseEmployeeID; TheFindEmployeeByEmployeeIDDataSet = TheEmployeeClass.FindEmployeeByEmployeeID(intWarehouseEmployee); strWarehouseEmployeeName = TheFindEmployeeByEmployeeIDDataSet.FindEmployeeByEmployeeID[0].FirstName + " " + TheFindEmployeeByEmployeeIDDataSet.FindEmployeeByEmployeeID[0].LastName; ViewToolHistoryDataSet.toolhistoryRow NewHistoryRow = TheViewToolHistoryDataSet.toolhistory.NewtoolhistoryRow(); NewHistoryRow.LastName = TheFindToolHistoryByToolKeyDataSet.FindToolHistoryByToolKey[intCounter].LastName; NewHistoryRow.Description = TheFindToolHistoryByToolKeyDataSet.FindToolHistoryByToolKey[intCounter].ToolDescription; NewHistoryRow.FirstName = TheFindToolHistoryByToolKeyDataSet.FindToolHistoryByToolKey[intCounter].FirstName; NewHistoryRow.ToolID = TheFindToolHistoryByToolKeyDataSet.FindToolHistoryByToolKey[intCounter].ToolID; NewHistoryRow.TransactionDate = TheFindToolHistoryByToolKeyDataSet.FindToolHistoryByToolKey[intCounter].TransactionDate; NewHistoryRow.TransactionID = TheFindToolHistoryByToolKeyDataSet.FindToolHistoryByToolKey[intCounter].TransactionID; NewHistoryRow.TransactionNotes = TheFindToolHistoryByToolKeyDataSet.FindToolHistoryByToolKey[intCounter].TransactionNotes; NewHistoryRow.WarehouseEmployee = strWarehouseEmployeeName; TheViewToolHistoryDataSet.toolhistory.Rows.Add(NewHistoryRow); } } } dgrResults.ItemsSource = TheViewToolHistoryDataSet.toolhistory; } catch (Exception Ex) { TheEventLogClass.InsertEventLogEntry(DateTime.Now, "Blue Jay ERP // Tool History // Find Button " + Ex.Message); TheMessagesClass.ErrorMessage(Ex.ToString()); } }
private void btnProcess_Click(object sender, RoutedEventArgs e) { //SETTING UP LOCAL VARIABLES int intAssetID; DateTime datTransactionDate = DateTime.Now; string strDescription; string strBJCAssetID; string strSite; string strLocation; string strSerialNumber; string strManufacturer; string strModel; string strErrorMessage = ""; bool blnFatalError = false; int intRecordsReturned; int intEmployeeID; try { intEmployeeID = MainWindow.TheVerifyLogonDataSet.VerifyLogon[0].EmployeeID; intAssetID = Convert.ToInt32(txtAssetID.Text); strDescription = txtDescription.Text; if (strDescription.Length < 10) { blnFatalError = true; strErrorMessage += "The Description is not Long Enough\n"; } if (cboAssetCategory.SelectedIndex < 1) { blnFatalError = true; strErrorMessage += "The Category was not Selected\n"; } strBJCAssetID = txtBJCAssetID.Text; if (strBJCAssetID.Length < 3) { blnFatalError = true; strErrorMessage += "The BJC Asset ID is not Long Enough\n"; } else { TheFindActiveToolByToolIDDataSet = TheToolsClass.FindActiveToolByToolID(strBJCAssetID); intRecordsReturned = TheFindActiveToolByToolIDDataSet.FindActiveToolByToolID.Rows.Count; if (intRecordsReturned > 0) { blnFatalError = true; strErrorMessage += "The BJC Asset ID Is Already in the Data Base\n"; } } strSite = txtSite.Text; strSerialNumber = txtSerialNo.Text; strManufacturer = txtManufacturer.Text; strModel = txtModel.Text; if (blnFatalError == true) { TheMessagesClass.ErrorMessage(strErrorMessage); return; } blnFatalError = TheAssetClass.InsertWaspAssets(intAssetID, strDescription, strBJCAssetID, gstrAssetCategory, strSite, MainWindow.gstrAssetLocation, MainWindow.gintWarehouseID, datTransactionDate, strSerialNumber, strManufacturer, strModel); if (blnFatalError == true) { throw new Exception(); } if (gblnTool == true) { blnFatalError = TheToolsClass.InsertTools(strBJCAssetID, MainWindow.gintWarehouseID, " ", MainWindow.gintCategoryID, strDescription, 0, MainWindow.gintWarehouseID); if (blnFatalError == true) { throw new Exception(); } } TheMessagesClass.InformationMessage("The Asset Has Been Added"); this.Close(); } catch (Exception Ex) { TheSendEmailClass.SendEventLog("New Blue Jay ERP // Add Wasp Asset // Process Button " + Ex.Message); TheEventLogClass.InsertEventLogEntry(DateTime.Now, "New Blue Jay ERP // Add Wasp Asset // Process Button " + Ex.Message); TheMessagesClass.ErrorMessage(Ex.ToString()); } }
private void btnFind_Click(object sender, RoutedEventArgs e) { //setting up local variables string strToolID; int intRecordsReturned; string strMessage; string strCaption; try { strToolID = txtEnterToolID.Text; if (strToolID == "") { TheMessagesClass.ErrorMessage("Tool ID Was Not Entered"); return; } TheFindActiveToolByToolIDDataSet = TheToolsClass.FindActiveToolByToolID(strToolID); intRecordsReturned = TheFindActiveToolByToolIDDataSet.FindActiveToolByToolID.Rows.Count; if (intRecordsReturned == 0) { TheMessagesClass.ErrorMessage("Tool is not Active or Does Not Exist"); return; } if (TheFindActiveToolByToolIDDataSet.FindActiveToolByToolID[0].Available == false) { strMessage = "Tool Is Currently Signed Out, Do You Want To Sign Tool In"; strCaption = "Please Select"; MainWindow.gstrToolID = strToolID; MessageBoxResult result = MessageBox.Show(strMessage, strCaption, MessageBoxButton.YesNo, MessageBoxImage.Question); if (result == MessageBoxResult.Yes) { SignToolInFromForm SignToolInFromForm = new SignToolInFromForm(); SignToolInFromForm.ShowDialog(); if (MainWindow.gblnToolSignedIn == false) { TheMessagesClass.InformationMessage("The Tool Was Not Signed In, the Transaction Will Not Proceed"); mitSignOutTool.IsEnabled = false; return; } TheFindActiveToolByToolIDDataSet = TheToolsClass.FindActiveToolByToolID(strToolID); } else { return; } } MainWindow.gintToolKey = TheFindActiveToolByToolIDDataSet.FindActiveToolByToolID[0].ToolKey; MainWindow.gblnToolSignedIn = true; txtDescription.Text = TheFindActiveToolByToolIDDataSet.FindActiveToolByToolID[0].ToolDescription; } catch (Exception Ex) { TheEventLogClass.InsertEventLogEntry(DateTime.Now, "Blue Jay ERP // Sign Out Tool // Find Button " + Ex.Message); TheMessagesClass.ErrorMessage(Ex.ToString()); } }