//
// Content Label
//
/// <summary>
/// Returns the list of Content Labels in the database.
/// </summary>
/// <returns></returns>
public static List <ContentLabel> GetContentLabels()
{
List <ContentLabel> contents = new List <ContentLabel>();
ContentLabel c;
string query = "SELECT * FROM Labels.FN_ListContentLabels() ORDER BY Content";
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())
{
c = new ContentLabel((int)rdr["ID"], (string)rdr["Content"]);
contents.Add(c);
}
}
}
catch (Exception)
{
}
}
return(contents);
}
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 ContentLabel(ContentLabel content)
{
ID = content.ID;
LabelText = content.LabelText;
}