public FindEmployeePunchedHoursDataSet FindEmployeePunchedHours(int intEmployeeID, DateTime datStartDate, DateTime datEndDate)
{
try
{
aFindEmployeePunchedHoursDataSet = new FindEmployeePunchedHoursDataSet();
aFindEmployeePunchedHoursTableAdapter = new FindEmployeePunchedHoursDataSetTableAdapters.FindEmployeePunchedHoursTableAdapter();
aFindEmployeePunchedHoursTableAdapter.Fill(aFindEmployeePunchedHoursDataSet.FindEmployeePunchedHours, intEmployeeID, datStartDate, datEndDate);
}
catch (Exception Ex)
{
TheEventLogClass.InsertEventLogEntry(DateTime.Now, "Employee Punched Hours Class // Find Employee Punched Hours " + Ex.Message);
}
return(aFindEmployeePunchedHoursDataSet);
}
public void RunPunchedVSProductionReport()
{
//setting local variables
int intCounter;
int intNumberOfRecords;
int intEmployeeID;
int intManagerID;
string strFirstName;
string strLastName;
string strManagerFirstName;
string strManagerLastName;
int intRecordReturned;
bool blnFatalError = false;
decimal decHoursPunched;
decimal decProductiveHours;
int intManagerCounter;
bool blnItemFound;
decimal decVariance;
int intTotalNumber;
int intSelectedIndex;
int intTotalNumberNeeded;
decimal decTopPercentage;
decimal decWorkingPercentage;
int intArrayCounter;
int intArrayNumberOfRecords = -1;
int intEmployeeCounter;
int intNumberOfEmployees;
decimal decCalVariance;
decimal decVarianceMean;
decimal decSumOfDifferences;
decimal decAverageOfDifferences;
DateTime datStartDate;
DateTime datEndDate;
string strEmailAddress = "*****@*****.**";
string strHeader;
string strMessage;
string strManager;
decimal decTotalPercentage;
try
{
TheEmployeeProductionPunchDataSet.employees.Rows.Clear();
TheProductionManagerStatsDataSet.productionmanager.Rows.Clear();
TheFinalProductionManagerStatsDataSet.productionmanager.Rows.Clear();
datEndDate = DateTime.Now;
datEndDate = TheDateSearchClass.RemoveTime(datEndDate);
datEndDate = TheDateSearchClass.SubtractingDays(datEndDate, 16);
datStartDate = TheDateSearchClass.SubtractingDays(datEndDate, 6);
TheFindActiveNoExemptEmployeesDataSet = TheEmployeeClass.FindActiveNonExemptEmployeesByPayDate(datStartDate);
intNumberOfRecords = TheFindActiveNoExemptEmployeesDataSet.FindActiveNonExemptEmployeesByPayDate.Rows.Count - 1;
for (intCounter = 0; intCounter <= intNumberOfRecords; intCounter++)
{
//getting employee info
intEmployeeID = TheFindActiveNoExemptEmployeesDataSet.FindActiveNonExemptEmployeesByPayDate[intCounter].EmployeeID;
strFirstName = TheFindActiveNoExemptEmployeesDataSet.FindActiveNonExemptEmployeesByPayDate[intCounter].FirstName;
strLastName = TheFindActiveNoExemptEmployeesDataSet.FindActiveNonExemptEmployeesByPayDate[intCounter].LastName;
intManagerID = TheFindActiveNoExemptEmployeesDataSet.FindActiveNonExemptEmployeesByPayDate[intCounter].ManagerID;
TheFindEmployeeByEmployeeIDDataSet = TheEmployeeClass.FindEmployeeByEmployeeID(intManagerID);
strManagerFirstName = TheFindEmployeeByEmployeeIDDataSet.FindEmployeeByEmployeeID[0].FirstName;
strManagerLastName = TheFindEmployeeByEmployeeIDDataSet.FindEmployeeByEmployeeID[0].LastName;
//getting employee punched hours
TheFindEmployeePunchedHoursDataSet = TheEmployeePunchedHoursClass.FindEmployeePunchedHours(intEmployeeID, datStartDate, datEndDate);
intRecordReturned = TheFindEmployeePunchedHoursDataSet.FindEmployeePunchedHours.Rows.Count;
if (intRecordReturned == 0)
{
decHoursPunched = 0;
}
else
{
decHoursPunched = TheFindEmployeePunchedHoursDataSet.FindEmployeePunchedHours[0].PunchedHours;
}
//getting production hours
TheFindEmployeeProductionHoursOverPayPeriodDataSet = TheEmployeeProjectAssignmentClass.FindEmployeeProductionHoursOverPayPeriodDataSet(intEmployeeID, datStartDate, datEndDate);
intRecordReturned = TheFindEmployeeProductionHoursOverPayPeriodDataSet.FindEmployeeProductionHoursOverPayPeriod.Rows.Count;
if (intRecordReturned == 0)
{
TheFindDesignTotalEmployeeProductivityHoursDataSet = TheDesignProductivityClass.FindDesignTotalEmployeeProductivityHours(intEmployeeID, datStartDate, datEndDate);
intRecordReturned = TheFindDesignTotalEmployeeProductivityHoursDataSet.FindDesignTotalEmployeeProductivityHours.Rows.Count;
if (intRecordReturned == 0)
{
decProductiveHours = 0;
}
else
{
decProductiveHours = TheFindDesignTotalEmployeeProductivityHoursDataSet.FindDesignTotalEmployeeProductivityHours[0].TotalHours;
}
}
else
{
decProductiveHours = TheFindEmployeeProductionHoursOverPayPeriodDataSet.FindEmployeeProductionHoursOverPayPeriod[0].ProductionHours;
TheFindDesignTotalEmployeeProductivityHoursDataSet = TheDesignProductivityClass.FindDesignTotalEmployeeProductivityHours(intEmployeeID, datStartDate, datEndDate);
intRecordReturned = TheFindDesignTotalEmployeeProductivityHoursDataSet.FindDesignTotalEmployeeProductivityHours.Rows.Count;
if (intRecordReturned > 0)
{
decProductiveHours += TheFindDesignTotalEmployeeProductivityHoursDataSet.FindDesignTotalEmployeeProductivityHours[0].TotalHours;
}
}
//loading the dataset
EmployeeProductionPunchDataSet.employeesRow NewEmployeeRow = TheEmployeeProductionPunchDataSet.employees.NewemployeesRow();
NewEmployeeRow.HomeOffice = TheFindActiveNoExemptEmployeesDataSet.FindActiveNonExemptEmployeesByPayDate[intCounter].HomeOffice;
NewEmployeeRow.FirstName = strFirstName;
NewEmployeeRow.LastName = strLastName;
NewEmployeeRow.ManagerFirstName = strManagerFirstName;
NewEmployeeRow.ManagerLastName = strManagerLastName;
NewEmployeeRow.ProductionHours = decProductiveHours;
NewEmployeeRow.PunchedHours = decHoursPunched;
NewEmployeeRow.HourVariance = decProductiveHours - decHoursPunched;
TheEmployeeProductionPunchDataSet.employees.Rows.Add(NewEmployeeRow);
}
intNumberOfEmployees = TheEmployeeProductionPunchDataSet.employees.Rows.Count;
decCalVariance = 0;
for (intEmployeeCounter = 0; intEmployeeCounter < intNumberOfEmployees; intEmployeeCounter++)
{
decCalVariance += TheEmployeeProductionPunchDataSet.employees[intEmployeeCounter].HourVariance;
}
decVarianceMean = decCalVariance / Convert.ToDecimal(intNumberOfEmployees);
decVarianceMean = Math.Round(decVarianceMean, 4);
gdecMean = decVarianceMean;
decSumOfDifferences = 0;
for (intEmployeeCounter = 0; intEmployeeCounter < intNumberOfEmployees; intEmployeeCounter++)
{
decSumOfDifferences += Convert.ToDecimal(Math.Pow(Convert.ToDouble(TheEmployeeProductionPunchDataSet.employees[intEmployeeCounter].HourVariance - gdecMean), 2));
}
decAverageOfDifferences = decSumOfDifferences / Convert.ToDecimal(intNumberOfEmployees);
gdecStandardDeviation = Convert.ToDecimal(Math.Sqrt(Convert.ToDouble(decAverageOfDifferences)));
gdecStandardDeviation = Math.Round(gdecStandardDeviation, 4);
intNumberOfRecords = TheEmployeeProductionPunchDataSet.employees.Rows.Count - 1;
gintManagerCounter = 0;
gdecTotalAcceptable = 0;
gdecTotalEntries = 0;
for (intCounter = 0; intCounter <= intNumberOfRecords; intCounter++)
{
strManagerFirstName = TheEmployeeProductionPunchDataSet.employees[intCounter].ManagerFirstName;
strManagerLastName = TheEmployeeProductionPunchDataSet.employees[intCounter].ManagerLastName;
decVariance = TheEmployeeProductionPunchDataSet.employees[intCounter].HourVariance;
blnItemFound = false;
intArrayNumberOfRecords = -1;
if (gintManagerCounter > 0)
{
for (intManagerCounter = 0; intManagerCounter <= gintManagerUpperLimit; intManagerCounter++)
{
if (strManagerFirstName == TheProductionManagerStatsDataSet.productionmanager[intManagerCounter].FirstName)
{
if (strManagerLastName == TheProductionManagerStatsDataSet.productionmanager[intManagerCounter].LastName)
{
blnItemFound = true;
if ((decVariance >= -5 && decVariance <= 5))
{
TheProductionManagerStatsDataSet.productionmanager[intManagerCounter].ZeroToFive++;
gdecTotalEntries++;
gdecTotalAcceptable++;
}
else if (((decVariance < -5) && (decVariance >= -10)) || ((decVariance > 5) && (decVariance <= 10)))
{
TheProductionManagerStatsDataSet.productionmanager[intManagerCounter].FiveToTen++;
gdecTotalEntries++;
}
else if ((decVariance < -10) || (decVariance > 10))
{
TheProductionManagerStatsDataSet.productionmanager[intManagerCounter].Above10++;
gdecTotalEntries++;
}
}
}
}
}
if (blnItemFound == false)
{
ProductionManagerStatsDataSet.productionmanagerRow NewManagerRow = TheProductionManagerStatsDataSet.productionmanager.NewproductionmanagerRow();
NewManagerRow.FirstName = strManagerFirstName;
NewManagerRow.LastName = strManagerLastName;
NewManagerRow.PercentInTolerance = 0;
if (Convert.ToDouble(decVariance) > -5.01)
{
NewManagerRow.ZeroToFive = 1;
NewManagerRow.FiveToTen = 0;
NewManagerRow.Above10 = 0;
gdecTotalEntries++;
gdecTotalAcceptable++;
}
else if ((Convert.ToDouble(decVariance) < -5) && (Convert.ToDouble(decVariance) > -10.01))
{
NewManagerRow.ZeroToFive = 0;
NewManagerRow.FiveToTen = 1;
NewManagerRow.Above10 = 0;
gdecTotalEntries++;
}
else if (Convert.ToDouble(decVariance) < -10)
{
NewManagerRow.ZeroToFive = 0;
NewManagerRow.FiveToTen = 0;
NewManagerRow.Above10 = 1;
gdecTotalEntries++;
}
TheProductionManagerStatsDataSet.productionmanager.Rows.Add(NewManagerRow);
gintManagerUpperLimit = gintManagerCounter;
gintManagerCounter++;
}
}
intNumberOfRecords = TheProductionManagerStatsDataSet.productionmanager.Rows.Count - 1;
for (intCounter = 0; intCounter <= intNumberOfRecords; intCounter++)
{
intTotalNumber = TheProductionManagerStatsDataSet.productionmanager[intCounter].ZeroToFive;
intTotalNumber += TheProductionManagerStatsDataSet.productionmanager[intCounter].FiveToTen;
intTotalNumber += TheProductionManagerStatsDataSet.productionmanager[intCounter].Above10;
TheProductionManagerStatsDataSet.productionmanager[intCounter].PercentInTolerance = (Convert.ToDecimal(TheProductionManagerStatsDataSet.productionmanager[intCounter].ZeroToFive) / intTotalNumber) * 100;
TheProductionManagerStatsDataSet.productionmanager[intCounter].PercentInTolerance = Math.Round(TheProductionManagerStatsDataSet.productionmanager[intCounter].PercentInTolerance, 2);
}
decTotalPercentage = ((Math.Round(((gdecTotalAcceptable / gdecTotalEntries) * 100), 4)));
intTotalNumberNeeded = 0;
decTopPercentage = 1000;
decWorkingPercentage = 0;
strLastName = "";
intSelectedIndex = -1;
while (intTotalNumberNeeded <= intNumberOfRecords)
{
for (intCounter = 0; intCounter <= intNumberOfRecords; intCounter++)
{
if (TheProductionManagerStatsDataSet.productionmanager[intCounter].PercentInTolerance <= decTopPercentage)
{
if (TheProductionManagerStatsDataSet.productionmanager[intCounter].PercentInTolerance >= decWorkingPercentage)
{
blnItemFound = false;
if (intArrayNumberOfRecords > -1)
{
for (intArrayCounter = 0; intArrayCounter <= intArrayNumberOfRecords; intArrayCounter++)
{
if (TheProductionManagerStatsDataSet.productionmanager[intCounter].LastName == gstrLastName[intArrayCounter])
{
blnItemFound = true;
}
}
}
if (blnItemFound == false)
{
decWorkingPercentage = TheProductionManagerStatsDataSet.productionmanager[intCounter].PercentInTolerance;
intSelectedIndex = intCounter;
}
}
}
}
ProductionManagerStatsDataSet.productionmanagerRow NewManagerRow = TheFinalProductionManagerStatsDataSet.productionmanager.NewproductionmanagerRow();
NewManagerRow.Above10 = TheProductionManagerStatsDataSet.productionmanager[intSelectedIndex].Above10;
NewManagerRow.FirstName = TheProductionManagerStatsDataSet.productionmanager[intSelectedIndex].FirstName;
NewManagerRow.LastName = TheProductionManagerStatsDataSet.productionmanager[intSelectedIndex].LastName;
NewManagerRow.PercentInTolerance = TheProductionManagerStatsDataSet.productionmanager[intSelectedIndex].PercentInTolerance;
NewManagerRow.FiveToTen = TheProductionManagerStatsDataSet.productionmanager[intSelectedIndex].FiveToTen;
NewManagerRow.ZeroToFive = TheProductionManagerStatsDataSet.productionmanager[intSelectedIndex].ZeroToFive;
TheFinalProductionManagerStatsDataSet.productionmanager.Rows.Add(NewManagerRow);
intTotalNumberNeeded++;
decTopPercentage = decWorkingPercentage;
decWorkingPercentage = 0;
intArrayNumberOfRecords++;
gstrLastName[intArrayNumberOfRecords] = TheProductionManagerStatsDataSet.productionmanager[intSelectedIndex].LastName;
}
strHeader = "Employee Punched Vs Production Report For " + Convert.ToString(datEndDate);
intNumberOfRecords = TheEmployeeProductionPunchDataSet.employees.Rows.Count;
strMessage = "<h1> Employee Punched Vs Production Report For " + Convert.ToString(datEndDate) + "</h1>";
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>Punched Hours</b></td>";
strMessage += "<td><b>Production Hours</b></td>";
strMessage += "<td><b>Hour Variance</b></td>";
strMessage += "</tr>";
strMessage += "<p> </p>";
if (intNumberOfRecords > 0)
{
for (intCounter = 0; intCounter < intNumberOfRecords; intCounter++)
{
strManager = TheEmployeeProductionPunchDataSet.employees[intCounter].ManagerFirstName + " ";
strManager += TheEmployeeProductionPunchDataSet.employees[intCounter].ManagerLastName;
strMessage += "<tr>";
strMessage += "<td>" + TheEmployeeProductionPunchDataSet.employees[intCounter].FirstName + "</td>";
strMessage += "<td>" + TheEmployeeProductionPunchDataSet.employees[intCounter].LastName + "</td>";
strMessage += "<td>" + TheEmployeeProductionPunchDataSet.employees[intCounter].HomeOffice + "</td>";
strMessage += "<td>" + strManager + "</td>";
strMessage += "<td>" + Convert.ToString(TheEmployeeProductionPunchDataSet.employees[intCounter].PunchedHours) + "</td>";
strMessage += "<td>" + Convert.ToString(TheEmployeeProductionPunchDataSet.employees[intCounter].ProductionHours) + "</td>";
strMessage += "<td>" + Convert.ToString(TheEmployeeProductionPunchDataSet.employees[intCounter].HourVariance) + "</td>";
strMessage += "</tr>";
}
}
strMessage += "</table>";
strMessage += "<p> </p>";
blnFatalError = TheSendEmailClass.SendEmail(strEmailAddress, strHeader, strMessage);
if (blnFatalError == true)
{
throw new Exception();
}
strHeader = "Manager Punched Vs Productivity Report For " + Convert.ToString(datEndDate);
strMessage = "<h1>Employee Punched Vs Production Report For " + Convert.ToString(datEndDate) + "</h1>";
strMessage += "<p> </p>";
strMessage += "<h3>Company Average   " + Convert.ToString(gdecMean) + "</h3>";
strMessage += "<h3>Company Standard Deviation   " + Convert.ToString(gdecStandardDeviation) + "</h3>";
strMessage += "<h3>Company Percentage   " + Convert.ToString(decTotalPercentage);
strMessage += "<p> </p>";
strMessage += "<table>";
strMessage += "<tr>";
strMessage += "<td><b>First Name</b></td>";
strMessage += "<td><b>Last Name</b></td>";
strMessage += "<td><b>Zero to Five</b></td>";
strMessage += "<td><b>Five To Ten</b></td>";
strMessage += "<td><b>Above Ten</b></td>";
strMessage += "<td><b>Tolerance Percent</b></td>";
strMessage += "</tr>";
strMessage += "<p> </p>";
intNumberOfEmployees = TheFinalProductionManagerStatsDataSet.productionmanager.Rows.Count;
if (intNumberOfEmployees > 0)
{
for (intCounter = 0; intCounter < intNumberOfEmployees; intCounter++)
{
strMessage += "<tr>";
strMessage += "<td>" + TheFinalProductionManagerStatsDataSet.productionmanager[intCounter].FirstName + "</td>";
strMessage += "<td>" + TheFinalProductionManagerStatsDataSet.productionmanager[intCounter].LastName + "</td>";
strMessage += "<td>" + Convert.ToString(TheFinalProductionManagerStatsDataSet.productionmanager[intCounter].ZeroToFive) + "</td>";
strMessage += "<td>" + Convert.ToString(TheFinalProductionManagerStatsDataSet.productionmanager[intCounter].FiveToTen) + "</td>";
strMessage += "<td>" + Convert.ToString(TheFinalProductionManagerStatsDataSet.productionmanager[intCounter].Above10) + "</td>";
strMessage += "<td>" + Convert.ToString(TheFinalProductionManagerStatsDataSet.productionmanager[intCounter].PercentInTolerance) + "</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 // Run Punched Vs Production Report " + Ex.Message);
TheMessagesClass.ErrorMessage(Ex.ToString());
}
}
private void cboSelectManager_SelectionChanged(object sender, SelectionChangedEventArgs e)
{
string strValueForValidation;
bool blnFatalError = false;
DateTime datPayPeriod = DateTime.Now;
DateTime datStartDate = DateTime.Now;
int intCounter;
int intNumberOfRecords;
int intEmployeeID;
int intManagerID;
string strFirstName;
string strLastName;
string strManagerFirstName;
string strManagerLastName;
int intRecordReturned;
decimal decHoursPunched;
decimal decProductiveHours = 0;
int intSelectedIndex;
try
{
intSelectedIndex = cboSelectManager.SelectedIndex - 1;
if (intSelectedIndex > -1)
{
TheEmployeeProductionPunchDataSet.employees.Rows.Clear();
strValueForValidation = txtEnterPayPeriod.Text;
blnFatalError = TheDataValidationClass.VerifyDateData(strValueForValidation);
if (blnFatalError == true)
{
TheMessagesClass.ErrorMessage("The Date is not a Date");
return;
}
datPayPeriod = Convert.ToDateTime(strValueForValidation);
datStartDate = TheDateSearchClass.SubtractingDays(datPayPeriod, 6);
intManagerID = TheFindProductionManagersDataSet.FindProductionManagers[intSelectedIndex].EmployeeID;
strManagerFirstName = TheFindProductionManagersDataSet.FindProductionManagers[intSelectedIndex].FirstName;
strManagerLastName = TheFindProductionManagersDataSet.FindProductionManagers[intSelectedIndex].LastName;
TheFindManagerEmployeesByPayDateDataSet = TheEmployeeClass.FindManagerEmployeesByPayDate(intManagerID, datPayPeriod);
intNumberOfRecords = TheFindManagerEmployeesByPayDateDataSet.FindManagerEmployeesByPayDate.Rows.Count - 1;
for (intCounter = 0; intCounter <= intNumberOfRecords; intCounter++)
{
//getting employee info
intEmployeeID = TheFindManagerEmployeesByPayDateDataSet.FindManagerEmployeesByPayDate[intCounter].EmployeeID;
strFirstName = TheFindManagerEmployeesByPayDateDataSet.FindManagerEmployeesByPayDate[intCounter].FirstName;
strLastName = TheFindManagerEmployeesByPayDateDataSet.FindManagerEmployeesByPayDate[intCounter].LastName;
//getting employee punched hours
TheFindEmployeePunchedHoursDataSet = TheEmployeePunchedHoursClass.FindEmployeePunchedHours(intEmployeeID, datStartDate, datPayPeriod);
intRecordReturned = TheFindEmployeePunchedHoursDataSet.FindEmployeePunchedHours.Rows.Count;
if (intRecordReturned == 0)
{
decHoursPunched = 0;
}
else
{
decHoursPunched = TheFindEmployeePunchedHoursDataSet.FindEmployeePunchedHours[0].PunchedHours;
}
//getting production hours
TheFindEmployeeProductionHoursOverPayPeriodDataSet = TheEmployeeProjectAssignmentClass.FindEmployeeProductionHoursOverPayPeriodDataSet(intEmployeeID, datStartDate, datPayPeriod);
intRecordReturned = TheFindEmployeeProductionHoursOverPayPeriodDataSet.FindEmployeeProductionHoursOverPayPeriod.Rows.Count;
if (intRecordReturned == 0)
{
decProductiveHours = 0;
}
else
{
decProductiveHours = TheFindEmployeeProductionHoursOverPayPeriodDataSet.FindEmployeeProductionHoursOverPayPeriod[0].ProductionHours;
}
TheFindDesignTotalEmployeeProductivityHoursDataSet = TheDesignProductivityClass.FindDesignTotalEmployeeProductivityHours(intEmployeeID, datStartDate, datPayPeriod);
intRecordReturned = TheFindDesignTotalEmployeeProductivityHoursDataSet.FindDesignTotalEmployeeProductivityHours.Rows.Count;
if (intRecordReturned > 0)
{
decProductiveHours += TheFindDesignTotalEmployeeProductivityHoursDataSet.FindDesignTotalEmployeeProductivityHours[0].TotalHours;
}
//loading the dataset
EmployeeProductionPunchDataSet.employeesRow NewEmployeeRow = TheEmployeeProductionPunchDataSet.employees.NewemployeesRow();
NewEmployeeRow.HomeOffice = TheFindManagerEmployeesByPayDateDataSet.FindManagerEmployeesByPayDate[intCounter].HomeOffice;
NewEmployeeRow.FirstName = strFirstName;
NewEmployeeRow.LastName = strLastName;
NewEmployeeRow.ManagerFirstName = strManagerFirstName;
NewEmployeeRow.ManagerLastName = strManagerLastName;
NewEmployeeRow.ProductionHours = decProductiveHours;
NewEmployeeRow.PunchedHours = decHoursPunched;
NewEmployeeRow.HourVariance = decProductiveHours - decHoursPunched;
TheEmployeeProductionPunchDataSet.employees.Rows.Add(NewEmployeeRow);
}
blnFatalError = TheEmployeeDateEntryClass.InsertIntoEmployeeDateEntry(MainWindow.TheVerifyLogonDataSet.VerifyLogon[0].EmployeeID, "New Blue Jay ERP // Employee Punched VS Production Hours // Report By Manager");
if (blnFatalError == true)
{
throw new Exception();
}
dgrResults.ItemsSource = TheEmployeeProductionPunchDataSet.employees;
}
}
catch (Exception Ex)
{
TheEventLogClass.InsertEventLogEntry(DateTime.Now, "New Blue Jay ERP // Employee Punched VS Productivity Hours // Select Manager Combo Box " + Ex.Message);
TheMessagesClass.ErrorMessage(Ex.ToString());
}
}
private void btnProcess_Click(object sender, RoutedEventArgs e)
{
//setting local variables
int intCounter;
int intNumberOfRecords;
int intEmployeeID;
int intManagerID;
string strFirstName;
string strLastName;
string strManagerFirstName;
string strManagerLastName;
int intRecordReturned;
bool blnFatalError = false;
decimal decHoursPunched;
decimal decProductiveHours;
int intManagerCounter;
bool blnItemFound;
decimal decVariance;
int intTotalNumber;
int intSelectedIndex;
int intTotalNumberNeeded;
decimal decTopPercentage;
decimal decWorkingPercentage;
int intArrayCounter;
int intArrayNumberOfRecords = -1;
int intEmployeeCounter;
int intNumberOfEmployees;
decimal decCalVariance;
decimal decVarianceMean;
decimal decSumOfDifferences;
decimal decAverageOfDifferences;
try
{
TheEmployeeProductionPunchDataSet.employees.Rows.Clear();
TheProductionManagerStatsDataSet.productionmanager.Rows.Clear();
TheFinalProductionManagerStatsDataSet.productionmanager.Rows.Clear();
blnFatalError = TheDataValidationClass.VerifyDateData(txtEnterPayPeriod.Text);
if (blnFatalError == true)
{
TheMessagesClass.ErrorMessage("The Date Entered is not a Date");
return;
}
else
{
MainWindow.gdatEndDate = Convert.ToDateTime(txtEnterPayPeriod.Text);
MainWindow.gdatStartDate = TheDateSearchClass.SubtractingDays(MainWindow.gdatEndDate, 6);
}
TheFindActiveNoExemptEmployeesDataSet = TheEmployeeClass.FindActiveNonExemptEmployeesByPayDate(MainWindow.gdatEndDate);
intNumberOfRecords = TheFindActiveNoExemptEmployeesDataSet.FindActiveNonExemptEmployeesByPayDate.Rows.Count - 1;
for (intCounter = 0; intCounter <= intNumberOfRecords; intCounter++)
{
//getting employee info
intEmployeeID = TheFindActiveNoExemptEmployeesDataSet.FindActiveNonExemptEmployeesByPayDate[intCounter].EmployeeID;
strFirstName = TheFindActiveNoExemptEmployeesDataSet.FindActiveNonExemptEmployeesByPayDate[intCounter].FirstName;
strLastName = TheFindActiveNoExemptEmployeesDataSet.FindActiveNonExemptEmployeesByPayDate[intCounter].LastName;
intManagerID = TheFindActiveNoExemptEmployeesDataSet.FindActiveNonExemptEmployeesByPayDate[intCounter].ManagerID;
TheFindEmployeeByEmployeeIDDataSet = TheEmployeeClass.FindEmployeeByEmployeeID(intManagerID);
strManagerFirstName = TheFindEmployeeByEmployeeIDDataSet.FindEmployeeByEmployeeID[0].FirstName;
strManagerLastName = TheFindEmployeeByEmployeeIDDataSet.FindEmployeeByEmployeeID[0].LastName;
//getting employee punched hours
TheFindEmployeePunchedHoursDataSet = TheEmployeePunchedHoursClass.FindEmployeePunchedHours(intEmployeeID, MainWindow.gdatStartDate, MainWindow.gdatEndDate);
intRecordReturned = TheFindEmployeePunchedHoursDataSet.FindEmployeePunchedHours.Rows.Count;
if (intRecordReturned == 0)
{
decHoursPunched = 0;
}
else
{
decHoursPunched = TheFindEmployeePunchedHoursDataSet.FindEmployeePunchedHours[0].PunchedHours;
}
//getting production hours
TheFindEmployeeProductionHoursOverPayPeriodDataSet = TheEmployeeProjectAssignmentClass.FindEmployeeProductionHoursOverPayPeriodDataSet(intEmployeeID, MainWindow.gdatStartDate, MainWindow.gdatEndDate);
intRecordReturned = TheFindEmployeeProductionHoursOverPayPeriodDataSet.FindEmployeeProductionHoursOverPayPeriod.Rows.Count;
if (intRecordReturned == 0)
{
TheFindDesignTotalEmployeeProductivityHoursDataSet = TheDesignProductivityClass.FindDesignTotalEmployeeProductivityHours(intEmployeeID, MainWindow.gdatStartDate, MainWindow.gdatEndDate);
intRecordReturned = TheFindDesignTotalEmployeeProductivityHoursDataSet.FindDesignTotalEmployeeProductivityHours.Rows.Count;
if (intRecordReturned == 0)
{
decProductiveHours = 0;
}
else
{
decProductiveHours = TheFindDesignTotalEmployeeProductivityHoursDataSet.FindDesignTotalEmployeeProductivityHours[0].TotalHours;
}
}
else
{
decProductiveHours = TheFindEmployeeProductionHoursOverPayPeriodDataSet.FindEmployeeProductionHoursOverPayPeriod[0].ProductionHours;
TheFindDesignTotalEmployeeProductivityHoursDataSet = TheDesignProductivityClass.FindDesignTotalEmployeeProductivityHours(intEmployeeID, MainWindow.gdatStartDate, MainWindow.gdatEndDate);
intRecordReturned = TheFindDesignTotalEmployeeProductivityHoursDataSet.FindDesignTotalEmployeeProductivityHours.Rows.Count;
if (intRecordReturned > 0)
{
decProductiveHours += TheFindDesignTotalEmployeeProductivityHoursDataSet.FindDesignTotalEmployeeProductivityHours[0].TotalHours;
}
}
//loading the dataset
EmployeeProductionPunchDataSet.employeesRow NewEmployeeRow = TheEmployeeProductionPunchDataSet.employees.NewemployeesRow();
NewEmployeeRow.HomeOffice = TheFindActiveNoExemptEmployeesDataSet.FindActiveNonExemptEmployeesByPayDate[intCounter].HomeOffice;
NewEmployeeRow.FirstName = strFirstName;
NewEmployeeRow.LastName = strLastName;
NewEmployeeRow.ManagerFirstName = strManagerFirstName;
NewEmployeeRow.ManagerLastName = strManagerLastName;
NewEmployeeRow.ProductionHours = decProductiveHours;
NewEmployeeRow.PunchedHours = decHoursPunched;
NewEmployeeRow.HourVariance = decProductiveHours - decHoursPunched;
TheEmployeeProductionPunchDataSet.employees.Rows.Add(NewEmployeeRow);
}
intNumberOfEmployees = TheEmployeeProductionPunchDataSet.employees.Rows.Count;
decCalVariance = 0;
for (intEmployeeCounter = 0; intEmployeeCounter < intNumberOfEmployees; intEmployeeCounter++)
{
decCalVariance += TheEmployeeProductionPunchDataSet.employees[intEmployeeCounter].HourVariance;
}
decVarianceMean = decCalVariance / Convert.ToDecimal(intNumberOfEmployees);
decVarianceMean = Math.Round(decVarianceMean, 4);
txtCompanyAverage.Text = Convert.ToString(decVarianceMean);
gdecMean = decVarianceMean;
decSumOfDifferences = 0;
for (intEmployeeCounter = 0; intEmployeeCounter < intNumberOfEmployees; intEmployeeCounter++)
{
decSumOfDifferences += Convert.ToDecimal(Math.Pow(Convert.ToDouble(TheEmployeeProductionPunchDataSet.employees[intEmployeeCounter].HourVariance - gdecMean), 2));
}
decAverageOfDifferences = decSumOfDifferences / Convert.ToDecimal(intNumberOfEmployees);
gdecStandardDeviation = Convert.ToDecimal(Math.Sqrt(Convert.ToDouble(decAverageOfDifferences)));
gdecStandardDeviation = Math.Round(gdecStandardDeviation, 4);
txtStandardDeviation.Text = Convert.ToString(gdecStandardDeviation);
intNumberOfRecords = TheEmployeeProductionPunchDataSet.employees.Rows.Count - 1;
gintManagerCounter = 0;
gdecTotalAcceptable = 0;
gdecTotalEntries = 0;
for (intCounter = 0; intCounter <= intNumberOfRecords; intCounter++)
{
strManagerFirstName = TheEmployeeProductionPunchDataSet.employees[intCounter].ManagerFirstName;
strManagerLastName = TheEmployeeProductionPunchDataSet.employees[intCounter].ManagerLastName;
decVariance = TheEmployeeProductionPunchDataSet.employees[intCounter].HourVariance;
blnItemFound = false;
intArrayNumberOfRecords = -1;
if (gintManagerCounter > 0)
{
for (intManagerCounter = 0; intManagerCounter <= gintManagerUpperLimit; intManagerCounter++)
{
if (strManagerFirstName == TheProductionManagerStatsDataSet.productionmanager[intManagerCounter].FirstName)
{
if (strManagerLastName == TheProductionManagerStatsDataSet.productionmanager[intManagerCounter].LastName)
{
blnItemFound = true;
if ((decVariance >= -5 && decVariance <= 5))
{
TheProductionManagerStatsDataSet.productionmanager[intManagerCounter].ZeroToFive++;
gdecTotalEntries++;
gdecTotalAcceptable++;
}
else if (((decVariance < -5) && (decVariance >= -10)) || ((decVariance > 5) && (decVariance <= 10)))
{
TheProductionManagerStatsDataSet.productionmanager[intManagerCounter].FiveToTen++;
gdecTotalEntries++;
}
else if ((decVariance < -10) || (decVariance > 10))
{
TheProductionManagerStatsDataSet.productionmanager[intManagerCounter].Above10++;
gdecTotalEntries++;
}
}
}
}
}
if (blnItemFound == false)
{
ProductionManagerStatsDataSet.productionmanagerRow NewManagerRow = TheProductionManagerStatsDataSet.productionmanager.NewproductionmanagerRow();
NewManagerRow.FirstName = strManagerFirstName;
NewManagerRow.LastName = strManagerLastName;
NewManagerRow.PercentInTolerance = 0;
if (Convert.ToDouble(decVariance) > -5.01)
{
NewManagerRow.ZeroToFive = 1;
NewManagerRow.FiveToTen = 0;
NewManagerRow.Above10 = 0;
gdecTotalEntries++;
gdecTotalAcceptable++;
}
else if ((Convert.ToDouble(decVariance) < -5) && (Convert.ToDouble(decVariance) > -10.01))
{
NewManagerRow.ZeroToFive = 0;
NewManagerRow.FiveToTen = 1;
NewManagerRow.Above10 = 0;
gdecTotalEntries++;
}
else if (Convert.ToDouble(decVariance) < -10)
{
NewManagerRow.ZeroToFive = 0;
NewManagerRow.FiveToTen = 0;
NewManagerRow.Above10 = 1;
gdecTotalEntries++;
}
TheProductionManagerStatsDataSet.productionmanager.Rows.Add(NewManagerRow);
gintManagerUpperLimit = gintManagerCounter;
gintManagerCounter++;
}
}
intNumberOfRecords = TheProductionManagerStatsDataSet.productionmanager.Rows.Count - 1;
for (intCounter = 0; intCounter <= intNumberOfRecords; intCounter++)
{
intTotalNumber = TheProductionManagerStatsDataSet.productionmanager[intCounter].ZeroToFive;
intTotalNumber += TheProductionManagerStatsDataSet.productionmanager[intCounter].FiveToTen;
intTotalNumber += TheProductionManagerStatsDataSet.productionmanager[intCounter].Above10;
TheProductionManagerStatsDataSet.productionmanager[intCounter].PercentInTolerance = (Convert.ToDecimal(TheProductionManagerStatsDataSet.productionmanager[intCounter].ZeroToFive) / intTotalNumber) * 100;
TheProductionManagerStatsDataSet.productionmanager[intCounter].PercentInTolerance = Math.Round(TheProductionManagerStatsDataSet.productionmanager[intCounter].PercentInTolerance, 2);
}
intTotalNumberNeeded = 0;
decTopPercentage = 1000;
decWorkingPercentage = 0;
strLastName = "";
intSelectedIndex = -1;
while (intTotalNumberNeeded <= intNumberOfRecords)
{
for (intCounter = 0; intCounter <= intNumberOfRecords; intCounter++)
{
if (TheProductionManagerStatsDataSet.productionmanager[intCounter].PercentInTolerance <= decTopPercentage)
{
if (TheProductionManagerStatsDataSet.productionmanager[intCounter].PercentInTolerance >= decWorkingPercentage)
{
blnItemFound = false;
if (intArrayNumberOfRecords > -1)
{
for (intArrayCounter = 0; intArrayCounter <= intArrayNumberOfRecords; intArrayCounter++)
{
if (TheProductionManagerStatsDataSet.productionmanager[intCounter].LastName == gstrLastName[intArrayCounter])
{
blnItemFound = true;
}
}
}
if (blnItemFound == false)
{
decWorkingPercentage = TheProductionManagerStatsDataSet.productionmanager[intCounter].PercentInTolerance;
intSelectedIndex = intCounter;
}
}
}
}
ProductionManagerStatsDataSet.productionmanagerRow NewManagerRow = TheFinalProductionManagerStatsDataSet.productionmanager.NewproductionmanagerRow();
NewManagerRow.Above10 = TheProductionManagerStatsDataSet.productionmanager[intSelectedIndex].Above10;
NewManagerRow.FirstName = TheProductionManagerStatsDataSet.productionmanager[intSelectedIndex].FirstName;
NewManagerRow.LastName = TheProductionManagerStatsDataSet.productionmanager[intSelectedIndex].LastName;
NewManagerRow.PercentInTolerance = TheProductionManagerStatsDataSet.productionmanager[intSelectedIndex].PercentInTolerance;
NewManagerRow.FiveToTen = TheProductionManagerStatsDataSet.productionmanager[intSelectedIndex].FiveToTen;
NewManagerRow.ZeroToFive = TheProductionManagerStatsDataSet.productionmanager[intSelectedIndex].ZeroToFive;
TheFinalProductionManagerStatsDataSet.productionmanager.Rows.Add(NewManagerRow);
intTotalNumberNeeded++;
decTopPercentage = decWorkingPercentage;
decWorkingPercentage = 0;
intArrayNumberOfRecords++;
gstrLastName[intArrayNumberOfRecords] = TheProductionManagerStatsDataSet.productionmanager[intSelectedIndex].LastName;
}
dgrResults.ItemsSource = TheFinalProductionManagerStatsDataSet.productionmanager;
txtCompanyPercent.Text = Convert.ToString((Math.Round(((gdecTotalAcceptable / gdecTotalEntries) * 100), 2)));
intNumberOfRecords = TheFinalProductionManagerStatsDataSet.productionmanager.Rows.Count - 1;
//CustomLabel strManager
Chart chart = this.FindName("MyWinformChart") as Chart;
chart.Legends.Clear();
Series ZeroToFive = chart.Series["ZeroToFive"];
Series SixToTen = chart.Series["SixToTen"];
Series Above10 = chart.Series["Above10"];
chart.Legends.Add(new Legend("ZeroToFive"));
//chart.Legends.Add(new Legend("SixToTen"));
//chart.Legends.Add(new Legend("Above10"));
ZeroToFive.Points.Clear();
SixToTen.Points.Clear();
Above10.Points.Clear();
chart.ChartAreas[0].AxisX.CustomLabels.Clear();
chart.ChartAreas[0].AxisX.MajorGrid.LineWidth = 0;
chart.ChartAreas[0].AxisX.Interval = 15;
for (intCounter = 0; intCounter <= intNumberOfRecords; intCounter++)
{
ZeroToFive.Points.Add(TheFinalProductionManagerStatsDataSet.productionmanager[intCounter].ZeroToFive);
SixToTen.Points.Add(TheFinalProductionManagerStatsDataSet.productionmanager[intCounter].FiveToTen);
Above10.Points.Add(TheFinalProductionManagerStatsDataSet.productionmanager[intCounter].Above10);
chart.ChartAreas[0].AxisX.CustomLabels.Add(intCounter + .5, intCounter + 1.5, TheFinalProductionManagerStatsDataSet.productionmanager[intCounter].LastName, 1, LabelMarkStyle.None);
}
//chart.Series["ZeroToFive"].XValueMember = "Key";
//chart.Series["ZeroToFive"].YValueMembers = "Value";
}
catch (Exception Ex)
{
TheEventLogClass.InsertEventLogEntry(DateTime.Now, "New Blue Jay ERP // Manager Productivity Punched // Process Button " + Ex.Message);
TheMessagesClass.ErrorMessage(Ex.ToString());
}
}
private void mitGenerateReport_Click(object sender, RoutedEventArgs e)
{
//setting local variables
int intCounter;
int intNumberOfRecords;
int intEmployeeID;
int intManagerID;
string strFirstName;
string strLastName;
string strManagerFirstName;
string strManagerLastName;
int intRecordReturned;
bool blnFatalError = false;
decimal decHoursPunched;
decimal decProductiveHours = 0;
try
{
TheEmployeeProductionPunchDataSet.employees.Rows.Clear();
blnFatalError = TheDataValidationClass.VerifyDateData(txtEnterPayPeriod.Text);
if (blnFatalError == true)
{
TheMessagesClass.ErrorMessage("The Date Entered is not a Date");
return;
}
else
{
MainWindow.gdatEndDate = Convert.ToDateTime(txtEnterPayPeriod.Text);
MainWindow.gdatStartDate = TheDateSearchClass.SubtractingDays(MainWindow.gdatEndDate, 6);
}
TheFindActiveNoExemptEmployeesDataSet = TheEmployeeClass.FindActiveNonExemptEmployeesByPayDate(MainWindow.gdatEndDate);
intNumberOfRecords = TheFindActiveNoExemptEmployeesDataSet.FindActiveNonExemptEmployeesByPayDate.Rows.Count - 1;
for (intCounter = 0; intCounter <= intNumberOfRecords; intCounter++)
{
//getting employee info
intEmployeeID = TheFindActiveNoExemptEmployeesDataSet.FindActiveNonExemptEmployeesByPayDate[intCounter].EmployeeID;
strFirstName = TheFindActiveNoExemptEmployeesDataSet.FindActiveNonExemptEmployeesByPayDate[intCounter].FirstName;
strLastName = TheFindActiveNoExemptEmployeesDataSet.FindActiveNonExemptEmployeesByPayDate[intCounter].LastName;
intManagerID = TheFindActiveNoExemptEmployeesDataSet.FindActiveNonExemptEmployeesByPayDate[intCounter].ManagerID;
TheFindEmployeeByEmployeeIDDataSet = TheEmployeeClass.FindEmployeeByEmployeeID(intManagerID);
strManagerFirstName = TheFindEmployeeByEmployeeIDDataSet.FindEmployeeByEmployeeID[0].FirstName;
strManagerLastName = TheFindEmployeeByEmployeeIDDataSet.FindEmployeeByEmployeeID[0].LastName;
//getting employee punched hours
TheFindEmployeePunchedHoursDataSet = TheEmployeePunchedHoursClass.FindEmployeePunchedHours(intEmployeeID, MainWindow.gdatStartDate, MainWindow.gdatEndDate);
intRecordReturned = TheFindEmployeePunchedHoursDataSet.FindEmployeePunchedHours.Rows.Count;
if (intRecordReturned == 0)
{
decHoursPunched = 0;
}
else
{
decHoursPunched = TheFindEmployeePunchedHoursDataSet.FindEmployeePunchedHours[0].PunchedHours;
}
//getting production hours
TheFindEmployeeProductionHoursOverPayPeriodDataSet = TheEmployeeProjectAssignmentClass.FindEmployeeProductionHoursOverPayPeriodDataSet(intEmployeeID, MainWindow.gdatStartDate, MainWindow.gdatEndDate);
intRecordReturned = TheFindEmployeeProductionHoursOverPayPeriodDataSet.FindEmployeeProductionHoursOverPayPeriod.Rows.Count;
if (intRecordReturned == 0)
{
decProductiveHours = 0;
}
else
{
decProductiveHours = TheFindEmployeeProductionHoursOverPayPeriodDataSet.FindEmployeeProductionHoursOverPayPeriod[0].ProductionHours;
}
TheFindDesignTotalEmployeeProductivityHoursDataSet = TheDesignProductivityClass.FindDesignTotalEmployeeProductivityHours(intEmployeeID, MainWindow.gdatStartDate, MainWindow.gdatEndDate);
intRecordReturned = TheFindDesignTotalEmployeeProductivityHoursDataSet.FindDesignTotalEmployeeProductivityHours.Rows.Count;
if (intRecordReturned > 0)
{
decProductiveHours += TheFindDesignTotalEmployeeProductivityHoursDataSet.FindDesignTotalEmployeeProductivityHours[0].TotalHours;
}
//loading the dataset
EmployeeProductionPunchDataSet.employeesRow NewEmployeeRow = TheEmployeeProductionPunchDataSet.employees.NewemployeesRow();
NewEmployeeRow.HomeOffice = TheFindActiveNoExemptEmployeesDataSet.FindActiveNonExemptEmployeesByPayDate[intCounter].HomeOffice;
NewEmployeeRow.FirstName = strFirstName;
NewEmployeeRow.LastName = strLastName;
NewEmployeeRow.ManagerFirstName = strManagerFirstName;
NewEmployeeRow.ManagerLastName = strManagerLastName;
NewEmployeeRow.ProductionHours = decProductiveHours;
NewEmployeeRow.PunchedHours = decHoursPunched;
NewEmployeeRow.HourVariance = decProductiveHours - decHoursPunched;
TheEmployeeProductionPunchDataSet.employees.Rows.Add(NewEmployeeRow);
}
blnFatalError = TheEmployeeDateEntryClass.InsertIntoEmployeeDateEntry(MainWindow.TheVerifyLogonDataSet.VerifyLogon[0].EmployeeID, "Blue Jay ERP // Employee Punched VS Production Hours // Generate Report Menu Item");
if (blnFatalError == true)
{
throw new Exception();
}
dgrResults.ItemsSource = TheEmployeeProductionPunchDataSet.employees;
}
catch (Exception Ex)
{
TheEventLogClass.InsertEventLogEntry(DateTime.Now, "Blue Jay ERP // Employee Punched VS Production Hours // Generate Report Menu Item " + Ex.Message);
TheMessagesClass.ErrorMessage(Ex.ToString());
}
}
private void btnFind_Click(object sender, RoutedEventArgs e)
{
int intCounter;
int intNumberOfRecords;
string strValueForValidation;
DateTime datTransactionDate = DateTime.Now;
bool blnFatalError = false;
int intEmployeeID;
int intSecondCounter;
int intSecondNumberOfRecords;
DateTime datSecondDate;
string strFirstName;
string strLastName;
try
{
PleaseWait PleaseWait = new PleaseWait();
PleaseWait.Show();
TheDuplicateEmployeeDataSet.duplicateemployees.Rows.Clear();
strValueForValidation = txtEnterPayPeriod.Text;
blnFatalError = TheDataValidationClass.VerifyDateData(strValueForValidation);
if (blnFatalError == true)
{
TheMessagesClass.ErrorMessage("The Date Entered is not a Date\n");
return;
}
else
{
datTransactionDate = Convert.ToDateTime(strValueForValidation);
}
datSecondDate = TheDateSearchClass.AddingDays(datTransactionDate, 1);
TheFindDuplicateEmployeePunchedHoursDataSet = TheEmployeePunchedHoursClass.FindDuplicateEmployeePunchedHours(datTransactionDate);
intNumberOfRecords = TheFindDuplicateEmployeePunchedHoursDataSet.FindDuplicateEmployeePunchedHours.Rows.Count;
if (intNumberOfRecords > 0)
{
for (intCounter = 0; intCounter < intNumberOfRecords; intCounter++)
{
intEmployeeID = TheFindDuplicateEmployeePunchedHoursDataSet.FindDuplicateEmployeePunchedHours[intCounter].EmployeeID;
strFirstName = TheFindDuplicateEmployeePunchedHoursDataSet.FindDuplicateEmployeePunchedHours[intCounter].FirstName;
strLastName = TheFindDuplicateEmployeePunchedHoursDataSet.FindDuplicateEmployeePunchedHours[intCounter].LastName;
TheFindEmployeePunchedHoursDataSet = TheEmployeePunchedHoursClass.FindEmployeePunchedHours(intEmployeeID, datTransactionDate, datSecondDate);
intSecondNumberOfRecords = TheFindEmployeePunchedHoursDataSet.FindEmployeePunchedHours.Rows.Count;
for (intSecondCounter = 0; intSecondCounter < intSecondNumberOfRecords; intSecondCounter++)
{
DuplicateEmployeeDataSet.duplicateemployeesRow NewEmployeeRow = TheDuplicateEmployeeDataSet.duplicateemployees.NewduplicateemployeesRow();
NewEmployeeRow.EmployeeID = intEmployeeID;
NewEmployeeRow.FirstName = strFirstName;
NewEmployeeRow.LastName = strLastName;
NewEmployeeRow.PunchedHours = TheFindEmployeePunchedHoursDataSet.FindEmployeePunchedHours[intSecondCounter].PunchedHours;
NewEmployeeRow.TransactionID = TheFindEmployeePunchedHoursDataSet.FindEmployeePunchedHours[intSecondCounter].TransactionID;
NewEmployeeRow.Remove = false;
TheDuplicateEmployeeDataSet.duplicateemployees.Rows.Add(NewEmployeeRow);
}
}
}
dgrEmployees.ItemsSource = TheDuplicateEmployeeDataSet.duplicateemployees;
PleaseWait.Close();
}
catch (Exception Ex)
{
TheEventLogClass.InsertEventLogEntry(DateTime.Now, "New Blue Jay ERP // Employee Double Hours // Find Button " + Ex.Message);
TheMessagesClass.ErrorMessage(Ex.ToString());
}
}
