/// <summary> /// Returns a list of RefVariableName objects with the provided refVarName. /// </summary> /// <param name="refVarName"></param> /// <returns></returns> public static List <RefVariableName> GetRefVarNamesPrefix(string prefix) { List <RefVariableName> refVarNames = new List <RefVariableName>(); string query = "SELECT refVarName, VarLabel, DomainNum, Domain, TopicNum, Topic, ContentNum, Content, ProductNum, Product FROM qryVariableInfo WHERE SUBSTRING(refVarName,1,2) = @prefix ORDER BY refVarName"; using (SqlDataAdapter sql = new SqlDataAdapter()) using (SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["ISISConnectionString"].ConnectionString)) { conn.Open(); sql.SelectCommand = new SqlCommand(query, conn); sql.SelectCommand.Parameters.AddWithValue("@prefix", prefix); try { using (SqlDataReader rdr = sql.SelectCommand.ExecuteReader()) { while (rdr.Read()) { RefVariableName rv = new RefVariableName() { refVarName = (string)rdr["refVarName"], VarLabel = (string)rdr["VarLabel"], Domain = new DomainLabel((int)rdr["DomainNum"], (string)rdr["Domain"]), Topic = new TopicLabel((int)rdr["TopicNum"], (string)rdr["Topic"]), Content = new ContentLabel((int)rdr["ContentNum"], (string)rdr["Content"]), Product = new ProductLabel((int)rdr["ProductNum"], (string)rdr["Product"]) }; refVarNames.Add(rv); } } } catch (Exception) { int i = 0; } } return(refVarNames); }
/// <summary> /// Returns a list of containing all refVarNames for a particular survey. /// </summary> /// <param name="surveyCode"></param> /// <returns></returns> public static List <RefVariableName> GetAllRefVars(string surveyCode) { List <RefVariableName> refVarNames = new List <RefVariableName>(); string query = "SELECT * FROM VarNames.FN_GetSurveyRefVars(@survey)"; using (SqlDataAdapter sql = new SqlDataAdapter()) using (SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["ISISConnectionString"].ConnectionString)) { conn.Open(); sql.SelectCommand = new SqlCommand(query, conn); sql.SelectCommand.Parameters.AddWithValue("@survey", surveyCode); try { using (SqlDataReader rdr = sql.SelectCommand.ExecuteReader()) { while (rdr.Read()) { RefVariableName rv = new RefVariableName() { refVarName = (string)rdr["refVarName"], VarLabel = (string)rdr["VarLabel"], Domain = new DomainLabel((int)rdr["DomainNum"], (string)rdr["Domain"]), Topic = new TopicLabel((int)rdr["TopicNum"], (string)rdr["Topic"]), Content = new ContentLabel((int)rdr["ContentNum"], (string)rdr["Content"]), Product = new ProductLabel((int)rdr["ProductNum"], (string)rdr["Product"]) }; refVarNames.Add(rv); } } } catch (Exception) { } } return(refVarNames); }