public FindFuelCardEmployeeDataSet FindFuelCardEmployee(int intFuelCardNumber) { try { aFindFuelCardEmployeeDataSet = new FindFuelCardEmployeeDataSet(); aFindFuelCardEmployeeTableAdapter = new FindFuelCardEmployeeDataSetTableAdapters.FindFuelCardEmployeeTableAdapter(); aFindFuelCardEmployeeTableAdapter.Fill(aFindFuelCardEmployeeDataSet.FindFuelCardEmployee, intFuelCardNumber); } catch (Exception Ex) { TheEventLogClass.InsertEventLogEntry(DateTime.Now, "Fuel Card Class // Find Fuel Card Employee " + Ex.Message); } return(aFindFuelCardEmployeeDataSet); }
private int RandomNumber() { int intFuelCardNumber = -1; int intRecordsReturned = 1; while (intRecordsReturned > 0) { Random FuelCardNumber = new Random(); intFuelCardNumber = FuelCardNumber.Next(1000, 9999); TheFindFuelCardEmployeeDataSet = TheFuelCardClass.FindFuelCardEmployee(intFuelCardNumber); intRecordsReturned = TheFindFuelCardEmployeeDataSet.FindFuelCardEmployee.Rows.Count; } return(intFuelCardNumber); }
private void btnProcess_Click(object sender, RoutedEventArgs e) { //setting up variables int intFuelPIN = 0; string strValueForValidation; string strErrorMessage = ""; bool blnFatalError = false; bool blnThereIsAProblem = false; int intRecordsReturned; try { if (cboSelectEmployee.SelectedIndex < 1) { blnFatalError = true; strErrorMessage += "The Employee Was Not Selected\n"; } strValueForValidation = txtEnterPIN.Text; blnThereIsAProblem = TheDataValidationClass.VerifyIntegerData(strValueForValidation); if (blnThereIsAProblem == true) { blnFatalError = true; strErrorMessage += "The Fuel PIN is not Numeric\n"; } else { intFuelPIN = Convert.ToInt32(strValueForValidation); if ((intFuelPIN < 1000) || (intFuelPIN > 9999)) { blnFatalError = true; strErrorMessage += "The Fuel PIN is out Range\n"; } } if (blnFatalError == true) { TheMessagesClass.ErrorMessage(strErrorMessage); return; } TheFindEmployeeActiveFuelCardNumberDataSet = TheFuelCardClass.FindEmployeeActiveFuelCardNumber(MainWindow.gintEmployeeID); intRecordsReturned = TheFindEmployeeActiveFuelCardNumberDataSet.FindEmployeeActiveFuelCardNumber.Rows.Count; if (intRecordsReturned > 0) { TheMessagesClass.ErrorMessage("Employee Already Has a Fuel Card PIN"); return; } TheFindFuelCardEmployeeDataSet = TheFuelCardClass.FindFuelCardEmployee(intFuelPIN); intRecordsReturned = TheFindFuelCardEmployeeDataSet.FindFuelCardEmployee.Rows.Count; if (intRecordsReturned > 0) { TheMessagesClass.ErrorMessage("The Fuel Card PIN Has Already Been Used"); return; } blnFatalError = TheFuelCardClass.InsertFuelCard(MainWindow.gintEmployeeID, intFuelPIN); if (blnFatalError == true) { throw new Exception(); } TheMessagesClass.InformationMessage("The Fuel PIN has been entered"); ResetControls(); } catch (Exception Ex) { TheEventLogClass.InsertEventLogEntry(DateTime.Now, "New Blue Jay ERP // Manually Add Fuel PIN // Process Button " + Ex.Message); TheMessagesClass.ErrorMessage(Ex.ToString()); } }