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); }