public string[] GetBlacklistedSpecies()
{
try {
using (SqlConnection cnn = new SqlConnection(ServerSettings.SpeciesDsn)) {
cnn.Open();
using (SqlCommand cmd = new SqlCommand("Select AssemblyFullName From Species Where BlackListed = 1", cnn))
using (SqlDataReader dr = cmd.ExecuteReader()) {
List <String> blackListedSpecies = new List <String>();
while (dr.Read())
{
blackListedSpecies.Add(dr["AssemblyFullName"].ToString());
}
if (blackListedSpecies.Count > 0)
{
return(blackListedSpecies.ToArray());
}
}
}
} catch (Exception e) {
InstallerInfo.WriteEventLog("GetBlacklistedSpecies", e.ToString());
return(null);
}
return(null);
}