package cart;
import java.sql.*;
import java.util.*;
import java.math.*;
import java.io.*;


public class CartManager 
{
	String sDBDriver = "sun.jdbc.odbc.JdbcOdbcDriver";
	String sConnStr = "jdbc:odbc:cart";
	Connection conn = null;
	ResultSet rs = null;
	
	private String userName=new String("");
	private int pageSize=10;
	private Vector orderItem=new Vector();
	private String queryProductId=new String("");
	private int orderPrice=0;
	private String orderId=new String("");
	

	public CartManager() 
	{
		
	}

	
	
	public int checkUser(String userName,String userPassword)
	{
		
		
		int result=0;
		UserEntity user=null;
                
                      
                try{
                user=UserEntity.queryUser(userName);
                }
                catch(SQLException ex) 
		{ 
			System.err.println(ex.getMessage());
		}
                    
		
		if(user==null)
			return 0;
		
		String pass=user.getUserPassword();
	
		
		if(pass.compareTo(userPassword)==0)
		{
			result=1;
			this.userName=userName;
		}
		
		return result;
	
	}

	public void setPageSize(int pageSize)
	{
		this.pageSize=pageSize;
	}

	public Vector queryProduct(int pageCount)
	{
		Vector v=null;
                try{
                v=ProductEntity.queryProduct(queryProductId,pageCount,this.pageSize);
                }
                catch(SQLException ex) 
		{ 
			System.err.println(ex.getMessage());
		}
                
		return v;
	}

	public void insertOrder()//insert intoDataBase
	{
		try
		{
		if(orderPrice==0)
			return;
		OrderEntity oe=new OrderEntity("null",userName,"null",Integer.toString(orderPrice));
		
		//insert order
		orderId=oe.insertOrder();
		
		
		//insert order items
		for(int i=0;i<orderItem.size();i++)
		{
			OrderItemEntity oi=(OrderItemEntity)orderItem.elementAt(i);
			oi.setOrderId(orderId);
			oi.insertOrderItem();
		}
		
		}
		catch(SQLException ex) 
		{ 
			System.err.println("InsertOrder executeQuery: " + ex.getMessage());
		}

		//clear order variable
		orderItem.removeAllElements();
		orderPrice=0;
	}

	public void addOrderItem(String productId,String productPrice)//add to Session private variables
	{
		for(int i=0;i<orderItem.size();i++)
		{
			OrderItemEntity oi=(OrderItemEntity)orderItem.elementAt(i);
			String pId=oi.getProductId();
			if(pId.compareTo(productId)==0)
			{
				int num=Integer.parseInt(oi.getProductNum());
				++num;
				oi.setProductNum(Integer.toString(num));
				
				this.orderPrice+=Integer.parseInt(productPrice);
				return;
			}
		}
		
		OrderItemEntity oiNew=new OrderItemEntity("null","null",productId,"1",Integer.parseInt(productPrice));
		orderItem.add(oiNew);
		this.orderPrice+=Integer.parseInt(productPrice);
		
	}

	public void deleteOrderItem(String productId)//delete from Session private varibles
	{
		for(int i=0;i<orderItem.size();i++)
		{
			OrderItemEntity oi=(OrderItemEntity)orderItem.elementAt(i);
			String pId=oi.getProductId();
			if(pId.compareTo(productId)==0)
			{
				int num=Integer.parseInt(oi.getProductNum());
				--num;
				oi.setProductNum(Integer.toString(num));
				
				if(num==0)
					orderItem.removeElementAt(i);
				
				this.orderPrice-=oi.getPrice();
				return;
			}
		}
	}
	
	public Vector getOrderItem()
	{
		return orderItem;
	}
	
	public String getUserName()
	{
		return userName;
	}
	
	public void setQueryProductId(String queryProductId)
	{
		this.queryProductId=queryProductId;
	}
	
	public String getQueryProductId()
	{
		return queryProductId;
	}
	
	public String getOrderPrice()
	{
		return Integer.toString(orderPrice);
	}

	public String getOrderId()
	{
		return orderId;
	}


}