protected DataTable LoadStructuresFromNDAR()
{
DataTable dt_fulllist;
object o = Session["StructuresFromNDAR"];
if (o != null)
{
dt_fulllist = (DataTable)o;
}
else
{
dt_fulllist = NDAR.LoadFullDataStructureList("NDAR");
}
return(dt_fulllist);
}
protected void LoadDataStructures(string source)
{
string where = txtWhere.Text;
DataTable dt = new System.Data.DataTable();
SQL_utils sql = new SQL_utils("data");
if (chkInStudy.Checked)
{
//UWAutism uwac = new UWAutism();
//int studyID = uwac.Master_studyID;
int studyID = sql.GetUserStudyID();
dt = NDAR.LoadFullDataStructureList(source, where, chkUWview.Checked, studyID);
}
else
{
dt = NDAR.LoadFullDataStructureList(source, where, chkUWview.Checked);
}
string code_no_ndar = String.Format("select * from uwautism_research_backend..tblMeasure where " +
" measureID in (select measureID from uwautism_research_backend..tblStudyMeas where studyID={0}) and measureID not in " +
" ( select measureID from def.Tbl a " +
" join NDAR_DS b ON a.tblname = b.uwtable where measureID>0) "
, Master.Master_studyID);
DataTable dt_no_ndar = sql.DataTable_from_SQLstring(code_no_ndar);
sql.Close();
gridNoNDAR.DataSource = dt_no_ndar;
gridNoNDAR.DataBind();
//gvScroll.DataSource = dt;
//gvScroll.DataBind();
Session["datastructures"] = dt;
grid.DataSource = dt;
grid.DataBind();
lblN.Text = "No. of Data Structures: " + dt.Rows.Count.ToString();
}
protected void OpenAllViewdataTabs(object sender, EventArgs e)
{
SQL_utils sql = new SQL_utils("data");
string where = txtWhere.Text;
int studyID = sql.GetUserStudyID();
DataTable dt = NDAR.LoadFullDataStructureList("localDB", where, chkUWview.Checked, studyID);
int counter = 0;
foreach (DataRow row in dt.Rows)
{
string shortName = row["shortName"].ToString();
string url = "NDARview.aspx?shortName=";
string url2 = String.Format("window.open('{0}{1}','_blank');", url, shortName);
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), String.Format("key{0}", counter), url2, true);
counter++;
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
DataTable dt = NDAR.LoadFullDataStructureList("NDAR");
SaveAllDataStructures(dt);
}