protected void LoadGrid0()
{
//LogToPageUrgent("preparing to load gv");
try
{
Panel0.Controls.Clear();
GridView agv = new AutoGridView("data", "vwTadpoleTxLogs__CHECK_stacked", "gv0", false, "", "");
Label lbl = new Label(); lbl.Font.Bold = true; lbl.Text = "Check 'ByWeek' vs. 'BySubject' data"; lbl.Font.Size = 12;
Panel0.Controls.Add(lbl);
Panel0.Controls.Add(agv);
GridView agv2 = new AutoGridView("data", "vwTadpoleTxLogs__CHECK_mismatch_by_ID", "gv0a", false, "", "");
Label lbl2 = new Label(); lbl2.Font.Bold = true; lbl2.Text = "List of subjects with mismatches: "; lbl.Font.Size = 8;
if (agv2.Rows.Count > 0)
{
Panel0.Controls.Add(lbl2);
Panel0.Controls.Add(agv2);
}
}
catch (Exception exc)
{
LogToPageUrgent(exc.Message);
}
//Populate_GridView("GridView_02", "select * from tblGroup where studyID = " + _content_studyID.ToString());
}
protected void LoadGrid4()
{
//LogToPageUrgent("preparing to load gv");
//DropDownList ddlID = (DropDownList)FindControl("ddlID");
if (ddlID.SelectedValue == "<select ID>")
{
LogToPageUrgent("Select an ID to view.");
}
else
{
try
{
Panel4.Controls.Clear();
GridView agv = new AutoGridView("data", "vwSEC_Tadpole_TxHours_WKLY_ByID_TOTALS where ID = '" + ddlID.SelectedValue.ToString() + "' order by txweekof", "gv4", false, "",
"gvBlack,gvBlack,gvBlue,gvBlack,gvBlack,gvBlack,gvBlack,gvBlack,gvBlack,gvBlack,gvRed,gvDkRed,gvDkRed,gvDkRed");
Label lbl = new Label(); lbl.Font.Bold = true; lbl.Text = "Weekly Totals for ID: " + ddlID.SelectedValue.ToString(); lbl.Font.Size = 12;
Panel4.Controls.Add(lbl);
Panel4.Controls.Add(agv);
LoadGrid4b();
}
catch (Exception exc)
{
LogToPageUrgent(exc.Message);
}
//Populate_GridView("GridView_02", "select * from tblGroup where studyID = " + _content_studyID.ToString());
}
}
protected void LoadGrid2()
{
//LogToPageUrgent("preparing to load gv");
try
{
GridView agv = new AutoGridView("data", "vwTadpoleTxLogBySubj__List", "gv_vwTadpoleTxLogBySubj__List", false, "", "");
Panel2.Controls.Clear();
Panel2.Controls.Add(agv);
//SqlCommand sqlCmd = new System.Data.SqlClient.SqlCommand("select * from ALL_TadpoleTxLogBySubj order by ID, ttl_date ", oConnData);
//DataTable dt = new DataTable();
//SqlDataAdapter sqlAdapter = new SqlDataAdapter(sqlCmd);
//sqlAdapter.Fill(dt);
//GridView gv = new GridView();
//gv.ID = "gv2";
//gv.AutoGenerateColumns = true;
//gv.DataSource = dt;
//gv.DataBind();
//Label lbl = new Label(); lbl.Font.Bold = true; lbl.Text = ""; lbl.Font.Size = 12;
//Panel2.Controls.Add(lbl);
//Panel2.Controls.Add(gv);
}
catch (Exception)
{
//LogToPageUrgent(exc.Message);
}
//Populate_GridView("GridView_02", "select * from tblGroup where studyID = " + _content_studyID.ToString());
}
protected void Load_TadpoleRandomization()
{
//need to build a Form View with the same # of fields that looks like the GridView
// see: http://forums.asp.net/t/1800561.aspx
//
Label lblError = (Label)Master.FindControl("lblInfoLog_Error");
lblError.Text += "<br/>********* Load_TadpoleRandomization()";
GridView agv = new AutoGridView("backend", "vw_Randomization_Tadpole order by site, ID", "gv_Randomization_Tadpole", true, "",
",,,,,,,,,gvGray,gvGray,gvGray,gvGray");
//DataTable dt = oDBLookup.GetView("_AutoGrid_testtable");
// Session["dataTable"] = dt;
agv.RowEditing += new GridViewEditEventHandler(gv_Randomization_Tadpole_RowEditing);
agv.RowUpdating += new GridViewUpdateEventHandler(gv_Randomization_Tadpole_RowUpdating); /* <-- needs the buttons to have CausesValidation=false */
agv.RowCancelingEdit += new GridViewCancelEditEventHandler(gv_Randomization_Tadpole_RowCancelingEdit);
agv.RowCommand += new GridViewCommandEventHandler(gv_Randomization_Tadpole_RowCommand);
agv.FooterRow.BackColor = Color.SlateBlue;
//Panel1.Controls.Clear();
//Panel1.Controls.Add(agv);
UpdatePanel1.ContentTemplateContainer.Controls.Clear();
UpdatePanel1.ContentTemplateContainer.Controls.Add(agv);
//lblError.Text += "<br/> $$$ DataKeyNames = " + agv.DataKeyNames.ToString();
//lblError.Text += "<br/> $$$ DataKeyNames = " + agv.DataKeyNames[0].ToString();
}
protected void LoadMaxIDs()
{
string spSQL = "exec spGet_MaxID_by_Group " + Int32.Parse(selStudyID.SelectedValue.ToString());
GridView gv1 = new AutoGridView("backend", spSQL, "gv_maxID", false, "", "");
Panel_maxID.Controls.Clear();
Panel_maxID.Controls.Add(gv1);
}
protected void Page_Load(object sender, EventArgs e)
{
GridView agv = new AutoGridView("backend", "vwTadpolePATH__ADOS_Reliability_Status_TOTALS", "gv_vwTadpolePATH__ADOS_Reliability_Status_TOTALS", false, "",
"gvNavy,gvNavy,gvNavy,gvNavy,gvNavy,gvPurple,gvPurple,gvBlack,gvDkBlack,gvRed");
Panel1.Controls.Clear();
Panel1.Controls.Add(agv);
}
protected void LoadMaxIDs(int studyID)
{
string spSQL = "exec spGet_MaxID_by_Group " + studyID.ToString();
GridView gv1 = new AutoGridView("backend", spSQL, "gv_maxID", false, "", "");
Panel_maxID.Controls.Clear();
Panel_maxID.Controls.Add(gv1);
}
protected void LoadNDARcsv(string tbl)
{
string ndarcsv = "select ROW_NUMBER() over(order by datatable_pk) as rownum, * from " + tbl.Replace(".csv", "");
GridView gv1 = new AutoGridView("ndar", ndarcsv, "gv_Sites", false, "", "");
Panel_ndarcsv.Controls.Clear();
Panel_ndarcsv.Controls.Add(gv1);
}
protected void LoadMaxIDs()
{
try
{
string spSQL = "exec spGet_MaxID_by_Group " + Int32.Parse(cboStudyID.Value.ToString());
GridView gv1 = new AutoGridView("backend", spSQL, "gv_maxID", false, "", "");
Panel_maxID.Controls.Clear();
Panel_maxID.Controls.Add(gv1);
}
catch (Exception ex) {
string x = ex.Message;
}
}
//Populate the Subjects Gridview
protected void Populate_DeletedRecs_Gridview()
{
Panel1.Controls.Clear();
Panel1.Visible = true;
try
{
string sql = "select * from vwDeletedRecs order by deleted desc";
GridView DeletedRecs_gridview = new AutoGridView("data", sql, "SubjectDetails_gridview", false, "", "", "");
Panel1.Controls.Clear();
Panel1.Controls.Add(DeletedRecs_gridview);
#region ORIG version
//// here the cols are actually rows
//SqlCommand sqlCmd_GetSubj = new System.Data.SqlClient.SqlCommand("exec spSEC_PIVOT__RowEQ_Subject__Dynamic_Where " + " ''," + where_cols, oConn);
//DataTable dt_GetSubj = new DataTable();
//SqlDataReader SqlReader_GetSubj = sqlCmd_GetSubj.ExecuteReader();
//dt_GetSubj.Load(SqlReader_GetSubj);
////SqlDataAdapter sqlAdapter_GetSubj = new SqlDataAdapter(sqlCmd_GetSubj);
////sqlAdapter_GetSubj.Fill(dt_GetSubj);
//int num_subjects = dt_GetSubj.Rows.Count;
////build the Gridview & columns
//GridView SubjectDetails_gridview = new GridView();
//SubjectDetails_gridview.ID = "SubjectDetails_gridview";
//SubjectDetails_gridview.AutoGenerateColumns = true;
//SubjectDetails_gridview.CssClass = "tblinputsmall_blue";
////SubjectDetails_gridview.RowDataBound += new GridViewRowEventHandler(SubjStatus_Totals_gridview_RowDataBound);
////Bind the data
//SubjectDetails_gridview.DataSource = dt_GetSubj;
//SubjectDetails_gridview.DataBind();
//Panel_SubjectDetails.Controls.Add(SubjectDetails_gridview);
#endregion
}
catch (SqlException oException)
{
//errorLink1.InnerHtml += oException.Message; //new with full study
foreach (SqlError oErr in oException.Errors)
{
tblmyinfo.Rows[0].Cells[0].InnerHtml += oErr.Message;
}
}
}
protected void LoadIt()
{
//GridView it = new jmgv(oConn);
GridView gv1a = new AutoGridView("data", "select * from vwPATH_and_PATH_TX_subjects_summary where [PATH group]='MIND'");
GridView gv1b = new AutoGridView("data", "select * from vwPATH_and_PATH_TX_subjects_summary where [PATH group]='UW'");
Panel1a.Controls.Add(gv1a);
Panel1b.Controls.Add(gv1b);
GridView it = new AutoGridView("data", "select * from vwPATH_and_PATH_TX_subjects", "gv2", false,
"l,l,l,l,l,l,l,l,l,l,l", "gvBlack,gvBlack,gvBlack,gvBlack,gvBlack,gvBlue,gvBlue,gvBlue,gvBlack,gvBlack,gvRed"); //"black,black,black,black,black,blue,blue,blue,black,black,red");
Panel2.Controls.Add(it);
}
protected void loadgrid()
{
Panel_gv.Controls.Clear();
GridView agv = new AutoGridView("backend", "exec spSEC__GUIDstatus_by_studyID " + _content_studyID.ToString() + ", ''"
, "gv4", false, "l,l,l,l,hyp4,hide,l,l,l,l,l,l,l,hyp4,hide",
"gvBlack,gvBlack,gvBlack,gvBlack,gvBlue,gvBlue,gvDkRed,gvDkRed,gvDkRed,gvDkRed,gvBlack,gvBlack,gvBlack,gvBlue"
,""
, "");
Label lbl = new Label(); lbl.Font.Bold = true; lbl.Text = "<br/>NDAR GUID INFO" ; lbl.Font.Size = 12;
Panel_gv.Controls.Add(lbl);
Panel_gv.Controls.Add(agv);
}
protected void LoadGrid4b()
{
try {
Panel4b.Controls.Clear();
GridView agv2 = new AutoGridView("data", "vwTadpoleTxLogBySubj__List where ID = '" + ddlID.SelectedValue.ToString() + "' order by cast(date as date), [clin name]", "gv4b", false, "l,h",
"gvBlue,gvBlack,gvBlack,gvBlack,gvBlack,gvBlack,gvBlack,gvBlack,gvBlack,gvDkRed", ",https://uwac.autism.washington.edu/research/DataEntryForms/Common/TadpoleTXlog/TadpoleTXlog.aspx?pk=");
Label lbl2 = new Label(); lbl2.Font.Bold = true; lbl2.Text = "All entries for ID: " + ddlID.SelectedValue.ToString(); lbl2.Font.Size = 12;
Panel4b.Controls.Add(lbl2);
Panel4b.Controls.Add(agv2);
}
catch (Exception exc)
{
LogToPageUrgent(exc.Message);
}
}
protected void LoadGrid4b()
{
try {
Panel4b.Controls.Clear();
GridView agv2 = new AutoGridView("data", "vwTadpoleTxLogBySubj__List where ID = '" + ddlID.SelectedValue.ToString() + "' order by date, clinname", "gv4b", false, "",
"gvBlue,gvBlack,gvBlack,gvBlack,gvBlack,gvBlack,gvBlack,gvBlack,gvBlack,gvDkRed");
Label lbl2 = new Label(); lbl2.Font.Bold = true; lbl2.Text = "All entries for ID: " + ddlID.SelectedValue.ToString(); lbl2.Font.Size = 12;
Panel4b.Controls.Add(lbl2);
Panel4b.Controls.Add(agv2);
}
catch (Exception exc)
{
LogToPageUrgent(exc.Message);
}
}
protected void LoadGrid2()
{
//LogToPageUrgent("preparing to load gv");
try
{
Panel2.Controls.Clear();
GridView agv = new AutoGridView("data", "vwSEC_Tadpole_TxHours_GROUPxSITE_TOTALS", "gv2", false, "all_l",
"gvBlack,gvBlack,gvBlack,gvBlack,gvBlack,gvPurple,gvGray,gvBlack,gvBlack,gvBlack,gvBlack,gvRed,gvDkRed,gvDkRed,gvDkRed,gvBlack,gvBlack");
Label lbl = new Label(); lbl.Font.Bold = true; lbl.Text = "Overall Totals by Site & Group"; lbl.Font.Size = 12;
Panel2.Controls.Add(lbl);
Panel2.Controls.Add(agv);
}
catch (Exception exc)
{
LogToPageUrgent(exc.Message);
}
//Populate_GridView("GridView_02", "select * from tblGroup where studyID = " + _content_studyID.ToString());
}
protected void LoadGrid0()
{
//LogToPageUrgent("preparing to load gv");
try
{
Panel0.Controls.Clear();
GridView agv = new AutoGridView("data", "vwTadpoleTxLogs__CHECK_stacked", "gv0", false, "", "all_gvNavy");
Label lbl = new Label(); lbl.Font.Bold = true; lbl.Text = "Check 'ByWeek' vs. 'BySubject' data"; lbl.Font.Size = 12; lbl.ForeColor = Color.Navy;
Panel0.Controls.Add(lbl);
Panel0.Controls.Add(agv);
GridView agv2 = new AutoGridView("data", "vwTadpoleTxLogs__CHECK_mismatch_by_ID", "gv0a", false, "", "all_gvNavy");
Label lbl2 = new Label(); lbl2.Font.Bold = true; lbl2.Text = "<br/>List of subjects with mismatches: "; lbl2.Font.Size = 10; lbl2.ForeColor = Color.Navy;
if (agv2.Rows.Count > 0)
{
Panel0.Controls.Add(lbl2);
Panel0.Controls.Add(agv2);
}
GridView agv3 = new AutoGridView("data", "select * from vwSEC_TadpoleTxLog_PotentialDUPS_ForWEB order by weekA, weekB, ID, [date]", "gv0b", false, "l,l,l,l,l,l,l,l,l,hyp4,hide,hyp4,hide", "all_gvNavy");
Label lbl3 = new Label(); lbl3.Font.Bold = true; lbl3.Text = "<br/>List of potential duplicates: "; lbl3.Font.Size = 10; lbl3.ForeColor = Color.Navy;
if (agv3.Rows.Count > 0)
{
Panel0.Controls.Add(lbl3);
Panel0.Controls.Add(agv3);
}
else
{
lbl3.Text = "<br/>Hooray no duplicates!";
Panel0.Controls.Add(lbl3);
}
}
catch (Exception exc)
{
LogToPageUrgent(exc.Message);
}
//Populate_GridView("GridView_02", "select * from tblGroup where studyID = " + _content_studyID.ToString());
}
protected void LoadGrid1()
{
//LogToPageUrgent("preparing to load gv");
try
{
//SqlCommand sqlCmd = new System.Data.SqlClient.SqlCommand("select * from vwTadpoleTxLogs__CHECK_stacked ", oConnData);
//DataTable dt = new DataTable();
//SqlDataAdapter sqlAdapter = new SqlDataAdapter(sqlCmd);
//sqlAdapter.Fill(dt);
//GridView gv = new GridView();
//gv.ID = "gv1";
//gv.AutoGenerateColumns = true;
//gv.DataSource = dt;
//gv.DataBind();
GridView agv = new AutoGridView("data", "vwTadpoleTxLogs__CHECK_stacked", "gv0", false, "", "all_gvNavy");
Label lbl = new Label(); lbl.Font.Bold = true; lbl.Text = ""; lbl.Font.Size = 10;
Panel1.Controls.Add(lbl);
Panel1.Controls.Add(agv);
//show list of weeks with mismatch
GridView agv2 = new AutoGridView("data", "vwTadpoleTxLogs__CHECK_mismatch_by_ID", "gv0a", false, "", "all_gvNavy");
Label lbl2 = new Label(); lbl2.Font.Bold = true; lbl2.Text = "<br/>List of subjects with mismatches: "; lbl2.Font.Size = 10; lbl2.ForeColor = Color.Navy;
if (agv2.Rows.Count > 0)
{
Panel1.Controls.Add(lbl2);
Panel1.Controls.Add(agv2);
}
}
catch (Exception exc)
{
//LogToPageUrgent(exc.Message);
}
//Populate_GridView("GridView_02", "select * from tblGroup where studyID = " + _content_studyID.ToString());
}
protected void LoadIt()
{
////GridView it = new jmgv(oConn);
//GridView gv0a = new AutoGridView("backend", "select * from vwTadpole_details_1");
//Panel0a.Controls.Add(gv0a);
//GridView gv1a = new AutoGridView("data", "select * from vwTadpole_and_Tadpole_TX_subjects_summary where [Site]='MIND'");
//GridView gv1b = new AutoGridView("data", "select * from vwTadpole_and_Tadpole_TX_subjects_summary where [Site]='UW'");
//GridView gv1c = new AutoGridView("data", "select * from vwTadpole_and_Tadpole_TX_subjects_summary where [Site]='VU'");
//Panel1a.Controls.Add(gv1a);
//Panel1b.Controls.Add(gv1b);
//Panel1b.Controls.Add(gv1c);
GridView it = new AutoGridView("data", "select * from vwTadpole_and_Tadpole_TX_subjects", "gv2", false,
"l,l,l,l,l,l,l,l,l,l,l,l,l,l,l,l", "gvBlack,gvBlack,gvBlack,gvBlack,gvBlack,gvBlack,gvBlack,gvBlue,gvBlue,gvBlue,gvBlack,gvBlack,gvBlack,gvPurple,gvPurple,gvPurple,gvPurple,gvPurple,gvRed"); //"black,black,black,black,black,blue,blue,blue,black,black,red");
Panel2.Controls.Add(it);
}
protected void BuildLegendTable()
{
GridView agv = new AutoGridView("backend", "vwDBrole_Pivoted", "gv0", false, "all_l", "gvBlack,gvBlueViolet,gvSkyblue,gvRoyalBlue,gvOrange,gvRed,gvLime,gvTeal");
Panel_LegendTable.Controls.Add(agv);
}
protected void Load_DescStats()
{
//Label lblError = (Label)Master.FindControl("lblInfoLog_Error");
//lblError.Text += "<br/>********* Load_TadpoleRandomization()<br/>";
GridView gv0 = new AutoGridView("backend", "vwTadpole_Sites__Crosstabs order by site", "gv_Cross", false, "", "");
Panel_Cross.Controls.Clear();
Panel_Cross.Controls.Add(gv0);
GridView gv0b = new AutoGridView("backend", "vwTadpole_Sites__Crosstabs2 order by txgroup", "gv_Cross2", false, "", "");
Panel_Cross2.Controls.Clear();
Panel_Cross2.Controls.Add(gv0b);
GridView gv1 = new AutoGridView("backend", "vwTadpole_Sites__DescStats order by site", "gv_Sites", false, "", "");
Panel_Sites.Controls.Clear();
Panel_Sites.Controls.Add(gv1);
GridView gv2 = new AutoGridView("backend", "vwTadpole_Groups__DescStats order by TxGroup", "gv_Groups", false, "", "");
Panel_Groups.Controls.Clear();
Panel_Groups.Controls.Add(gv2);
GridView gv3a = new AutoGridView("backend", "vwTadpole_Groups__DescStats_SiteByGroup order by Site,TxGroup", "gv_3a", false, "", "");
Panel3a.Controls.Clear();
Panel3a.Controls.Add(gv3a);
GridView gv3b = new AutoGridView("backend", "vwTadpole_Groups__DescStats_SiteByGroup order by TxGroup, Site", "gv_3b", false, "", "");
Panel3b.Controls.Clear();
Panel3b.Controls.Add(gv3b);
//DETAILS
SQL_utils sql = new SQL_utils();
int n1 = sql.IntScalar_from_SQLstring("select count(*) as n from uwautism_research_backend..vw_Randomization_Tadpole where TxGroup is not null");
int n2 = sql.IntScalar_from_SQLstring("select count(*) as n from uwautism_research_backend..vw_Randomization_Tadpole where TxGroup is null");
GridView gvDetails = new AutoGridView("backend", "vw_Randomization_Tadpole where TxGroup is not null order by Site, ID", "gvDetails", false, "", "");
Label lbl1 = new Label();
lbl1.Text = "Randomized Subjects (N = " + n1.ToString() + ")<br/>";
lbl1.Font.Bold = true; lbl1.Font.Size = 12;
Panel_Details.Controls.Clear();
Panel_Details.Controls.Add(lbl1);
Panel_Details.Controls.Add(gvDetails);
GridView gvDetails2 = new AutoGridView("backend", "vw_Randomization_Tadpole where TxGroup is null order by Site, ID", "gvDetails2", false, "", "");
Label lbl2 = new Label();
lbl2.Text = "Subjects Not Randomized (N = " + n2.ToString() + ")<br/>";
lbl2.Font.Bold = true; lbl2.Font.Size = 12;
Panel_Details2.Controls.Clear();
Panel_Details2.Controls.Add(lbl2);
Panel_Details2.Controls.Add(gvDetails2);
}
