Ejemplo n.º 1
0
        public FindDriveTimeForVoidingDataSet FindDriveTimeForVoiding(DateTime datTransactionDate, int intEmployeeID, int intProjectID)
        {
            try
            {
                aFindDriveTimeForVoidingDataSet      = new FindDriveTimeForVoidingDataSet();
                aFindDriveTimeForVoidingTableAdapter = new FindDriveTimeForVoidingDataSetTableAdapters.FindDriveTimeForVoidingTableAdapter();
                aFindDriveTimeForVoidingTableAdapter.Fill(aFindDriveTimeForVoidingDataSet.FindDriveTimeForVoiding, datTransactionDate, intEmployeeID, intProjectID);
            }
            catch (Exception Ex)
            {
                TheEventLogClass.InsertEventLogEntry(DateTime.Now, "Employee Project Assignment Class // Find Drive Time For Voiding " + Ex.Message);
            }

            return(aFindDriveTimeForVoidingDataSet);
        }
Ejemplo n.º 2
0
        private void expFindItems_Expanded(object sender, RoutedEventArgs e)
        {
            bool     blnThereIsAProblem = false;
            bool     blnFatalError      = false;
            string   strErrorMessage    = "";
            string   strValueForValidation;
            string   strProjectID;
            DateTime datTransactionDate = DateTime.Now;
            int      intRecordsReturned;
            int      intProjectID = 0;
            int      intCounter;
            int      intNumberForRecords;

            try
            {
                expFindItems.IsExpanded = false;

                TheDriveTimeForVoidingDataSet.drivetimeforvoiding.Rows.Clear();

                if (cboSelectEmployee.SelectedIndex < 1)
                {
                    blnFatalError    = true;
                    strErrorMessage += "The Employee Has Not Been Selected\n";
                }
                strProjectID = txtProjectID.Text;
                if (strProjectID.Length < 4)
                {
                    blnFatalError    = true;
                    strErrorMessage += "The Project ID Is Not Long Enough\n";
                }
                else
                {
                    TheFindProjectMatrixByCustomerProjectIDDataSet = TheProjectMatrixClass.FindProjectMatrixByCustomerProjectID(strProjectID);

                    intRecordsReturned = TheFindProjectMatrixByCustomerProjectIDDataSet.FindProjectMatrixByCustomerProjectID.Rows.Count;

                    if (intRecordsReturned > 0)
                    {
                        intProjectID = TheFindProjectMatrixByCustomerProjectIDDataSet.FindProjectMatrixByCustomerProjectID[0].ProjectID;
                    }
                    else if (intRecordsReturned < 1)
                    {
                        TheFindProjectMatrixByAssignedProjectIDDataSet = TheProjectMatrixClass.FindProjectMatrixByAssignedProjectID(strProjectID);

                        intRecordsReturned = TheFindProjectMatrixByAssignedProjectIDDataSet.FindProjectMatrixByAssignedProjectID.Rows.Count;

                        if (intRecordsReturned > 0)
                        {
                            intProjectID = TheFindProjectMatrixByAssignedProjectIDDataSet.FindProjectMatrixByAssignedProjectID[0].ProjectID;
                        }
                        else if (intRecordsReturned < 1)
                        {
                            strErrorMessage += "The Project Was Not Found\n";
                        }
                    }
                }
                strValueForValidation = txtDate.Text;
                blnThereIsAProblem    = TheDataValidationClass.VerifyDateData(strValueForValidation);
                if (blnThereIsAProblem == true)
                {
                    blnFatalError    = true;
                    strErrorMessage += "The Date Entered is not a Date\n";
                }
                else
                {
                    datTransactionDate = Convert.ToDateTime(strValueForValidation);
                }
                if (blnFatalError == true)
                {
                    TheMessagesClass.ErrorMessage(strErrorMessage);
                    return;
                }

                TheFindDriveTimeForVoidingDataSet = TheEmployeeProjectAssignmentClass.FindDriveTimeForVoiding(datTransactionDate, MainWindow.gintEmployeeID, intProjectID);

                intNumberForRecords = TheFindDriveTimeForVoidingDataSet.FindDriveTimeForVoiding.Rows.Count;

                if (intNumberForRecords > 0)
                {
                    for (intCounter = 0; intCounter < intNumberForRecords; intCounter++)
                    {
                        DriveTimeForVoidingDataSet.drivetimeforvoidingRow NewDriveTime = TheDriveTimeForVoidingDataSet.drivetimeforvoiding.NewdrivetimeforvoidingRow();

                        NewDriveTime.FirstName        = TheFindDriveTimeForVoidingDataSet.FindDriveTimeForVoiding[intCounter].FirstName;
                        NewDriveTime.LastName         = TheFindDriveTimeForVoidingDataSet.FindDriveTimeForVoiding[intCounter].LastName;
                        NewDriveTime.ProjectID        = TheFindDriveTimeForVoidingDataSet.FindDriveTimeForVoiding[intCounter].CustomerAssignedID;
                        NewDriveTime.TransactionDate  = TheFindDriveTimeForVoidingDataSet.FindDriveTimeForVoiding[intCounter].TransactionDate;
                        NewDriveTime.TransactionID    = TheFindDriveTimeForVoidingDataSet.FindDriveTimeForVoiding[intCounter].TransactionID;
                        NewDriveTime.VoidTransactions = false;
                        NewDriveTime.WorkTask         = TheFindDriveTimeForVoidingDataSet.FindDriveTimeForVoiding[intCounter].WorkTask;

                        TheDriveTimeForVoidingDataSet.drivetimeforvoiding.Rows.Add(NewDriveTime);
                    }
                }

                dgrResults.ItemsSource = TheDriveTimeForVoidingDataSet.drivetimeforvoiding;
            }
            catch (Exception Ex)
            {
                TheEventLogClass.InsertEventLogEntry(DateTime.Now, "New Blue Jay ERP // Void Drive Time // Find Items Expander " + Ex.Message);

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