protected void LoadNDARview(string shortName, string studymeasIDs)
{
int studyID = sql.GetUserStudyID();
string IDexclude = txtIDexclude.Text;
try
{
gvNDARview.DataSource = null;
DataTable dt = NDAR.GetNDAR_view(shortName, studyID, IDexclude, studymeasIDs);
if (dt.Rows.Count > 0)
{
Session["NDARview"] = dt;
gridNDARview.DataSource = dt;
gridNDARview.DataBind();
gridNDARview.Visible = true;
gridNDARview.Columns[0].FixedStyle = DevExpress.Web.GridViewColumnFixedStyle.Left;
gridNDARview.Columns[1].FixedStyle = DevExpress.Web.GridViewColumnFixedStyle.Left;
gridNDARview.Columns[2].FixedStyle = DevExpress.Web.GridViewColumnFixedStyle.Left;
gridNDARview.Columns[3].FixedStyle = DevExpress.Web.GridViewColumnFixedStyle.Left;
gridNDARview.Columns[4].FixedStyle = DevExpress.Web.GridViewColumnFixedStyle.Left;
//count rows where reason_exclude is not null
int n_reason_exclude_NotNull = dt.AsEnumerable().Where(f => f.Field <string>("reason_exclude") != "").Count();
int n_reason_exclude_IsNull = dt.Rows.Count - n_reason_exclude_NotNull;
v5.Text = dt.Rows.Count.ToString();
v5.ForeColor = Color.Navy;
v6.Text = n_reason_exclude_IsNull.ToString();
v6.ForeColor = Color.Navy;
v7.Text = n_reason_exclude_NotNull.ToString();
v7.ForeColor = Color.DarkRed;
}
else
{
gvNDARview.Visible = false;
v5.Text = "This query returned 0 records.";
v5.ForeColor = Color.Red;
}
}
catch (Exception ex)
{
//To show the query
string sqlout = NDAR.GetSQL_for_NDAR_view(shortName, studyID, IDexclude, studymeasIDs);
lblInfo.Text = ex.Message + "<br/><br/>" + sqlout;
//string sqlout = NDAR.GetSQL_for_NDAR_studymeas_to_include(shortName, studyID, 0);
//lblInfo.Text = "<br/><br/>" + sqlout;
}
}
protected string SaveNDARCSV(string shortName, string IDexclude, string studymeasIDs, string filename, int studyID)
{
bool savedCSV = false;
DataTable dt = NDAR.GetNDAR_view(shortName, studyID, 0, false, IDexclude, studymeasIDs);
dt.TableName = shortName;
if (dt.HasRows())
{
string filename_result = SpreadsheetGearUtils.WriteDataTableAsCSV(dt, filename, "csv", true);
filename_result += String.Format("|{0}", dt.Rows.Count);
return(filename_result);
}
else
{
return(String.Format("ERROR: No rows for {0}|0", shortName));
}
}
protected void btnSaveNDARCSV_Click(object sender, EventArgs e)
{
UpdatePanel_O_CheckBoxes p = (UpdatePanel_O_CheckBoxes)panelStudymeas.FindControlRecursive("studymeasID");
string studymeasIDs = p.GetChecked_as_CSV();
string shortName = Request.QueryString["shortName"];
int studyID = sql.GetUserStudyID();
string studyname = sql.GetUserStudyName();
string IDexclude = txtIDexclude.Text;
DataTable dt = NDAR.GetNDAR_view(shortName, studyID, 0, false, IDexclude, studymeasIDs);
dt.TableName = shortName;
string now = DateTime.Now.ToString("yyyyMMdd__HH_mm");
string filename = studyname + "_" + shortName + "_" + now;
SpreadsheetGearUtils.SaveDataTableToFile(dt, filename, "csv", true);
}