package com.lovo.bo;


import java.sql.SQLException;
import java.util.List;

import com.lovo.factory.DAOFactory;
import com.lovo.po.AreaPO;
import com.lovo.po.BlockPO;

public class BlockBOImpl implements BlockBO{
	
	public boolean addBlock(BlockPO po) {
		try {
			DAOFactory.getBlockDAOInstance().insert(po);
		} catch (SQLException e) {
			e.printStackTrace();
			return false;
		}
		return true;
	}
	public boolean delectBlock(int id) {
		try {
			DAOFactory.getBlockDAOInstance().delete(id);
			
		} catch (SQLException e) {
			e.printStackTrace();
			return false;
		}
		return true;
	}
	public boolean modify(BlockPO po) {
		try {
			DAOFactory.getBlockDAOInstance().update(po);
		} catch (SQLException e) {
			e.printStackTrace();
			return false;
		}
		return true;
	}
	public List<BlockPO> queryBlockByArea(int areaId) {
		List<BlockPO> list = null;
		try {
			list = DAOFactory.getBlockDAOInstance().queryBlockByAreaId(areaId);
		} catch (SQLException e) {
			e.printStackTrace();
		}
		return list;
	}
	public BlockPO queryBlockById(int blockId) {
		BlockPO blockPO=null;
		try {
			blockPO=DAOFactory.getBlockDAOInstance().queryBlockById(blockId);
		} catch (SQLException e) {
			e.printStackTrace();
		}
		return blockPO;
	}
	
	public boolean initArea(BlockPO po) {
		try {
			AreaPO area = DAOFactory.getAreaDAOInstance().queryById(po.getArea().getId());
			po.setArea(area);
		} catch (SQLException e) {
			e.printStackTrace();
			return false;
		}
		return true;
	}
	public boolean delectBlocks(int areaID) {
		try {
			DAOFactory.getBlockDAOInstance().deleteByAreaID(areaID);
			
		} catch (SQLException e) {
			e.printStackTrace();
			return false;
		}
		return true;
	}
	
}