private void expProcessImport_Expanded(object sender, RoutedEventArgs e) { int intCounter; int intNumberOfRecords; DateTime datEventDate; int intVehicleID; bool blnInSide; int intEmployeeID; string strDriver; int intRecordsReturned; bool blnFatalError; PleaseWait PleaseWait = new PleaseWait(); PleaseWait.Show(); try { intNumberOfRecords = TheImportGEOFenceDataSet.importgeofence.Rows.Count - 1; for (intCounter = 0; intCounter <= intNumberOfRecords; intCounter++) { intVehicleID = TheImportGEOFenceDataSet.importgeofence[intCounter].VehicleID; datEventDate = TheImportGEOFenceDataSet.importgeofence[intCounter].EventTime; blnInSide = TheImportGEOFenceDataSet.importgeofence[intCounter].InSide; intEmployeeID = TheImportGEOFenceDataSet.importgeofence[intCounter].EmployeeID; strDriver = TheImportGEOFenceDataSet.importgeofence[intCounter].Driver; if (intVehicleID > -1) { TheFindGEOFenceTransactionExactDateDataSet = TheGEOFenceClass.FindGEOFenceTransaction(datEventDate, intVehicleID); intRecordsReturned = TheFindGEOFenceTransactionExactDateDataSet.FindGEOFenceTransactionByExactDate.Rows.Count; if (intRecordsReturned < 1) { blnFatalError = TheGEOFenceClass.InsertGEOFenceImportEntry(datEventDate, intVehicleID, blnInSide, intEmployeeID, strDriver); if (blnFatalError == true) { throw new Exception(); } } } } TheMessagesClass.InformationMessage("The Records Have Been Inserted"); } catch (Exception Ex) { TheEventLogClass.InsertEventLogEntry(DateTime.Now, "New Blue Jay ERP // Import GEO Fence Report // Process Import " + Ex.Message); TheMessagesClass.ErrorMessage(Ex.ToString()); } PleaseWait.Close(); }
public FindGEOFenceTransactionByExactDateDataSet FindGEOFenceTransaction(DateTime datEventDate, int intVehicleID) { try { aFindGEOFenceTransactionByExactDateDataSet = new FindGEOFenceTransactionByExactDateDataSet(); aFindGEOFenceTransactionByExactDateTableAdapter = new FindGEOFenceTransactionByExactDateDataSetTableAdapters.FindGEOFenceTransactionByExactDateTableAdapter(); aFindGEOFenceTransactionByExactDateTableAdapter.Fill(aFindGEOFenceTransactionByExactDateDataSet.FindGEOFenceTransactionByExactDate, datEventDate, intVehicleID); } catch (Exception Ex) { TheEventLogClass.InsertEventLogEntry(DateTime.Now, "GEO Fence Class // Find GEO Fence Transaction " + Ex.Message); } return(aFindGEOFenceTransactionByExactDateDataSet); }