//protected void DeleteRecs(object sender, EventArgs e)
//{
// string ID = cboSubject.Value.ToString();
// int studymeasID = Convert.ToInt32(cboStudymeas.Value.ToString());
// DataImporter importer = new DataImporter(ID, studymeasID);
// importer.DeleteRecs();
// Response.Redirect(Request.Url.AbsolutePath);
//}
#region Get RED Cap Data
protected void btnLoadFormData_OnClick(object sender, EventArgs e)
{
Debug.WriteLine("*************** btnLoadFormData_OnClick");
List <string> formnames = GetSelectedFormnames();
if (formnames.Count > 0)
{
placeholder_gridMeta.Controls.Clear();
for (int i = 0; i < formnames.Count; i++)
{
SQL_utils sql = new SQL_utils("data");
bool commit_to_DB = chkSaveToDB.Checked;
REDCapDataImport rcdata = new REDCapDataImport(redcap, formnames[i], Master.Master_studyID, commit_to_DB);
ASPxLabel lbllog = new ASPxLabel();
lbllog.EncodeHtml = false;
lbllog.Text = rcdata.resultslog.LogNotesToHtml();
//foreach (string s in rcdata.resultslog)
// {
// lbllog.Text += s + "</br/>";
//}
placeholder_gridMeta.Controls.Add(lbllog);
DataTable foo = redcap.DataFromForm(formnames[i]);
bool has_id = (foo.ContainsColumnName("id"));
if (has_id)
{
DataTable foo2 = foo.AsEnumerable().Where(f => f.Field <string>("id") != "").CopyToDataTable();
}
ASPxGridView grid = redcap.gridDataFromForm(formnames[i], true);
if (grid != null)
{
grid.SettingsPager.PageSize = 200;
ASPxLabel lbl = new ASPxLabel();
lbl.Font.Bold = true;
lbl.EncodeHtml = false;
lbl.Text = String.Format("<br/><br/>{0}", formnames[i]);
placeholder_gridMeta.Controls.Add(lbl);
placeholder_gridMeta.Controls.Add(grid);
}
}
lblNoneSelected.Text = "";
}
else
{
lblNoneSelected.Text = "Select a REDCap form.";
}
}
protected void btnShowREDCap_OnClick(object sender, EventArgs e)
{
string ID = cboSubject.Value.ToString();
int studymeasID = Convert.ToInt32(cboStudymeas.Value.ToString());
REDCap redcap = new REDCap(Master.Master_studyID);
if (redcap.IsREDCapMeasure(studymeasID))
{
DataTable dt_forms = DataImporter.LinkedREDCapForms(Master.Master_studyID, studymeasID, DbEntityType.studymeas);
List <string> formnames = dt_forms.AsEnumerable().Select(f => f.Field <string>("form_name")).ToList();
ASPxGridView grid = redcap.gridDataFromForm(formnames);
if (grid != null)
{
placeholder_REDCap_data.Controls.Clear();
placeholder_REDCap_data.Controls.Add(grid);
}
}
}
