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