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