public FindGEOFenceByVehicleIDDataSet FindGEOFenceByVehicleID(int intVehicleID, DateTime datStartDate, DateTime datEndDate)
{
try
{
aFindGEOFenceByVehicleIDDataSet = new FindGEOFenceByVehicleIDDataSet();
aFindGEOFenceByVehicleIDTableAdapter = new FindGEOFenceByVehicleIDDataSetTableAdapters.FindGEOFenceByVehicleIDTableAdapter();
aFindGEOFenceByVehicleIDTableAdapter.Fill(aFindGEOFenceByVehicleIDDataSet.FindGEOFenceByVehicleID, intVehicleID, datStartDate, datEndDate);
}
catch (Exception Ex)
{
TheEventLogClass.InsertEventLogEntry(DateTime.Now, "GEO Fence Class // Find GEO Fence By Vehicle ID " + Ex.Message);
}
return(aFindGEOFenceByVehicleIDDataSet);
}
private void expCreateReport_Expanded(object sender, RoutedEventArgs e)
{
//setting local variables
DateTime datStartDate;
DateTime datEndDate;
DateTime datTransactionDate;
DateTime datLimitingDate;
int intCounter;
int intNumberOfRecords;
int intRecordReturned;
int intVehicleID;
PleaseWait PleaseWait = new PleaseWait();
PleaseWait.Show();
try
{
TheVehicleUsageDataSet.vehicleusage.Rows.Clear();
expCreateReport.IsExpanded = false;
TheFindActiveVehicleMainSortedDataSet = TheVehicleMainClass.FindActiveVehicleMainSorted();
intNumberOfRecords = TheFindActiveVehicleMainSortedDataSet.FindActiveVehicleMainSorted.Rows.Count - 1;
for (intCounter = 0; intCounter <= intNumberOfRecords; intCounter++)
{
VehicleUsageDataSet.vehicleusageRow NewVehicleRow = TheVehicleUsageDataSet.vehicleusage.NewvehicleusageRow();
NewVehicleRow.VehicleID = TheFindActiveVehicleMainSortedDataSet.FindActiveVehicleMainSorted[intCounter].VehicleID;
NewVehicleRow.VehicleNumber = TheFindActiveVehicleMainSortedDataSet.FindActiveVehicleMainSorted[intCounter].VehicleNumber;
NewVehicleRow.AssignedOffice = TheFindActiveVehicleMainSortedDataSet.FindActiveVehicleMainSorted[intCounter].AssignedOffice;
NewVehicleRow.TimesInYard = 0;
NewVehicleRow.TimesUnknown = 0;
NewVehicleRow.TimesDriven = 0;
TheVehicleUsageDataSet.vehicleusage.Rows.Add(NewVehicleRow);
}
datEndDate = DateTime.Now;
datEndDate = TheDateSearchClass.RemoveTime(datEndDate);
datStartDate = TheDateSearchClass.SubtractingDays(datEndDate, 120);
datTransactionDate = datStartDate;
datLimitingDate = TheDateSearchClass.AddingDays(datTransactionDate, 1);
intNumberOfRecords = TheVehicleUsageDataSet.vehicleusage.Rows.Count - 1;
while (datLimitingDate <= datEndDate)
{
if (datTransactionDate.DayOfWeek != DayOfWeek.Saturday)
{
if (datTransactionDate.DayOfWeek != DayOfWeek.Sunday)
{
for (intCounter = 0; intCounter <= intNumberOfRecords; intCounter++)
{
intVehicleID = TheVehicleUsageDataSet.vehicleusage[intCounter].VehicleID;
TheFindGEOFenceByVehicleIDDataSet = TheGEOFenceClass.FindGEOFenceByVehicleID(intVehicleID, datTransactionDate, datLimitingDate);
intRecordReturned = TheFindGEOFenceByVehicleIDDataSet.FindGEOFenceByVehicleID.Rows.Count;
if (intRecordReturned > 0)
{
TheVehicleUsageDataSet.vehicleusage[intCounter].TimesDriven++;
}
else
{
TheFindDailyVehicleInspectionByVehicleIDAndDateRangeDataSet = TheInspectionsClass.FindDailyVehicleInspectionByVehicleIDAndDateRange(intVehicleID, datTransactionDate, datLimitingDate);
intRecordReturned = TheFindDailyVehicleInspectionByVehicleIDAndDateRangeDataSet.FindDailyVehicleInspectionsByVehicleIDAndDateRange.Rows.Count;
if (intRecordReturned > 0)
{
TheVehicleUsageDataSet.vehicleusage[intCounter].TimesDriven++;
}
else
{
TheFindVehicleInYardByVehicleIDAndDateRangeDataSet = TheVehicleInYardClass.FindVehiclesInYardByVehicleIDAndDateRange(intVehicleID, datTransactionDate, datLimitingDate);
intRecordReturned = TheFindVehicleInYardByVehicleIDAndDateRangeDataSet.FindVehiclesInYardByVehicleIDAndDateRange.Rows.Count;
if (intRecordReturned > 0)
{
TheVehicleUsageDataSet.vehicleusage[intCounter].TimesInYard++;
}
else
{
TheVehicleUsageDataSet.vehicleusage[intCounter].TimesUnknown++;
}
}
}
}
}
}
datTransactionDate = TheDateSearchClass.AddingDays(datTransactionDate, 1);
datLimitingDate = TheDateSearchClass.AddingDays(datLimitingDate, 1);
}
dgrResults.ItemsSource = TheVehicleUsageDataSet.vehicleusage;
}
catch (Exception Ex)
{
TheEventLogClass.InsertEventLogEntry(DateTime.Now, "New Blue Jay ERP // Vehicle Usage Report // Create Report Expander " + Ex.Message);
TheMessagesClass.ErrorMessage(Ex.ToString());
}
PleaseWait.Close();
}
