<%@ page language = "java" import = "java.sql.*,java.io.*,java.util.*" %>
<%!
	public static int parseInt(String source)
		{
		return parseInt(source, 0);
		}
	
	public static int parseInt(String source,int dInt)
		{
		try
			{
			return Integer.parseInt(source);
			}
		catch(Exception e)
			{
			return dInt;
			}
		}

	public static String parseString(String source)
		{
		return parseString(source, "", true);
		}
	
	public static String parseString(String source, String dString)
		{
		return parseString(source, dString, true);
		}
	
	public static String parseString(String source, String dString, boolean allowNullString)
		{
		try
			{
			if(source == null)
				return dString;
			if(source.equals("") && !allowNullString)
				return dString;
			return source;
			}
		catch(Exception e)
			{
			return dString;
			}
		}
%>
<%	
	Boolean adminLogged = (Boolean)session.getValue("adminLogged");
	if (adminLogged==null)
		adminLogged = new Boolean(false);
	if(!adminLogged.booleanValue())
		response.sendRedirect("admin.jsp?isErr=" + response.encodeURL("You need to login first !"));

	Class.forName("org.hsqldb.jdbcDriver");
	String conStr = "jdbc:hsqldb:" + application.getRealPath("/~smhumayun/GuestBook/GuestBook");
	final String GuestBookDBUser = "sa";
	final String GuestBookDBPwd = "";
	Connection con = DriverManager.getConnection(conStr,GuestBookDBUser,GuestBookDBPwd);

	String mode = parseString(request.getParameter("mode"), "");
		
	int total = parseInt(request.getParameter("total"), 0);
	int c = 0;
	String ids = "";
	for(int i=0; i<total; i++)
		{
		int temp = parseInt(request.getParameter("rec"+i), 0);
		if(temp > 0)
			{
			c++;
			if ( ids.equals("") )
				ids = "" + temp;
			else
				ids += "," + temp;
			}
		}
	
	if (mode.equals("enable"))
		{
		try
			{
			con.createStatement().executeUpdate(" update Guestbook set Status = True where UID in (" + ids + ") ");
			}
		catch(Exception e)
			{
			System.out.println("\n\nError : \n\n" + e.toString() + "\n\n");
			response.sendRedirect("GuestBook_Admin.jsp?isErr=" + response.encodeURL("Error occured, try some time later"));
			}
		response.sendRedirect("GuestBook_Admin.jsp?isErr=" + response.encodeURL("" + c + " comments enabled successfully !"));
		}
	else if(mode.equals("disable"))
		{
		try
			{
			con.createStatement().executeUpdate(" update Guestbook set Status = False where UID in (" + ids + ") ");
			}
		catch(Exception e)
			{
			System.out.println("\n\nError : \n\n" + e.toString() + "\n\n");
			response.sendRedirect("GuestBook_Admin.jsp?isErr=" + response.encodeURL("Error occured, try some time later"));
			}
		response.sendRedirect("GuestBook_Admin.jsp?isErr=" + response.encodeURL("" + c + " comments disabled successfully !"));
		}
	else if(mode.equals("delete"))
		{
		try
			{
			con.createStatement().executeUpdate(" delete from Guestbook where UID in (" + ids + ") ");
			}
		catch(Exception e)
			{
			System.out.println("\n\nError : \n\n" + e.toString() + "\n\n");
			response.sendRedirect("GuestBook_Admin.jsp?isErr=" + response.encodeURL("Error occured, try some time later"));
			}
		response.sendRedirect("GuestBook_Admin.jsp?isErr=" + response.encodeURL("" + c + " comments deleted successfully !"));
		}
	else
			response.sendRedirect("GuestBook_Admin.jsp?isErr=" + response.encodeURL("Unknown user action : " + mode));
%>