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