public FindDailyVehicleInspectionByVehicleIDAndDateRangeDataSet FindDailyVehicleInspectionByVehicleIDAndDateRange(int intVehicleID, DateTime datStartDate, DateTime datEndDate)
{
try
{
aFindDailyVehicleInspectionbyVehicleIDAndDateRangeDataSet = new FindDailyVehicleInspectionByVehicleIDAndDateRangeDataSet();
aFindDailyVehicleInspectionByVehicleIDAndDateRangeTableAdapter = new FindDailyVehicleInspectionByVehicleIDAndDateRangeDataSetTableAdapters.FindDailyVehicleInspectionsByVehicleIDAndDateRangeTableAdapter();
aFindDailyVehicleInspectionByVehicleIDAndDateRangeTableAdapter.Fill(aFindDailyVehicleInspectionbyVehicleIDAndDateRangeDataSet.FindDailyVehicleInspectionsByVehicleIDAndDateRange, intVehicleID, datStartDate, datEndDate);
}
catch (Exception Ex)
{
TheEventLogClass.InsertEventLogEntry(DateTime.Now, "Inspection Class // Find Daily Vehicle Inspection By Vehicle ID and Date Range " + Ex.Message);
}
return(aFindDailyVehicleInspectionbyVehicleIDAndDateRangeDataSet);
}
private void mitGenerateReport_Click(object sender, RoutedEventArgs e)
{
int intCounter;
int intNumberOfRecords;
int intRecordsReturned;
DateTime datStartDate;
DateTime datEndDated;
DateTime datLimitDate;
string strAssignedOffice;
int intVehicleID;
bool blnItemFound;
try
{
TheHistoricalExceptionDataSet.vehicleexception.Rows.Clear();
strAssignedOffice = txtOfficeName.Text;
if (strAssignedOffice == "")
{
TheMessagesClass.ErrorMessage("Assigned Office Was Not Entered");
return;
}
TheFindVehicleMainForAssignedOfficeDataSet = TheVehicleMainClass.FindVehicleMainForAssignedOffice(strAssignedOffice);
intNumberOfRecords = TheFindVehicleMainForAssignedOfficeDataSet.FindVehicleMainForAssignedOffice.Rows.Count - 1;
if (intNumberOfRecords < 0)
{
TheMessagesClass.ErrorMessage("The Assigned Office Does Not Exist");
return;
}
datLimitDate = DateTime.Now;
datLimitDate = TheDateSearchClass.RemoveTime(datLimitDate);
datStartDate = TheDateSearchClass.SubtractingDays(datLimitDate, 90);
while (datStartDate < datLimitDate)
{
for (intCounter = 0; intCounter <= intNumberOfRecords; intCounter++)
{
blnItemFound = false;
datEndDated = TheDateSearchClass.AddingDays(datStartDate, 1);
intVehicleID = TheFindVehicleMainForAssignedOfficeDataSet.FindVehicleMainForAssignedOffice[intCounter].VehicleID;
TheFindDailyVehicleInspectionByVehicleIDAndDateRangeDataSete = TheInspectionClass.FindDailyVehicleInspectionByVehicleIDAndDateRange(intVehicleID, datStartDate, datEndDated);
intRecordsReturned = TheFindDailyVehicleInspectionByVehicleIDAndDateRangeDataSete.FindDailyVehicleInspectionsByVehicleIDAndDateRange.Rows.Count;
if (intRecordsReturned > 0)
{
blnItemFound = true;
}
else
{
TheFindVehicleInYardByVehicleIDAndDateRangeDataSet = TheVehiclesInYardClass.FindVehiclesInYardByVehicleIDAndDateRange(intVehicleID, datStartDate, datEndDated);
intRecordsReturned = TheFindVehicleInYardByVehicleIDAndDateRangeDataSet.FindVehiclesInYardByVehicleIDAndDateRange.Rows.Count;
if (intRecordsReturned > 0)
{
blnItemFound = true;
}
}
if (blnItemFound == false)
{
HistoricalExceptionsDataSet.vehicleexceptionRow NewVehicleRow = TheHistoricalExceptionDataSet.vehicleexception.NewvehicleexceptionRow();
NewVehicleRow.AssignedOffice = strAssignedOffice;
NewVehicleRow.FirstName = TheFindVehicleMainForAssignedOfficeDataSet.FindVehicleMainForAssignedOffice[intCounter].FirstName;
NewVehicleRow.LastName = TheFindVehicleMainForAssignedOfficeDataSet.FindVehicleMainForAssignedOffice[intCounter].LastName;
NewVehicleRow.InspectionDate = datStartDate;
NewVehicleRow.VehicleID = intVehicleID;
NewVehicleRow.VehicleNumber = TheFindVehicleMainForAssignedOfficeDataSet.FindVehicleMainForAssignedOffice[intCounter].VehicleNumber;
TheHistoricalExceptionDataSet.vehicleexception.Rows.Add(NewVehicleRow);
}
}
datStartDate = TheDateSearchClass.AddingDays(datStartDate, 1);
if (datStartDate.DayOfWeek == DayOfWeek.Saturday)
{
datStartDate = TheDateSearchClass.AddingDays(datStartDate, 2);
}
else if (datStartDate.DayOfWeek == DayOfWeek.Sunday)
{
datStartDate = TheDateSearchClass.AddingDays(datStartDate, 1);
}
}
dgrResults.ItemsSource = TheHistoricalExceptionDataSet.vehicleexception;
}
catch (Exception Ex)
{
TheEventLogClass.InsertEventLogEntry(DateTime.Now, "Blue Jay ERP // Historical Vehicle Exception Report // Generate Report " + Ex.Message);
TheMessagesClass.ErrorMessage(Ex.ToString());
}
}
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();
}
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 expImportExcel_Expanded(object sender, RoutedEventArgs e)
{
Excel.Application xlDropOrder;
Excel.Workbook xlDropBook;
Excel.Worksheet xlDropSheet;
Excel.Range range;
int intColumnRange = 0;
int intCounter;
int intNumberOfRecords;
string strIsInside;
string strDriver;
string strVehicleNumber;
string strEventDate;
double douEventDate;
DateTime datEventDate;
bool blnIsInSide = false;
int intVehicleCounter;
int intVehicleNumberOfRecords;
int intEmployeeCounter;
int intEmployeeNumberOfRecords;
string strAssignedOffice = "";
int intSubstringLength;
string strFullName;
int intVehicleID = 0;
DateTime datStartDate = DateTime.Now;
DateTime datEndDate = DateTime.Now;
try
{
TheImportGEOFenceDataSet.importgeofence.Rows.Clear();
Microsoft.Win32.OpenFileDialog dlg = new Microsoft.Win32.OpenFileDialog();
dlg.FileName = "Document"; // Default file name
dlg.DefaultExt = ".xlsx"; // Default file extension
dlg.Filter = "Excel (.xlsx)|*.xlsx"; // Filter files by extension
// Show open file dialog box
Nullable <bool> result = dlg.ShowDialog();
// Process open file dialog box results
if (result == true)
{
// Open document
string filename = dlg.FileName;
}
PleaseWait PleaseWait = new PleaseWait();
PleaseWait.Show();
xlDropOrder = new Excel.Application();
xlDropBook = xlDropOrder.Workbooks.Open(dlg.FileName, 0, true, 5, "", "", true, Microsoft.Office.Interop.Excel.XlPlatform.xlWindows, "\t", false, false, 0, true, 1, 0);
xlDropSheet = (Excel.Worksheet)xlDropOrder.Worksheets.get_Item(1);
range = xlDropSheet.UsedRange;
intNumberOfRecords = range.Rows.Count;
intColumnRange = range.Columns.Count;
for (intCounter = 5; intCounter <= intNumberOfRecords; intCounter++)
{
strEventDate = Convert.ToString((range.Cells[intCounter, 1] as Excel.Range).Value2).ToUpper();
strIsInside = Convert.ToString((range.Cells[intCounter, 9] as Excel.Range).Value2).ToUpper();
strDriver = Convert.ToString((range.Cells[intCounter, 10] as Excel.Range).Value2).ToUpper();
strVehicleNumber = Convert.ToString((range.Cells[intCounter, 11] as Excel.Range).Value2).ToUpper();
douEventDate = Convert.ToDouble(strEventDate);
datEventDate = DateTime.FromOADate(douEventDate);
if (strIsInside == "YES")
{
blnIsInSide = true;
}
else
{
blnIsInSide = false;
}
ImportGEOFencedDataSet.importgeofenceRow NewGEOFenceTransaction = TheImportGEOFenceDataSet.importgeofence.NewimportgeofenceRow();
NewGEOFenceTransaction.Driver = strDriver;
NewGEOFenceTransaction.EmployeeID = -1;
NewGEOFenceTransaction.EventTime = datEventDate;
NewGEOFenceTransaction.VehicleID = -1;
NewGEOFenceTransaction.VehicleNumber = strVehicleNumber;
NewGEOFenceTransaction.InSide = blnIsInSide;
TheImportGEOFenceDataSet.importgeofence.Rows.Add(NewGEOFenceTransaction);
}
dgrResults.ItemsSource = TheImportGEOFenceDataSet.importgeofence;
TheMessagesClass.InformationMessage("Click OK to Continue");
intNumberOfRecords = TheImportGEOFenceDataSet.importgeofence.Rows.Count - 1;
intVehicleNumberOfRecords = TheFindActiveVehicleMainDataSet.FindActiveVehicleMain.Rows.Count - 1;
for (intCounter = 0; intCounter <= intNumberOfRecords; intCounter++)
{
for (intVehicleCounter = 0; intVehicleCounter <= intVehicleNumberOfRecords; intVehicleCounter++)
{
strVehicleNumber = TheFindActiveVehicleMainDataSet.FindActiveVehicleMain[intVehicleCounter].VehicleNumber;
if (TheImportGEOFenceDataSet.importgeofence[intCounter].VehicleNumber.Contains(strVehicleNumber) == true)
{
TheImportGEOFenceDataSet.importgeofence[intCounter].VehicleID = TheFindActiveVehicleMainDataSet.FindActiveVehicleMain[intVehicleCounter].VehicleID;
TheImportGEOFenceDataSet.importgeofence[intCounter].VehicleNumber = strVehicleNumber;
strAssignedOffice = TheFindActiveVehicleMainDataSet.FindActiveVehicleMain[intVehicleCounter].AssignedOffice;
intVehicleID = TheFindActiveVehicleMainDataSet.FindActiveVehicleMain[intVehicleCounter].VehicleID;
datStartDate = TheDateSearchClass.RemoveTime(TheImportGEOFenceDataSet.importgeofence[intCounter].EventTime);
datEndDate = TheDateSearchClass.AddingDays(datStartDate, 1);
}
}
strDriver = TheImportGEOFenceDataSet.importgeofence[intCounter].Driver;
if (strDriver == "NO DRIVER CHECKED IN")
{
intEmployeeNumberOfRecords = TheFindWarehouseDataSet.FindWarehouses.Rows.Count - 1;
for (intEmployeeCounter = 0; intEmployeeCounter <= intEmployeeNumberOfRecords; intEmployeeCounter++)
{
if (strAssignedOffice == TheFindWarehouseDataSet.FindWarehouses[intEmployeeCounter].FirstName)
{
TheImportGEOFenceDataSet.importgeofence[intCounter].EmployeeID = TheFindWarehouseDataSet.FindWarehouses[intEmployeeCounter].EmployeeID;
}
}
}
else
{
TheFindEmployeeByLastDataSet = TheEmployeeClass.FindEmployeesByLastNameKeyWord(strDriver);
intEmployeeNumberOfRecords = TheFindEmployeeByLastDataSet.FindEmployeeByLastName.Rows.Count - 1;
if (intEmployeeNumberOfRecords == 0)
{
TheImportGEOFenceDataSet.importgeofence[intCounter].EmployeeID = TheFindEmployeeByLastDataSet.FindEmployeeByLastName[0].EmployeeID;
}
else
{
TheFindDailyVehicleInspectionByVehicleIDandDateRangeDataSet = TheInspectionsClass.FindDailyVehicleInspectionByVehicleIDAndDateRange(intVehicleID, datStartDate, datEndDate);
intEmployeeNumberOfRecords = TheFindDailyVehicleInspectionByVehicleIDandDateRangeDataSet.FindDailyVehicleInspectionsByVehicleIDAndDateRange.Rows.Count;
if (intEmployeeNumberOfRecords > 0)
{
TheImportGEOFenceDataSet.importgeofence[intCounter].EmployeeID = TheFindDailyVehicleInspectionByVehicleIDandDateRangeDataSet.FindDailyVehicleInspectionsByVehicleIDAndDateRange[0].EmployeeID;
}
else
{
intEmployeeNumberOfRecords = TheFindWarehouseDataSet.FindWarehouses.Rows.Count - 1;
for (intEmployeeCounter = 0; intEmployeeCounter <= intEmployeeNumberOfRecords; intEmployeeCounter++)
{
if (strAssignedOffice == TheFindWarehouseDataSet.FindWarehouses[intEmployeeCounter].FirstName)
{
TheImportGEOFenceDataSet.importgeofence[intCounter].EmployeeID = TheFindWarehouseDataSet.FindWarehouses[intEmployeeCounter].EmployeeID;
}
}
}
}
}
}
PleaseWait.Close();
}
catch (Exception Ex)
{
TheEventLogClass.InsertEventLogEntry(DateTime.Now, "New Blue Jay ERP // Import GEO Fence Report // Import Excel " + 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());
}
}
private void mitGenerateReport_Click(object sender, RoutedEventArgs e)
{
//setting local variables
bool blnThereIsAProblem = false;
bool blnFatalError = false;
string strValueForValidation;
string strErrorMessage = "";
int intCounter;
int intNumberOfRecords;
int intInspectionID;
int intRecordsReturned;
string strVehicleNumber;
PleaseWait PleaseWait = new PleaseWait();
PleaseWait.Show();
try
{
TheDailyVehicleInspectionReportDataSet.dailyinspection.Rows.Clear();
strValueForValidation = txtStartDate.Text;
blnThereIsAProblem = TheDataValidationClass.VerifyDateData(strValueForValidation);
if (blnThereIsAProblem == true)
{
blnFatalError = true;
strErrorMessage += "Start Date is not a Date\n";
}
else
{
gdatStartDate = Convert.ToDateTime(strValueForValidation);
}
strValueForValidation = txtEndDate.Text;
blnThereIsAProblem = TheDataValidationClass.VerifyDateData(strValueForValidation);
if (blnThereIsAProblem == true)
{
blnFatalError = true;
strErrorMessage += "End Date is not a Date\n";
}
else
{
gdatEndDate = Convert.ToDateTime(strValueForValidation);
gdatEndDate = TheDataSearchClass.RemoveTime(gdatEndDate);
gdatEndDate = TheDataSearchClass.AddingDays(gdatEndDate, 1);
}
if (blnFatalError == true)
{
TheMessagesClass.ErrorMessage(strErrorMessage);
PleaseWait.Close();
return;
}
else
{
blnFatalError = TheDataValidationClass.verifyDateRange(gdatStartDate, gdatEndDate);
if (blnFatalError == true)
{
TheMessagesClass.ErrorMessage("Start Date is After the End Date");
PleaseWait.Close();
return;
}
}
if (gstrReportType == "DATE RANGE")
{
TheFindDailyVehicleInspectionByDateRangeDataSet = TheInspectionClass.FindDailyVehicleInspectionByDateRange(gdatStartDate, gdatEndDate);
intNumberOfRecords = TheFindDailyVehicleInspectionByDateRangeDataSet.FindDailyVehicleInspectionByDateRange.Rows.Count - 1;
if (intNumberOfRecords > -1)
{
for (intCounter = 0; intCounter <= intNumberOfRecords; intCounter++)
{
DailyVehicleInspectionReportDataSet.dailyinspectionRow NewInspectionRow = TheDailyVehicleInspectionReportDataSet.dailyinspection.NewdailyinspectionRow();
intInspectionID = TheFindDailyVehicleInspectionByDateRangeDataSet.FindDailyVehicleInspectionByDateRange[intCounter].TransactionID;
TheFindVehicleInspectionProblemByInsepctionIDDataSet = TheInspectionClass.FindVehicleInspectionProblemsbyInspectionID(intInspectionID);
intRecordsReturned = TheFindVehicleInspectionProblemByInsepctionIDDataSet.FindVehicleInspectionProblemsByInspectionID.Rows.Count;
if (intRecordsReturned == 0)
{
NewInspectionRow.InspectionNotes = "NO NOTES REPORTED";
}
else
{
NewInspectionRow.InspectionNotes = TheFindVehicleInspectionProblemByInsepctionIDDataSet.FindVehicleInspectionProblemsByInspectionID[0].InspectionNotes;
}
NewInspectionRow.FirstName = TheFindDailyVehicleInspectionByDateRangeDataSet.FindDailyVehicleInspectionByDateRange[intCounter].FirstName;
NewInspectionRow.InspectionDate = TheFindDailyVehicleInspectionByDateRangeDataSet.FindDailyVehicleInspectionByDateRange[intCounter].InspectionDate;
NewInspectionRow.InspectionID = intInspectionID;
NewInspectionRow.InspectionStatus = TheFindDailyVehicleInspectionByDateRangeDataSet.FindDailyVehicleInspectionByDateRange[intCounter].InspectionStatus;
NewInspectionRow.LastName = TheFindDailyVehicleInspectionByDateRangeDataSet.FindDailyVehicleInspectionByDateRange[intCounter].LastName;
NewInspectionRow.OdometerReading = TheFindDailyVehicleInspectionByDateRangeDataSet.FindDailyVehicleInspectionByDateRange[intCounter].OdometerReading;
NewInspectionRow.VehicleID = TheFindDailyVehicleInspectionByDateRangeDataSet.FindDailyVehicleInspectionByDateRange[intCounter].VehicleID;
NewInspectionRow.VehicleNumber = TheFindDailyVehicleInspectionByDateRangeDataSet.FindDailyVehicleInspectionByDateRange[intCounter].VehicleNumber;
NewInspectionRow.HomeOffice = TheFindDailyVehicleInspectionByDateRangeDataSet.FindDailyVehicleInspectionByDateRange[intCounter].AssignedOffice;
TheDailyVehicleInspectionReportDataSet.dailyinspection.Rows.Add(NewInspectionRow);
}
}
}
else if (gstrReportType == "EMPLOYEE")
{
TheFindDailyVehicleInspectionByEmployeeIDAndDateRangeDataSet = TheInspectionClass.FindDailyVehicleInspectionByEmployeeIDAndDateRange(gintEmployeeID, gdatStartDate, gdatEndDate);
intNumberOfRecords = TheFindDailyVehicleInspectionByEmployeeIDAndDateRangeDataSet.FindDailyVehicleInspectionsByEmployeeIDAndDateRange.Rows.Count - 1;
if (intNumberOfRecords > -1)
{
for (intCounter = 0; intCounter <= intNumberOfRecords; intCounter++)
{
DailyVehicleInspectionReportDataSet.dailyinspectionRow NewInspectionRow = TheDailyVehicleInspectionReportDataSet.dailyinspection.NewdailyinspectionRow();
intInspectionID = TheFindDailyVehicleInspectionByEmployeeIDAndDateRangeDataSet.FindDailyVehicleInspectionsByEmployeeIDAndDateRange[intCounter].TransactionID;
TheFindVehicleInspectionProblemByInsepctionIDDataSet = TheInspectionClass.FindVehicleInspectionProblemsbyInspectionID(intInspectionID);
intRecordsReturned = TheFindVehicleInspectionProblemByInsepctionIDDataSet.FindVehicleInspectionProblemsByInspectionID.Rows.Count;
if (intRecordsReturned == 0)
{
NewInspectionRow.InspectionNotes = "NO NOTES REPORTED";
}
else
{
NewInspectionRow.InspectionNotes = TheFindVehicleInspectionProblemByInsepctionIDDataSet.FindVehicleInspectionProblemsByInspectionID[0].InspectionNotes;
}
NewInspectionRow.FirstName = TheFindDailyVehicleInspectionByEmployeeIDAndDateRangeDataSet.FindDailyVehicleInspectionsByEmployeeIDAndDateRange[intCounter].FirstName;
NewInspectionRow.InspectionDate = TheFindDailyVehicleInspectionByEmployeeIDAndDateRangeDataSet.FindDailyVehicleInspectionsByEmployeeIDAndDateRange[intCounter].InspectionDate;
NewInspectionRow.InspectionID = intInspectionID;
NewInspectionRow.InspectionStatus = TheFindDailyVehicleInspectionByEmployeeIDAndDateRangeDataSet.FindDailyVehicleInspectionsByEmployeeIDAndDateRange[intCounter].InspectionStatus;
NewInspectionRow.LastName = TheFindDailyVehicleInspectionByEmployeeIDAndDateRangeDataSet.FindDailyVehicleInspectionsByEmployeeIDAndDateRange[intCounter].LastName;
NewInspectionRow.OdometerReading = TheFindDailyVehicleInspectionByEmployeeIDAndDateRangeDataSet.FindDailyVehicleInspectionsByEmployeeIDAndDateRange[intCounter].OdometerReading;
NewInspectionRow.VehicleID = TheFindDailyVehicleInspectionByEmployeeIDAndDateRangeDataSet.FindDailyVehicleInspectionsByEmployeeIDAndDateRange[intCounter].VehicleID;
NewInspectionRow.VehicleNumber = TheFindDailyVehicleInspectionByEmployeeIDAndDateRangeDataSet.FindDailyVehicleInspectionsByEmployeeIDAndDateRange[intCounter].VehicleNumber;
NewInspectionRow.HomeOffice = TheFindDailyVehicleInspectionByEmployeeIDAndDateRangeDataSet.FindDailyVehicleInspectionsByEmployeeIDAndDateRange[intCounter].AssignedOffice;
TheDailyVehicleInspectionReportDataSet.dailyinspection.Rows.Add(NewInspectionRow);
}
}
}
else if (gstrReportType == "VEHICLE NUMBER")
{
strVehicleNumber = txtSearchInfo.Text;
if (strVehicleNumber == "")
{
TheMessagesClass.ErrorMessage("Vehicle Number Not Entered");
PleaseWait.Close();
return;
}
TheFindActiveVehicleMainByVehicleNumberDataSet = TheVehicleMainClass.FindActiveVehicleMainByVehicleNumber(strVehicleNumber);
intRecordsReturned = TheFindActiveVehicleMainByVehicleNumberDataSet.FindActiveVehicleMainByVehicleNumber.Rows.Count;
if (intRecordsReturned == 0)
{
TheMessagesClass.ErrorMessage("Vehicle Numbered Does Not Exist");
PleaseWait.Close();
return;
}
else
{
gintVehicleID = TheFindActiveVehicleMainByVehicleNumberDataSet.FindActiveVehicleMainByVehicleNumber[0].VehicleID;
}
TheFindDailyVehicleInspectionByVehicleIDAndDateRangeDataSet = TheInspectionClass.FindDailyVehicleInspectionByVehicleIDAndDateRange(gintVehicleID, gdatStartDate, gdatEndDate);
intNumberOfRecords = TheFindDailyVehicleInspectionByVehicleIDAndDateRangeDataSet.FindDailyVehicleInspectionsByVehicleIDAndDateRange.Rows.Count - 1;
if (intNumberOfRecords > -1)
{
for (intCounter = 0; intCounter <= intNumberOfRecords; intCounter++)
{
DailyVehicleInspectionReportDataSet.dailyinspectionRow NewInspectionRow = TheDailyVehicleInspectionReportDataSet.dailyinspection.NewdailyinspectionRow();
intInspectionID = TheFindDailyVehicleInspectionByVehicleIDAndDateRangeDataSet.FindDailyVehicleInspectionsByVehicleIDAndDateRange[intCounter].TransactionID;
TheFindVehicleInspectionProblemByInsepctionIDDataSet = TheInspectionClass.FindVehicleInspectionProblemsbyInspectionID(intInspectionID);
intRecordsReturned = TheFindVehicleInspectionProblemByInsepctionIDDataSet.FindVehicleInspectionProblemsByInspectionID.Rows.Count;
if (intRecordsReturned == 0)
{
NewInspectionRow.InspectionNotes = "NO NOTES REPORTED";
}
else
{
NewInspectionRow.InspectionNotes = TheFindVehicleInspectionProblemByInsepctionIDDataSet.FindVehicleInspectionProblemsByInspectionID[0].InspectionNotes;
}
NewInspectionRow.FirstName = TheFindDailyVehicleInspectionByVehicleIDAndDateRangeDataSet.FindDailyVehicleInspectionsByVehicleIDAndDateRange[intCounter].FirstName;
NewInspectionRow.InspectionDate = TheFindDailyVehicleInspectionByVehicleIDAndDateRangeDataSet.FindDailyVehicleInspectionsByVehicleIDAndDateRange[intCounter].InspectionDate;
NewInspectionRow.InspectionID = intInspectionID;
NewInspectionRow.InspectionStatus = TheFindDailyVehicleInspectionByVehicleIDAndDateRangeDataSet.FindDailyVehicleInspectionsByVehicleIDAndDateRange[intCounter].InspectionStatus;
NewInspectionRow.LastName = TheFindDailyVehicleInspectionByVehicleIDAndDateRangeDataSet.FindDailyVehicleInspectionsByVehicleIDAndDateRange[intCounter].LastName;
NewInspectionRow.OdometerReading = TheFindDailyVehicleInspectionByVehicleIDAndDateRangeDataSet.FindDailyVehicleInspectionsByVehicleIDAndDateRange[intCounter].OdometerReading;
NewInspectionRow.VehicleID = TheFindDailyVehicleInspectionByVehicleIDAndDateRangeDataSet.FindDailyVehicleInspectionsByVehicleIDAndDateRange[intCounter].VehicleID;
NewInspectionRow.VehicleNumber = TheFindDailyVehicleInspectionByVehicleIDAndDateRangeDataSet.FindDailyVehicleInspectionsByVehicleIDAndDateRange[intCounter].VehicleNumber;
NewInspectionRow.HomeOffice = TheFindDailyVehicleInspectionByVehicleIDAndDateRangeDataSet.FindDailyVehicleInspectionsByVehicleIDAndDateRange[intCounter].AssignedOffice;
TheDailyVehicleInspectionReportDataSet.dailyinspection.Rows.Add(NewInspectionRow);
}
}
}
dgrResults.ItemsSource = TheDailyVehicleInspectionReportDataSet.dailyinspection;
}
catch (Exception Ex)
{
TheEventLogClass.InsertEventLogEntry(DateTime.Now, "Blue Jay ERP // Daily Vehicle Inspection Report // Generate Report Menu Item " + Ex.Message);
TheMessagesClass.ErrorMessage(Ex.ToString());
}
PleaseWait.Close();
}
private void mitPrint_Click(object sender, RoutedEventArgs e)
{
//setting local variables
int intCounter;
int intNumberOfRecords;
int intVehicleID;
DateTime datTransactionDate;
int intSecondCounter;
int intSecondNumberOfRecords;
string strInspectStatus;
string strVehicleProblem;
string strInspectionNotes;
int intThirdCounter;
int intThirdNumberOfRecords;
pdProblemReport = new PrintDialog();
if (pdProblemReport.ShowDialog().Value)
{
PleaseWait PleaseWait = new PleaseWait();
PleaseWait.Show();
try
{
gdatEndDate = DateTime.Now;
gdatEndDate = TheDateSearchClass.RemoveTime(gdatEndDate);
gdatStartDate = TheDateSearchClass.SubtractingDays(gdatEndDate, 200);
intNumberOfRecords = TheSortedDOTAuditDataSete.dotaudit.Rows.Count - 1;
for (intCounter = 0; intCounter <= intNumberOfRecords; intCounter++)
{
TheDOTVehicleInspectionDataSet.inspectionresults.Rows.Clear();
intVehicleID = TheSortedDOTAuditDataSete.dotaudit[intCounter].VehicleID;
TheFindDailyVehicleInspectionByVehicleIDAndDateRangeDataSet = TheInspectionsClass.FindDailyVehicleInspectionByVehicleIDAndDateRange(intVehicleID, gdatStartDate, gdatEndDate);
intSecondNumberOfRecords = TheFindDailyVehicleInspectionByVehicleIDAndDateRangeDataSet.FindDailyVehicleInspectionsByVehicleIDAndDateRange.Rows.Count - 1;
for (intSecondCounter = 0; intSecondCounter <= intSecondNumberOfRecords; intSecondCounter++)
{
strInspectStatus = TheFindDailyVehicleInspectionByVehicleIDAndDateRangeDataSet.FindDailyVehicleInspectionsByVehicleIDAndDateRange[intSecondCounter].InspectionStatus;
datTransactionDate = TheFindDailyVehicleInspectionByVehicleIDAndDateRangeDataSet.FindDailyVehicleInspectionsByVehicleIDAndDateRange[intSecondCounter].InspectionDate;
datTransactionDate = TheDateSearchClass.RemoveTime(datTransactionDate);
strVehicleProblem = "";
strInspectionNotes = "";
if (strInspectStatus == "PASSED")
{
strVehicleProblem = "NO PROBLEM REPORTED";
strInspectionNotes = "NO PROBLEM REPORTED";
}
else
{
TheFindDailyVehicleInspectionProblemByVehicleIDAndDateRangeDataSet = TheInspectionsClass.FindDailyVehicleInspectionProblemByVehicleIDAndDateRange(intVehicleID, datTransactionDate, datTransactionDate.AddDays(1));
intThirdNumberOfRecords = TheFindDailyVehicleInspectionProblemByVehicleIDAndDateRangeDataSet.FindDailyVehicleInspectionProblemsByVehicleIDAndDateRange.Rows.Count - 1;
for (intThirdCounter = 0; intThirdCounter <= intThirdNumberOfRecords; intThirdCounter++)
{
if (TheFindDailyVehicleInspectionProblemByVehicleIDAndDateRangeDataSet.FindDailyVehicleInspectionProblemsByVehicleIDAndDateRange[intThirdCounter].VehicleProblem == null)
{
strVehicleProblem = TheFindDailyVehicleInspectionProblemByVehicleIDAndDateRangeDataSet.FindDailyVehicleInspectionProblemsByVehicleIDAndDateRange[intThirdCounter].InspectionNotes + "\n";
}
else
{
strVehicleProblem = TheFindDailyVehicleInspectionProblemByVehicleIDAndDateRangeDataSet.FindDailyVehicleInspectionProblemsByVehicleIDAndDateRange[intThirdCounter].VehicleProblem + "\n";
}
strInspectionNotes = TheFindDailyVehicleInspectionProblemByVehicleIDAndDateRangeDataSet.FindDailyVehicleInspectionProblemsByVehicleIDAndDateRange[intThirdCounter].InspectionNotes + "\n";
}
}
DOTVehicleInspectionDataSet.inspectionresultsRow NewInspectionRow = TheDOTVehicleInspectionDataSet.inspectionresults.NewinspectionresultsRow();
NewInspectionRow.VehicleNumber = TheSortedDOTAuditDataSete.dotaudit[intCounter].VehicleNumber;
NewInspectionRow.InspectionNotes = strInspectionNotes;
NewInspectionRow.InspectionStatus = strInspectStatus;
NewInspectionRow.OdometerReading = TheFindDailyVehicleInspectionByVehicleIDAndDateRangeDataSet.FindDailyVehicleInspectionsByVehicleIDAndDateRange[intSecondCounter].OdometerReading;
NewInspectionRow.TransactionDate = datTransactionDate;
NewInspectionRow.VehicleProblem = strVehicleProblem;
TheDOTVehicleInspectionDataSet.inspectionresults.Rows.Add(NewInspectionRow);
}
PrintReports();
}
dgrResults.ItemsSource = TheDOTVehicleInspectionDataSet.inspectionresults;
}
catch (Exception Ex)
{
TheEventLogClass.InsertEventLogEntry(DateTime.Now, "Blue Jay ERP // DOT Audit Report // Process Menu Item " + Ex.Message);
TheMessagesClass.ErrorMessage(Ex.ToString());
}
PleaseWait.Close();
}
}
