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