package dell_system;
import databases.DBConnector;
import targets.Company;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;

public class Dell_company {
	static List<Company> companies=null;
	// ²éѯËùÓй«Ë¾
	public static List<Company> getAllCompanies() throws SQLException {
		companies = new ArrayList<>();
		ResultSet rs = DBConnector.queryTableData("company");

		while (rs.next()) {
			Company company = new Company();
			company.setId(rs.getInt("id"));
			company.setCompanyName(rs.getString("company_name"));
			company.setCompanyLogoUrl(rs.getString("company_logo_url"));
			company.setAddedBy(rs.getString("added_by"));
			company.setAddedDate(rs.getString("added_date"));
			companies.add(company);
		}
		return companies;
	}

	// ÐÂÔö¹«Ë¾
	public static void insertCompany(Company company) throws SQLException {
		String sql = "INSERT INTO company (company_name, added_date) " +
				"VALUES (?, ?)";
		DBConnector.executeUpdate(sql,
				company.getCompanyName(),
				company.getAddedDate());
	}

	// ¸üй«Ë¾
	public static void updateCompany(Company company) throws SQLException {
		String sql = "UPDATE company SET company_name = ? WHERE id = ?";
		DBConnector.executeUpdate(sql, 
				company.getCompanyName(), 
				company.getId());
	}

	// ɾ³ý¹«Ë¾
	public static void deleteCompany(int companyId) throws SQLException {
		String sql = "DELETE FROM company WHERE id = ?";
		DBConnector.executeUpdate(sql, companyId);
	}

	// ÐÂÔö£º»ñÈ¡ËùÓй«Ë¾Ãû³ÆÊý×é
	public static String[] getAllCompanyNames() {
		if (companies == null || companies.isEmpty()) {
			return new String[0];
		}

		String[] companyNames = new String[companies.size()];
		for (int i = 0; i < companies.size(); i++) {
			companyNames[i] = companies.get(i).getCompanyName();
		}

		return companyNames;
	}
}