public FindProjectTaskForVoidingDataSet FindProjectTaskForVoiding(int intEmployeeID, DateTime datTransactionDate)
        {
            try
            {
                aFindProjectTaskForVoidingDataSet      = new FindProjectTaskForVoidingDataSet();
                aFindProjectTaskForVoidingTableAdapter = new FindProjectTaskForVoidingDataSetTableAdapters.FindProjectTaskForVoidingTableAdapter();
                aFindProjectTaskForVoidingTableAdapter.Fill(aFindProjectTaskForVoidingDataSet.FindProjectTaskForVoiding, intEmployeeID, datTransactionDate);
            }
            catch (Exception Ex)
            {
                TheEventLogClass.InsertEventLogEntry(DateTime.Now, "Project Task Class // Find Project Task For Voiding " + Ex.Message);
            }

            return(aFindProjectTaskForVoidingDataSet);
        }
示例#2
0
        private void expFindTransactions_Expanded(object sender, RoutedEventArgs e)
        {
            bool   blnFatalError = false;
            int    intCounter;
            int    intNumberOfRecords;
            string strValueForValidation;
            string strErrorMessage    = "";
            bool   blnThereIsAProblem = false;
            int    intProjectID;
            int    intTaskID;
            int    intSecondCounter;
            int    intSecondNumberOfRecords;

            try
            {
                //data validation
                expFindTransactions.IsExpanded = false;
                if (cboSelectEmployee.SelectedIndex < 1)
                {
                    blnFatalError    = true;
                    strErrorMessage += "The Employee Was Not Selected\n";
                }
                strValueForValidation = txtEnterDate.Text;
                blnThereIsAProblem    = TheDataValidationClass.VerifyDateData(strValueForValidation);
                if (blnThereIsAProblem == true)
                {
                    blnFatalError    = true;
                    strErrorMessage += "The Date Entered is not a Date\n";
                }
                else
                {
                    gdatTransactionDate = Convert.ToDateTime(strValueForValidation);
                }
                if (blnFatalError == true)
                {
                    TheMessagesClass.ErrorMessage(strErrorMessage);
                    return;
                }

                TheFindEmployeeProjectAssignmentForVoidingDataSet = TheEmployeeProjectAssignmentClass.FindEmployeeProjectAssignmentForVoiding(gintEmployeeID, gdatTransactionDate);

                intNumberOfRecords = TheFindEmployeeProjectAssignmentForVoidingDataSet.FindEmployeeProjectAssignmentForVoiding.Rows.Count;

                for (intCounter = 0; intCounter < intNumberOfRecords; intCounter++)
                {
                    ProjectsForVoidingDataSet.projectsforvoidingRow NewProjectRow = TheProjectsForVoidingDataSet.projectsforvoiding.NewprojectsforvoidingRow();

                    NewProjectRow.AssignedProjectID       = TheFindEmployeeProjectAssignmentForVoidingDataSet.FindEmployeeProjectAssignmentForVoiding[intCounter].AssignedProjectID;
                    NewProjectRow.AssignmentTransactionID = TheFindEmployeeProjectAssignmentForVoidingDataSet.FindEmployeeProjectAssignmentForVoiding[intCounter].TransactionID;
                    NewProjectRow.CustomerProjectID       = TheFindEmployeeProjectAssignmentForVoidingDataSet.FindEmployeeProjectAssignmentForVoiding[intCounter].CustomerAssignedID;
                    NewProjectRow.Footage           = 0;
                    NewProjectRow.ProjectID         = TheFindEmployeeProjectAssignmentForVoidingDataSet.FindEmployeeProjectAssignmentForVoiding[intCounter].ProjectID;
                    NewProjectRow.TaskTransactionID = -1;
                    NewProjectRow.TotalHours        = TheFindEmployeeProjectAssignmentForVoidingDataSet.FindEmployeeProjectAssignmentForVoiding[intCounter].TotalHours;
                    NewProjectRow.WorkTask          = TheFindEmployeeProjectAssignmentForVoidingDataSet.FindEmployeeProjectAssignmentForVoiding[intCounter].WorkTask;
                    NewProjectRow.WorkTaskID        = TheFindEmployeeProjectAssignmentForVoidingDataSet.FindEmployeeProjectAssignmentForVoiding[intCounter].TaskID;

                    TheProjectsForVoidingDataSet.projectsforvoiding.Rows.Add(NewProjectRow);
                }

                TheFindProjectTaskForVoidingDataSet = TheProjectTaskClass.FindProjectTaskForVoiding(gintEmployeeID, gdatTransactionDate);

                intNumberOfRecords       = TheProjectsForVoidingDataSet.projectsforvoiding.Rows.Count;
                intSecondNumberOfRecords = TheFindProjectTaskForVoidingDataSet.FindProjectTaskForVoiding.Rows.Count;

                if (intNumberOfRecords > 0)
                {
                    for (intCounter = 0; intCounter < intNumberOfRecords; intCounter++)
                    {
                        intTaskID    = TheProjectsForVoidingDataSet.projectsforvoiding[intCounter].WorkTaskID;
                        intProjectID = TheProjectsForVoidingDataSet.projectsforvoiding[intCounter].ProjectID;

                        if (intSecondNumberOfRecords > 0)
                        {
                            for (intSecondCounter = 0; intSecondCounter < intSecondNumberOfRecords; intSecondCounter++)
                            {
                                if (intTaskID == TheFindProjectTaskForVoidingDataSet.FindProjectTaskForVoiding[intSecondCounter].WorkTaskID)
                                {
                                    if (intProjectID == TheFindProjectTaskForVoidingDataSet.FindProjectTaskForVoiding[intSecondCounter].ProjectID)
                                    {
                                        TheProjectsForVoidingDataSet.projectsforvoiding[intCounter].TaskTransactionID = TheFindProjectTaskForVoidingDataSet.FindProjectTaskForVoiding[intSecondCounter].TransactionID;
                                        TheProjectsForVoidingDataSet.projectsforvoiding[intCounter].Footage           = TheFindProjectTaskForVoidingDataSet.FindProjectTaskForVoiding[intSecondCounter].FootagePieces;
                                    }
                                }
                            }
                        }
                    }
                }

                dgrResults.ItemsSource = TheProjectsForVoidingDataSet.projectsforvoiding;
            }
            catch (Exception Ex)
            {
                TheEventLogClass.InsertEventLogEntry(DateTime.Now, "New Blue Jay Erp // Void Productivity Sheet // Find Transactions Expander " + Ex.Message);

                TheMessagesClass.ErrorMessage(Ex.ToString());
            }
        }