public FindEmployeesOverFortyHoursDataSet FindEmployeesOverFortyHours(DateTime datPayPeriod)
{
try
{
aFindEmployeesOverFortyHoursDataSet = new FindEmployeesOverFortyHoursDataSet();
aFindEmployeesOverFortyHoursTableAdapter = new FindEmployeesOverFortyHoursDataSetTableAdapters.FindEmployeesOverFortyHoursTableAdapter();
aFindEmployeesOverFortyHoursTableAdapter.Fill(aFindEmployeesOverFortyHoursDataSet.FindEmployeesOverFortyHours, datPayPeriod);
}
catch (Exception Ex)
{
TheEventLogClass.InsertEventLogEntry(DateTime.Now, "Employee Punched Hours Class // Find Employees Over Forty Hours " + Ex.Message);
}
return(aFindEmployeesOverFortyHoursDataSet);
}
public void CreateOverTimeReport()
{
//setting local variables
int intCounter;
int intNumberOfRecords;
int intManagerID;
string strManager;
string strEmailAddress = "*****@*****.**";
string strHeader;
string strMessage;
DateTime datPayDate = DateTime.Now;
bool blnFatalError = false;
try
{
TheEmployeeOvertimeDataSet.employeeovertime.Rows.Clear();
datPayDate = TheDateSearchClass.RemoveTime(datPayDate);
datPayDate = TheDateSearchClass.SubtractingDays(datPayDate, 9);
TheFindEmployeesOverFortyHoursDataSet = TheEmployeePunchedHoursClass.FindEmployeesOverFortyHours(datPayDate);
intNumberOfRecords = TheFindEmployeesOverFortyHoursDataSet.FindEmployeesOverFortyHours.Rows.Count;
if (intNumberOfRecords > 0)
{
for (intCounter = 0; intCounter < intNumberOfRecords; intCounter++)
{
intManagerID = TheFindEmployeesOverFortyHoursDataSet.FindEmployeesOverFortyHours[intCounter].ManagerID;
TheFindEmployeeByEmployeeIDDataSet = TheEmployeeClass.FindEmployeeByEmployeeID(intManagerID);
strManager = TheFindEmployeeByEmployeeIDDataSet.FindEmployeeByEmployeeID[0].FirstName + " ";
strManager += TheFindEmployeeByEmployeeIDDataSet.FindEmployeeByEmployeeID[0].LastName;
EmployeeOvertimeDataSet.employeeovertimeRow NewEmployeeRow = TheEmployeeOvertimeDataSet.employeeovertime.NewemployeeovertimeRow();
NewEmployeeRow.FirstName = TheFindEmployeesOverFortyHoursDataSet.FindEmployeesOverFortyHours[intCounter].FirstName;
NewEmployeeRow.LastName = TheFindEmployeesOverFortyHoursDataSet.FindEmployeesOverFortyHours[intCounter].LastName;
NewEmployeeRow.HomeOffice = TheFindEmployeesOverFortyHoursDataSet.FindEmployeesOverFortyHours[intCounter].HomeOffice;
NewEmployeeRow.Manager = strManager;
NewEmployeeRow.TotalHours = TheFindEmployeesOverFortyHoursDataSet.FindEmployeesOverFortyHours[intCounter].PunchedHours;
TheEmployeeOvertimeDataSet.employeeovertime.Rows.Add(NewEmployeeRow);
}
}
strHeader = "Employee Overtime Report For " + Convert.ToString(datPayDate);
strMessage = "<h1>Employee Overtime Report For " + Convert.ToString(datPayDate) + "</h1>";
strMessage += "<p> </p>";
strMessage += "<p> </p>";
strMessage += "<table>";
strMessage += "<tr>";
strMessage += "<td><b>First Name</b></td>";
strMessage += "<td><b>Last Name</b></td>";
strMessage += "<td><b>Home Office</b></td>";
strMessage += "<td><b>Manager</b></td>";
strMessage += "<td><b>Total Hours</b></td>";
strMessage += "</tr>";
strMessage += "<p> </p>";
intNumberOfRecords = TheEmployeeOvertimeDataSet.employeeovertime.Rows.Count;
if (intNumberOfRecords > 0)
{
for (intCounter = 0; intCounter < intNumberOfRecords; intCounter++)
{
strMessage += "<tr>";
strMessage += "<td>" + TheEmployeeOvertimeDataSet.employeeovertime[intCounter].FirstName + "</td>";
strMessage += "<td>" + TheEmployeeOvertimeDataSet.employeeovertime[intCounter].LastName + "</td>";
strMessage += "<td>" + TheEmployeeOvertimeDataSet.employeeovertime[intCounter].HomeOffice + "</td>";
strMessage += "<td>" + TheEmployeeOvertimeDataSet.employeeovertime[intCounter].Manager + "</td>";
strMessage += "<td>" + Convert.ToString(TheEmployeeOvertimeDataSet.employeeovertime[intCounter].TotalHours) + "</td>";
strMessage += "</tr>";
strMessage += "<p> </p>";
}
}
strMessage += "</table>";
blnFatalError = TheSendEmailClass.SendEmail(strEmailAddress, strHeader, strMessage);
if (blnFatalError == true)
{
throw new Exception();
}
}
catch (Exception Ex)
{
TheEventLogClass.InsertEventLogEntry(DateTime.Now, "Event Log Tracker // Run Punched Vs Production Class // Create Overtime Report " + Ex.Message);
TheMessagesClass.ErrorMessage(Ex.ToString());
}
}
private void expCreateReport_Expanded(object sender, RoutedEventArgs e)
{
int intCounter;
int intNumberOfRecords;
string strManager;
int intManagerID;
bool blnFatalError = false;
string strValueForValidation;
try
{
expCreateReport.IsExpanded = false;
TheEmployeeOvertimeDataSet.employeeovertime.Rows.Clear();
//performing data validation
strValueForValidation = txtPayDate.Text;
blnFatalError = TheDataValidationClass.VerifyDateData(strValueForValidation);
if (blnFatalError == true)
{
TheMessagesClass.ErrorMessage("The Date Entered is not a Date");
return;
}
else
{
gdatSelectedDate = Convert.ToDateTime(strValueForValidation);
}
TheFindEmployeeOverFortyHoursDataSet = TheEmployeePunchedHoursClass.FindEmployeesOverFortyHours(gdatSelectedDate);
intNumberOfRecords = TheFindEmployeeOverFortyHoursDataSet.FindEmployeesOverFortyHours.Rows.Count;
if (intNumberOfRecords > 1)
{
for (intCounter = 0; intCounter < intNumberOfRecords; intCounter++)
{
intManagerID = TheFindEmployeeOverFortyHoursDataSet.FindEmployeesOverFortyHours[intCounter].ManagerID;
TheFindEmployeeByEmployeeIDDataSet = TheEmployeeClass.FindEmployeeByEmployeeID(intManagerID);
strManager = TheFindEmployeeByEmployeeIDDataSet.FindEmployeeByEmployeeID[0].FirstName + " ";
strManager += TheFindEmployeeByEmployeeIDDataSet.FindEmployeeByEmployeeID[0].LastName;
EmployeeOvertimeDataSet.employeeovertimeRow NewEmployeeRow = TheEmployeeOvertimeDataSet.employeeovertime.NewemployeeovertimeRow();
NewEmployeeRow.FirstName = TheFindEmployeeOverFortyHoursDataSet.FindEmployeesOverFortyHours[intCounter].FirstName;
NewEmployeeRow.HomeOffice = TheFindEmployeeOverFortyHoursDataSet.FindEmployeesOverFortyHours[intCounter].HomeOffice;
NewEmployeeRow.LastName = TheFindEmployeeOverFortyHoursDataSet.FindEmployeesOverFortyHours[intCounter].LastName;
NewEmployeeRow.Manager = strManager;
NewEmployeeRow.PunchedHours = TheFindEmployeeOverFortyHoursDataSet.FindEmployeesOverFortyHours[intCounter].PunchedHours;
TheEmployeeOvertimeDataSet.employeeovertime.Rows.Add(NewEmployeeRow);
}
}
dgrEmployees.ItemsSource = TheEmployeeOvertimeDataSet.employeeovertime;
}
catch (Exception Ex)
{
TheEventLogClass.InsertEventLogEntry(DateTime.Now, "New Blue Jay ERP // Employee Overtime Report // Create Report Expander // " + Ex.Message);
TheMessagesClass.ErrorMessage(Ex.ToString());
}
}
