package com.ascenttech.ebookstore.servlet;

import javax.servlet.*;
import javax.servlet.http.*;

import com.ascenttech.ebookstore.bean.*;
import com.ascenttech.ebookstore.shopcart.BookDetails;
import com.ascenttech.ebookstore.shopcart.ShoppingCart;
import com.ascenttech.ebookstore.shopcart.ShoppingCartItem;
import com.ascenttech.ebookstore.util.*;

import java.io.*;
import java.util.*;
import java.sql.*;

public class OrderServlet extends HttpServlet {
  private static final String CONTENT_TYPE = "text/html; charset=GBK";

  //Initialize global variables
  public void init() throws ServletException {
  }

  //Process the HTTP Get request
  public void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {

    String oid = request.getParameter("oid");
    String custname=request.getParameter("custname");
    String address = request.getParameter("address");
    float total = Float.parseFloat(request.getParameter("total"));

    String str="";
    int quantity = 0;
    float price=(float)0.0;
    HttpSession session = request.getSession();
    String user = (String) session.getAttribute("username");
    ShoppingCart sc=(ShoppingCart) session.getAttribute(user);
    Collection items = sc.getItems();
    Iterator it = items.iterator();
    while(it.hasNext()){

      ShoppingCartItem sci = (ShoppingCartItem)it.next();
      BookDetails bd = (BookDetails)sci.getItem();
      str+=bd.getIsbn() + " " ;
    }

    
    Orderinfo  oi = new Orderinfo();
    oi.setCustomer(custname);
    oi.setPrice(total);
    oi.setAddress(address);
    oi.setBooklist(str);
    oi.setUser(user);
    oi.setDate(new java.sql.Date(new java.util.Date().getTime()));

    try {
      oi.saveOrder();
    }
    catch (Exception ex) {
      ex.printStackTrace();
    }


    Collection sc2 = sc.getItems();
    Iterator it2 = items.iterator();

    while(it2.hasNext()){

      ShoppingCartItem sci = (ShoppingCartItem)it2.next();
      quantity = sci.getQuantity();

      BookDetails bd = (BookDetails)sci.getItem();
      price=bd.getPrice();

      Orderinfo  oi2 = new Orderinfo();
      int oid2= 0;
      try {
         oid2 = oi2.getLastInsertId();
      }
      catch (SQLException ex1) {
         ex1.printStackTrace();
      }

      Orderline ol = new Orderline();
      ol.setIsbn(bd.getIsbn());
      ol.setOid(oid2);
      ol.setPrice(price);
      ol.setQuantity(quantity);

      
      try {
        ol.saveOrderline();
      }
      catch (Exception ex2) {
        ex2.printStackTrace();
      }

    }

    RequestDispatcher rd=this.getServletContext().getRequestDispatcher("/orderconfirm.jsp");
    rd.forward(request,response);
  }

  //Process the HTTP Post request
  public void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
    doGet(request, response);
  }

  //Clean up resources
  public void destroy() {
  }
}