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