private void ResetControls() { //setting back to default TheFindWarehouseByWarehouseNameDataSet = TheEmployeeClass.FindWarehouseByWarehouseName(""); TheImportITAssetsDataSet.importitassets.Rows.Clear(); dgrAssets.ItemsSource = TheImportITAssetsDataSet.importitassets; }
public FindWarehouseByWarehouseNameDataSet FindWarehouseByWarehouseName(string strWarehouseName) { try { aFindWarehouseByWarehouseNameDataSet = new FindWarehouseByWarehouseNameDataSet(); aFindWarehouseByWarehouseNameTableAdapter = new FindWarehouseByWarehouseNameDataSetTableAdapters.FindWarehouseByWarehouseNameTableAdapter(); aFindWarehouseByWarehouseNameTableAdapter.Fill(aFindWarehouseByWarehouseNameDataSet.FindWarehouseByWarehouseName, strWarehouseName); } catch (Exception Ex) { TheEventLogClass.InsertEventLogEntry(DateTime.Now, "Employee Class // Find Warehouse By Warehouse Name " + Ex.Message); } return(aFindWarehouseByWarehouseNameDataSet); }
private void expImportExcel_Expanded(object sender, RoutedEventArgs e) { Excel.Application xlDropOrder; Excel.Workbook xlDropBook; Excel.Worksheet xlDropSheet; Excel.Range range; int intColumnRange = 0; int intCounter; int intNumberOfRecords; int intAssetID; string strAssetID; string strAssetDescription; string strAssetType; string strSite; string strLocation; string strSerialNumber; string strManufacturer; string strModel; int intRecordsReturned; bool blnItemFound; int intWarehouseID; PleaseWait PleaseWait = new PleaseWait(); PleaseWait.Show(); try { expImportExcel.IsExpanded = false; TheImportWASPITAssetsDataSet.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; } 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++) { blnItemFound = false; strAssetID = Convert.ToString((range.Cells[intCounter, 1] as Excel.Range).Value2).ToUpper(); intAssetID = Convert.ToInt32(strAssetID); strAssetDescription = Convert.ToString((range.Cells[intCounter, 2] as Excel.Range).Value2).ToUpper(); strAssetType = Convert.ToString((range.Cells[intCounter, 3] as Excel.Range).Value2).ToUpper(); strSite = Convert.ToString((range.Cells[intCounter, 5] as Excel.Range).Value2).ToUpper(); strLocation = Convert.ToString((range.Cells[intCounter, 6] as Excel.Range).Value2).ToUpper(); strSerialNumber = Convert.ToString((range.Cells[intCounter, 13] as Excel.Range).Value2).ToUpper(); strManufacturer = Convert.ToString((range.Cells[intCounter, 15] as Excel.Range).Value2).ToUpper(); strModel = Convert.ToString((range.Cells[intCounter, 16] as Excel.Range).Value2).ToUpper(); if (strSite == "GROVEPORT") { strSite = "CBUS-GROVEPORT"; } TheFindWarehouseByWarehouseNameDataSet = TheEmployeeClass.FindWarehouseByWarehouseName(strSite); intWarehouseID = TheFindWarehouseByWarehouseNameDataSet.FindWarehouseByWarehouseName[0].EmployeeID; TheFindWASPAssetByAssetIDDataSet = TheAssetClass.FindWaspAssetByAssetID(intAssetID); intRecordsReturned = TheFindWASPAssetByAssetIDDataSet.FindWaspAssetByAssetID.Rows.Count; if (intRecordsReturned > 0) { blnItemFound = true; } else if (intRecordsReturned < 1) { TheFindWaspAssetsBySerialNumberDataSet = TheAssetClass.FindWaspAssetsBySerialNumber(strSerialNumber); intRecordsReturned = TheFindWaspAssetsBySerialNumberDataSet.FindWaspAssetsBySerialNumber.Rows.Count; if (intRecordsReturned > 0) { blnItemFound = true; } } if (blnItemFound == false) { ImportWASPITAssetsDataSet.importassetsRow NewAssetRow = TheImportWASPITAssetsDataSet.importassets.NewimportassetsRow(); NewAssetRow.AssetDescription = strAssetDescription; NewAssetRow.AssetID = intAssetID; NewAssetRow.AssetType = strAssetType; NewAssetRow.Location = strLocation; NewAssetRow.Manufacturer = strManufacturer; NewAssetRow.Model = strModel; NewAssetRow.SerialNumber = strSerialNumber; NewAssetRow.Site = strSite; NewAssetRow.WarehouseID = intWarehouseID; TheImportWASPITAssetsDataSet.importassets.Rows.Add(NewAssetRow); } } dgrITAssets.ItemsSource = TheImportWASPITAssetsDataSet.importassets; } catch (Exception Ex) { TheEventLogClass.InsertEventLogEntry(DateTime.Now, "New Blue Jay ERP // Import Wasp IT Assets // Import Excel " + Ex.Message); TheMessagesClass.ErrorMessage(Ex.ToString()); } PleaseWait.Close(); }
private void ChangeVehicleInYardToWarehouse() { DateTime datStartDate = DateTime.Now; DateTime datEndDate = DateTime.Now; int intCounter; int intNumberOfRecords; int intVehicleID; int intWarehouseID; int intTransactionID; string strWarehouse; bool blnFatalError = false; try { datStartDate = TheDateSearchClass.RemoveTime(datStartDate); datEndDate = TheDateSearchClass.AddingDays(datStartDate, 1); TheFindVehiclesInYardShowingVehicleIDDateRangeDataSet = TheVehicleInYardClass.FindVehiclesInYardShowingVehicleIDDateRange(datStartDate, datEndDate); intNumberOfRecords = TheFindVehiclesInYardShowingVehicleIDDateRangeDataSet.FindVehiclesInYardShowingVehicleDateRange.Rows.Count - 1; if(intNumberOfRecords > -1) { for(intCounter = 0; intCounter <= intNumberOfRecords; intCounter++) { intVehicleID = TheFindVehiclesInYardShowingVehicleIDDateRangeDataSet.FindVehiclesInYardShowingVehicleDateRange[intCounter].VehicleID; strWarehouse = TheFindVehiclesInYardShowingVehicleIDDateRangeDataSet.FindVehiclesInYardShowingVehicleDateRange[intCounter].AssignedOffice; TheFindWarehouseByWarehouseNameDataSet = TheEmployeeClass.FindWarehouseByWarehouseName(strWarehouse); intWarehouseID = TheFindWarehouseByWarehouseNameDataSet.FindWarehouseByWarehouseName[0].EmployeeID; TheFindCurrentAssignedVehicleMainByVehicleIDDataSet = TheVehicleAssignmentClass.FindCurrentAssignedVehicleMainByVehicleID(intVehicleID); intTransactionID = TheFindCurrentAssignedVehicleMainByVehicleIDDataSet.FindCurrentAssignedVehicleMainByVehicleID[0].TransactionID; blnFatalError = TheVehicleAssignmentClass.UpdateCurrentVehicleAssignment(intTransactionID, false); if (blnFatalError == true) throw new Exception(); blnFatalError = TheVehicleAssignmentClass.InsertVehicleAssignment(intVehicleID, intWarehouseID); if (blnFatalError == true) throw new Exception(); blnFatalError = TheVehicleMainClass.UpdateVehicleMainEmployeeID(intVehicleID, intWarehouseID); if (blnFatalError == true) throw new Exception(); } } } catch (Exception Ex) { TheEventLogClass.InsertEventLogEntry(DateTime.Now, "Event Log Tracker // Main Window // Change Vehicle In Yard To Warehouse " + Ex.Message); TheMessagesClass.ErrorMessage(Ex.ToString()); } }
private void Window_Loaded(object sender, RoutedEventArgs e) { //setting up local variables DateTime datTransactionDate = DateTime.Now; int intNumberOfRecords; int intCounter; int intTransactionID; int intAssetID; bool blnFatalError = false; string strSite; try { TheWaspAssetIDDataSet = TheAssetClass.GetWaspAssetIDInfo(); chkIsTool.IsChecked = false; intAssetID = TheWaspAssetIDDataSet.waspassetid[0].CreatedAssetID; intTransactionID = TheWaspAssetIDDataSet.waspassetid[0].TransactionID; MainWindow.gintAssetID = intAssetID; intAssetID++; txtAssetID.Text = Convert.ToString(MainWindow.gintAssetID); txtDate.Text = Convert.ToString(datTransactionDate); blnFatalError = TheAssetClass.UpdateWaspAssetID(intTransactionID, intAssetID); txtLocation.Text = MainWindow.gstrAssetLocation; TheFindWaspAssetLocationByLoctionDataSet = TheAssetClass.FindWaspAssetLocationByLocation(MainWindow.gstrAssetLocation); strSite = TheFindWaspAssetLocationByLoctionDataSet.FindWaspAssetLocationByLocation[0].AssetSite; txtSite.Text = strSite; if (strSite == "GROVEPORT") { strSite = "CBUS-GROVEPORT"; } TheFindWarehouseByWarehouseNameDataSet = TheEmployeeClass.FindWarehouseByWarehouseName(strSite); MainWindow.gintWarehouseID = TheFindWarehouseByWarehouseNameDataSet.FindWarehouseByWarehouseName[0].EmployeeID; txtWarehouseID.Text = Convert.ToString(MainWindow.gintWarehouseID); TheFindSortedToolCategoryDataSet = TheToolCategoryClass.FindSortedToolCategory(); cboAssetCategory.Items.Add("Select Category"); intNumberOfRecords = TheFindSortedToolCategoryDataSet.FindSortedToolCategory.Rows.Count; for (intCounter = 0; intCounter < intNumberOfRecords; intCounter++) { cboAssetCategory.Items.Add(TheFindSortedToolCategoryDataSet.FindSortedToolCategory[intCounter].ToolCategory); } cboAssetCategory.SelectedIndex = 0; txtSerialNo.Text = "UNKNOWN"; txtModel.Text = "UNKNOWN"; txtManufacturer.Text = "UNKNOWN"; } catch (Exception Ex) { TheSendEmailClass.SendEventLog("New Blue Jay ERP // Add Wasp Asset // Window Loaded Method " + Ex.Message); TheEventLogClass.InsertEventLogEntry(DateTime.Now, "New Blue Jay ERP // Add Wasp Asset // Window Loaded Method " + Ex.Message); TheMessagesClass.ErrorMessage(Ex.ToString()); } }
private void expImportExcel_Expanded(object sender, RoutedEventArgs e) { Excel.Application xlDropOrder; Excel.Workbook xlDropBook; Excel.Worksheet xlDropSheet; Excel.Range range; int intColumnRange = 0; int intCounter; int intNumberOfRecords; int intVehicleID = 0; DateTime datStartDate = DateTime.Now; DateTime datEndDate = DateTime.Now; string strItemID; int intItemID = 0; string strItem; string strManufacturer; string strModel; string strSerialNumber; string strQuantity; int intQuantity = 0; string strWarehouse; string strAssetNotes; bool blnFatalError = false; int intWarehouseID; try { TheImportITAssetsDataSet.importitassets.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(); 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 = 5; intCounter <= intNumberOfRecords; intCounter++) { strItemID = Convert.ToString((range.Cells[intCounter, 1] as Excel.Range).Value2).ToUpper(); blnFatalError = TheDataValidationClass.VerifyIntegerData(strItemID); if (blnFatalError == true) { TheMessagesClass.ErrorMessage("The Item ID is not Numeric at Count " + Convert.ToString(intCounter)); return; } else { intItemID = Convert.ToInt32(strItemID); } strItem = Convert.ToString((range.Cells[intCounter, 2] as Excel.Range).Value2).ToUpper(); strManufacturer = Convert.ToString((range.Cells[intCounter, 3] as Excel.Range).Value2).ToUpper(); strModel = Convert.ToString((range.Cells[intCounter, 4] as Excel.Range).Value2).ToUpper(); strSerialNumber = Convert.ToString((range.Cells[intCounter, 5] as Excel.Range).Value2).ToUpper(); strQuantity = Convert.ToString((range.Cells[intCounter, 6] as Excel.Range).Value2).ToUpper(); blnFatalError = TheDataValidationClass.VerifyIntegerData(strQuantity); if (blnFatalError == true) { TheMessagesClass.ErrorMessage("The Quantity is not Numeric"); return; } else { intQuantity = Convert.ToInt32(strQuantity); } strWarehouse = Convert.ToString((range.Cells[intCounter, 7] as Excel.Range).Value2).ToUpper(); TheFindWarehouseByWarehouseNameDataSet = TheEmployeeClass.FindWarehouseByWarehouseName(strWarehouse); intWarehouseID = TheFindWarehouseByWarehouseNameDataSet.FindWarehouseByWarehouseName[0].EmployeeID; strAssetNotes = Convert.ToString((range.Cells[intCounter, 8] as Excel.Range).Value2).ToUpper(); ImportITAssetsDataSet.importitassetsRow NewItAsset = TheImportITAssetsDataSet.importitassets.NewimportitassetsRow(); NewItAsset.Item = strItem; NewItAsset.ItemID = intItemID; NewItAsset.Location = strWarehouse; NewItAsset.Manufacturer = strManufacturer; NewItAsset.Model = strModel; NewItAsset.Notes = strAssetNotes; NewItAsset.Quantity = intQuantity; NewItAsset.SerialNumber = strSerialNumber; NewItAsset.WarehouseID = intWarehouseID; TheImportITAssetsDataSet.importitassets.Rows.Add(NewItAsset); } dgrAssets.ItemsSource = TheImportITAssetsDataSet.importitassets; PleaseWait.Close(); } catch (Exception Ex) { TheEventLogClass.InsertEventLogEntry(DateTime.Now, "New Blue Jay ERP // Import IT Assets // Import Excel " + Ex.Message); TheMessagesClass.ErrorMessage(Ex.ToString()); } }