public SurveyQuestion(string var, string qnum) { VarName = new VariableName(var); //VarName = var; Qnum = qnum; PreP = ""; PreI = ""; PreA = ""; LitQ = ""; PstI = ""; PstP = ""; RespOptions = ""; NRCodes = ""; Translations = new List <Translation>(); Comments = new List <QuestionComment>(); PreviousNameList = new List <VariableName>(); //PreP = new Wording(); //PreP.PropertyChanged += WordingChanged; }
/// <summary> /// Returns a list containing every unique refVarName. /// </summary> /// <returns></returns> public static List <VariableName> GetAllVarNames() { List <VariableName> VarNames = new List <VariableName>(); string query = "SELECT * FROM qryVariableInfo ORDER BY VarName"; 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()) { VariableName v = new VariableName() { FullVarName = (string)rdr["VarName"], 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"]) }; VarNames.Add(v); } } } catch (Exception) { } } return(VarNames); }
/// <summary> /// Returns the list of all variables in use by a specific survey. /// </summary> /// <param name="surveyFilter"></param> /// <returns></returns> public static List <VariableName> GetVariableList(string surveyFilter) { List <VariableName> varnames = new List <VariableName>(); string query = "SELECT * FROM VarNames.FN_GetSurveyVarNames(@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", surveyFilter); try { using (SqlDataReader rdr = sql.SelectCommand.ExecuteReader()) { while (rdr.Read()) { VariableName v = new VariableName((string)rdr["VarName"]) { 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"]), }; varnames.Add(v); } } } catch (Exception) { } } return(varnames); }
/// <summary> /// Returns a VariabelName object with the provided VarName. /// </summary> /// <param name="varname">A valid VarName.</param> /// <returns> Null is returned if the VarName is not found in the database.</returns> public static VariableName GetVariable(string varname) { VariableName v; string query = "SELECT * FROM VarNames.FN_GetVarName(@varname)"; 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("@varname", varname); try { using (SqlDataReader rdr = sql.SelectCommand.ExecuteReader()) { rdr.Read(); v = new VariableName((string)rdr["VarName"]) { 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"])), }; } } catch (Exception) { return(null); } } return(v); }