private void txtEnterVehicleNumber_TextChanged(object sender, TextChangedEventArgs e)
{
//setting local variables
string strVehicleNumber;
int intLength;
int intRecordsReturned;
try
{
strVehicleNumber = txtEnterVehicleNumber.Text;
MainWindow.gstrVehicleNumber = strVehicleNumber;
intLength = strVehicleNumber.Length;
if (intLength == 4)
{
TheFindActivehicleMainByVehicleNumberDataSet = TheVehicleMainClass.FindActiveVehicleMainByVehicleNumber(strVehicleNumber);
intRecordsReturned = TheFindActivehicleMainByVehicleNumberDataSet.FindActiveVehicleMainByVehicleNumber.Rows.Count;
if (intRecordsReturned > 0)
{
MainWindow.gintVehicleID = TheFindActivehicleMainByVehicleNumberDataSet.FindActiveVehicleMainByVehicleNumber[0].VehicleID;
TheFindOpenVehicleMainProblemsByVehicleIDDataSet = TheVehicleProblemsClass.FindOpenVehicleMainProblemsByVehicleID(MainWindow.gintVehicleID);
dgrOpenProblems.ItemsSource = TheFindOpenVehicleMainProblemsByVehicleIDDataSet.FindOpenVehicleMainProblemsByVehicleID;
TheFindVehiclesInShopByVehlcleIDDataSet = TheVehiclesInShopClass.FindVehiclesInShopByVehicleID(MainWindow.gintVehicleID);
intRecordsReturned = TheFindVehiclesInShopByVehlcleIDDataSet.FindVehiclesInShopByVehicleID.Rows.Count;
if (intRecordsReturned > 0)
{
txtVehicleInyard.Text = "YES With " + TheFindVehiclesInShopByVehlcleIDDataSet.FindVehiclesInShopByVehicleID[0].VendorName;
}
else
{
txtVehicleInyard.Text = "Not In Shop";
}
}
}
else if (intLength == 6)
{
TheFindActivehicleMainByVehicleNumberDataSet = TheVehicleMainClass.FindActiveVehicleMainByVehicleNumber(strVehicleNumber);
intRecordsReturned = TheFindActivehicleMainByVehicleNumberDataSet.FindActiveVehicleMainByVehicleNumber.Rows.Count;
if (intRecordsReturned > 0)
{
MainWindow.gintVehicleID = TheFindActivehicleMainByVehicleNumberDataSet.FindActiveVehicleMainByVehicleNumber[0].VehicleID;
TheFindOpenVehicleMainProblemsByVehicleIDDataSet = TheVehicleProblemsClass.FindOpenVehicleMainProblemsByVehicleID(MainWindow.gintVehicleID);
dgrOpenProblems.ItemsSource = TheFindOpenVehicleMainProblemsByVehicleIDDataSet.FindOpenVehicleMainProblemsByVehicleID;
TheFindVehiclesInShopByVehlcleIDDataSet = TheVehiclesInShopClass.FindVehiclesInShopByVehicleID(MainWindow.gintVehicleID);
intRecordsReturned = TheFindVehiclesInShopByVehlcleIDDataSet.FindVehiclesInShopByVehicleID.Rows.Count;
if (intRecordsReturned > 0)
{
txtVehicleInyard.Text = "YES With " + TheFindVehiclesInShopByVehlcleIDDataSet.FindVehiclesInShopByVehicleID[0].VendorName;
}
else
{
txtVehicleInyard.Text = "Not In Shop";
}
}
else
{
TheMessagesClass.ErrorMessage("Vehicle Not Found");
return;
}
}
else if (intLength > 6)
{
TheMessagesClass.ErrorMessage("Vehicle Number Entered has to Many Characters");
return;
}
}
catch (Exception Ex)
{
TheEventLogClass.InsertEventLogEntry(DateTime.Now, "Blue Jay ERP // Update Vehicle Problem // Enter Vehicle Textbox " + 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);
}
