public FindEmployeeHoursOverDateRangeDataSet FindEmployeeHoursOverDateRange(int intEmployeeID, DateTime datStartDate, DateTime datEndDate)
{
try
{
aFindEmployeeHoursOverDateRangeDataSet = new FindEmployeeHoursOverDateRangeDataSet();
aFindEmployeeHoursOverDateRangeTableAdapter = new FindEmployeeHoursOverDateRangeDataSetTableAdapters.FindEmployeeHoursOverDateRangeTableAdapter();
aFindEmployeeHoursOverDateRangeTableAdapter.Fill(aFindEmployeeHoursOverDateRangeDataSet.FindEmployeeHoursOverDateRange, intEmployeeID, datStartDate, datEndDate);
}
catch (Exception Ex)
{
TheEventLogClass.InsertEventLogEntry(DateTime.Now, "Employee Project Assignment Class // Find Employee Hours Over Date Range " + Ex.Message);
}
return(aFindEmployeeHoursOverDateRangeDataSet);
}
private bool CheckEmployeeTotalHours(int intEmployeeID, decimal decHoursEntered)
{
bool blnOverHours = false;
int intCounter;
int intNumberOfRecords;
decimal decTotalHours = 0;
DateTime datStartDate = DateTime.Now;
DateTime datEndDate = DateTime.Now;
try
{
datStartDate = Convert.ToDateTime(txtEnterDate.Text);
datStartDate = TheDateSearchClass.RemoveTime(datStartDate);
datEndDate = datStartDate;
TheFindEmployeeHoursOverADateRangeDataSet = TheEmployeeProjectAssignmentClass.FindEmployeeHoursOverDateRange(intEmployeeID, datStartDate, datEndDate);
decTotalHours = decHoursEntered - gdecLunchHour;
intNumberOfRecords = TheFindEmployeeHoursOverADateRangeDataSet.FindEmployeeHoursOverDateRange.Rows.Count - 1;
if (intNumberOfRecords > -1)
{
for (intCounter = 0; intCounter <= intNumberOfRecords; intCounter++)
{
decTotalHours += TheFindEmployeeHoursOverADateRangeDataSet.FindEmployeeHoursOverDateRange[intCounter].TotalHours;
}
}
if (decTotalHours > 16)
{
blnOverHours = true;
}
}
catch (Exception Ex)
{
TheEventLogClass.InsertEventLogEntry(DateTime.Now, "New Blue Jay ERP // Add Project Labor // Check Employee Total Hours " + Ex.Message);
TheSendEmailClass.SendEventLog("New Blue Jay ERP // Add Project Labor // Check Employee Total Hours " + Ex.ToString());
TheMessagesClass.ErrorMessage(Ex.ToString());
blnOverHours = true;
}
return(blnOverHours);
}
