private void ResetControls() { txtEnterItem.Text = ""; TheFindITAssetBySerialNumberDataSet = TheITAssetsClass.FindITAssetBySerialNumber("f**k you asshole"); dgrResults.ItemsSource = TheFindITAssetBySerialNumberDataSet.FindITAssetBySerialNumber; }
private void BtnFind_Click(object sender, RoutedEventArgs e) { int intRecordsReturned; string strItem; try { strItem = txtEnterItem.Text; if (strItem == "") { TheMessagesClass.ErrorMessage("The Item Or Serial Number Were\nNot Entered"); return; } TheFindITAssetBySerialNumber = TheITAssetClass.FindITAssetBySerialNumber(strItem); intRecordsReturned = TheFindITAssetBySerialNumber.FindITAssetBySerialNumber.Rows.Count; if (intRecordsReturned == 1) { txtHomeOffice.Text = TheFindITAssetBySerialNumber.FindITAssetBySerialNumber[0].HomeOffice; txtItem.Text = TheFindITAssetBySerialNumber.FindITAssetBySerialNumber[0].Item; txtManufacturer.Text = TheFindITAssetBySerialNumber.FindITAssetBySerialNumber[0].Manufacturer; txtModel.Text = TheFindITAssetBySerialNumber.FindITAssetBySerialNumber[0].Model; txtSerialNumber.Text = TheFindITAssetBySerialNumber.FindITAssetBySerialNumber[0].SerialNumber; gintItemID = TheFindITAssetBySerialNumber.FindITAssetBySerialNumber[0].ItemID; } else { TheFindITAssetsByItemDataSet = TheITAssetClass.FindITAssetsByItem(strItem); intRecordsReturned = TheFindITAssetsByItemDataSet.FindITAssetByItem.Rows.Count; if (intRecordsReturned == 1) { txtHomeOffice.Text = TheFindITAssetsByItemDataSet.FindITAssetByItem[0].HomeOffice; txtItem.Text = TheFindITAssetsByItemDataSet.FindITAssetByItem[0].Item; txtManufacturer.Text = TheFindITAssetsByItemDataSet.FindITAssetByItem[0].Manufacturer; txtModel.Text = TheFindITAssetsByItemDataSet.FindITAssetByItem[0].Model; txtSerialNumber.Text = TheFindITAssetsByItemDataSet.FindITAssetByItem[0].SerialNumber; gintItemID = TheFindITAssetsByItemDataSet.FindITAssetByItem[0].ItemID; } else { TheMessagesClass.ErrorMessage("Asset not Found or Be More specific"); return; } } } catch (Exception Ex) { TheEventLogClass.InsertEventLogEntry(DateTime.Now, "Blue Jay ERP // Sign Out IT Asset // Find Button " + Ex.Message); TheMessagesClass.ErrorMessage(Ex.ToString()); } }
public FindITAssetBySerialNumberDataSet FindITAssetBySerialNumber(string strSerialNumber) { try { aFindITAssetBySerialNumberDataSet = new FindITAssetBySerialNumberDataSet(); aFindITAssetBySerialNumberTableAdapter = new FindITAssetBySerialNumberDataSetTableAdapters.FindITAssetBySerialNumberTableAdapter(); aFindITAssetBySerialNumberTableAdapter.Fill(aFindITAssetBySerialNumberDataSet.FindITAssetBySerialNumber, strSerialNumber); } catch (Exception Ex) { TheEventLogClass.InsertEventLogEntry(DateTime.Now, "IT Asset Class // Find IT Asset By Serial Number " + Ex.Message); } return(aFindITAssetBySerialNumberDataSet); }
private void BtnFind_Click(object sender, RoutedEventArgs e) { string strSerialNumber; int intRecordsReturned; try { strSerialNumber = txtEnterSerialNumber.Text; if (strSerialNumber == "") { TheMessagesClass.ErrorMessage("Serial Number Was Not Entered"); return; } TheFindITAssetBySerialNumberDataSet = TheITAssetsClass.FindITAssetBySerialNumber(strSerialNumber); intRecordsReturned = TheFindITAssetBySerialNumberDataSet.FindITAssetBySerialNumber.Rows.Count; if (intRecordsReturned == 0) { TheMessagesClass.ErrorMessage("The Serial Number was not Found"); return; } //loading controls gintItemID = TheFindITAssetBySerialNumberDataSet.FindITAssetBySerialNumber[0].ItemID; txtItemID.Text = Convert.ToString(gintItemID); txtItem.Text = TheFindITAssetBySerialNumberDataSet.FindITAssetBySerialNumber[0].Item; txtManufacturer.Text = TheFindITAssetBySerialNumberDataSet.FindITAssetBySerialNumber[0].Manufacturer; txtModel.Text = TheFindITAssetBySerialNumberDataSet.FindITAssetBySerialNumber[0].Model; txtHomeOffice.Text = TheFindITAssetBySerialNumberDataSet.FindITAssetBySerialNumber[0].HomeOffice; mitProcess.IsEnabled = true; } catch (Exception Ex) { TheEventLogClass.InsertEventLogEntry(DateTime.Now, "Blue Jay ERP // Retire IT Assets // Find Button " + Ex.Message); TheMessagesClass.ErrorMessage(Ex.ToString()); } }
private void TxtEnterItem_TextChanged(object sender, TextChangedEventArgs e) { string strSerialNumber; int intLength; int intRecordsReturned; strSerialNumber = txtEnterItem.Text; intLength = strSerialNumber.Length; if (intLength > 4) { TheFindITAssetBySerialNumberDataSet = TheITAssetsClass.FindITAssetBySerialNumber(strSerialNumber); intRecordsReturned = TheFindITAssetBySerialNumberDataSet.FindITAssetBySerialNumber.Rows.Count; if (intRecordsReturned == 0) { TheFindITAssetsByItemDataSet = TheITAssetsClass.FindITAssetsByItem(strSerialNumber); intRecordsReturned = TheFindITAssetsByItemDataSet.FindITAssetByItem.Rows.Count; if (intRecordsReturned < 1) { TheMessagesClass.ErrorMessage("No Records Found"); return; } dgrResults.ItemsSource = TheFindITAssetsByItemDataSet.FindITAssetByItem; } else { dgrResults.ItemsSource = TheFindITAssetBySerialNumberDataSet.FindITAssetBySerialNumber; } } }
private void expProcessImport_Expanded(object sender, RoutedEventArgs e) { int intCounter; int intNumberOfRecords; bool blnFatalError = false; int intItemID; string strItem; string strManufacturer; string strModel; string strSerialNumber; int intQuantity; decimal decValue = 0; string strUpgrades = "NONE"; int intWarehouseID; int intRecordsReturned; try { intNumberOfRecords = TheImportITAssetsDataSet.importitassets.Rows.Count; for (intCounter = 0; intCounter < intNumberOfRecords; intCounter++) { intItemID = TheImportITAssetsDataSet.importitassets[intCounter].ItemID; strItem = TheImportITAssetsDataSet.importitassets[intCounter].Item; strManufacturer = TheImportITAssetsDataSet.importitassets[intCounter].Manufacturer; strModel = TheImportITAssetsDataSet.importitassets[intCounter].Model; strSerialNumber = TheImportITAssetsDataSet.importitassets[intCounter].SerialNumber; intQuantity = TheImportITAssetsDataSet.importitassets[intCounter].Quantity; intWarehouseID = TheImportITAssetsDataSet.importitassets[intCounter].WarehouseID; if (intItemID > 1000) { blnFatalError = TheITAssetsClass.UpdateITAssetLocation(intItemID, intWarehouseID); if (blnFatalError == true) { throw new Exception(); } } else { TheFindITAssetBySerialNumberDataSet = TheITAssetsClass.FindITAssetBySerialNumber(strSerialNumber); intRecordsReturned = TheFindITAssetByItemIDDataSet.FindITAssetByItemID.Rows.Count; if (intRecordsReturned > 0) { blnFatalError = TheITAssetsClass.UpdateITAssetLocation(intItemID, intWarehouseID); if (blnFatalError == true) { throw new Exception(); } } else if (intRecordsReturned < 1) { blnFatalError = TheITAssetsClass.InsertITAsset(strItem, strManufacturer, strModel, strSerialNumber, intQuantity, decValue, strUpgrades, intWarehouseID); if (blnFatalError == true) { throw new Exception(); } } } } TheMessagesClass.InformationMessage("The Records have been Updated"); ResetControls(); } catch (Exception Ex) { TheEventLogClass.InsertEventLogEntry(DateTime.Now, "New Blue Jay ERP // Import IT Assets // Process Import Expander " + Ex.Message); TheMessagesClass.ErrorMessage(Ex.ToString()); } }