private void txtEnterVehicleNumber_TextChanged(object sender, TextChangedEventArgs e) { //setting local variables string strVehicleNumber; int intLength; int intRecordsReturned; try { strVehicleNumber = txtEnterVehicleNumber.Text; MainWindow.gstrVehicleNumber = strVehicleNumber; intLength = strVehicleNumber.Length; if (intLength == 4) { TheFindActivehicleMainByVehicleNumberDataSet = TheVehicleMainClass.FindActiveVehicleMainByVehicleNumber(strVehicleNumber); intRecordsReturned = TheFindActivehicleMainByVehicleNumberDataSet.FindActiveVehicleMainByVehicleNumber.Rows.Count; if (intRecordsReturned > 0) { MainWindow.gintVehicleID = TheFindActivehicleMainByVehicleNumberDataSet.FindActiveVehicleMainByVehicleNumber[0].VehicleID; TheFindOpenVehicleMainProblemsByVehicleIDDataSet = TheVehicleProblemsClass.FindOpenVehicleMainProblemsByVehicleID(MainWindow.gintVehicleID); dgrOpenProblems.ItemsSource = TheFindOpenVehicleMainProblemsByVehicleIDDataSet.FindOpenVehicleMainProblemsByVehicleID; TheFindVehiclesInShopByVehlcleIDDataSet = TheVehiclesInShopClass.FindVehiclesInShopByVehicleID(MainWindow.gintVehicleID); intRecordsReturned = TheFindVehiclesInShopByVehlcleIDDataSet.FindVehiclesInShopByVehicleID.Rows.Count; if (intRecordsReturned > 0) { txtVehicleInyard.Text = "YES With " + TheFindVehiclesInShopByVehlcleIDDataSet.FindVehiclesInShopByVehicleID[0].VendorName; } else { txtVehicleInyard.Text = "Not In Shop"; } } } else if (intLength == 6) { TheFindActivehicleMainByVehicleNumberDataSet = TheVehicleMainClass.FindActiveVehicleMainByVehicleNumber(strVehicleNumber); intRecordsReturned = TheFindActivehicleMainByVehicleNumberDataSet.FindActiveVehicleMainByVehicleNumber.Rows.Count; if (intRecordsReturned > 0) { MainWindow.gintVehicleID = TheFindActivehicleMainByVehicleNumberDataSet.FindActiveVehicleMainByVehicleNumber[0].VehicleID; TheFindOpenVehicleMainProblemsByVehicleIDDataSet = TheVehicleProblemsClass.FindOpenVehicleMainProblemsByVehicleID(MainWindow.gintVehicleID); dgrOpenProblems.ItemsSource = TheFindOpenVehicleMainProblemsByVehicleIDDataSet.FindOpenVehicleMainProblemsByVehicleID; TheFindVehiclesInShopByVehlcleIDDataSet = TheVehiclesInShopClass.FindVehiclesInShopByVehicleID(MainWindow.gintVehicleID); intRecordsReturned = TheFindVehiclesInShopByVehlcleIDDataSet.FindVehiclesInShopByVehicleID.Rows.Count; if (intRecordsReturned > 0) { txtVehicleInyard.Text = "YES With " + TheFindVehiclesInShopByVehlcleIDDataSet.FindVehiclesInShopByVehicleID[0].VendorName; } else { txtVehicleInyard.Text = "Not In Shop"; } } else { TheMessagesClass.ErrorMessage("Vehicle Not Found"); return; } } else if (intLength > 6) { TheMessagesClass.ErrorMessage("Vehicle Number Entered has to Many Characters"); return; } } catch (Exception Ex) { TheEventLogClass.InsertEventLogEntry(DateTime.Now, "Blue Jay ERP // Update Vehicle Problem // Enter Vehicle Textbox " + Ex.Message); TheMessagesClass.ErrorMessage(Ex.ToString()); } }
private bool RunVehicleExceptionReport(DateTime datStartDate) { bool blnFatalError = false; int intCounter; int intNumberOfRecords; int intVehicleID; int intRecordsReturned; DateTime datEndDate; string strFirstNamed = ""; string strLastName = ""; try { TheVehicleExceptionDataSet.vehicleexception.Rows.Clear(); datEndDate = TheDateSearchClass.AddingDays(datStartDate, 1); TheFindActiveVehicleMainDataSet = TheVehicleMainClass.FindActiveVehicleMain(); intNumberOfRecords = TheFindActiveVehicleMainDataSet.FindActiveVehicleMain.Rows.Count - 1; for (intCounter = 0; intCounter <= intNumberOfRecords; intCounter++) { intVehicleID = TheFindActiveVehicleMainDataSet.FindActiveVehicleMain[intCounter].VehicleID; TheFindDailyVehicleInspectionByVehicleIDAndDateRangeDataSet = TheInspectionClass.FindDailyVehicleInspectionByVehicleIDAndDateRange(intVehicleID, datStartDate, datEndDate); intRecordsReturned = TheFindDailyVehicleInspectionByVehicleIDAndDateRangeDataSet.FindDailyVehicleInspectionsByVehicleIDAndDateRange.Rows.Count; if (intRecordsReturned == 0) { TheFindVehicleInYardByVehicleIDAndDateRangeDataSet = TheVehicleInYardClass.FindVehiclesInYardByVehicleIDAndDateRange(intVehicleID, datStartDate, datEndDate); intRecordsReturned = TheFindVehicleInYardByVehicleIDAndDateRangeDataSet.FindVehiclesInYardByVehicleIDAndDateRange.Rows.Count; if (intRecordsReturned == 0) { TheFindVehicleInShopByVehicleIDDataSet = TheVehicleInShopClass.FindVehiclesInShopByVehicleID(intVehicleID); intRecordsReturned = TheFindVehicleInShopByVehicleIDDataSet.FindVehiclesInShopByVehicleID.Rows.Count; if (intRecordsReturned == 0) { TheFindcurrentAssignedVehicleMainByVehicleIDDataSet = TheVehicleAssignmentClass.FindCurrentAssignedVehicleMainByVehicleID(intVehicleID); intRecordsReturned = TheFindcurrentAssignedVehicleMainByVehicleIDDataSet.FindCurrentAssignedVehicleMainByVehicleID.Rows.Count; if (intRecordsReturned == 0) { strLastName = "NOT ASSIGNED"; strFirstNamed = "NOT ASSIGNED"; } else { strLastName = TheFindcurrentAssignedVehicleMainByVehicleIDDataSet.FindCurrentAssignedVehicleMainByVehicleID[0].LastName; strFirstNamed = TheFindcurrentAssignedVehicleMainByVehicleIDDataSet.FindCurrentAssignedVehicleMainByVehicleID[0].FirstName; } VehicleExceptionDataSet.vehicleexceptionRow NewVehicleRow = TheVehicleExceptionDataSet.vehicleexception.NewvehicleexceptionRow(); NewVehicleRow.AssignedOffice = TheFindActiveVehicleMainDataSet.FindActiveVehicleMain[intCounter].AssignedOffice; NewVehicleRow.FirstName = strFirstNamed; NewVehicleRow.LastName = strLastName; NewVehicleRow.VehicleID = intVehicleID; NewVehicleRow.VehicleNumber = TheFindActiveVehicleMainDataSet.FindActiveVehicleMain[intCounter].VehicleNumber; TheVehicleExceptionDataSet.vehicleexception.Rows.Add(NewVehicleRow); } } } } } catch (Exception Ex) { TheEventLogClass.InsertEventLogEntry(DateTime.Now, "Blue Jay ERP // Automate Vehicle Reports // Run Vehicle Exception Report " + Ex.Message); TheMessagesClass.ErrorMessage(Ex.ToString()); blnFatalError = true; } return(blnFatalError); }