protected void btnGetAddresses_Click(object sender, EventArgs e) { UpdatePanel_O_CheckBoxes p = (UpdatePanel_O_CheckBoxes)panelChk.FindControl("study1"); string studies = p.GetChecked_as_CSV(); SQL_utils sql = new SQL_utils("backend"); List <SqlParameter> ps = new List <SqlParameter>(); ps.Add(sql.CreateParam("studies", studies, "text")); DataTable dt = sql.DataTable_from_ProcName("spTracking_Subj_AddressList", ps); dt.TableName = "Subject Addresses"; string datenow = DateTime.Now.Year.ToString() + ((DateTime.Now.Month < 10) ? "0" : "") + DateTime.Now.Month.ToString() + ((DateTime.Now.Day < 10) ? "0" : "") + DateTime.Now.Day.ToString(); string hrminnow = ((DateTime.Now.Hour < 10) ? "0" : "") + DateTime.Now.Hour.ToString() + ((DateTime.Now.Minute < 10) ? "0" : "") + DateTime.Now.Minute.ToString(); string filename = "UWAC_Subject_Addresses_" + datenow + "_" + hrminnow; //TODO SpreadsheetGearUtils.SaveDataTableToExcel(dt, filename, "xlsx"); }
protected void btnCreateExcel_Click(object sender, EventArgs e) { DataTable dt = GetAddressData(); string datetxt = SpreadsheetGearUtils.DateTime_for_filename(); SpreadsheetGearUtils.SaveDataTableToExcel(dt, Master.Master_studyname + "_Addresses_" + datetxt, true, "xlsx"); }
protected void ExportDictionaryForNDAR(int measureID) { Datadictionary dict = new Datadictionary(measureID); if (dict.dt_ndardict.HasRows()) { string dictfilename = String.Format("{0}_definitions", dict.measname); dict.dt_ndardict.TableName = dictfilename; SpreadsheetGearUtils.SaveDataTableToExcel(dict.dt_ndardict, dictfilename); } }
protected void GetInfo(string infotype, string sqlproc) { SQL_utils sql = new SQL_utils("backend"); // Create a DataTable of the selected studies DataTable dt = new DataTable(); dt.Columns.Add("fld", typeof(string)); dt.Columns.Add("value", typeof(int)); int counter = 0; foreach (ListItem li in lstStudies.Items) { counter++; lblInfo.Text += ", " + counter.ToString(); if (li.Selected) { DataRow r = dt.NewRow(); r["fld"] = "studyID"; r["value"] = Convert.ToInt16(li.Value); dt.Rows.Add(r); lblInfo.Text += "SELECTED"; } } ViewState["SelectedStudies"] = dt; if (dt.Rows.Count > 0) { SqlParameter p = sql.CreateParam("studies", dt); DataTable info = sql.DataTable_from_ProcName(infotype, p); //ShowSelectedStudies(mailing); SpreadsheetGearUtils.SaveDataTableToExcel(info, "mailing", true, "xlsx"); } else { lblInfo.Text = "0 records in data table."; } }
protected void btnGetIDList_Click(object sender, EventArgs e) { int labID = Convert.ToInt32(ddlLab.SelectedValue.ToString()); if (labID > 0) { SQL_utils sql = new SQL_utils("backend"); List <SqlParameter> ps = new List <SqlParameter>(); ps.Add(sql.CreateParam("labID", labID.ToString(), "int")); ps.Add(sql.CreateParam("study_csv", "all", "text")); DataTable dt = sql.DataTable_from_ProcName("spCode6_person_by_Lab", ps); string filename = "code6_IDs_" + SpreadsheetGearUtils.DateTime_for_filename(); SpreadsheetGearUtils.SaveDataTableToExcel(dt, filename, true, "csv"); sql.Close(); } }
protected void btnDownload_Click(object sender, EventArgs e) { DataTable dt = GetActionsTables(); SpreadsheetGearUtils.SaveDataTableToExcel(dt, "Actions_list_" + Master.Master_studyname); }
protected void ShowCode6Wide() { int labID = Convert.ToInt32(ddlLab.SelectedValue.ToString()); if (labID > 0) { //var x = lstStudy.SelectedValue; var x2 = gridStudy.GetSelectedFieldValues("studyID"); if (x2.Count == 0) //if (lstStudy.SelectedValue == "") { lblSelectOne.Text = "Select some studies."; lblSelectOne.Visible = true; } else if (chkDisplayOnPage.Checked == false && chkXLSX.Checked == false) { lblSelectOne.Text = "Select the output method."; lblSelectOne.Visible = true; } else { SQL_utils sql = new SQL_utils("backend"); string study_csv = String.Join(",", x2); List <SqlParameter> ps = new List <SqlParameter>(); ps.Add(sql.CreateParam("labID", labID.ToString(), "int")); //ps.Add(sql.CreateParam("study_csv", lstStudy.SelectedValue, "text")); ps.Add(sql.CreateParam("study_csv", study_csv, "text")); DataTable dt = sql.DataTable_from_ProcName("spCode6_person_by_Lab", ps); PivotTable pivotTable = utilPivotTable.DataTable_to_PivotTable(dt, new List <string> { "code6" }, new List <string> { "source_of_ID" }, "ID", new List <utilPivotTable.AggrFx> { utilPivotTable.AggrFx.Concat2 }); lblSelectOne.Visible = false; if (chkDisplayOnPage.Checked == true) { //Write back to page var htmlResult = new StringWriter(); var pvtHtmlWr = new PivotTableHtmlWriter(htmlResult); pvtHtmlWr.TotalsColumn = false; pvtHtmlWr.TotalsRow = false; pvtHtmlWr.GrandTotal = false; pvtHtmlWr.Write(pivotTable); Literal xtab = new Literal(); xtab.Text = htmlResult.ToString(); panel_wide.Controls.Add(xtab); } if (chkXLSX.Checked == true) { var dataTblWr = new PivotTableDataTableWriter("Test"); //.Write(pivotTable); var tbl = dataTblWr.Write(pivotTable); string filename = "code6_IDs_wide_" + SpreadsheetGearUtils.DateTime_for_filename(); SpreadsheetGearUtils.SaveDataTableToExcel(tbl, filename, true, "xlsx"); } sql.Close(); } } }