package com.lovo.bo;

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

import com.lovo.factory.DAOFactory;
import com.lovo.po.ChatroomPO;
import com.lovo.vo.ChatroomVO;

public class ChatroomBOImpl implements ChatroomBO{
	
	/**
	 * 添加聊天室
	 */
	public boolean addChatroom(ChatroomVO vo) {
		ChatroomPO po = new ChatroomPO();
		po.setMaxUserNum(vo.getMaxUserNum());
		po.setName(vo.getName());
		try {
			DAOFactory.getChatroomDAOInstance().insert(po);
			return true;
		} catch (SQLException e) {
			e.printStackTrace();
		}
		return false;
	}

	/**
	 *  刪除聊天室
	 */
	public boolean delete(int id) {
		ChatroomPO po = new ChatroomPO();
		po.getId();
		try {
			DAOFactory.getChatroomDAOInstance().delete(id);
			return true;
		} catch (SQLException e) {
			e.printStackTrace();
		}
		return false;
	}

	/**
	 * 修改聊天室信息
	 */
	public boolean modify(ChatroomVO vo) {
		ChatroomPO po = new ChatroomPO();
		po.setId(vo.getId());
		po.setName(vo.getName());
		po.setMaxUserNum(vo.getMaxUserNum());
		try {
			DAOFactory.getChatroomDAOInstance().update(po);
			return true;
		} catch (SQLException e) {
			e.printStackTrace();
		}
		return false;
	}

	/**
	 * 根據聊天室名字查詢聊天室
	 */
	public List<ChatroomPO> queryByName(String name) throws SQLException {
		try {
			List<ChatroomPO> list = DAOFactory.getChatroomDAOInstance().queryByName(name);
			return list;
		} catch (SQLException e) {
			e.printStackTrace();
			throw e;
		}
	}

	public List<ChatroomPO> queryAllChatroom() throws SQLException {
		try {
			List<ChatroomPO> list = DAOFactory.getChatroomDAOInstance().queryAll();
			return list;
		} catch (SQLException e) {
			e.printStackTrace();
			throw e;
		}
		
	}

	public ChatroomPO queryById(int id) throws SQLException {
		return DAOFactory.getChatroomDAOInstance().queryById(id);
	}

}