private void UpdateVehicleStatus()
{
int intCounter;
int intNumberOfRecords;
int intVehicleID;
int intRecordsReturned;
bool blnFatalError = false;
string strStatus;
try
{
//getting the vehicles
TheFindActiveVehiclesDataSet = TheVehicleClass.FindActiveVehicles();
intNumberOfRecords = TheFindActiveVehiclesDataSet.FindActiveVehicles.Rows.Count - 1;
for(intCounter = 0; intCounter <= intNumberOfRecords; intCounter++)
{
intVehicleID = TheFindActiveVehiclesDataSet.FindActiveVehicles[intCounter].VehicleID;
TheFindOpenVehicleProblemsByVehicleIDDataSet = TheVehicleProblemClass.FindOpenVehicleProblemsbyVehicleID(intVehicleID);
intRecordsReturned = TheFindOpenVehicleProblemsByVehicleIDDataSet.FindOpenVehicleProblemsByVehicleID.Rows.Count;
if(intRecordsReturned > 0)
{
//checking to see what the status is
TheFindVehicleStatusByVehicleIDDataSet = TheVehicleStatusClass.FindVehicleStatusByVehicleID(intVehicleID);
intRecordsReturned = TheFindVehicleStatusByVehicleIDDataSet.FindVehicleStatusByVehicleID.Rows.Count;
if(intRecordsReturned == 1)
{
strStatus = TheFindVehicleStatusByVehicleIDDataSet.FindVehicleStatusByVehicleID[0].VehicleStatus;
if((strStatus == "AVAILABLE") || (strStatus == "SIGNED OUT"))
{
blnFatalError = TheVehicleStatusClass.UpdateVehicleStatus(intVehicleID, "NEEDS WORK", DateTime.Now);
if (blnFatalError == true)
throw new Exception();
}
if(strStatus == "NO PROBLEM")
{
blnFatalError = TheVehicleStatusClass.UpdateVehicleStatus(intVehicleID, "NEEDS WORK", DateTime.Now);
if (blnFatalError == true)
throw new Exception();
}
}
}
else if (intRecordsReturned == 0)
{
TheFindVehicleStatusByVehicleIDDataSet = TheVehicleStatusClass.FindVehicleStatusByVehicleID(intVehicleID);
intRecordsReturned = TheFindVehicleStatusByVehicleIDDataSet.FindVehicleStatusByVehicleID.Rows.Count;
if(intRecordsReturned == 1)
{
if(TheFindVehicleStatusByVehicleIDDataSet.FindVehicleStatusByVehicleID[0].VehicleStatus != "NO PROBLEM")
{
blnFatalError = TheVehicleStatusClass.UpdateVehicleStatus(intVehicleID, "NO PROBLEM", DateTime.Now);
if (blnFatalError == true)
throw new Exception();
}
}
else if (intRecordsReturned == 0)
{
blnFatalError = TheVehicleStatusClass.InsertVehicleStatus(intVehicleID, "NO PROBLEM", DateTime.Now);
if (blnFatalError == true)
throw new Exception();
}
}
}
}
catch (Exception Ex)
{
TheEventLogClass.InsertEventLogEntry(DateTime.Now, "Event Log Tracker // Update Vehicle Status " + Ex.Message);
}
}