Beispiel #1
0
        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());
            }
        }