public FindEmployeeProjectHoursOverDateRangeDataSet FindEmployeeProjectHoursOverDateRange(int intEmployeeID, int intProjectID, DateTime datStartDate, DateTime datEndDate)
{
try
{
aFindEmployeeProjectHoursOverDateRangeDataSet = new FindEmployeeProjectHoursOverDateRangeDataSet();
aFindEmployeeProjectHoursOverDateRangeTableAdapter = new FindEmployeeProjectHoursOverDateRangeDataSetTableAdapters.FindEmployeeProjectHoursOverDateRangeTableAdapter();
aFindEmployeeProjectHoursOverDateRangeTableAdapter.Fill(aFindEmployeeProjectHoursOverDateRangeDataSet.FindEmployeeProjectHoursOverDateRange, intEmployeeID, intProjectID, datStartDate, datEndDate);
}
catch (Exception Ex)
{
TheEventLogClass.InsertEventLogEntry(DateTime.Now, "Employee Project Assignment Class // Find Employee Project Hours Over Date Range " + Ex.Message);
}
return(aFindEmployeeProjectHoursOverDateRangeDataSet);
}
private void LoadTaskComboBox()
{
//setting local variables;
int intFirstCounter;
int intFirstNumberOfRecords;
int intSecondCounter;
int intSecondNumberOfRecords;
int intTaskCounter;
bool blnItemFound;
int intEmployeeID;
int intProjectID;
int intTaskID;
string strWorkTask;
try
{
intFirstNumberOfRecords = TheCompareCrewEmployeesDataSet.employees.Rows.Count - 1;
gintTaskCounter = 0;
gintTaskUpperLimit = 0;
for (intFirstCounter = 0; intFirstCounter <= intFirstNumberOfRecords; intFirstCounter++)
{
intEmployeeID = TheCompareCrewEmployeesDataSet.employees[intFirstCounter].EmployeeID;
intProjectID = TheCompareCrewEmployeesDataSet.employees[intFirstCounter].ProjectID;
TheFindEmployeeProjectHoursOverDateRangeDataSet = TheEmployeeProjectAssignmentClass.FindEmployeeProjectHoursOverDateRange(intEmployeeID, intProjectID, gdatStartDate, gdatEndDate);
intSecondNumberOfRecords = TheFindEmployeeProjectHoursOverDateRangeDataSet.FindEmployeeProjectHoursOverDateRange.Rows.Count - 1;
if (intSecondNumberOfRecords > -1)
{
for (intSecondCounter = 0; intSecondCounter <= intSecondNumberOfRecords; intSecondCounter++)
{
blnItemFound = false;
strWorkTask = TheFindEmployeeProjectHoursOverDateRangeDataSet.FindEmployeeProjectHoursOverDateRange[intSecondCounter].WorkTask;
TheFindWorkTaskByWorkTaskDataSet = TheWorkTaskClass.FindWorkTaskByWorkTask(strWorkTask);
intTaskID = TheFindWorkTaskByWorkTaskDataSet.FindWorkTaskByWorkTask[0].WorkTaskID;
if (gintTaskCounter > 0)
{
for (intTaskCounter = 0; intTaskCounter <= gintTaskUpperLimit; intTaskCounter++)
{
if (intTaskID == TheCompareCrewTasksDataSet.worktasks[intTaskCounter].WorkTaskID)
{
blnItemFound = true;
}
}
}
if (blnItemFound == false)
{
CompareCrewTasksDataSet.worktasksRow NewTaskRow = TheCompareCrewTasksDataSet.worktasks.NewworktasksRow();
NewTaskRow.WorkTask = strWorkTask;
NewTaskRow.WorkTaskID = intTaskID;
TheCompareCrewTasksDataSet.worktasks.Rows.Add(NewTaskRow);
cboSelectTask.Items.Add(strWorkTask);
gintTaskUpperLimit = gintTaskCounter;
gintTaskCounter++;
}
}
}
}
cboSelectTask.SelectedIndex = 0;
}
catch (Exception Ex)
{
TheEventLogClass.InsertEventLogEntry(DateTime.Now, "Blue Jay ERP // Compare Employee Crews // Load Task Combo Box " + Ex.Message);
TheMessagesClass.ErrorMessage(Ex.ToString());
}
}
