import java.io.IOException;
import java.io.PrintWriter;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.util.Calendar;

import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import com.google.gson.Gson;
import com.mysql.jdbc.Statement;

/**
 * Servlet implementation class PostUserServlet
 */
@WebServlet("/PostUserServlet")
public class PostUserServlet extends HttpServlet {
	private static final long serialVersionUID = 1L;

	protected void doGet(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException {

		response.getWriter().append("Served at: ").append(request.getContextPath());
	}

	protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {

		try {
			Class.forName("com.mysql.jdbc.Driver");
			System.out.println("dada");
			Connection conn;
			conn = DriverManager.getConnection(IDB.DATABASE_URL, IDB.DATABASE_USERNAME, IDB.DATABASE_PASSWORD);

			String userJson = request.getParameter("userJson");
			String type = request.getParameter("type");

			Gson gson = new Gson();
			User user = gson.fromJson(userJson, User.class);
			int isSmoking = (user.isSmoking())? 1:0;

			Calendar calendar = user.getDateOfBirth();
			String date = calendar.getInstance().get(Calendar.YEAR) + "-"
		 			+ calendar.getInstance().get(Calendar.MONTH) + "-"
		 			+ calendar.getInstance().get(Calendar.DAY_OF_MONTH);

			Statement statement = (Statement) conn.createStatement();
			int set;
			switch(type){
			case "register":

				set = statement.executeUpdate(
						 "INSERT INTO users_table (names, avatar, username, email, password, phone, date_of_birth, gendre, country, smoking)"
						 + " VALUES ('"
								 + user.getNames() + "', '"
								 + user.getAvatar() + "', '"
								 + user.getUsername() + "', '"
								 + user.getEmail() + "', '"
								 + user.getPassword() + "', '"
								 + user.getMobilePhone() + "', '"
								 + "CAST('" + date +"' AS DATE), '"
								 + user.getGender() + "', '"
								 + user.getCountry() + "', '"
								 + isSmoking + "');"
								 );
				break;
			case "delete":
				set = statement.executeUpdate(
						"DELETE FROM users_table WHERE user_id=" + user.getUserId()
						);
				break;
			case "update":
				set = statement.executeUpdate(
						"UPDATE users_table SET "
								+ "names=" + "'" + user.getNames() + "', "
								+ "avatar=" + "'" + user.getAvatar() + "', "
								+ "username=" + "'" + user.getUsername() + "', "
								+ "email=" + "'" + user.getEmail() + "', "
								+ "password=" + "'" + user.getPassword() + "', "
								+ "phone=" + "'" + user.getMobilePhone() + "', "
								+ "date_of_birth=" + "'" + "CAST('" + date +"' AS DATE), "
								+ "gendre=" + "'" + user.getGender() + "', "
								+ "country=" + "'" + user.getCountry() + "', "
							+ "smoking=" + "'" + isSmoking + "' "
							+ "WHERE user_id='" + user.getUserId() + "';"
						);
		}

			System.out.println("nene");

		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		} catch (ClassNotFoundException e1) {
			// TODO Auto-generated catch block
			e1.printStackTrace();
		}
	}

}