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