import client.clientdata;
import java.io.IOException;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.Statement;
import javax.servlet.RequestDispatcher;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;


public class Process extends HttpServlet {



    @Override
    protected void doGet(HttpServletRequest request, HttpServletResponse response)
            throws ServletException, IOException {
        String url="/";
    String path = getServletContext().getRealPath("/WEB-INF/favoritecustomers.txt");
    String message="";
    String fname = request.getParameter("fname");
    String lname = request.getParameter("lname");
    String email = request.getParameter("email");
        String software = request.getParameter("software");
    String os = request.getParameter("os");
        String problem = request.getParameter("problem");
        int cost=0;

        if(software.equals("Windows 95") || software.equals("Windows 98")){cost = 100;}
        else if(software.equals("Windows 2000 pro") || software.equals("Windows Server")){cost =120;}
        else if(software.equals("Windows XP")){cost = 150;}
        else{cost = 0;}

    if(fname.length() == 0 || lname.length() == 0 || email.length() ==0){
    message = "fill out form";
    url = "/index.jsp";
    }
        else{

            try{
        Class.forName("com.mysql.jdbc.Driver");
            String dbURL = "jdbc:mysql://localhost:3306/requestdb";
            String username = "root";
            String password = "";

            Connection connection = DriverManager.getConnection(dbURL, username, password);



        Statement statement = connection.createStatement();
        ResultSet rs = statement.executeQuery("SELECT * FROM `request`");
        String sql = "INSERT INTO `request`(`software`, `os`, `problem`) VALUES (?,?,?);";
        PreparedStatement ps = connection.prepareStatement(sql);
        ps.setString(1,software);
        ps.setString(2,os);
        ps.setString(3,problem);
        ps.executeUpdate();

        rs.last();
        int id =rs.getInt("ID");

        clientdata c = new clientdata(id, fname, lname, email);
        clientdata.insert(c, path);
                message = String.valueOf(c.getId());
                url = "/confirm.jsp";
    }
    catch(Exception e){System.out.println(e.getMessage());}
        }

    HttpSession session = request.getSession();
    //session.setAttribute("id", id);
        session.setAttribute("fname", fname);
        session.setAttribute("lname", lname);
        session.setAttribute("message", message);
        session.setAttribute("cost", cost);

    RequestDispatcher dispatcher = getServletContext().getRequestDispatcher(url);
        dispatcher.forward(request, response);
    }
    @Override
    protected void doPost(HttpServletRequest request, HttpServletResponse response)
            throws ServletException, IOException {
        doGet(request, response);
    }



}