public FindActiveTrailerByTrailerNumberDataSet FindActiveTrailerByTrailerNumber(string strTrailerNumber) { try { aFindActiveTrailerByTrailerNumberDataSet = new FindActiveTrailerByTrailerNumberDataSet(); aFindActiveTrailerByTrailerNumberTableAdapter = new FindActiveTrailerByTrailerNumberDataSetTableAdapters.FindActiveTrailerByTrailerNumberTableAdapter(); aFindActiveTrailerByTrailerNumberTableAdapter.Fill(aFindActiveTrailerByTrailerNumberDataSet.FindActiveTrailerByTrailerNumber, strTrailerNumber); } catch (Exception Ex) { TheEventLogClass.InsertEventLogEntry(DateTime.Now, "Trailers Class // Find Active Trailer By Trailer Number " + Ex.Message); } return(aFindActiveTrailerByTrailerNumberDataSet); }
private void btnFind_Click(object sender, RoutedEventArgs e) { string strTrailerNumber; int intRecordsReturned; string strFullName; try { strTrailerNumber = txtEnterTrailerNumber.Text; if (strTrailerNumber == "") { TheMessagesClass.ErrorMessage("Trailer Number Was Not Entered"); return; } TheFindActiveTrailerByTrailerNumberDataSet = TheTrailersClass.FindActiveTrailerByTrailerNumber(strTrailerNumber); intRecordsReturned = TheFindActiveTrailerByTrailerNumberDataSet.FindActiveTrailerByTrailerNumber.Rows.Count; if (intRecordsReturned < 1) { TheMessagesClass.ErrorMessage("Trailer Not Found"); return; } MainWindow.gintTrailerID = TheFindActiveTrailerByTrailerNumberDataSet.FindActiveTrailerByTrailerNumber[0].TrailerID; txtTrailerDescription.Text = TheFindActiveTrailerByTrailerNumberDataSet.FindActiveTrailerByTrailerNumber[0].TrailerDescription; txtTrailerID.Text = Convert.ToString(MainWindow.gintTrailerID); txtTrailerNotes.Text = TheFindActiveTrailerByTrailerNumberDataSet.FindActiveTrailerByTrailerNumber[0].TrailerNotes; strFullName = TheFindActiveTrailerByTrailerNumberDataSet.FindActiveTrailerByTrailerNumber[0].FirstName + " "; strFullName += TheFindActiveTrailerByTrailerNumberDataSet.FindActiveTrailerByTrailerNumber[0].LastName; txtEmployeeName.Text = strFullName; TheFindOpenTrailerProblemByTrailerIDDataSet = TheTrailerProblemClass.FindOpenTrailerProblemsByTrailerID(MainWindow.gintTrailerID); dgrResults.ItemsSource = TheFindOpenTrailerProblemByTrailerIDDataSet.FindOpenTrailerProblemByTrailerID; } catch (Exception Ex) { TheEventLogClass.InsertEventLogEntry(DateTime.Now, "Blue Jay ERP // Update Trailer Problem // Find Button " + Ex.Message); TheMessagesClass.ErrorMessage(Ex.ToString()); } }
private void btnProcess_Click(object sender, RoutedEventArgs e) { //setting up variables string strTrailerNumber; int intRecordsReturned; bool blnFatalError = false; try { strTrailerNumber = txtEnterTrailerNumber.Text; if (strTrailerNumber == "") { TheMessagesClass.ErrorMessage("Trailer Number Not Found"); return; } TheFindActiveTrailerByTrailerNumberDataSet = TheTrailersClass.FindActiveTrailerByTrailerNumber(strTrailerNumber); intRecordsReturned = TheFindActiveTrailerByTrailerNumberDataSet.FindActiveTrailerByTrailerNumber.Rows.Count; if (intRecordsReturned < 1) { TheMessagesClass.ErrorMessage("The Trailer Was Not Found"); return; } MainWindow.gintTrailerID = TheFindActiveTrailerByTrailerNumberDataSet.FindActiveTrailerByTrailerNumber[0].TrailerID; blnFatalError = TheTrailersInYardClass.InsertTrailerInYard(MainWindow.gintTrailerID); if (blnFatalError == true) { throw new Exception(); } txtEnterTrailerNumber.Text = ""; txtEnterTrailerNumber.Focus(); } catch (Exception Ex) { TheEventLogClass.InsertEventLogEntry(DateTime.Now, "Blue Jay ERP // Trailers In Yard // Process Button " + Ex.Message); TheMessagesClass.ErrorMessage(Ex.ToString()); } }
private void TxtEnterTrailerNumber_TextChanged(object sender, TextChangedEventArgs e) { string strTrailerNumber; int intLength; int intRecordsReturned; try { strTrailerNumber = txtEnterTrailerNumber.Text; intLength = strTrailerNumber.Length; if (intLength == 4) { TheFindActiveTrailerByTrailerNumberDataSet = TheTrailersClass.FindActiveTrailerByTrailerNumber(strTrailerNumber); intRecordsReturned = TheFindActiveTrailerByTrailerNumberDataSet.FindActiveTrailerByTrailerNumber.Rows.Count; if (intRecordsReturned > 0) { LoadTrailerInformation(); } } else if (intLength == 6) { TheFindActiveTrailerByTrailerNumberDataSet = TheTrailersClass.FindActiveTrailerByTrailerNumber(strTrailerNumber); intRecordsReturned = TheFindActiveTrailerByTrailerNumberDataSet.FindActiveTrailerByTrailerNumber.Rows.Count; if (intRecordsReturned == 0) { TheMessagesClass.ErrorMessage("The Trailer Was Not Found"); return; } } cboSelectVendor.IsEnabled = true; btnCheckOpenProblems.IsEnabled = true; } catch (Exception Ex) { TheEventLogClass.InsertEventLogEntry(DateTime.Now, "Blue Jay ERP // Create Trailer Problem // Enter Trailer Number Textbox " + 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; int intRecordsReturned; try { TheNewTrailerDataSet.newtrailers.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++) { gstrTrailerNumber = Convert.ToString((range.Cells[intCounter, 2] as Excel.Range).Value2); gstrTrailerNumber = gstrTrailerNumber.Substring(4); TheFindActiveTrailerByTrailerNumberDataSet = TheTrailersClass.FindActiveTrailerByTrailerNumber(gstrTrailerNumber); intRecordsReturned = TheFindActiveTrailerByTrailerNumberDataSet.FindActiveTrailerByTrailerNumber.Rows.Count; if (intRecordsReturned == 0) { gstrAssignedOffice = Convert.ToString((range.Cells[intCounter, 1] as Excel.Range).Value2).ToUpper(); gstrTrailerDescription = Convert.ToString((range.Cells[intCounter, 3] as Excel.Range).Value2).ToUpper(); gstrTrailerCategory = Convert.ToString((range.Cells[intCounter, 4] as Excel.Range).Value2).ToUpper(); gstrLicensePlate = Convert.ToString((range.Cells[intCounter, 5] as Excel.Range).Value2).ToUpper(); gstrVINNumber = Convert.ToString((range.Cells[intCounter, 6] as Excel.Range).Value2).ToUpper(); gintLocationID = FindLocationID(gstrAssignedOffice); TheFindTrailerCategoryByCategoryDataSet = TheTrailerCategoryClass.FindTrailerCategoryByCategory(gstrTrailerCategory); gintCategoryID = TheFindTrailerCategoryByCategoryDataSet.FindTrailerCategoryByCategory[0].CategoryID; NewTrailerDataSet.newtrailersRow NewTrailerRow = TheNewTrailerDataSet.newtrailers.NewnewtrailersRow(); NewTrailerRow.CategoryID = gintCategoryID; NewTrailerRow.LicensePlate = gstrLicensePlate; NewTrailerRow.Location = gstrAssignedOffice; NewTrailerRow.LocationID = gintLocationID; NewTrailerRow.TrailerCategory = gstrTrailerCategory; NewTrailerRow.TrailerDescription = gstrTrailerDescription; NewTrailerRow.TrailerNumber = gstrTrailerNumber; NewTrailerRow.VINNumber = gstrVINNumber; TheNewTrailerDataSet.newtrailers.Rows.Add(NewTrailerRow); } } PleaseWait.Close(); dgrTrailers.ItemsSource = TheNewTrailerDataSet.newtrailers; mitSave.IsEnabled = true; } catch (Exception Ex) { TheEventLogClass.InsertEventLogEntry(DateTime.Now, "Blue Jay ERP // Import Trailers // Import Excel Menu Item " + Ex.Message); TheMessagesClass.ErrorMessage(Ex.ToString()); } }
private void txtTrailerNumber_TextChanged(object sender, TextChangedEventArgs e) { string strTrailerNumber; int intLength; int intRecordsReturned; string strFullName; try { strTrailerNumber = txtTrailerNumber.Text; intLength = strTrailerNumber.Length; if (intLength == 4) { TheFindActiveTrailerByTrailerNumberDataSet = TheTrailersClass.FindActiveTrailerByTrailerNumber(strTrailerNumber); intRecordsReturned = TheFindActiveTrailerByTrailerNumberDataSet.FindActiveTrailerByTrailerNumber.Rows.Count; if (intRecordsReturned > 0) { gintTrailerID = TheFindActiveTrailerByTrailerNumberDataSet.FindActiveTrailerByTrailerNumber[0].TrailerID; strFullName = TheFindActiveTrailerByTrailerNumberDataSet.FindActiveTrailerByTrailerNumber[0].FirstName + " "; strFullName += TheFindActiveTrailerByTrailerNumberDataSet.FindActiveTrailerByTrailerNumber[0].LastName; txtTrailerCurrentEmployee.Text = strFullName; txtTrailerEnterLastName.IsEnabled = true; } else if (intRecordsReturned < 1) { TheMessagesClass.ErrorMessage("Trailer Number Not Found"); return; } } else if (intLength == 6) { TheFindActiveTrailerByTrailerNumberDataSet = TheTrailersClass.FindActiveTrailerByTrailerNumber(strTrailerNumber); intRecordsReturned = TheFindActiveTrailerByTrailerNumberDataSet.FindActiveTrailerByTrailerNumber.Rows.Count; if (intRecordsReturned > 0) { gintTrailerID = TheFindActiveTrailerByTrailerNumberDataSet.FindActiveTrailerByTrailerNumber[0].TrailerID; strFullName = TheFindActiveTrailerByTrailerNumberDataSet.FindActiveTrailerByTrailerNumber[0].FirstName + " "; strFullName += TheFindActiveTrailerByTrailerNumberDataSet.FindActiveTrailerByTrailerNumber[0].LastName; txtTrailerCurrentEmployee.Text = strFullName; txtTrailerEnterLastName.IsEnabled = true; } else if (intRecordsReturned < 1) { TheMessagesClass.ErrorMessage("Trailer Number Not Found"); return; } } } catch (Exception Ex) { TheEventLogClass.InsertEventLogEntry(DateTime.Now, "Daily Vehicle Data Entry // Main Window // Trailer Number Text Box " + Ex.Message); TheMessagesClass.ErrorMessage(Ex.ToString()); } }
private void txtEnterName_TextChanged(object sender, TextChangedEventArgs e) { string strEnteredData; int intLength; int intCounter; int intNumberOfRecords; try { strEnteredData = txtEnterName.Text; intLength = strEnteredData.Length; if (gblnTrailerNumber == true) { if ((intLength == 4) || (intLength >= 6)) { TheFindActiveTrailerByTrailerNumberDataSet = TheTrailersClass.FindActiveTrailerByTrailerNumber(strEnteredData); intNumberOfRecords = TheFindActiveTrailerByTrailerNumberDataSet.FindActiveTrailerByTrailerNumber.Rows.Count; if (intNumberOfRecords < 1) { TheMessagesClass.ErrorMessage("Trailer Was Not Found"); return; } MainWindow.gintTrailerID = TheFindActiveTrailerByTrailerNumberDataSet.FindActiveTrailerByTrailerNumber[0].TrailerID; gstrTrailerNumber = strEnteredData; } } else if (gblnEmployee == true) { if (intLength > 2) { cboSelectEmployee.Items.Clear(); cboSelectEmployee.Items.Add("Select Employee"); TheComboEmployeeDataSet = TheEmployeeClass.FillEmployeeComboBox(strEnteredData); intNumberOfRecords = TheComboEmployeeDataSet.employees.Rows.Count - 1; if (intNumberOfRecords < 0) { TheMessagesClass.ErrorMessage("Employee Not Found"); return; } for (intCounter = 0; intCounter <= intNumberOfRecords; intCounter++) { cboSelectEmployee.Items.Add(TheComboEmployeeDataSet.employees[intCounter].FullName); } cboSelectEmployee.SelectedIndex = 0; } } } catch (Exception Ex) { TheEventLogclass.InsertEventLogEntry(DateTime.Now, "Blue Jay ERP // Daily Trailer Inspection Report // Enter Name Text Change " + Ex.Message); TheMessagesClass.ErrorMessage(Ex.ToString()); } }