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());
}
}
