private void mitSave_Click(object sender, RoutedEventArgs e) { // this will save the status string strGPSStatus; bool blnFatalError = false; int intRecordsReturned = 0; try { strGPSStatus = txtGPSStatus.Text; if (strGPSStatus == "") { TheMessagesClass.ErrorMessage("The GPS Status Was Not Entered"); return; } TheFindGPSStatusByStatusDataSet = TheVehicleInfoClass.FindGPSStatusByStatus(strGPSStatus); intRecordsReturned = TheFindGPSStatusByStatusDataSet.FindGPSStatusByStatus.Rows.Count; if (intRecordsReturned > 0) { TheMessagesClass.InformationMessage("The GPS Status Already Exists"); return; } blnFatalError = TheVehicleInfoClass.InsertGPSPlugStatus(strGPSStatus); if (blnFatalError == true) { TheMessagesClass.ErrorMessage("There Was a Problem, Contact IT"); return; } txtGPSStatus.Text = ""; } catch (Exception Ex) { TheEventLogClass.InsertEventLogEntry(DateTime.Now, "Blue Jay ERP // Add GPS Status // Save Button " + Ex.Message); TheMessagesClass.ErrorMessage(Ex.ToString()); } }
private void mitImportExcel_Click(object sender, RoutedEventArgs e) { Excel.Application xlDropOrder; Excel.Workbook xlDropBook; Excel.Worksheet xlDropSheet; Excel.Range range; int intColumnRange = 0; int intCounter; int intNumberOfRecords; string strVehicleNumber; int intRecordsReturned; string strAssignedOffice; string strIMEI; int intGPSStatusID; int intDOTStatusID; string strDOTStatus; string strGPSStatus; try { TheImportVehiclesDataSet.importvehicles.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 = 2; intCounter <= intNumberOfRecords; intCounter++) { strVehicleNumber = Convert.ToString((range.Cells[intCounter, 1] as Excel.Range).Value2); TheFindActiveVehicleMainShortVehicleNumberDataSet = TheVehicleMainClass.FindActiveVehicleMainShortVehicleNumber(strVehicleNumber); intRecordsReturned = TheFindActiveVehicleMainShortVehicleNumberDataSet.FindActiveVehicleMainShortVehicleNumber.Rows.Count; if (intRecordsReturned == 0) { strAssignedOffice = Convert.ToString((range.Cells[intCounter, 8] as Excel.Range).Value2).ToUpper(); strDOTStatus = Convert.ToString((range.Cells[intCounter, 13] as Excel.Range).Value2).ToUpper(); strIMEI = Convert.ToString((range.Cells[intCounter, 11] as Excel.Range).Value2).ToUpper(); MainWindow.gintEmployeeID = FindEmployeeID(strAssignedOffice); if (MainWindow.gintEmployeeID < 1) { TheMessagesClass.ErrorMessage("Problems Find Assigned Office, Check the Spelling"); return; } TheFindDOTStatusByStatusDataSet = TheVehicleInfoClass.FindDOTStatusByStatus(strDOTStatus); intRecordsReturned = TheFindDOTStatusByStatusDataSet.FindDOTStatusByStatus.Rows.Count; if (intRecordsReturned < 1) { TheMessagesClass.ErrorMessage("DOT Status Was Not Found, Check Spelling"); return; } intDOTStatusID = TheFindDOTStatusByStatusDataSet.FindDOTStatusByStatus[0].DOTStatusID; if (strIMEI.Length > 12) { strGPSStatus = "IN USE"; } else { strGPSStatus = "NOT IN USE"; } TheFindGPSStatusByStatusDataSet = TheVehicleInfoClass.FindGPSStatusByStatus(strGPSStatus); intGPSStatusID = TheFindGPSStatusByStatusDataSet.FindGPSStatusByStatus[0].GPSStatusID; ImportVehiclesDataSet.importvehiclesRow NewVehicleRow = TheImportVehiclesDataSet.importvehicles.NewimportvehiclesRow(); NewVehicleRow.AssignedOffice = strAssignedOffice; NewVehicleRow.EmployeeID = MainWindow.gintEmployeeID; NewVehicleRow.CDLRequired = Convert.ToString((range.Cells[intCounter, 9] as Excel.Range).Value2).ToUpper(); NewVehicleRow.DOTStatus = strDOTStatus; NewVehicleRow.IMEI = strIMEI; NewVehicleRow.MedicalCardRequired = Convert.ToString((range.Cells[intCounter, 10] as Excel.Range).Value2).ToUpper(); NewVehicleRow.OdometerReading = Convert.ToInt32(Convert.ToString((range.Cells[intCounter, 6] as Excel.Range).Value2)); NewVehicleRow.TamperTag = Convert.ToString((range.Cells[intCounter, 12] as Excel.Range).Value2).ToUpper(); NewVehicleRow.VehicleMake = Convert.ToString((range.Cells[intCounter, 3] as Excel.Range).Value2).ToUpper(); NewVehicleRow.VehicleModel = Convert.ToString((range.Cells[intCounter, 4] as Excel.Range).Value2).ToUpper(); NewVehicleRow.VehicleNumber = Convert.ToString((range.Cells[intCounter, 1] as Excel.Range).Value2).ToUpper(); NewVehicleRow.VINNumber = Convert.ToString((range.Cells[intCounter, 7] as Excel.Range).Value2).ToUpper(); NewVehicleRow.Year = Convert.ToInt32(Convert.ToString((range.Cells[intCounter, 2] as Excel.Range).Value2)); NewVehicleRow.DOTStatusID = intDOTStatusID; NewVehicleRow.GPSStatusID = intGPSStatusID; NewVehicleRow.LicensePlate = Convert.ToString((range.Cells[intCounter, 5] as Excel.Range).Value2).ToUpper(); TheImportVehiclesDataSet.importvehicles.Rows.Add(NewVehicleRow); } } PleaseWait.Close(); dgrResults.ItemsSource = TheImportVehiclesDataSet.importvehicles; mitProcess.IsEnabled = true; } catch (Exception Ex) { TheEventLogClass.InsertEventLogEntry(DateTime.Now, "Blue Jay ERP // Import Vehicles // Import Excel Menu Item " + Ex.Message); TheMessagesClass.ErrorMessage(Ex.ToString()); } }