public FindEmployeeOverNightWorkByManagerIDDataSet FindEmployeeOverNightWorkByManagerID(int intManagerID, DateTime datStartDate, DateTime datEndDate) { try { aFindEmployeeOverNightWorkByManagerIDDataSet = new FindEmployeeOverNightWorkByManagerIDDataSet(); aFindEmployeeOverNightWorkByManagerIDTableAdapter = new FindEmployeeOverNightWorkByManagerIDDataSetTableAdapters.FindEmployeeOverNightWorkByManagerIDTableAdapter(); aFindEmployeeOverNightWorkByManagerIDTableAdapter.Fill(aFindEmployeeOverNightWorkByManagerIDDataSet.FindEmployeeOverNightWorkByManagerID, intManagerID, datStartDate, datEndDate); } catch (Exception Ex) { TheEventLogClass.InsertEventLogEntry(DateTime.Now, "After Hours Work Class // Find Employee Over Night Work By Manager ID " + Ex.Message); } return(aFindEmployeeOverNightWorkByManagerIDDataSet); }
private void expSubmitForm_Expanded(object sender, RoutedEventArgs e) { int intCounter; int intNumberOfRecords; int intManagerID; int intWarehouseID; int intDepartmentID; int intEmployeeID; int intProjectID; int intVehicleID; DateTime datWorkDate = DateTime.Now; string strOutTime; string strWorkLocation; string strInETA; bool blnFatalError = false; DateTime datStartDate = DateTime.Now; DateTime datLimitingDate = DateTime.Now; DateTime datEndDate; try { expSubmitForm.IsExpanded = false; intNumberOfRecords = TheSubmitAfterHoursWorkDataSet.submitafterhourswork.Rows.Count; for (intCounter = 0; intCounter < intNumberOfRecords; intCounter++) { intManagerID = TheSubmitAfterHoursWorkDataSet.submitafterhourswork[intCounter].ManagerID; intWarehouseID = TheSubmitAfterHoursWorkDataSet.submitafterhourswork[intCounter].WarehouseID; intDepartmentID = TheSubmitAfterHoursWorkDataSet.submitafterhourswork[intCounter].DepartmentID; intEmployeeID = TheSubmitAfterHoursWorkDataSet.submitafterhourswork[intCounter].EmployeeID; intProjectID = TheSubmitAfterHoursWorkDataSet.submitafterhourswork[intCounter].ProjectID; intVehicleID = TheSubmitAfterHoursWorkDataSet.submitafterhourswork[intCounter].VehicleID; datWorkDate = TheSubmitAfterHoursWorkDataSet.submitafterhourswork[intCounter].WorkDate; strOutTime = TheSubmitAfterHoursWorkDataSet.submitafterhourswork[intCounter].OutTime; strWorkLocation = TheSubmitAfterHoursWorkDataSet.submitafterhourswork[intCounter].WorkLocation; strInETA = TheSubmitAfterHoursWorkDataSet.submitafterhourswork[intCounter].InETA; if (datWorkDate > datLimitingDate) { datLimitingDate = datWorkDate; } blnFatalError = TheAfterHoursClass.InsertEmployeeOverNightWork(intWarehouseID, intDepartmentID, intEmployeeID, intManagerID, intVehicleID, intProjectID, datWorkDate, strOutTime, strWorkLocation, strInETA, DateTime.Now); if (blnFatalError == true) { throw new Exception(); } } datStartDate = TheDateSearchClass.RemoveTime(datStartDate); datEndDate = TheDateSearchClass.AddingDays(datLimitingDate, 1); intManagerID = MainWindow.TheVerifyLogonDataSet.VerifyLogon[0].EmployeeID; TheFindEmployeeOverNightWorkByManagerIDDataSet = TheAfterHoursClass.FindEmployeeOverNightWorkByManagerID(intManagerID, datStartDate, datEndDate); CreateMessage(); TheMessagesClass.InformationMessage("The Report has been Sent\n"); ResetControls(); TheSubmitAfterHoursWorkDataSet.submitafterhourswork.Rows.Clear(); TheEmployeeAssignedDataSet.employeesassigned.Rows.Clear(); } catch (Exception Ex) { TheEventLogClass.InsertEventLogEntry(DateTime.Now, "New Blue Jay ERP // Submit After Hours Work // Submit Form Expander " + Ex.Message); TheMessagesClass.ErrorMessage(Ex.ToString()); } }