private void mitRemoveEmployees_Click(object sender, RoutedEventArgs e) { int intCounter; int intNumberOfRecords; int intWarehouseID; string strHomeOffice; int intVehicleID; bool blnFatalError; int intTransactionID; try { intNumberOfRecords = TheFindVehicleMainDeactiveEmployeesDataSet.FindVehicleMainByDeactiveEmployees.Rows.Count - 1; for (intCounter = 0; intCounter <= intNumberOfRecords; intCounter++) { intVehicleID = TheFindVehicleMainDeactiveEmployeesDataSet.FindVehicleMainByDeactiveEmployees[intCounter].VehicleID; strHomeOffice = TheFindVehicleMainDeactiveEmployeesDataSet.FindVehicleMainByDeactiveEmployees[intCounter].AssignedOffice; intWarehouseID = FindWarehouseID(strHomeOffice); TheFindCurrentAssignedVehicleMainByVehicleIDDataSet = TheVehicleAssignmentClass.FindCurrentAssignedVehicleMainByVehicleID(intVehicleID); intTransactionID = TheFindCurrentAssignedVehicleMainByVehicleIDDataSet.FindCurrentAssignedVehicleMainByVehicleID[0].TransactionID; blnFatalError = TheVehicleMainClass.UpdateVehicleMainEmployeeID(intVehicleID, intWarehouseID); if (blnFatalError == true) { throw new Exception(); } blnFatalError = TheVehicleAssignmentClass.UpdateCurrentVehicleAssignment(intTransactionID, false); if (blnFatalError == true) { throw new Exception(); } blnFatalError = TheVehicleAssignmentClass.InsertVehicleAssignment(intVehicleID, intWarehouseID); if (blnFatalError == true) { throw new Exception(); } } TheMessagesClass.InformationMessage("Employees Have Been Removed from Vehicles"); TheFindVehicleMainDeactiveEmployeesDataSet = TheVehicleMainClass.FindVehicleMainByDeactiveEmployees(); dgrResults.ItemsSource = TheFindVehicleMainDeactiveEmployeesDataSet.FindVehicleMainByDeactiveEmployees; } catch (Exception Ex) { TheEventLogclass.InsertEventLogEntry(DateTime.Now, "Blue Jay ERP // Remove Employees From Vehicles // Remove Employess " + Ex.Message); TheMessagesClass.ErrorMessage(Ex.ToString()); } }
private void txtVehicleNumber_TextChanged(object sender, TextChangedEventArgs e) { //setting variables string strVehicleNumber; bool blnFatalError = false; int intRecordsReturned; int intLength; strVehicleNumber = txtVehicleNumber.Text; intLength = strVehicleNumber.Length; if (intLength >= 4) { blnFatalError = TheDataValidationClass.VerifyTextData(strVehicleNumber); if (blnFatalError == true) { TheMessagesClass.ErrorMessage("The Vehicle Number Entered Is not Integer"); return; } TheFindActiveVehicleMainByVehicleNumberDataSet = TheVehicleMainClass.FindActiveVehicleMainByVehicleNumber(strVehicleNumber); intRecordsReturned = TheFindActiveVehicleMainByVehicleNumberDataSet.FindActiveVehicleMainByVehicleNumber.Rows.Count; if (intRecordsReturned > 0) { MainWindow.gintVehicleID = TheFindActiveVehicleMainByVehicleNumberDataSet.FindActiveVehicleMainByVehicleNumber[0].VehicleID; TheFindCurrentAssignedVehicleMainByVehicleIDDataSet = TheVehicleAssignmentClass.FindCurrentAssignedVehicleMainByVehicleID(MainWindow.gintVehicleID); intRecordsReturned = TheFindCurrentAssignedVehicleMainByVehicleIDDataSet.FindCurrentAssignedVehicleMainByVehicleID.Rows.Count; if (intRecordsReturned == 0) { txtCurrentFirstName.Text = "Not Assigned"; txtCurrentLastName.Text = "Not Assigned"; } else { txtCurrentFirstName.Text = TheFindCurrentAssignedVehicleMainByVehicleIDDataSet.FindCurrentAssignedVehicleMainByVehicleID[0].FirstName; txtCurrentLastName.Text = TheFindCurrentAssignedVehicleMainByVehicleIDDataSet.FindCurrentAssignedVehicleMainByVehicleID[0].LastName; } cboSelectEmployee.IsEnabled = true; } } }
public FindCurrentAssignedVehicleMainByVehicleIDDataSet FindCurrentAssignedVehicleMainByVehicleID(int intVehicleID) { try { aFindCurrentAssignedVehicleMainByVehicleIDDataSet = new FindCurrentAssignedVehicleMainByVehicleIDDataSet(); aFindCurrentAssignedVehicleMainByVehicleIDTableAdapter = new FindCurrentAssignedVehicleMainByVehicleIDDataSetTableAdapters.FindCurrentAssignedVehicleMainByVehicleIDTableAdapter(); aFindCurrentAssignedVehicleMainByVehicleIDTableAdapter.Fill(aFindCurrentAssignedVehicleMainByVehicleIDDataSet.FindCurrentAssignedVehicleMainByVehicleID, intVehicleID); } catch (Exception Ex) { TheEventLogClass.InsertEventLogEntry(DateTime.Now, "Vehicle Assignment Class // Find Current Assigned Vehicle Main By Vehicle ID " + Ex.Message); } return(aFindCurrentAssignedVehicleMainByVehicleIDDataSet); }
private void expProcess_Expanded_1(object sender, RoutedEventArgs e) { int intVehicleCounter; int intVehicleNumberOfRecords; int intAutomileCounter; int intAutomileNumberOfRecords; int intVehicleID; string strVehicleNumber; string strAutomileVehicleNumber; bool blnItemFound; bool blnItemEntered; int intThirdCounter; string strInOrOut; string strManager; string strFullName; string strAssignedOffice; DateTime datStartDate; DateTime datEndDate; int intRecordsReturned; int intManagerID; try { expProcess.IsExpanded = false; //loading the vehicle data set TheFindActiveVehicleMainDataSet = TheVehicleMainClass.FindActiveVehicleMain(); TheVehicleCurrentStatusDataSet.vehiclecurrentstatus.Rows.Clear(); TheShortedCurrentVehicleDataSet.shortenlist.Rows.Clear(); datStartDate = DateTime.Now; datStartDate = TheDateSearchClass.RemoveTime(datStartDate); datEndDate = TheDateSearchClass.AddingDays(datStartDate, 1); intVehicleNumberOfRecords = TheFindActiveVehicleMainDataSet.FindActiveVehicleMain.Rows.Count - 1; intAutomileNumberOfRecords = TheAutomileImportDataSet.automileimport.Rows.Count - 1; gintThirdCounter = 0; gintThirdNumberOfRecords = 0; for (intVehicleCounter = 0; intVehicleCounter <= intVehicleNumberOfRecords; intVehicleCounter++) { intVehicleID = TheFindActiveVehicleMainDataSet.FindActiveVehicleMain[intVehicleCounter].VehicleID; if (intVehicleID != 9076) { strVehicleNumber = TheFindActiveVehicleMainDataSet.FindActiveVehicleMain[intVehicleCounter].VehicleNumber; strAssignedOffice = TheFindActiveVehicleMainDataSet.FindActiveVehicleMain[intVehicleCounter].AssignedOffice; TheFindCurrentAssignedVehicleMainByVehicleIDDataSet = TheVehicleAssignmentClass.FindCurrentAssignedVehicleMainByVehicleID(intVehicleID); strFullName = TheFindCurrentAssignedVehicleMainByVehicleIDDataSet.FindCurrentAssignedVehicleMainByVehicleID[0].FirstName + " "; strFullName += TheFindCurrentAssignedVehicleMainByVehicleIDDataSet.FindCurrentAssignedVehicleMainByVehicleID[0].LastName; intManagerID = TheFindCurrentAssignedVehicleMainByVehicleIDDataSet.FindCurrentAssignedVehicleMainByVehicleID[0].ManagerID; TheFindEnmployeeByEmployeeIDDataSet = TheEmployeeClass.FindEmployeeByEmployeeID(intManagerID); strManager = TheFindEnmployeeByEmployeeIDDataSet.FindEmployeeByEmployeeID[0].FirstName + " "; strManager += TheFindEnmployeeByEmployeeIDDataSet.FindEmployeeByEmployeeID[0].LastName; strInOrOut = "UNKNOWN"; if (TheFindCurrentAssignedVehicleMainByVehicleIDDataSet.FindCurrentAssignedVehicleMainByVehicleID[0].LastName == "WAREHOUSE") { strManager = "FLEET MANAGER"; } TheFindVehicleInShopByVehicleIDDataSet = TheVehiclesInShopClass.FindVehicleMainInShopByVehicleID(intVehicleID); TheFindVehicleInYardByVehicleIDAndDateRangeDataSet = TheVehicleInYardClass.FindVehiclesInYardByVehicleIDAndDateRange(intVehicleID, datStartDate, datEndDate); intRecordsReturned = TheFindVehicleInYardByVehicleIDAndDateRangeDataSet.FindVehiclesInYardByVehicleIDAndDateRange.Rows.Count; if (intRecordsReturned > 0) { strInOrOut = "IN YARD"; } blnItemEntered = false; for (intAutomileCounter = 0; intAutomileCounter <= intAutomileNumberOfRecords; intAutomileCounter++) { strAutomileVehicleNumber = TheAutomileImportDataSet.automileimport[intAutomileCounter].VehicleNumber; blnItemFound = strAutomileVehicleNumber.Contains(strVehicleNumber); if (blnItemFound == true) { strInOrOut = TheAutomileImportDataSet.automileimport[intAutomileCounter].IsInside; if (strInOrOut == "YES") { strInOrOut = "IN YARD"; } else if (strInOrOut == "NO") { strInOrOut = "OUT"; } if (gintThirdCounter > 0) { for (intThirdCounter = 0; gintThirdCounter <= gintThirdNumberOfRecords; intThirdCounter++) { if (strVehicleNumber == TheVehicleCurrentStatusDataSet.vehiclecurrentstatus[intThirdCounter].VehicleNumber) { if (strInOrOut == "YES") { TheVehicleCurrentStatusDataSet.vehiclecurrentstatus[intThirdCounter].InOrOut = "IN YARD"; } else if (strInOrOut == "NO") { TheVehicleCurrentStatusDataSet.vehiclecurrentstatus[intThirdCounter].InOrOut = strInOrOut; } blnItemEntered = true; } } } } } intRecordsReturned = TheFindVehicleInShopByVehicleIDDataSet.FindVehicleMainInShopByVehicleID.Rows.Count; if (intRecordsReturned > 0) { strInOrOut = "IN SHOP"; } if (blnItemEntered == false) { VehicleCurrentStatusDataSet.vehiclecurrentstatusRow NewVehicleRow = TheVehicleCurrentStatusDataSet.vehiclecurrentstatus.NewvehiclecurrentstatusRow(); NewVehicleRow.AssignedOffice = strAssignedOffice; NewVehicleRow.Manager = strManager; NewVehicleRow.Driver = strFullName; NewVehicleRow.InOrOut = strInOrOut; NewVehicleRow.VehicleNumber = strVehicleNumber; TheVehicleCurrentStatusDataSet.vehiclecurrentstatus.Rows.Add(NewVehicleRow); ShortedCurrentVehicleDataSet.shortenlistRow SecondVehicleRow = TheShortedCurrentVehicleDataSet.shortenlist.NewshortenlistRow(); SecondVehicleRow.Driver = strFullName; SecondVehicleRow.VehicleNumber = strVehicleNumber; SecondVehicleRow.InOrOut = strInOrOut; TheShortedCurrentVehicleDataSet.shortenlist.Rows.Add(SecondVehicleRow); } } } TheMessagesClass.InformationMessage("Processing the Report Is Completed"); dgrResults.ItemsSource = TheVehicleCurrentStatusDataSet.vehiclecurrentstatus; } catch (Exception Ex) { TheEventLogClass.InsertEventLogEntry(DateTime.Now, "Four Thirty Report // Main Window // Process Expander " + Ex.Message); TheMessagesClass.ErrorMessage(Ex.ToString()); } }
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 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); }
private void txtVehicleNumber_TextChanged(object sender, TextChangedEventArgs e) { string strValueForValidation; bool blnFatalError = false; string strVehicleNumber; int intLength; int intRecordsReturned; string strEmployeeGroup; string strFullName; try { strValueForValidation = txtEnterID.Text; blnFatalError = TheDataValidationClass.VerifyIntegerData(strValueForValidation); if (blnFatalError == true) { if (gblnRecordSaved == false) { TheMessagesClass.ErrorMessage("The Employee ID is not an Integer"); gblnRecordSaved = false; return; } } else { //getting warehouse id gintWarehouseEmployeeID = Convert.ToInt32(strValueForValidation); TheFindEmployeeByEmployeeIDDataSet = TheEmployeeClass.FindEmployeeByEmployeeID(gintWarehouseEmployeeID); intRecordsReturned = TheFindEmployeeByEmployeeIDDataSet.FindEmployeeByEmployeeID.Rows.Count; if (intRecordsReturned < 1) { TheMessagesClass.ErrorMessage("Employee ID Was Not Found"); return; } else { strEmployeeGroup = TheFindEmployeeByEmployeeIDDataSet.FindEmployeeByEmployeeID[0].EmployeeGroup; if (strEmployeeGroup != "WAREHOUSE") { if (strEmployeeGroup != "ADMIN") { if (strEmployeeGroup != "MANAGERS") { TheMessagesClass.ErrorMessage("Employee Is Not a Warehouse Employee"); return; } } } else { expAssignTask.IsEnabled = true; } } } strVehicleNumber = txtVehicleNumber.Text; intLength = strVehicleNumber.Length; if (intLength == 4) { TheFindActiveVehicleMainByVehicleNumberDataSet = TheVehicleMainClass.FindActiveVehicleMainByVehicleNumber(strVehicleNumber); intRecordsReturned = TheFindActiveVehicleMainByVehicleNumberDataSet.FindActiveVehicleMainByVehicleNumber.Rows.Count; if (intRecordsReturned > 0) { gintVehicleID = TheFindActiveVehicleMainByVehicleNumberDataSet.FindActiveVehicleMainByVehicleNumber[0].VehicleID; TheFindCurrentAssignedVehicleMainByVehicleIDDataSet = TheVehicleAssignmentClass.FindCurrentAssignedVehicleMainByVehicleID(gintVehicleID); gintEmployeeID = TheFindCurrentAssignedVehicleMainByVehicleIDDataSet.FindCurrentAssignedVehicleMainByVehicleID[0].EmployeeID; strFullName = TheFindCurrentAssignedVehicleMainByVehicleIDDataSet.FindCurrentAssignedVehicleMainByVehicleID[0].FirstName + " "; strFullName += TheFindCurrentAssignedVehicleMainByVehicleIDDataSet.FindCurrentAssignedVehicleMainByVehicleID[0].LastName; txtCurrentEmployee.Text = strFullName; txtEnterLastName.IsEnabled = true; } } else if (intLength == 6) { TheFindActiveVehicleMainByVehicleNumberDataSet = TheVehicleMainClass.FindActiveVehicleMainByVehicleNumber(strVehicleNumber); intRecordsReturned = TheFindActiveVehicleMainByVehicleNumberDataSet.FindActiveVehicleMainByVehicleNumber.Rows.Count; if (intRecordsReturned < 1) { TheMessagesClass.ErrorMessage("Vehicle Not Found"); return; } gintVehicleID = TheFindActiveVehicleMainByVehicleNumberDataSet.FindActiveVehicleMainByVehicleNumber[0].VehicleID; TheFindCurrentAssignedVehicleMainByVehicleIDDataSet = TheVehicleAssignmentClass.FindCurrentAssignedVehicleMainByVehicleID(gintVehicleID); gintEmployeeID = TheFindCurrentAssignedVehicleMainByVehicleIDDataSet.FindCurrentAssignedVehicleMainByVehicleID[0].EmployeeID; strFullName = TheFindCurrentAssignedVehicleMainByVehicleIDDataSet.FindCurrentAssignedVehicleMainByVehicleID[0].FirstName + " "; strFullName += TheFindCurrentAssignedVehicleMainByVehicleIDDataSet.FindCurrentAssignedVehicleMainByVehicleID[0].LastName; txtCurrentEmployee.Text = strFullName; txtEnterLastName.IsEnabled = true; } else if (intLength > 6) { TheMessagesClass.ErrorMessage("Vehicle Is Not Formated Correctly"); return; } } catch (Exception Ex) { TheEventLogClass.InsertEventLogEntry(DateTime.Now, "Daily Vehicle Data Entry // Main Window // Vehicle Number Text Box " + Ex.Message); TheMessagesClass.ErrorMessage(Ex.ToString()); } }
private void mitProcess_Click(object sender, RoutedEventArgs e) { //this will process the information string strValueForValidation; bool blnFatalError = false; bool blnThereIsAProblem = false; string strErrorMessage = ""; int intRecordsReturned; try { //data validation MainWindow.gstrVehicleNumber = txtEnterVehicleNumber.Text; TheFindActiveVehicleMainByVehicleNumberDataSet = TheVehicleMainClass.FindActiveVehicleMainByVehicleNumber(MainWindow.gstrVehicleNumber); intRecordsReturned = TheFindActiveVehicleMainByVehicleNumberDataSet.FindActiveVehicleMainByVehicleNumber.Rows.Count; if (intRecordsReturned == 0) { blnFatalError = true; strErrorMessage += "Vehicle Number Not Found\n"; } else { MainWindow.gintVehicleID = TheFindActiveVehicleMainByVehicleNumberDataSet.FindActiveVehicleMainByVehicleNumber[0].VehicleID; TheFindCurrentAssignedVehicleMainByVehicleIDDataSet = TheVehicleAssignmentClass.FindCurrentAssignedVehicleMainByVehicleID(MainWindow.gintVehicleID); if (TheFindCurrentAssignedVehicleMainByVehicleIDDataSet.FindCurrentAssignedVehicleMainByVehicleID[0].LastName == "WAREHOUSE") { blnFatalError = true; strErrorMessage += "Vehicle is Assigned to a Warehouse and\nMust Be Assigned to a Technician\n"; } } strValueForValidation = cboEmployee.SelectedItem.ToString(); if (strValueForValidation == "Select Employee") { blnFatalError = true; strErrorMessage += "The Employee Was Not Selected\n"; } strValueForValidation = txtOdometerReading.Text; blnThereIsAProblem = TheDataValidationClass.VerifyIntegerData(strValueForValidation); if (blnThereIsAProblem == true) { blnFatalError = true; strErrorMessage += "The Odometer Reading is not an Integer\n"; } else { MainWindow.gintOdometerReading = Convert.ToInt32(strValueForValidation); } if (cboGPSInstalled.SelectedIndex < 1) { blnFatalError = true; strErrorMessage += "The GPS Installed was not Selected\n"; } if (blnFatalError == true) { TheMessagesClass.ErrorMessage(strErrorMessage); return; } MainWindow.gdatTransactionDate = DateTime.Now; blnFatalError = TheInspectionsClass.InsertDailyVehicleInspection(MainWindow.gintVehicleID, MainWindow.gdatTransactionDate, MainWindow.gintEmployeeID, MainWindow.gstrInspectionStatus, MainWindow.gintOdometerReading); if (blnFatalError == true) { throw new Exception(); } blnFatalError = TheVehicleHistoryClass.InsertVehicleHistory(MainWindow.gintVehicleID, MainWindow.gintEmployeeID, MainWindow.TheVerifyLogonDataSet.VerifyLogon[0].EmployeeID); if (blnFatalError == true) { throw new Exception(); } blnFatalError = TheVehicleMainClass.UpdateVehicleMainEmployeeID(MainWindow.gintVehicleID, MainWindow.gintEmployeeID); if (blnFatalError == true) { TheMessagesClass.ErrorMessage("There Was a Problem, Contact ID"); return; } TheFindDailyVehicleMainInspectionByDateMatchDataSet = TheInspectionsClass.FindDailyVehicleMainInspectionByDateMatch(MainWindow.gdatTransactionDate); MainWindow.gintInspectionID = TheFindDailyVehicleMainInspectionByDateMatchDataSet.FindDailyVehicleMainInspectionByDateMatch[0].TransactionID; blnFatalError = TheInspectGPSClass.InsertInspectGPS(MainWindow.gintInspectionID, MainWindow.gstrInspectionType, gblnGPSInstalled); if (blnFatalError == true) { throw new Exception(); } TheVehicleStatusClass.UpdateVehicleStatus(MainWindow.gintVehicleID, gstrVehicleStatus, DateTime.Now); if (rdoPassedServiceRequired.IsChecked == true) { VehicleInspectionProblem VehicleInspectionProblem = new VehicleInspectionProblem(); VehicleInspectionProblem.ShowDialog(); } txtEnterVehicleNumber.Text = ""; cboEmployee.Items.Clear(); txtEnterLastName.Text = ""; txtOdometerReading.Text = ""; rdoPassed.IsChecked = false; rdoPassedServiceRequired.IsChecked = false; cboBodyDamageReported.SelectedIndex = 0; cboGPSInstalled.SelectedIndex = 0; } catch (Exception Ex) { TheEventLogClass.InsertEventLogEntry(DateTime.Now, "Vehicle Data Entry // Daily Vehicle Inspection // Process Button " + Ex.Message); TheMessagesClass.ErrorMessage(Ex.ToString()); } }
private void mitGenerateReport_Click(object sender, RoutedEventArgs e) { int intCounter; int intNumberOfRecords; int intVehicleID; int intRecordsReturned; DateTime datStartDate = DateTime.Now; DateTime datEndDate; string strFirstNamed = ""; string strLastName = ""; try { TheVehicleExceptionDataSet.vehicleexception.Rows.Clear(); datStartDate = TheDateSearchClass.RemoveTime(datStartDate); 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; TheFindDailyVehicleInspectionByVehicleIDAndDateRangeDataSete = TheInspectionClass.FindDailyVehicleInspectionByVehicleIDAndDateRange(intVehicleID, datStartDate, datEndDate); intRecordsReturned = TheFindDailyVehicleInspectionByVehicleIDAndDateRangeDataSete.FindDailyVehicleInspectionsByVehicleIDAndDateRange.Rows.Count; if (intRecordsReturned == 0) { TheFindVehicleInYardByVehicleIDAndDateRangeDataSet = TheVehicleInYardClass.FindVehiclesInYardByVehicleIDAndDateRange(intVehicleID, datStartDate, datEndDate); intRecordsReturned = TheFindVehicleInYardByVehicleIDAndDateRangeDataSet.FindVehiclesInYardByVehicleIDAndDateRange.Rows.Count; if (intRecordsReturned == 0) { TheFindVehicleMainInShopByVehicleIDDataSet = TheVehicleInShopClass.FindVehicleMainInShopByVehicleID(intVehicleID); intRecordsReturned = TheFindVehicleMainInShopByVehicleIDDataSet.FindVehicleMainInShopByVehicleID.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); } } } } dgrResults.ItemsSource = TheVehicleExceptionDataSet.vehicleexception; } catch (Exception Ex) { TheEventLogClass.InsertEventLogEntry(DateTime.Now, "Blue Jay ERP // Vehicle Exception Report // Generate The Report Menu Item " + Ex.Message); TheMessagesClass.ErrorMessage(Ex.ToString()); } }