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