package com.cric.onlineshopclothes.dao;

import java.util.Date;
import java.text.SimpleDateFormat;

import java.sql.ResultSet;
import java.util.ArrayList;
import java.util.List;

import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import com.cric.onlineshopclothes.javabean.Category;
import com.cric.onlineshopclothes.javabean.Product;
import com.cric.onlineshopclothes.util.DBUtils;

import com.cric.onlineshopclothes.util.UploadBeanUTF;

public class ProductDAO {
public Category addCategoryParam(HttpServletRequest request, HttpServletResponse response){
		
		
	   Category category=new Category();
		
		String categoryName=request.getParameter("categoryName");
	    String categoryState=request.getParameter("categoryState");
	    SimpleDateFormat format=new SimpleDateFormat("yyyy年MM月dd日 HH:mm:ss");
	    String ctime=format.format(new Date());
	    
	
		category.setCategoryName(categoryName==null?"":categoryName);
		category.setCategoryState(categoryState);
		category.setUpdateTime(ctime);
		//category.setCategoryState(categoryState==null?"":categoryState);
		
		return category;
	}
	public boolean insertCategory(Category category){
		boolean flag=false;	
		String sqlStr="insert into category values('"+category.getCategoryName()+"','"+category.getCategoryState()+"','"+category.getUpdateTime()+"')";
		System.out.println(sqlStr);
		DBUtils db=new DBUtils();
		flag=db.excuteUpdate(sqlStr);
		db.closeStmt();
		db.closeConnection();
		System.out.println(flag);
		
		return flag;
	}
	
	public List getAllCategory(){
		DBUtils db=new DBUtils();
		List list=new ArrayList();
		String sql="select * from category";
		try{
			ResultSet rs=db.excuteQuery(sql);
			while(rs.next()){
				Category category=new Category();
				category.setCategoryId(rs.getInt("categoryId"));
				category.setCategoryName(rs.getString("categoryName"));
				category.setCategoryState(rs.getString("categoryState"));
				category.setUpdateTime(rs.getString("updateTime"));
				list.add(category);
				
			}
		}catch(Exception e){
			e.printStackTrace();
		}finally{
			db.closeConnection();
		}
		return list;
	}
	
	public List getCategoryByUsername(String categoryName){
		DBUtils db=new DBUtils();
		List list=new ArrayList();
		String sql="select * from category where categoryName like '%"+categoryName+"%'";
		try{
			ResultSet rs=db.excuteQuery(sql);
			while(rs.next()){
				Category category=new Category();
				category.setCategoryId(rs.getInt("categoryId"));
				category.setCategoryName(rs.getString("categoryName"));
				category.setCategoryState(rs.getString("categoryState"));
				category.setUpdateTime(rs.getString("updateTime"));
				list.add(category);
			}
		}catch(Exception e){
			e.printStackTrace();
		}finally{
			db.closeConnection();
		}
		return list;
	}
	
	public List getProductCategory(){
		DBUtils db=new DBUtils();
		List list=new ArrayList();
		String sql="select * from category" ;
		try{
			ResultSet rs=db.excuteQuery(sql);
			while(rs.next()){
				Category category=new Category();
				category.setCategoryId(rs.getInt("categoryId"));
				category.setCategoryName(rs.getString("categoryName"));
				category.setCategoryState(rs.getString("categoryState"));
				category.setUpdateTime(rs.getString("updateTime"));
				list.add(category);
				
			}
		}catch(Exception e){
			e.printStackTrace();
		}finally{
			db.closeConnection();
		}
		return list;
	}
	
	
	public Product getProductParam(HttpServletRequest request, HttpServletResponse response){
		UploadBeanUTF fileBean=new UploadBeanUTF();
		String filename="";
		try{
			fileBean.setObjectPath("E:\\Workspaces\\OnlineShopClothes\\WebRoot");
			//fileBean.setObjectFileName("1.jpg");
			//fileBean.setSize(10000*1024);
			fileBean.setSourceFile(request);
			filename=fileBean.getNewFileName();
		}catch(Exception e){e.printStackTrace();}
		
		Product pro=new Product();
		
		 SimpleDateFormat format=new SimpleDateFormat("yyyy年MM月dd日 HH:mm:ss");
		 String ctime=format.format(new Date());
		
		String categoryId=fileBean.getFieldValue("categoryId");
		String productName=fileBean.getFieldValue("PName");
		String productDetail=fileBean.getFieldValue(" Detail");
		String productInPrice=fileBean.getFieldValue("InPrice");
		String productOutPrice=fileBean.getFieldValue("OutPrice");
		String productAmount=fileBean.getFieldValue("productAmount");
		String productState=fileBean.getFieldValue("State");
		String hot=fileBean.getFieldValue("Hot");
		String saledAmount=fileBean.getFieldValue("SaledAmount");
		String productPic=filename;
		
		
		pro.setCategoryId(categoryId==null?0:Integer.parseInt(categoryId));
		pro.setPName(productName==null?"":productName);
		pro.setDetail(productDetail==null?"":productDetail);
		pro.setInPrice(productInPrice==null?0:Float.parseFloat(productInPrice));
		pro.setInPrice(productOutPrice==null?0:Float.parseFloat(productOutPrice));
		pro.setAmount(productAmount==null?0:Integer.parseInt(productAmount));
		pro.setState(productState==null?"":productState);
		pro.setProductTime(ctime);
		pro.setHot(hot==null?"":hot);
		pro.setSaledAmount(Integer.parseInt(saledAmount));
		pro.setPicture(productPic==null?"":productPic);
		
		return pro;
	}
	
	
	public boolean insertProduct(Product product){
		boolean flag=false;
		DBUtils db=new DBUtils();
		String sqlStr="insert into product(" +
		        "categoryId," +
				"PName," +
				"Detail," +
				"InPrice," +
				"OutPrice," +
				"Amount," +
				"Picture,"+
				"State," +
				"ProductTime," +
				" Hot," +
				"SaledAmount) " +
				"values("
				        +product.getCategoryId()+",'" 
				        +product.getPName()+"','" 
						+product.getDetail()+"',"
						+product.getInPrice()+","
						+product.getOutPrice()+","
						+product.getAmount()+",'"
						+product.getPicture()+"','"
						+product.getState()+"','"
						+product.getProductTime()+"','"
						+product.getHot()+"',"
						+product.getSaledAmount()+")";
		flag=db.excuteUpdate(sqlStr);
		return flag;
	}
	
}