//
// Domain Label
//
/// <summary>
/// Returns the list of Domain Labels in the database.
/// </summary>
/// <returns></returns>
public static List <DomainLabel> ListDomainLabels()
{
List <DomainLabel> domains = new List <DomainLabel>();
DomainLabel d;
string query = "SELECT * FROM Labels.FN_ListDomainLabels() ORDER BY Domain";
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())
{
d = new DomainLabel((int)rdr["ID"], (string)rdr["Domain"]);
domains.Add(d);
}
}
}
catch (Exception)
{
}
}
return(domains);
}
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 DomainLabel(DomainLabel domain)
{
ID = domain.ID;
LabelText = domain.LabelText;
}