public FindCurrentVehicleAssignmentByEmployeeIDDataSet FindCurrentVehicleAssignmentByEmployeeID(int intEmployeeID) { try { aFindCurrentVehicleAssignmentByEmployeeIDDataSet = new FindCurrentVehicleAssignmentByEmployeeIDDataSet(); aFindCurrentVehicleAssignmentByEmployeeIDTableAdapter = new FindCurrentVehicleAssignmentByEmployeeIDDataSetTableAdapters.FindCurrentVehicleMainAssignmentByEmployeeIDTableAdapter(); aFindCurrentVehicleAssignmentByEmployeeIDTableAdapter.Fill(aFindCurrentVehicleAssignmentByEmployeeIDDataSet.FindCurrentVehicleMainAssignmentByEmployeeID, intEmployeeID); } catch (Exception Ex) { TheEventLogClass.InsertEventLogEntry(DateTime.Now, "Vehicle Assignment Class // Find Current Vehicle Assignment By Employee ID " + Ex.Message); } return(aFindCurrentVehicleAssignmentByEmployeeIDDataSet); }
private bool VehicleAssignment() { //data validation string strValueForValidation; bool blnFatalError = false; string strErrorMessage = ""; int intRecordsReturned; int intTransactionID; string strMessage; string strCaption = "Thank You"; string strHomeOffice = ""; string strSecondVehicleNumber; int intVehicleID; int intWarehouseID; try { gstrVehicleNumber = txtVehicleNumber.Text; TheFindActiveVehicleMainByVehicleNumberDataSet = TheVehicleMainClass.FindActiveVehicleMainByVehicleNumber(gstrVehicleNumber); intRecordsReturned = TheFindActiveVehicleMainByVehicleNumberDataSet.FindActiveVehicleMainByVehicleNumber.Rows.Count; if (intRecordsReturned == 0) { blnFatalError = true; strErrorMessage += "Vehice Number Not Valid\n"; } else { MainWindow.gintVehicleID = TheFindActiveVehicleMainByVehicleNumberDataSet.FindActiveVehicleMainByVehicleNumber[0].VehicleID; strHomeOffice = TheFindActiveVehicleMainByVehicleNumberDataSet.FindActiveVehicleMainByVehicleNumber[0].AssignedOffice; } strValueForValidation = cboSelectEmployee.SelectedItem.ToString(); if (strValueForValidation == "Select Employee") { blnFatalError = true; strErrorMessage += "The Employee Was Not Selected\n"; } if (blnFatalError == true) { TheMessagesClass.ErrorMessage(strErrorMessage); return(blnFatalError); } TheFindCurrentVehicleAssignmentByEmployeeIDDataSet = TheVehicleAssignmentClass.FindCurrentVehicleAssignmentByEmployeeID(MainWindow.gintEmployeeID); intRecordsReturned = TheFindCurrentVehicleAssignmentByEmployeeIDDataSet.FindCurrentVehicleMainAssignmentByEmployeeID.Rows.Count; if (intRecordsReturned > 0) { if (TheFindCurrentVehicleAssignmentByEmployeeIDDataSet.FindCurrentVehicleMainAssignmentByEmployeeID[0].LastName != "WAREHOUSE") { intTransactionID = TheFindCurrentVehicleAssignmentByEmployeeIDDataSet.FindCurrentVehicleMainAssignmentByEmployeeID[0].TransactionID; strMessage = "Employee Is Assigned To Vehicle Number " + TheFindCurrentVehicleAssignmentByEmployeeIDDataSet.FindCurrentVehicleMainAssignmentByEmployeeID[0].VehicleNumber + "\nDo You Want to Sign Out the Employee of " + TheFindCurrentVehicleAssignmentByEmployeeIDDataSet.FindCurrentVehicleMainAssignmentByEmployeeID[0].VehicleNumber; MessageBoxResult result = MessageBox.Show(strMessage, strCaption, MessageBoxButton.YesNo, MessageBoxImage.Question); if (result == MessageBoxResult.Yes) { intWarehouseID = FindWarehouseID(strHomeOffice); strSecondVehicleNumber = TheFindCurrentVehicleAssignmentByEmployeeIDDataSet.FindCurrentVehicleMainAssignmentByEmployeeID[0].VehicleNumber; TheFindActiveVehicleMainByVehicleNumberDataSet = TheVehicleMainClass.FindActiveVehicleMainByVehicleNumber(strSecondVehicleNumber); intVehicleID = TheFindActiveVehicleMainByVehicleNumberDataSet.FindActiveVehicleMainByVehicleNumber[0].VehicleID; blnFatalError = TheVehicleAssignmentClass.UpdateCurrentVehicleAssignment(intTransactionID, false); if (blnFatalError == true) { throw new Exception(); } blnFatalError = TheVehicleMainClass.UpdateVehicleMainEmployeeID(intVehicleID, intWarehouseID); if (blnFatalError == true) { throw new Exception(); } blnFatalError = TheVehicleAssignmentClass.InsertVehicleAssignment(intVehicleID, intWarehouseID); if (blnFatalError == true) { throw new Exception(); } } else { blnFatalError = true; return(blnFatalError); } } } blnFatalError = TheVehicleMainClass.UpdateVehicleMainEmployeeID(MainWindow.gintVehicleID, MainWindow.gintEmployeeID); if (blnFatalError == true) { throw new Exception(); } blnFatalError = TheVehicleAssignmentClass.InsertVehicleAssignment(MainWindow.gintVehicleID, MainWindow.gintEmployeeID); if (blnFatalError == true) { throw new Exception(); } intRecordsReturned = TheFindCurrentAssignedVehicleMainByVehicleIDDataSet.FindCurrentAssignedVehicleMainByVehicleID.Rows.Count; if (intRecordsReturned == 1) { intTransactionID = TheFindCurrentAssignedVehicleMainByVehicleIDDataSet.FindCurrentAssignedVehicleMainByVehicleID[0].TransactionID; blnFatalError = TheVehicleAssignmentClass.UpdateCurrentVehicleAssignment(intTransactionID, false); if (blnFatalError == true) { throw new Exception(); } } txtEnterDate.Text = Convert.ToString(DateTime.Now); TheMessagesClass.InformationMessage("The Record Has Been Saved"); txtVehicleNumber.Focus(); } catch (Exception Ex) { TheEventLogClass.InsertEventLogEntry(DateTime.Now, "Daily Vehicle Data Entry // Vehicle Assignment // Process Menu Item " + Ex.Message); TheMessagesClass.ErrorMessage(Ex.ToString()); blnFatalError = true; } return(blnFatalError); }
private void mitProcess_Click(object sender, RoutedEventArgs e) { //data validation string strValueForValidation; bool blnFatalError = false; string strErrorMessage = ""; int intRecordsReturned; int intTransactionID; try { MainWindow.gstrVehicleNumber = txtVehicleNumber.Text; TheFindActiveVehicleMainByVehicleNumberDataSet = TheVehicleMainClass.FindActiveVehicleMainByVehicleNumber(MainWindow.gstrVehicleNumber); intRecordsReturned = TheFindActiveVehicleMainByVehicleNumberDataSet.FindActiveVehicleMainByVehicleNumber.Rows.Count; if (intRecordsReturned == 0) { blnFatalError = true; strErrorMessage += "Vehice Number Not Valid\n"; } else { MainWindow.gintVehicleID = TheFindActiveVehicleMainByVehicleNumberDataSet.FindActiveVehicleMainByVehicleNumber[0].VehicleID; } strValueForValidation = cboSelectEmployee.SelectedItem.ToString(); if (strValueForValidation == "Select Employee") { blnFatalError = true; strErrorMessage += "The Employee Was Not Selected\n"; } if (blnFatalError == true) { TheMessagesClass.ErrorMessage(strErrorMessage); return; } TheFindCurrentVehicleAssignmentByEmployeeIDDataSet = TheVehicleAssignmentClass.FindCurrentVehicleAssignmentByEmployeeID(MainWindow.gintEmployeeID); intRecordsReturned = TheFindCurrentVehicleAssignmentByEmployeeIDDataSet.FindCurrentVehicleMainAssignmentByEmployeeID.Rows.Count; if (intRecordsReturned > 0) { if (TheFindCurrentVehicleAssignmentByEmployeeIDDataSet.FindCurrentVehicleMainAssignmentByEmployeeID[0].LastName != "WAREHOUSE") { TheMessagesClass.ErrorMessage("Employee Is Assigned To Vehicle Number " + TheFindCurrentVehicleAssignmentByEmployeeIDDataSet.FindCurrentVehicleMainAssignmentByEmployeeID[0].VehicleNumber); return; } } blnFatalError = TheVehicleMainClass.UpdateVehicleMainEmployeeID(MainWindow.gintVehicleID, MainWindow.gintEmployeeID); if (blnFatalError == true) { throw new Exception(); } blnFatalError = TheVehicleAssignmentClass.InsertVehicleAssignment(MainWindow.gintVehicleID, MainWindow.gintEmployeeID); if (blnFatalError == true) { throw new Exception(); } intRecordsReturned = TheFindCurrentAssignedVehicleMainByVehicleIDDataSet.FindCurrentAssignedVehicleMainByVehicleID.Rows.Count; if (intRecordsReturned == 1) { intTransactionID = TheFindCurrentAssignedVehicleMainByVehicleIDDataSet.FindCurrentAssignedVehicleMainByVehicleID[0].TransactionID; blnFatalError = TheVehicleAssignmentClass.UpdateCurrentVehicleAssignment(intTransactionID, false); if (blnFatalError == true) { throw new Exception(); } } TheMessagesClass.InformationMessage("The Record Has Been Saved"); ResetControls(); txtVehicleNumber.Focus(); } catch (Exception Ex) { TheEventLogClass.InsertEventLogEntry(DateTime.Now, "Blue Jay ERP // Assign Vehicle // Process Menu Item " + Ex.Message); TheMessagesClass.ErrorMessage(Ex.ToString()); } }