@RequestMapping("/edit_customer")
public ModelAndView edit_customer(HttpServletRequest request) {
int ID = Integer.parseInt(request.getParameter("userID"));
ApplicationContext context = new ClassPathXmlApplicationContext("Spring-Module.xml");
Map<String, String> user = new HashMap<String, String>();
CustomerDAO customerDAO = (CustomerDAO) context.getBean("customerDAO");
user = customerDAO.findCurrentCustomerById(ID);
IndustryDAO industryDAO = (IndustryDAO) context.getBean("industryDAO");
List<Industry> industries = new ArrayList<Industry>();
industries = industryDAO.getIndustriesList();
ModelAndView model = new ModelAndView("edit_customer");
model.addObject("userData", user);
model.addObject("industryList", industries);
/**
* <c:forEach items="${countries}" var="country"> <option
* value="${country.key}">${country.value}</option> </c:forEach>
*/
return model;
}
@Scope("session")
@RequestMapping(value = "/search_list", method = RequestMethod.GET)
public ModelAndView searchList(HttpServletRequest request) {
ModelAndView model = new ModelAndView("searchList");
try {
String industry = request.getParameter("industry").toString();
ApplicationContext context = new ClassPathXmlApplicationContext("Spring-Module.xml");
CustomerDAO customerDAO = (CustomerDAO) context.getBean("customerDAO");
Map<Integer, HashMap<String, String>> ResultMap =
new HashMap<Integer, HashMap<String, String>>();
ResultMap =
customerDAO.SQLquery(
"SELECT companies.*, NameIndustry FROM companies LEFT JOIN industry"
+ " ON companies.Industry = industry.ID WHERE companies.Industry = "
+ industry);
model.addObject("ResultMap", ResultMap);
} catch (Throwable q) {
return model;
}
return model;
}
@Scope("session")
@RequestMapping(
value = {"/search"},
method = RequestMethod.GET)
public String dashboard(
Locale locale, Model model, HttpServletRequest request, HttpSession httpSession) {
try {
ApplicationContext context = new ClassPathXmlApplicationContext("Spring-Module.xml");
CustomerDAO customerDAO = (CustomerDAO) context.getBean("customerDAO");
Map<Integer, HashMap<String, String>> ResultMap =
new HashMap<Integer, HashMap<String, String>>();
ResultMap =
customerDAO.SQLquery(
"SELECT companies.*, NameIndustry FROM companies LEFT JOIN industry"
+ " ON companies.Industry = industry.ID ");
System.out.println(ResultMap);
Map<Integer, HashMap<String, String>> ResultIndustry =
new HashMap<Integer, HashMap<String, String>>();
ResultIndustry = customerDAO.SQLquery("SELECT * FROM industry");
model.addAttribute("ResultMap", ResultMap);
model.addAttribute("ResultIndustry", ResultIndustry);
return "search";
} catch (Throwable t) {
System.out.println(t);
return "search";
}
}
@Scope("session")
@RequestMapping(value = "/unjoin_company", method = RequestMethod.GET)
public String unjoinCustomer(Locale locale, Model model, HttpServletRequest request) {
try {
ApplicationContext context = new ClassPathXmlApplicationContext("Spring-Module.xml");
CustomerDAO customerDAO = (CustomerDAO) context.getBean("customerDAO");
int ID = Integer.parseInt(request.getParameter("id"));
/*String name = request.getParameter("name").toString();
int age = Integer.parseInt(request.getParameter("age"));
Customer user = new Customer(ID, name, age);*/
String sql = "UPDATE customer SET Assigned = \"\" WHERE CUST_ID = " + ID;
customerDAO.unjoinCustomer(sql);
ID = Integer.parseInt(request.getParameter("companyID"));
sql = "UPDATE companies SET Count = Count + 1 WHERE ID = " + ID;
customerDAO.unjoinCustomer(sql);
} catch (Throwable q) {
}
return "redirect:/companies";
}
@Scope("session")
@RequestMapping(value = "/add_customer", method = RequestMethod.POST)
public String addCustomer(Locale locale, Model model, HttpServletRequest request) {
try {
/**/
ApplicationContext context = new ClassPathXmlApplicationContext("Spring-Module.xml");
CustomerDAO customerDAO = (CustomerDAO) context.getBean("customerDAO");
int ID = 0;
String name = request.getParameter("name").toString();
int age = Integer.parseInt(request.getParameter("age"));
String industry = request.getParameter("industry").toString();
String LastName = request.getParameter("LastName").toString();
String Gender = request.getParameter("Gender").toString();
String Phone = request.getParameter("Phone").toString();
String Email = request.getParameter("Email").toString();
String Country = request.getParameter("Country").toString();
String City = request.getParameter("City").toString();
String Experience = request.getParameter("Experience").toString();
String Education = request.getParameter("Education").toString();
HashMap<String, String> HashMap = new HashMap<String, String>();
HashMap.put("ID", Integer.toString(ID));
HashMap.put("Name", name);
HashMap.put("Age", Integer.toString(age));
HashMap.put("Industry", industry);
HashMap.put("LastName", LastName);
HashMap.put("Gender", Gender);
HashMap.put("Phone", Phone);
HashMap.put("Email", Email);
HashMap.put("Country", Country);
HashMap.put("City", City);
HashMap.put("Experience", Experience);
HashMap.put("Education", Education);
customerDAO.insert(HashMap);
} catch (Throwable q) {
}
return "redirect:/humans";
}
@RequestMapping("/list")
public ModelAndView home(HttpServletRequest request) {
int page = Integer.parseInt(request.getParameter("page"));
System.out.println(page);
ApplicationContext context = new ClassPathXmlApplicationContext("Spring-Module.xml");
CustomerDAO customerDAO = (CustomerDAO) context.getBean("customerDAO");
List<Customer> customerList = new ArrayList<Customer>();
int limit = 15;
int offset = limit * page;
customerList = customerDAO.findCustomers(limit, offset);
ModelAndView model = new ModelAndView("list");
model.addObject("customerList", customerList);
return model;
}
@Scope("session")
@RequestMapping(value = "/delete_customer", method = RequestMethod.GET)
public String deleteCustomer(Locale locale, Model model, HttpServletRequest request) {
try {
ApplicationContext context = new ClassPathXmlApplicationContext("Spring-Module.xml");
CustomerDAO customerDAO = (CustomerDAO) context.getBean("customerDAO");
int ID = Integer.parseInt(request.getParameter("id"));
System.out.println(ID);
/*String name = request.getParameter("name").toString();
int age = Integer.parseInt(request.getParameter("age"));
Customer user = new Customer(ID, name, age);*/
customerDAO.delete(ID);
} catch (Throwable q) {
}
return "redirect:/humans";
}
@Scope("session")
@RequestMapping(value = "/search_humans_params", method = RequestMethod.GET)
public ModelAndView searchByCampaign(HttpServletRequest request) {
ModelAndView model = new ModelAndView("searchByCompany");
try {
String sql = "SELECT * FROM companies WHERE";
sql += " ID = " + request.getParameter("ID");
// System.out.println(sql);
ApplicationContext context = new ClassPathXmlApplicationContext("Spring-Module.xml");
CustomerDAO customerDAO = (CustomerDAO) context.getBean("customerDAO");
Map<Integer, HashMap<String, String>> ResultMap =
new HashMap<Integer, HashMap<String, String>>();
ResultMap = customerDAO.SQLquery(sql);
Map<String, String> searchMap = new HashMap<String, String>();
searchMap = ResultMap.get(0);
String FindSql = "SELECT * FROM customer WHERE";
if (searchMap.get("Industry") != "") {
FindSql += " `Industry` = '" + searchMap.get("Industry").trim() + "'";
FindSql += " AND";
}
if (searchMap.get("Experience") != "") {
FindSql += " `Experience` = '" + searchMap.get("Experience").trim() + "'";
FindSql += " AND";
}
if (searchMap.get("Education") != "") {
FindSql += " `Education` = '" + searchMap.get("Education").trim() + "'";
FindSql += " AND";
}
if (searchMap.get("Country") != "") {
FindSql += " `Country` = '" + searchMap.get("requireCountry").trim() + "'";
FindSql += " AND";
}
if (searchMap.get("Gender") != "") {
FindSql += " `Gender` = '" + searchMap.get("Gender").trim() + "'";
FindSql += " AND";
}
if (searchMap.get("City") != "") {
FindSql += " `City` = '" + searchMap.get("City").trim() + "'";
FindSql += " AND";
}
if (searchMap.get("From") != "") {
FindSql += " `AGE` >= " + searchMap.get("From") + "";
FindSql += " AND";
FindSql += " `AGE` <= " + searchMap.get("To") + "";
FindSql += " AND";
}
FindSql += " CUST_ID > 0 AND Assigned = \"\" ";
Map<Integer, HashMap<String, String>> ResultSearch =
new HashMap<Integer, HashMap<String, String>>();
ResultMap = customerDAO.SQLquery(FindSql);
System.out.println(ResultMap);
model.addObject("userData", ResultMap);
} catch (Throwable q) {
return model;
}
return model;
}
