Ejemplo n.º 1
0
        public FindDuplicateEmployeePunchedHoursDataSet FindDuplicateEmployeePunchedHours(DateTime datTransactionDate)
        {
            try
            {
                aFindDuplicateEmployeePunchedHoursDataSet      = new FindDuplicateEmployeePunchedHoursDataSet();
                aFindDuplicateEmployeePunchedHoursTableAdpater = new FindDuplicateEmployeePunchedHoursDataSetTableAdapters.FindDuplicateEmployeePunchedHoursTableAdapter();
                aFindDuplicateEmployeePunchedHoursTableAdpater.Fill(aFindDuplicateEmployeePunchedHoursDataSet.FindDuplicateEmployeePunchedHours, datTransactionDate);
            }
            catch (Exception Ex)
            {
                TheEventLogClass.InsertEventLogEntry(DateTime.Now, "Employee Punched Hours Class // Find Duplicate Employee Punched Hours " + Ex.Message);
            }

            return(aFindDuplicateEmployeePunchedHoursDataSet);
        }
Ejemplo n.º 2
0
        private void btnFind_Click(object sender, RoutedEventArgs e)
        {
            int      intCounter;
            int      intNumberOfRecords;
            string   strValueForValidation;
            DateTime datTransactionDate = DateTime.Now;
            bool     blnFatalError      = false;
            int      intEmployeeID;
            int      intSecondCounter;
            int      intSecondNumberOfRecords;
            DateTime datSecondDate;
            string   strFirstName;
            string   strLastName;

            try
            {
                PleaseWait PleaseWait = new PleaseWait();
                PleaseWait.Show();

                TheDuplicateEmployeeDataSet.duplicateemployees.Rows.Clear();

                strValueForValidation = txtEnterPayPeriod.Text;
                blnFatalError         = TheDataValidationClass.VerifyDateData(strValueForValidation);
                if (blnFatalError == true)
                {
                    TheMessagesClass.ErrorMessage("The Date Entered is not a Date\n");
                    return;
                }
                else
                {
                    datTransactionDate = Convert.ToDateTime(strValueForValidation);
                }

                datSecondDate = TheDateSearchClass.AddingDays(datTransactionDate, 1);

                TheFindDuplicateEmployeePunchedHoursDataSet = TheEmployeePunchedHoursClass.FindDuplicateEmployeePunchedHours(datTransactionDate);

                intNumberOfRecords = TheFindDuplicateEmployeePunchedHoursDataSet.FindDuplicateEmployeePunchedHours.Rows.Count;

                if (intNumberOfRecords > 0)
                {
                    for (intCounter = 0; intCounter < intNumberOfRecords; intCounter++)
                    {
                        intEmployeeID = TheFindDuplicateEmployeePunchedHoursDataSet.FindDuplicateEmployeePunchedHours[intCounter].EmployeeID;
                        strFirstName  = TheFindDuplicateEmployeePunchedHoursDataSet.FindDuplicateEmployeePunchedHours[intCounter].FirstName;
                        strLastName   = TheFindDuplicateEmployeePunchedHoursDataSet.FindDuplicateEmployeePunchedHours[intCounter].LastName;

                        TheFindEmployeePunchedHoursDataSet = TheEmployeePunchedHoursClass.FindEmployeePunchedHours(intEmployeeID, datTransactionDate, datSecondDate);

                        intSecondNumberOfRecords = TheFindEmployeePunchedHoursDataSet.FindEmployeePunchedHours.Rows.Count;

                        for (intSecondCounter = 0; intSecondCounter < intSecondNumberOfRecords; intSecondCounter++)
                        {
                            DuplicateEmployeeDataSet.duplicateemployeesRow NewEmployeeRow = TheDuplicateEmployeeDataSet.duplicateemployees.NewduplicateemployeesRow();

                            NewEmployeeRow.EmployeeID    = intEmployeeID;
                            NewEmployeeRow.FirstName     = strFirstName;
                            NewEmployeeRow.LastName      = strLastName;
                            NewEmployeeRow.PunchedHours  = TheFindEmployeePunchedHoursDataSet.FindEmployeePunchedHours[intSecondCounter].PunchedHours;
                            NewEmployeeRow.TransactionID = TheFindEmployeePunchedHoursDataSet.FindEmployeePunchedHours[intSecondCounter].TransactionID;
                            NewEmployeeRow.Remove        = false;

                            TheDuplicateEmployeeDataSet.duplicateemployees.Rows.Add(NewEmployeeRow);
                        }
                    }
                }

                dgrEmployees.ItemsSource = TheDuplicateEmployeeDataSet.duplicateemployees;

                PleaseWait.Close();
            }
            catch (Exception Ex)
            {
                TheEventLogClass.InsertEventLogEntry(DateTime.Now, "New Blue Jay ERP // Employee Double Hours // Find Button " + Ex.Message);

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