/* 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 Page_Load(object sender, EventArgs e)
{
Debug.WriteLine(String.Format("Page_Load IsPostBack:{0} IsCallback:{1}", IsPostBack, IsCallback));
//LoadSubjects();
LoadREDCapMeasures();
LoadlinkedTables();
redcap = new REDCap(Master.Master_studyID);
//ASPxComboBox cbo = redcap.cboFormSelector();
ASPxListBox lst = redcap.lstFormSelector();
//if (lst != null)
//{
// lst.EnableViewState = true;
// //placeholder_cboForms.Controls.Add(cbo);
// placeholder_cboForms.Controls.Add(lst);
// panelREDCap_controls.Visible = true;
//}
//else {
// panelREDCap_controls.Visible = false;
//}
LoadlinkedTables();
//btnImportMeta.Visible = false;
if (IsCallback)
{
//if (Session["redcap_metadata"] != null)
//{
// gridREDCap.DataSource = (DataTable)Session["redcap_metadata"];
// gridREDCap.DataBind();
//}
}
if (panel.IsCallback)
{
//LoadFormData();
}
//Load the comparison between selected measure and Redcap
CompareLinkedRedcap();
}
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);
}
}
}
protected void CompareLinkedRedcap()
{
if (cboMeas.Value != null)
{
int measureID = Convert.ToInt32(cboMeas.Value.ToString());
Datadictionary dict = new Datadictionary(measureID);
REDCap redcap = new REDCap(Master.Master_studyID);
DataTable foo = redcap.dt_metadata;
var x =
from a in dict.dt_dict.AsEnumerable()
join b in redcap.dt_metadata.AsEnumerable() on a.Field <string>("fldname_in_redcap").ToLower() equals b.Field <string>("field_name").ToLower()
into ab
from b in ab.DefaultIfEmpty()
select new
{
ord_pos = a.Field <double>("ord_pos"),
fldname = a.Field <string>("fldname").ToLower(),
fldlabel = a.Field <string>("fieldlabel"),
redcap_formname = (b == null) ? null : b.Field <string>("form_name"),
redcap_fldname = (b == null) ? null : b.Field <string>("field_name"),
redcap_fldlabel = (b == null) ? null : b.Field <string>("field_label")
};
DataTable dtMerged = x.CustomCopyToDataTable();
if (dtMerged.HasRows())
{
gridMerged.DataSource = dtMerged;
gridMerged.SettingsPager.PageSize = 200;
gridMerged.DataBind();
gridMerged.Caption = "Matched Fields between DB & REDCap: " + cboMeas.Text;
panelMerged.Visible = true;
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
Debug.WriteLine(String.Format("Page_Load IsPostBack:{0} IsCallback:{1}", IsPostBack, IsCallback));
GridViewDataComboBoxColumn cbo = ((GridViewDataComboBoxColumn)gv_Redcap_FormEvent.Columns["studymeasid"]);
cbo.PropertiesComboBox.DataSource = GetStudymeasids();
//LoadSubjects();
LoadREDCapMeasures();
LoadlinkedTables();
redcap = new REDCap(Master.Master_studyID);
//ASPxComboBox cbo = redcap.cboFormSelector();
ASPxListBox lst = redcap.lstFormSelector_with_studymeasID();
ASPxComboBox cboForms = redcap.cboFormSelector();
if (cboForms != null)
{
cboForms.SelectedIndexChanged += cboForm_OnSelectedIndexChanged;
cboForms.ID = "cboForms";
placeholder.Controls.Add(cboForms);
//tab_import_fields.Controls.Add(cboForms);
}
if (lst != null)
{
lst.EnableViewState = true;
//placeholder_cboForms.Controls.Add(cbo);
placeholder_cboForms.Controls.Add(lst);
panelREDCap_controls.Visible = true;
}
else
{
panelREDCap_controls.Visible = false;
}
LoadlinkedTables();
if (IsCallback)
{
//if (Session["redcap_metadata"] != null)
//{
// gridREDCap.DataSource = (DataTable)Session["redcap_metadata"];
// gridREDCap.DataBind();
//}
}
if (panel.IsCallback)
{
//LoadFormData();
}
//Load the comparison between selected measure and Redcap
CompareLinkedRedcap();
}
