//
// Topic Label
//
/// <summary>
/// Returns the list of Topic Labels in the database.
/// </summary>
/// <returns></returns>
public static List <TopicLabel> GetTopicLabels()
{
List <TopicLabel> topics = new List <TopicLabel>();
TopicLabel t;
string query = "SELECT * FROM Labels.FN_ListTopicLabels() ORDER BY Topic";
using (SqlDataAdapter sql = new SqlDataAdapter())
using (SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["ISISConnectionString"].ConnectionString))
{
conn.Open();
sql.SelectCommand = new SqlCommand(query, conn);
try
{
using (SqlDataReader rdr = sql.SelectCommand.ExecuteReader())
{
while (rdr.Read())
{
t = new TopicLabel((int)rdr["ID"], (string)rdr["Topic"]);
topics.Add(t);
}
}
}
catch (Exception)
{
}
}
return(topics);
}
public RefVariableName(string refvarname)
{
refVarName = refvarname;
VarLabel = "";
Domain = new DomainLabel(0, "No Domain");
Topic = new TopicLabel(0, "No Topic");
Content = new ContentLabel(0, "No Content");
Product = new ProductLabel(0, "Unassigned");
}
public VariableName(string varname)
{
FullVarName = varname;
RefVarName = Utilities.ChangeCC(varname);
VarLabel = "";
Domain = new DomainLabel(0, "No Domain");
Topic = new TopicLabel(0, "No Topic");
Content = new ContentLabel(0, "No Content");
Product = new ProductLabel(0, "Unassigned");
}
public VariableName()
{
FullVarName = "";
RefVarName = "";
VarLabel = "";
Domain = new DomainLabel(0, "No Domain");
Topic = new TopicLabel(0, "No Topic");
Content = new ContentLabel(0, "No Content");
Product = new ProductLabel(0, "Unassigned");
}
public TopicLabel(TopicLabel topic)
{
ID = topic.ID;
LabelText = topic.LabelText;
}