private void CheckEmployeePayRate()
{
int intCounter;
int intNumberOfRecords;
int intEmployeeID;
int intRecordsReturned;
bool blnFatalError = false;
try
{
TheFindActiveEmployeesDataSet = TheEmployeeClass.FindActiveEmployees();
intNumberOfRecords = TheFindActiveEmployeesDataSet.FindActiveEmployees.Rows.Count - 1;
for (intCounter = 0; intCounter <= intNumberOfRecords; intCounter++)
{
intEmployeeID = TheFindActiveEmployeesDataSet.FindActiveEmployees[intCounter].EmployeeID;
TheFindEmployeeLaborRateDataSet = TheEmployeeLaborRateClass.FindEmployeeLaborRate(intEmployeeID);
intRecordsReturned = TheFindEmployeeLaborRateDataSet.FindEmployeeLaborRate.Rows.Count;
if(intRecordsReturned == 0)
{
blnFatalError = TheEmployeeLaborRateClass.InsertEmployeeLaborRate(intEmployeeID, 1);
if (blnFatalError == true)
throw new Exception();
}
}
}
catch (Exception Ex)
{
TheEventLogClass.InsertEventLogEntry(DateTime.Now, "Event Log Tracker // Cheeck Employee Pay Rate " + Ex.Message);
TheMessagesClass.ErrorMessage(Ex.ToString());
}
}
private void cboSelectEmployee_SelectionChanged(object sender, SelectionChangedEventArgs e)
{
//setting local variables
int intSelectedIndex;
int intRecordsReturned;
try
{
intSelectedIndex = cboSelectEmployee.SelectedIndex - 1;
if (intSelectedIndex > -1)
{
MainWindow.gintEmployeeID = TheComboEmployeeDataSet.employees[intSelectedIndex].EmployeeID;
TheFindEmployeeLaborRateDataSet = TheEmployeeLaborRateClass.FindEmployeeLaborRate(MainWindow.gintEmployeeID);
intRecordsReturned = TheFindEmployeeLaborRateDataSet.FindEmployeeLaborRate.Rows.Count;
if (intRecordsReturned < 1)
{
gblnNewRecord = true;
txtLaborRate.Text = "None Found";
}
else if (intRecordsReturned > 0)
{
gblnNewRecord = false;
txtLaborRate.Text = Convert.ToString(TheFindEmployeeLaborRateDataSet.FindEmployeeLaborRate[0].PayRate);
}
}
}
catch (Exception Ex)
{
TheEventLogClass.InsertEventLogEntry(DateTime.Now, "New Blue Jay ERP // Add Employee Labor Rate // Combo Selection Changed Event " + Ex.Message);
TheSendEmailClass.SendEventLog(Ex.ToString());
TheMessagesClass.ErrorMessage(Ex.ToString());
}
}
private void cboSelectManager_SelectionChanged(object sender, SelectionChangedEventArgs e)
{
int intSelectedIndex;
bool blnFatalError = false;
bool blnThereIsAProblem = false;
string strErrorMessage = "";
string strValueForValidation;
DateTime datTransactionDate;
DateTime datLimitingDate;
string strFirstName;
string strLastName;
decimal decProductivityHours;
double douPunchedHours;
decimal decLaborRate;
decimal decPunchedHours;
int intEmployeeID;
int intCounter;
int intNumberOfRecords;
int intRecordsReturned;
decimal decStraightHours = 0;
decimal decOverTimeHours = 0;
decimal decStraightCost = 0;
decimal decOverTimeCosts = 0;
decimal decOverTimeRate = 0;
double douTotalLaborCost = 0;
decimal decHourVariance = 0;
try
{
intSelectedIndex = cboSelectManager.SelectedIndex - 1;
TheEmployeePunchesProductivityDataSet.employeepunchesproductivity.Rows.Clear();
if (intSelectedIndex > -1)
{
strValueForValidation = txtStartDate.Text;
blnThereIsAProblem = TheDataValidationClass.VerifyDateData(strValueForValidation);
if (blnThereIsAProblem == true)
{
blnFatalError = true;
strErrorMessage += "The Start Date is not a Date\n";
}
else
{
gdatStartDate = Convert.ToDateTime(strValueForValidation);
}
strValueForValidation = txtEndDate.Text;
blnThereIsAProblem = TheDataValidationClass.VerifyDateData(strValueForValidation);
if (blnThereIsAProblem == true)
{
blnFatalError = true;
strErrorMessage += "The End Date is not a Date\n";
}
else
{
gdatEndDate = Convert.ToDateTime(strValueForValidation);
}
if (blnFatalError == true)
{
TheMessagesClass.ErrorMessage(strErrorMessage);
return;
}
else
{
blnFatalError = TheDataValidationClass.verifyDateRange(gdatStartDate, gdatEndDate);
if (blnFatalError == true)
{
TheMessagesClass.ErrorMessage("The Start Date is after the End Date");
return;
}
}
gintManagerID = TheFindProductionManagersDataSet.FindProductionManagers[intSelectedIndex].EmployeeID;
TheFindSortedManagerHourlyemployeesDataSet = TheEmployeeClass.FindSortedManagersHourlyEmployees(gintManagerID);
intNumberOfRecords = TheFindSortedManagerHourlyemployeesDataSet.FindSortedManagersHourlyEmployees.Rows.Count - 1;
datTransactionDate = gdatStartDate;
datLimitingDate = TheDateSearchClass.AddingDays(datTransactionDate, 1);
datLimitingDate = datLimitingDate.AddSeconds(-1);
while (datLimitingDate <= gdatEndDate)
{
for (intCounter = 0; intCounter <= intNumberOfRecords; intCounter++)
{
intEmployeeID = TheFindSortedManagerHourlyemployeesDataSet.FindSortedManagersHourlyEmployees[intCounter].EmployeeID;
TheFindEmployeeProductionHoursOverPayPeriodDataSet = TheEmployeeProjectAssignmentClass.FindEmployeeProductionHoursOverPayPeriodDataSet(intEmployeeID, datTransactionDate, datTransactionDate);
intRecordsReturned = TheFindEmployeeProductionHoursOverPayPeriodDataSet.FindEmployeeProductionHoursOverPayPeriod.Rows.Count;
if (intRecordsReturned < 1)
{
decProductivityHours = 0;
}
else
{
decProductivityHours = TheFindEmployeeProductionHoursOverPayPeriodDataSet.FindEmployeeProductionHoursOverPayPeriod[0].ProductionHours;
}
TheFindAlohaEmployeeHoursOverDateRangeDataSet = TheEmployeePunchedHoursClass.FindAlohaEmployeeHoursOverDateRange(intEmployeeID, datTransactionDate, datLimitingDate);
intRecordsReturned = TheFindAlohaEmployeeHoursOverDateRangeDataSet.FindAlohaEmployeeHoursOverDateRange.Rows.Count;
if (intRecordsReturned > 0)
{
decPunchedHours = TheFindAlohaEmployeeHoursOverDateRangeDataSet.FindAlohaEmployeeHoursOverDateRange[0].TotalHours;
if (decPunchedHours > 8)
{
decStraightHours = 8;
decOverTimeHours = decPunchedHours - 8;
}
else
{
decStraightHours = decPunchedHours;
decOverTimeHours = 0;
}
TheFindEmployeeLaborRateDataSet = TheEmployeeLaborRateClass.FindEmployeeLaborRate(intEmployeeID);
decLaborRate = TheFindEmployeeLaborRateDataSet.FindEmployeeLaborRate[0].PayRate;
decStraightCost = decStraightHours * decLaborRate;
decOverTimeRate = decLaborRate * Convert.ToDecimal(1.5);
decOverTimeCosts = decOverTimeHours * decOverTimeRate;
strFirstName = TheFindSortedManagerHourlyemployeesDataSet.FindSortedManagersHourlyEmployees[intCounter].FirstName;
strLastName = TheFindSortedManagerHourlyemployeesDataSet.FindSortedManagersHourlyEmployees[intCounter].LastName;
douTotalLaborCost = Math.Round(Convert.ToDouble(decStraightCost + decOverTimeCosts), 2);
if (decPunchedHours != 0)
{
decHourVariance = decProductivityHours - decPunchedHours;
EmployeePunchesProductivityDataSet.employeepunchesproductivityRow NewProductivityRow = TheEmployeePunchesProductivityDataSet.employeepunchesproductivity.NewemployeepunchesproductivityRow();
NewProductivityRow.Date = datTransactionDate;
NewProductivityRow.FirstName = strFirstName;
NewProductivityRow.LastName = strLastName;
NewProductivityRow.TotalLaborCost = Convert.ToDecimal(douTotalLaborCost);
NewProductivityRow.HoursProductive = decProductivityHours;
NewProductivityRow.HoursPunched = decPunchedHours;
NewProductivityRow.HourVariance = decHourVariance;
TheEmployeePunchesProductivityDataSet.employeepunchesproductivity.Rows.Add(NewProductivityRow);
}
}
}
datTransactionDate = datLimitingDate.AddSeconds(1);
datLimitingDate = TheDateSearchClass.AddingDays(datLimitingDate, 1);
}
dgrResults.ItemsSource = TheEmployeePunchesProductivityDataSet.employeepunchesproductivity;
}
}
catch (Exception Ex)
{
TheEventLogClass.InsertEventLogEntry(DateTime.Now, "New Blue Jay ERP // Manager Hourly Daily Report // Manager Selection " + Ex.Message);
TheMessagesClass.ErrorMessage(Ex.ToString());
}
}