public UserDetailsDTO CheckLoginDetails(String username, String securedPassword) {

    logger.info("Entered CheckLoginDetails method of UserLoginDAO");
    ResultSet results = null;
    UserDetailsDTO user = new UserDetailsDTO();
    try {

      conn = ConnectionFactory.getConnection();
      conn.setAutoCommit(false);
      String query =
          "SELECT USER_ID,FULL_NAME FROM userdetails WHERE EMAIL = ? AND PASSWORD = ? AND ISACTIVE=?";
      PreparedStatement pstmt = conn.prepareStatement(query);
      pstmt.setString(1, username);
      pstmt.setString(2, securedPassword);
      pstmt.setBoolean(3, true);
      results = pstmt.executeQuery();
      if (results.first()) {
        user.setUserId(results.getInt("USER_ID"));
        user.setFullName(results.getString("FULL_NAME"));
        conn.commit();
      }
      logger.info("Exit CheckLoginDetails method of UserLoginDAO");
    } catch (Exception e) {
      try {
        conn.rollback();
      } catch (SQLException e1) {
        try {
          conn.rollback();
        } catch (SQLException e2) {
          logger.error("CheckLoginDetails method of UserLoginDAO threw error:" + e.getMessage());
          e2.printStackTrace();
        }
        logger.error("CheckLoginDetails method of UserLoginDAO threw error:" + e.getMessage());
        e1.printStackTrace();
      }
      logger.error("CheckLoginDetails method of UserLoginDAO threw error:" + e.getMessage());
      e.printStackTrace();
    } finally {
      try {
        conn.close();
      } catch (SQLException e) {
        logger.error("CheckLoginDetails method of UserLoginDAO threw error:" + e.getMessage());
        e.printStackTrace();
      }
    }
    return user;
  }
Ejemplo n.º 2
0
 /** @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response) */
 protected void doPost(HttpServletRequest request, HttpServletResponse response)
     throws ServletException, IOException {
   String email = request.getParameter("email");
   UserDetailsDTO userDetails = new UserDetailsDTO();
   int userId = 0;
   if (email != null) {
     AdminUserDAO user = new AdminUserDAO();
     userDetails = user.GetUserDetails(email);
     userId = userDetails.getUserId();
     if (userId != 0) {
       request.setAttribute("uId", userId);
       RequestDispatcher rd =
           getServletContext().getRequestDispatcher("/Deactivate_Delete_User.jsp");
       rd.forward(request, response);
     } else {
       Boolean isInvalid = true;
       request.setAttribute("isInvalidEmail", isInvalid);
       RequestDispatcher rd =
           getServletContext().getRequestDispatcher("/Deactivate_User_Email.jsp");
       rd.forward(request, response);
     }
   }
 }
  /** @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse response) */
  protected void doGet(HttpServletRequest request, HttpServletResponse response)
      throws ServletException, IOException {

    logger.info("Entered doGet method of AdvisorMyAccountPreviousSessionViewDetailController");

    logger.info("Entered doGet method of AdvisorMyAccountPreviousSessionViewDetailController");
    int advisorId = 0;
    String username = "";
    int userId = 0;
    String rId = "";
    String advisorName = "";
    String picture = "";
    String relImage = "";
    String userName = "";
    String mode = "";
    int sId = 0;
    FeedbackDTO feeds = new FeedbackDTO();
    Boolean isFeedback = false;
    Timestamp acceptedDate = null;
    try {
      advisorId = (int) request.getSession().getAttribute("advisorId");
      username = (String) request.getSession().getAttribute("username");
      rId = (String) request.getParameter("rId");

    } catch (Exception e) {
      response.sendRedirect("Error");
    }
    List<SessionDTO> list = new ArrayList<SessionDTO>();
    if (username != null && advisorId != 0 && !("").equals(username)) {
      List<UserDetailsDTO> list2 = new ArrayList<UserDetailsDTO>();
      List<UserRequestDTO> list1 = new ArrayList<UserRequestDTO>();
      List<AdvisorProfileDTO> list3 = new ArrayList<AdvisorProfileDTO>();

      // Getting the session details
      AdvisorMyAccountSessionDAO session = new AdvisorMyAccountSessionDAO();
      list = session.getSessionDetails(rId);
      for (SessionDTO SessionDTO : list) {
        sId = SessionDTO.getSessionId();
        userId = SessionDTO.getUserId();
        acceptedDate = SessionDTO.getAcceptedDate();
        SessionDTO.setAcceptedDateString(
            new SimpleDateFormat("dd-MMM-yyyy' 'h:mm a")
                .format(new Date(SessionDTO.getAcceptedDate().getTime())));
      }

      MyAccountRequestDAO name = new MyAccountRequestDAO();
      list3 = name.getAdvisorName(advisorId);
      for (AdvisorProfileDTO advisorProfileDTO : list3) {
        advisorName = advisorProfileDTO.getName();
      }
      MyAccountRequestDAO image = new MyAccountRequestDAO();
      list2 = image.getUserImage(userId);
      for (UserDetailsDTO userDetailsDTO : list2) {
        userName = userDetailsDTO.getFullName();
        picture = userDetailsDTO.getImage();
      }
      if (!("").equals(picture)) {
        GetRelativeImageURL image1 = new GetRelativeImageURL();
        relImage = image1.getImageURL(picture);
      }
      List<TimeDTO> difference = new ArrayList<TimeDTO>();
      // After retrieving the user details, get the user request details
      MyAccountRequestDAO dao = new MyAccountRequestDAO();
      list1 = dao.getUserRequestDetails(rId);
      GetTimeLeftForReply time = new GetTimeLeftForReply();
      difference = time.getTimeLeftForSession(acceptedDate);
      for (UserRequestDTO userRequestDTO : list1) {
        mode = userRequestDTO.getMode();
        if (userRequestDTO.getService().equals("cvcritique")
            || userRequestDTO.getService().equals("mockinterview")) {
          isFeedback = true;
        }
        if (difference.size() > 0) {
          for (TimeDTO timeDTO : difference) {
            userRequestDTO.setDays(timeDTO.getDay());
            userRequestDTO.setHours(timeDTO.getHours());
            userRequestDTO.setMinutes(timeDTO.getMinutes());
          }
        } else {
          userRequestDTO.setDays(0);
          userRequestDTO.setHours(0);
          userRequestDTO.setMinutes(0);
        }
      }
      String sessionDate = "";
      String date = "";
      String time1 = "";
      if (acceptedDate != null) {
        sessionDate = acceptedDate.toString();
        Timestamp timestamp = new Timestamp(acceptedDate.getTime());
        SimpleDateFormat simpleDateFormat = new SimpleDateFormat("dd-MMM-yyyy");
        SimpleDateFormat simpleDateFormat1 = new SimpleDateFormat("h:mm a");
        date = simpleDateFormat.format(timestamp);
        if (mode.equals("email")) {
          time1 = "N/A";
        } else {
          time1 = simpleDateFormat1.format(timestamp);
        }
      } else {
        date = "NOT FIXED";
        time1 = "NOT FIXED";
      }
      // Check if the user has given any feedback
      SessionFeedBackDTO feedUser = new SessionFeedBackDTO();
      SessionFeedBackDTO feedAdvisor = new SessionFeedBackDTO();
      // Check if the user has given any feedback
      SessionFeedBackDAO feedback = new SessionFeedBackDAO();
      feedUser = feedback.GetUserFeedBackDetailsForUser(sId);
      SessionFeedBackDAO feedbackAdvisor = new SessionFeedBackDAO();
      feedAdvisor = feedbackAdvisor.GetAdvisorFeedbackDetailsForAdvisor(sId);
      if (isFeedback) {
        // Getting the FeedBack Form Path
        MyAccountRequestDAO form = new MyAccountRequestDAO();
        feeds = form.GetFeedbackPath(sId);
      }
      // Check if the user has sent any mail
      SessionFeedBackDTO emailUser = new SessionFeedBackDTO();
      SessionFeedBackDTO emailAdvisor = new SessionFeedBackDTO();
      SessionFeedBackDAO mail = new SessionFeedBackDAO();
      emailUser = mail.GetUserMailForAdvisor(sId);
      SessionFeedBackDAO mailAdvisor = new SessionFeedBackDAO();
      emailAdvisor = mailAdvisor.GetAdvisorMailForAdvisor(sId);

      // Update Advisor's Notification
      String url = request.getRequestURI() + "?" + request.getQueryString();
      url = url.substring(url.lastIndexOf('/') + 1);
      AdvisorNotificationDAO admin = new AdvisorNotificationDAO();
      admin.SetNotificationRead(url, advisorId);

      if (list.size() > 0 && list1.size() > 0 && list2.size() > 0) {
        request.setAttribute("advisorname", advisorName);
        request.setAttribute("userName", userName);
        request.setAttribute("image", relImage);
        request.setAttribute("sessions", list);
        request.setAttribute("time", time1);
        request.setAttribute("date", date);
        request.setAttribute("feedUser", feedUser);
        request.setAttribute("feedAdvisor", feedAdvisor);
        request.setAttribute("emailUser", emailUser);
        request.setAttribute("emailAdvisor", emailAdvisor);
        request.setAttribute("isFromPreviousSession", true);
        request.setAttribute("requests", list1);
        request.setAttribute("userdetails", list2);
        request.setAttribute("sessionDate", sessionDate);
        request.setAttribute("feed", feeds);
        RequestDispatcher rd = getServletContext().getRequestDispatcher("/Session_ViewDetails.jsp");
        rd.forward(request, response);
      }
    }
    logger.info("Exit doGet method of AdvisorMyAccountPreviousSessionViewDetailController");
  }