<%@ page import="com.smartidea.tm.*, com.smartidea.connection.*, java.sql.*, com.smartidea.utilities.shopcart.ShopCart" %>
<%@ page import="com.smartidea.utilities.*, java.util.*, com.smartidea.*" %>
<%
		ConnUtil connutil = new ConnUtil();
		Connection conn = connutil.OpenConnection();
		SignUpBean sgBean = new SignUpBean(conn);
		ShopCart sc = new ShopCart();
		DateUtil dateutil = new DateUtil();
		String nowdate = dateutil.getCurrentDate();

		String url = request.getParameter("URL");
		String nextsubdate = dateutil.NextMonthStartDate();
		String referemail = request.getParameter("referemail");
		String product = request.getParameter("product");
		String k1 = request.getParameter("keyword1");
		String k2 = request.getParameter("keyword2");
		String k3 = request.getParameter("keyword3");
		String k4 = request.getParameter("keyword4");
		String k5 = request.getParameter("keyword5");
		String k6 = request.getParameter("keyword6");
		String k7 = request.getParameter("keyword7");
		String k8 = request.getParameter("keyword8");
		String k9 = request.getParameter("keyword9");
		String title = request.getParameter("title");
		String description = request.getParameter("description");
		String webcat = request.getParameter("category");

		String errormessage = new String();

		if (url == null || url.equals("") || k1 == null || k1.equals("") || title == null || title.equals("") || description == null || description.equals("") || webcat.equals("-1"))
		{
					errormessage = "There are missing details entered to the system";
					session.setAttribute("errormessage", errormessage);
					response.sendRedirect("/signup/processsignuperror.jsp");
		}
		else {
				String keyword = sgBean.JoinKeywords(k1, k2, k3, k4, k5, k6, k7, k8, k9);
				keyword = Formatter.sqlEscape(keyword);
				title = Formatter.sqlEscape(title);
				description = Formatter.sqlEsc(description);

				int subcat = 0;
				if (webcat == null || webcat.equals(""))
						subcat = 0;
				else
						subcat = Integer.parseInt(webcat);

				String maincat = sgBean.GetSubCat(webcat);

				int category = 0;
				if (maincat == null || maincat.equals(""))
						category = 0;
				else
						category = Integer.parseInt(maincat);

				String planid = "BP-TM-" + product.toUpperCase();
				String productid = "TM-" + product.toUpperCase();

				referemail = "TM2";

				ServiceJB servJB = new ServiceJB(0,"",productid.toUpperCase(),url,keyword,title,description,category,subcat,"",0,nowdate,"",0,0,
																				 0,"",nextsubdate,planid.toUpperCase(),"","0","0","0", referemail, nowdate,"");

				HashMap shopcart = (HashMap)session.getAttribute("shopcart");
				ArrayList shoplist = (ArrayList)session.getAttribute("shoplist");
				String cart = new String();
				if (shopcart == null)
						shopcart = new HashMap();

				if (shoplist == null)
						shoplist = new ArrayList();

				boolean exist = sgBean.ValidateURLExists(url.trim());
				if (exist) {
						errormessage = "Unfortunately the URL you have entered already exists in our database";
						session.setAttribute("errormessage", errormessage);
						response.sendRedirect("/signup/processsignuperror.jsp");
						connutil.FreeConnection(conn);
				}
				else {
						shopcart = sc.AddItem(servJB,shopcart,url.trim());
						shoplist = sc.AddItem(servJB, shoplist);
						session.setAttribute("shopcart",shopcart);
						session.setAttribute("shoplist", shoplist);
						response.sendRedirect("/signup/signupform1.jsp");
						connutil.FreeConnection(conn);
				}
		}


%>