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