public FindGEOFenceTransactionDateRangeDataSet FindGEOFenceTransactionDAteRanage(DateTime datStartDate, DateTime datEndDate)
{
try
{
aFindGEOFenceTransactionDateRangeDataSet = new FindGEOFenceTransactionDateRangeDataSet();
aFindGEOFenceTransactionDateRangeTableAdapter = new FindGEOFenceTransactionDateRangeDataSetTableAdapters.FindGEOFenceTransasctionDateRangeTableAdapter();
aFindGEOFenceTransactionDateRangeTableAdapter.Fill(aFindGEOFenceTransactionDateRangeDataSet.FindGEOFenceTransasctionDateRange, datStartDate, datEndDate);
}
catch (Exception Ex)
{
TheEventLogClass.InsertEventLogEntry(DateTime.Now, "GEO Fence Class // Find GEO Fence Transaction Date Range " + Ex.Message);
}
return(aFindGEOFenceTransactionDateRangeDataSet);
}
private void SendVehicleAfterHourActivity()
{
int intCounter;
int intNumberOfRecords;
string strEmailAddress = "*****@*****.**";
DateTime datStartDate = DateTime.Now;
DateTime datEndDate = DateTime.Now;
string strEventDate = "";
string strVehicleNumber;
string strEmployee;
string strAssignedOffice;
string strDriver;
bool blnInSide;
string strInOut = "";
string strHeader = "BJC Vehicle After Hour Report";
string strMessage;
bool blnFatalError;
try
{
datStartDate = TheDateSearchClass.RemoveTime(datStartDate);
datEndDate = TheDateSearchClass.RemoveTime(datEndDate);
datStartDate = TheDateSearchClass.SubtractingDays(datStartDate, 1);
datStartDate = datStartDate.AddHours(18);
datEndDate = datEndDate.AddHours(6);
TheFindGeoFenceTransactionDateRangeDataSet = TheGeoFenceClass.FindGEOFenceTransactionDAteRanage(datStartDate, datEndDate);
strMessage = "<h1>" + strHeader + " - Do Not Reply</h1>";
strMessage += "<table>";
strMessage += "<tr>";
strMessage += "<td>Event Date</td>";
strMessage += "<td>Vehicle Number</td>";
strMessage += "<td>Employee</td>";
strMessage += "<td>Office</td>";
strMessage += "<td>Driver</td>";
strMessage += "<td>In Or Out</td>";
strMessage += "</tr>";
strMessage += "<p> </p>";
intNumberOfRecords = TheFindGeoFenceTransactionDateRangeDataSet.FindGEOFenceTransasctionDateRange.Rows.Count;
if (intNumberOfRecords > 0)
{
for (intCounter = 0; intCounter < intNumberOfRecords; intCounter++)
{
strEventDate = Convert.ToString(TheFindGeoFenceTransactionDateRangeDataSet.FindGEOFenceTransasctionDateRange[intCounter].EventDate);
strVehicleNumber = TheFindGeoFenceTransactionDateRangeDataSet.FindGEOFenceTransasctionDateRange[intCounter].VehicleNumber;
strEmployee = TheFindGeoFenceTransactionDateRangeDataSet.FindGEOFenceTransasctionDateRange[intCounter].FirstName + " ";
strEmployee += TheFindGeoFenceTransactionDateRangeDataSet.FindGEOFenceTransasctionDateRange[intCounter].LastName;
strAssignedOffice = TheFindGeoFenceTransactionDateRangeDataSet.FindGEOFenceTransasctionDateRange[intCounter].AssignedOffice;
strDriver = TheFindGeoFenceTransactionDateRangeDataSet.FindGEOFenceTransasctionDateRange[intCounter].Driver;
blnInSide = TheFindGeoFenceTransactionDateRangeDataSet.FindGEOFenceTransasctionDateRange[intCounter].InSide;
if (blnInSide == true)
strInOut = "IN";
else if (blnInSide == false)
strInOut = "OUT";
strMessage += "<tr>";
strMessage += "<td>" + strEventDate + "</td>";
strMessage += "<td>" + strVehicleNumber + "</td>";
strMessage += "<td>" + strEmployee + "</td>";
strMessage += "<td>" + strAssignedOffice + "</td>";
strMessage += "<td>" + strDriver+ "</td>";
strMessage += "<td>" + strInOut + "</td>";
strMessage += "</tr>";
}
}
strMessage += "</table>";
blnFatalError = TheSendEmailClass.SendEmail(strEmailAddress, strHeader, strMessage);
if (blnFatalError == true)
throw new Exception();
}
catch (Exception Ex)
{
TheEventLogClass.InsertEventLogEntry(DateTime.Now, "Event Log Tracker // Send Overdue Project Report " + Ex.Message);
TheMessagesClass.ErrorMessage(Ex.ToString());
}
}
