public FindEmployeePunchedHoursForValidationDataSet FindEmployeePunchedHoursForValidation(DateTime datTransactionDate, int intEmployeeID, int intPayID) { try { aFindEmployeePunchedHoursForValidationDataSet = new FindEmployeePunchedHoursForValidationDataSet(); aFindEmployeePunchedHoursForValidationTableAdapter = new FindEmployeePunchedHoursForValidationDataSetTableAdapters.FindEmployeePunchedHoursForValidationTableAdapter(); aFindEmployeePunchedHoursForValidationTableAdapter.Fill(aFindEmployeePunchedHoursForValidationDataSet.FindEmployeePunchedHoursForValidation, datTransactionDate, intEmployeeID, intPayID); } catch (Exception Ex) { TheEventLogClass.InsertEventLogEntry(DateTime.Now, "Employee Punched Hours Class // Find Employee Punched Hours For Validation " + Ex.Message); } return(aFindEmployeePunchedHoursForValidationDataSet); }
private void expInsertRecords_Expanded(object sender, RoutedEventArgs e) { int intCounter; int intNumberOfRecords; int intEmployeeID; int intPayID;; DateTime datStartDate; DateTime datEndDate; DateTime datPayDate; decimal decDailyHours;; decimal decTotalHours; bool blnFatalError = false; int intRecordsReturned; try { expInsertRecords.IsExpanded = false; PleaseWait PleaseWait = new PleaseWait(); PleaseWait.Show(); intNumberOfRecords = TheCalculatedHoursDataSet.calculatedhours.Rows.Count; for (intCounter = 0; intCounter < intNumberOfRecords; intCounter++) { intEmployeeID = TheCalculatedHoursDataSet.calculatedhours[intCounter].EmployeeID; datStartDate = TheCalculatedHoursDataSet.calculatedhours[intCounter].StartTime; datEndDate = TheCalculatedHoursDataSet.calculatedhours[intCounter].EndTime; decDailyHours = TheCalculatedHoursDataSet.calculatedhours[intCounter].DailyHours; TheFindAholaEmployeePunchForVerificationDataSet = TheEmployeePunchedHoursClass.FindAholaEmployeePunchForVerification(intEmployeeID, datStartDate, datEndDate, decDailyHours); intRecordsReturned = TheFindAholaEmployeePunchForVerificationDataSet.FindAholaEmployeePunchForVerification.Rows.Count; if (intRecordsReturned < 1) { blnFatalError = TheEmployeePunchedHoursClass.InsertIntoAholaEmployeePunch(intEmployeeID, datStartDate, datEndDate, decDailyHours); if (blnFatalError == true) { throw new Exception(); } } } intNumberOfRecords = TheEmployeeHoursDataSet.employeehours.Rows.Count; for (intCounter = 0; intCounter < intNumberOfRecords; intCounter++) { intEmployeeID = TheEmployeeHoursDataSet.employeehours[intCounter].EmployeeID; intPayID = TheEmployeeHoursDataSet.employeehours[intCounter].PayID; datPayDate = TheEmployeeHoursDataSet.employeehours[intCounter].TransactionDate; decTotalHours = TheEmployeeHoursDataSet.employeehours[intCounter].PunchedHours; TheFindEmployeePunchedHoursForValidationDataSet = TheEmployeePunchedHoursClass.FindEmployeePunchedHoursForValidation(datPayDate, intEmployeeID, intEmployeeID); intRecordsReturned = TheFindEmployeePunchedHoursForValidationDataSet.FindEmployeePunchedHoursForValidation.Rows.Count; if (intRecordsReturned < 1) { blnFatalError = TheEmployeePunchedHoursClass.InsertEmployeePunchedHours(datPayDate, intEmployeeID, intPayID, decTotalHours); if (blnFatalError == true) { throw new Exception(); } } } PleaseWait.Close(); TheMessagesClass.InformationMessage("All Records Have Been Inserted"); ResetControls(); } catch (Exception Ex) { TheSendEmailClass.SendEventLog("New Blue Jay ERP // Import Employee Punches // Insert Records " + Ex.ToString()); TheEventLogClass.InsertEventLogEntry(DateTime.Now, "New Blue Jay ERP // Import Employee Punches // Insert Records " + Ex.Message); TheMessagesClass.ErrorMessage(Ex.ToString()); } }