package dell_targets;
import databases.DBConnector;
import targets.MessageType;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;

public class Dell_MessageType {
    // ¾²Ì¬±äÁ¿£¬ÓÃÓÚ´æ´¢ MessageType ¶ÔÏóÁбí
    static List<MessageType> messageTypes;
    // ´ÓÊý¾Ý¿âÖлñÈ¡ËùÓÐ MessageType Êý¾Ý
    public static List<MessageType> getMessageTypes() throws SQLException {
        List<MessageType> messageTypes = new ArrayList<>();
        ResultSet rs = DBConnector.queryTableData("message_type");
        while (rs.next()) {
            MessageType messageType = new MessageType();
            messageType.setId(rs.getInt("ID"));
            messageType.setTypeCode(rs.getString("Type_Code"));
            messageType.setTypeName(rs.getString("Type_Name"));
            messageType.setAddTime(rs.getString("Add_Time"));
            messageTypes.add(messageType);
        }
        return messageTypes;
    }

    // ÏòÊý¾Ý¿âÖвåÈëÒ»Ìõ MessageType Êý¾Ý
    public static void insertMessageType(MessageType messageType) throws SQLException {
        String sql = "INSERT INTO message_type (Type_Code, Type_Name, Add_Time) VALUES (?, ?, ?)";
        DBConnector.executeUpdate(sql, 
                messageType.getTypeCode(), 
                messageType.getTypeName(), 
                messageType.getAddTime());
    }

    // ¸ù¾Ý ID ɾ³ýÒ»Ìõ MessageType Êý¾Ý
    public static void deleteMessageType(int id) throws SQLException {
        String sql = "DELETE FROM message_type WHERE ID = ?";
        DBConnector.executeUpdate(sql, id);
    }
    
    public static List<String> getAllMessageTypes() {
        List<String> types = new ArrayList<>();
        try {
            // »ñÈ¡MessageType¶ÔÏóÁбí
            List<MessageType> typeList = getMessageTypes();
            // Ìáȡÿ¸ö¶ÔÏóµÄTypeName
            for (MessageType mt : typeList) {            	
                types.add(mt.getTypeName());
            }
        } catch (SQLException e) {
            e.printStackTrace(); // ʵ¼ÊÓ¦ÓÃÖÐÓ¦´¦ÀíÒì³£
        }
        return types;
    }
    
}