private void DataEntryReports(DateTime datStartDate, DateTime datEndDate)
{
//setting up the variables
int intCounter;
int intNumberOfRecords;
string strEmailAddress = "*****@*****.**";
string strHeader = "Employee ERP Logins";
string strMessage = "";
bool blnFatalError = false;
try
{
//loading up the data
TheFindEmployeeDataEntryByDateRangeDataSet = TheEmployeeDataEntryClass.FindEmployeeDataEntryByDateRange(datStartDate, datEndDate);
intNumberOfRecords = TheFindEmployeeDataEntryByDateRangeDataSet.FindEmployeeDateEntryByDateRange.Rows.Count - 1;
strMessage = "<h1>" + strHeader + " - Do Not Reply</h1>";
strMessage += "<table>";
strMessage += "<tr>";
strMessage += "<td>Transaction Date</td>";
strMessage += "<td>First Name</td>";
strMessage += "<td>Last Name</td>";
strMessage += "<td>Home Office</td>";
strMessage += "<td>Window Entered</td>";
strMessage += "</tr>";
strMessage += "<p> </p>";
if(intNumberOfRecords > -1)
{
for(intCounter = 0; intCounter <= intNumberOfRecords; intCounter++)
{
strMessage += "<tr>";
strMessage += "<td>" + Convert.ToString(TheFindEmployeeDataEntryByDateRangeDataSet.FindEmployeeDateEntryByDateRange[intCounter].TransactionDate) + "</td>";
strMessage += "<td>" + TheFindEmployeeDataEntryByDateRangeDataSet.FindEmployeeDateEntryByDateRange[intCounter].FirstName + "</td>";
strMessage += "<td>" + TheFindEmployeeDataEntryByDateRangeDataSet.FindEmployeeDateEntryByDateRange[intCounter].LastName + "</td>";
strMessage += "<td>" + TheFindEmployeeDataEntryByDateRangeDataSet.FindEmployeeDateEntryByDateRange[intCounter].HomeOffice + "</td>";
strMessage += "<td>" + TheFindEmployeeDataEntryByDateRangeDataSet.FindEmployeeDateEntryByDateRange[intCounter].WindowEntered + "</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 // Main Window // Data Entry Reports " + Ex.Message);
TheMessagesClass.ErrorMessage(Ex.ToString());
}
}
public FindEmployeeDataEntryByDateRangeDataSet FindEmployeeDataEntryByDateRange(DateTime datStartDate, DateTime datEndDate)
{
try
{
aFindEmployeeDataEntryByDateRangeDataSet = new FindEmployeeDataEntryByDateRangeDataSet();
aFindEmployeeDataEntryByDateRangeTableAdapter = new FindEmployeeDataEntryByDateRangeDataSetTableAdapters.FindEmployeeDateEntryByDateRangeTableAdapter();
aFindEmployeeDataEntryByDateRangeTableAdapter.Fill(aFindEmployeeDataEntryByDateRangeDataSet.FindEmployeeDateEntryByDateRange, datStartDate, datEndDate);
}
catch (Exception Ex)
{
TheEventLogClass.InsertEventLogEntry(DateTime.Now, "Employee Date Entry Class // Find Employee Date Entry By Date Range " + Ex.Message);
}
return(aFindEmployeeDataEntryByDateRangeDataSet);
}