/* IMPORT THE DATA */
protected void ImportREDCapToDB()
{
string info;
DateTime startupload = DateTime.Now;
info = String.Format("Begin. {0}<br/>", startupload.ToString());
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();
DataImporter importer = new DataImporter(ID, studymeasID, formnames);
info += importer.ResultsToString();
}
double timeelapsed = Math.Round((DateTime.Now - startupload).TotalSeconds, 2);
info += String.Format("<br/> End. {0} total seconds.", timeelapsed);
DisplayImporterResults(info);
}
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);
}
}
}