public FindManagerEmployeesByPayDateDataSet FindManagerEmployeesByPayDate(int intManagerID, DateTime datEndDate)
{
try
{
aFindManagerEmployeesByPayDateDataSet = new FindManagerEmployeesByPayDateDataSet();
aFindManagerEmployeesByPayDateTableAdapter = new FindManagerEmployeesByPayDateDataSetTableAdapters.FindManagerEmployeesByPayDateTableAdapter();
aFindManagerEmployeesByPayDateTableAdapter.Fill(aFindManagerEmployeesByPayDateDataSet.FindManagerEmployeesByPayDate, intManagerID, datEndDate);
}
catch (Exception Ex)
{
TheEventLogClass.InsertEventLogEntry(DateTime.Now, "Employee Class // Find Manager Employees By Pay Date " + Ex.Message);
}
return(aFindManagerEmployeesByPayDateDataSet);
}
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());
}
}
