@RequestMapping(value = "/UserModifiedSuccessfully", method = RequestMethod.POST)
public ModelAndView post(
@RequestParam("modUseradd1") String textAddress1,
@RequestParam("modUseradd2") String textAddress2,
@RequestParam("modUsercity") String city,
@RequestParam("modUserstate") String state,
@RequestParam("modUserzipcode") String zipCode,
@RequestParam("modUserphone") String phoneNumber,
@RequestParam("modUsercell") String cellNumber,
@RequestParam("modUseremail") String email,
@RequestParam("modUserdept") String dept,
@RequestParam("designation") String designation,
HttpSession sessionID)
throws SQLException {
String modUser = (String) sessionID.getAttribute("modUser");
/*if(userName == null)
{
return new ModelAndView("index");
}*/
InternalUserDAO internalUserDAO1 = new InternalUserDAO();
InternalUser internalUser = internalUserDAO1.findInternalUser(modUser);
internalUser.setAddress1(textAddress1);
internalUser.setAddress2(textAddress2);
internalUser.setCity(city);
internalUser.setState(state);
internalUser.setZipcode(zipCode);
internalUser.setPhoneNumber(phoneNumber);
internalUser.setCellNumber(cellNumber);
internalUser.setEmail(email);
internalUser.setDepartment(dept);
internalUser.setUserName(modUser);
internalUser.setDesignation(designation);
internalUserDAO1.persist(internalUser);
String modifiedUserName = internalUser.getFirstName() + internalUser.getLastName();
InternalUserTransactionDAO internalUserTransactionDAO = new InternalUserTransactionDAO();
String operation = "Modified";
InternalUserTransaction newTransaction =
new InternalUserTransaction(
(String) sessionID.getAttribute("userName"),
operation,
internalUser.getFirstName(),
internalUser.getLastName());
internalUserTransactionDAO.persist(newTransaction);
return new ModelAndView("UserModifiedSuccessfully", "message", modifiedUserName);
}
/*
* To display the list of subordinates to delete and modify under a manager.
*/
@RequestMapping(value = "/modifyDeleteInternalUser", method = RequestMethod.GET)
public ModelAndView get(HttpSession sessionID) throws Exception {
// check for correct permissions.
String userName = (String) sessionID.getAttribute("userName");
InternalUserDAO internalUserDAO = new InternalUserDAO();
InternalUser loggedInUser = internalUserDAO.findInternalUser(userName);
if (loggedInUser.getDesignation().equalsIgnoreCase("employee")
|| loggedInUser.getDesignation().equalsIgnoreCase("sysadmin")) {
return new ModelAndView("NotAuthorizedModDel", "message", null);
}
String departmentOfLoggedInUser = loggedInUser.getDepartment();
List<InternalUser> allSubordinates =
internalUserDAO.findSubordinates(departmentOfLoggedInUser, userName);
return new ModelAndView("ModifyDeleteSubordinates", "message", allSubordinates);
}
@RequestMapping(value = "/ModifySubordinate", method = RequestMethod.POST)
public ModelAndView post(@RequestParam("modUserame") String user, HttpSession sessionID)
throws SQLException {
String userName = user;
InternalUserDAO internalUserDAO = new InternalUserDAO();
InternalUser selectedUser = internalUserDAO.findInternalUser(userName);
sessionID.setAttribute("modUser", user);
// Sid - Fetch column values which can be updated by the user
String city = selectedUser.getCity();
String state = selectedUser.getState();
String zipcode = selectedUser.getZipcode();
String phoneNo = selectedUser.getPhoneNumber();
String email = selectedUser.getEmail();
String cellNo = selectedUser.getCellNumber();
String department = selectedUser.getDepartment();
String designation = selectedUser.getDesignation();
String address = selectedUser.getAddress1();
String address2 = selectedUser.getAddress2();
ModelMap editmodel = new ModelMap();
editmodel.addAttribute("city", city);
editmodel.addAttribute("state", state);
editmodel.addAttribute("zipcode", zipcode);
editmodel.addAttribute("phoneNo", phoneNo);
editmodel.addAttribute("email", email);
editmodel.addAttribute("cell", cellNo);
editmodel.addAttribute("addr1", address);
editmodel.addAttribute("addr2", address2);
editmodel.addAttribute("dept", department);
editmodel.addAttribute("designation", designation);
return new ModelAndView("ModifySubordinate", editmodel);
}
@RequestMapping(value = "/DeleteSubordinate", method = RequestMethod.POST)
public ModelAndView deleteSubordinates(
@RequestParam("delUserame") String userToBeDeletedUserName, HttpSession sessionID)
throws SQLException {
InternalUserDAO internalUserDAO = new InternalUserDAO();
InternalUser userToBeDeleted = internalUserDAO.findInternalUser(userToBeDeletedUserName);
if (userToBeDeleted.getFirstDelete() == 1) {
internalUserDAO.delete(userToBeDeleted);
InternalUserTransactionDAO internalUserTransactionDAO = new InternalUserTransactionDAO();
// Added a transaction to the Internal User Transaction Table.
String operation = "Deleted";
InternalUserTransaction newTransaction =
new InternalUserTransaction(
(String) sessionID.getAttribute("userName"),
operation,
userToBeDeleted.getFirstName(),
userToBeDeleted.getLastName());
internalUserTransactionDAO.persist(newTransaction);
// delete from ToDo Table also.
ToDoDAO toDoDAO = new ToDoDAO();
toDoDAO.delete(
toDoDAO.findAParticularToDo(
(String) sessionID.getAttribute("userName"),
userToBeDeleted.getUserName(),
"Delete"));
return new ModelAndView(
"DeleteSubordinate", "message", "The Employee has been deleted from the Records");
} else {
userToBeDeleted.setFirstDelete(1);
internalUserDAO.persist(userToBeDeleted);
// String manager = userToBeDeleted.getManager();
InternalUser loggedInUser =
internalUserDAO.findInternalUser((String) sessionID.getAttribute("userName"));
String manager = loggedInUser.getManager();
if (loggedInUser.getDesignation().equalsIgnoreCase("corporate")) {
// corporrate people have authority to directly delete a employee
internalUserDAO.delete(userToBeDeleted);
// Added a transaction to the Internal User Transaction Table.
InternalUserTransactionDAO internalUserTransactionDAO = new InternalUserTransactionDAO();
String operation = "Deleted";
InternalUserTransaction newTransaction =
new InternalUserTransaction(
(String) sessionID.getAttribute("userName"),
operation,
userToBeDeleted.getFirstName(),
userToBeDeleted.getLastName());
internalUserTransactionDAO.persist(newTransaction);
return new ModelAndView(
"DeleteSubordinate", "message", "The Employee has been deleted from the Records");
} else {
// Have to Finalize based on what Manager Name is given.Right Now its on First Name basis
/*String firstName = manager.substring(0, manager.indexOf(" "));
String lastName = manager.substring(manager.indexOf(" "));*/
InternalUser userNameManager =
internalUserDAO.findInternalUserByName(manager /*, lastName*/);
String actioneer = userNameManager.getUserName();
ToDo newEntry =
new ToDo(
actioneer,
userToBeDeletedUserName,
0,
"Delete",
"Requesting second Authorization for Deletion");
ToDoDAO toDoDAO = new ToDoDAO();
toDoDAO.persist(newEntry);
return new ModelAndView(
"DeleteSubordinate",
"message",
"Notification has been send to Manager for approval for deletion");
}
}
}