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