protected void btnSaveCSV_Click(object sender, EventArgs e)
{
string shortName = Request.QueryString["shortName"];
NDAR.NDAR_DataStructure ds = NDAR.GetNDARDataStructure(shortName);
DataTable dt = NDAR.NDARDataStructureElements_to_DataTable(ds);
dt.TableName = "csv";
SpreadsheetGearUtils.SaveDataTableToFile(dt, "testit", "csv");
}
protected int LoadDataStructureInfo(string shortName)
{
int return_value = 0;
//Don't need to retrieve all the DSE yet.
//DataTable dt = NDAR.NDAR_DSE_from_DB(shortName);
//instead, just get the count of DSE
int n_dse = NDAR.Get_Count_NDAR_DSE_from_DB(shortName);
if (shortName != "")
{
string source = "UWAC DB";
NDAR.NDAR_DataStructure ds = NDAR.GetNDARDataStructure(shortName);
if (ds == null)
{
return_value++;
lblInfo.Text = "**ERROR** '" + shortName + "' is inaccessible from the NDAR API.<br/>";
}
//Get the associated table
string uwtable = sql.StringScalar_from_SQLstring("select coalesce(uwtable, 'NONE') uwtable from NDAR_DS where shortname = '" + shortName + "'");
if (uwtable == null)
{
return_value++;
lblInfo.Text += "**ERROR** No linked UW table found for '" + shortName + "'.<br/>";
}
v0.Text = sql.GetUserStudyName();
v1.Text = shortName;
v2.Text = (ds != null) ? ds.title : "";
v3.Text = n_dse.ToString();
v4.Text = source;
return(return_value);
}
else
{
return(0);
}
}
//protected void btnSave_Click(object sender, EventArgs e)
//{
// DataTable dt = NDAR.LoadFullDataStructureList("NDAR");
// SaveAllDataStructures(dt);
//}
//protected void SaveAllDataStructures(DataTable dt)
//{
// SQL_utils sql = new SQL_utils();
// SqlParameter p = sql.CreateParam("NDAR_DS", dt);
// sql.NonQuery_from_ProcName("spNDAR_Insert_DS", p);
//}
protected void gvScroll_RowCommand(object sender, GridViewCommandEventArgs e)
{
//save DSE here
if (e.CommandName == "Import flds")
{
NDAR.NDAR_DataStructure ds = NDAR.GetNDARDataStructure(e.CommandArgument.ToString());
DataTable dse = NDAR.NDARDataStructureElements_to_DataTable(ds);
//lblInfo.Text = "nrow = {" + dse.Rows.Count.ToString() + "}";
SQL_utils sql = new SQL_utils();
SqlParameter p = sql.CreateParam("NDAR_DSE", dse);
sql.NonQuery_from_ProcName("spNDAR_Insert_DSE", p);
//GridView gv_Fields = new GridView();
//gv_Fields.DataSource = dse;
//gv_Fields.DataBind();
//Panel_dataElements.Controls.Add(gv_Fields);
//Panel_dataElements.Visible = true;
}
}
protected void LoadDataStructure(string shortName)
{
SQL_utils sql = new SQL_utils("data");
string source = "UWAC DB";
NDAR.NDAR_DataStructure ds = NDAR.GetNDARDataStructure(shortName);
DataTable dt = NDAR.NDAR_DSE_from_DB(shortName);
//Get the associated table
string uwtable = sql.StringScalar_from_SQLstring("select coalesce(uwtable, 'NONE') uwtable from NDAR_DS where shortname = '" + shortName + "'");
if (dt.Rows.Count == 0)
{
dt = NDAR.NDARDataStructureElements_to_DataTable(ds);
source = "NDAR";
}
v1.Text = ds.shortName;
v2.Text = ds.title;
v3.Text = ds.dataElements.Count.ToString();
v4.Text = source;
string ndar_datadict_string = @"https://ndar.nih.gov/ndar_data_dictionary.html?short_name=" + shortName;
//linkNDAR_DataDict.PostBackUrl = ndar_datadict_string;
//linkNDAR_DataDict.Text = shortName;
dynLink.NavigateUrl = ndar_datadict_string;
dynLink.Text = shortName;
Session["ndar_dataElements"] = dt;
griddataElements.DataSource = dt;
griddataElements.DataBind();
if (uwtable != "NONE")
{
LoadUWfields(uwtable);
ddlUWtables.Visible = false;
btnShowUWtable.Visible = false;
btnLinkUWtable.Visible = false;
LoadMatchedFlds(shortName);
}
else
{
Panel_UWtable.Visible = false;
}
//List<SqlParameter> ps = new List<SqlParameter>();
//ps.Add(sql.CreateParam("shortname", shortName, "text"));
//ps.Add(sql.CreateParam("mode", "count", "text"));
//DataTable dt_uwflds = sql.DataTable_from_ProcName("def.spNDAR_matching_UWflds", ps);
//GridView gv = new GridView();
//gv.DataSource = dt_uwflds;
//gv.DataBind();
//panel_UWfldsinfo.Controls.Add(gv);
sql.Close();
}