protected void SaveIntHxCharts_for_study(object sender, EO.Web.ProgressTaskEventArgs e)
{
SQL_utils sql = new SQL_utils();
Debug.WriteLine(" here in SaveIntHxCharts_for_study");
panelProgressBar.Visible = true;
DataTable dt = GetIDs(Master.Master_studyID);
int max = dt.Rows.Count;
int counter = 0;
foreach (DataRow row in dt.Rows)
{
string id = row["id"].ToString();
if (counter <= max + 1)
{
if (e.IsStopped)
{
break;
}
float pct = (float)counter / (float)max * 100;
e.UpdateProgress((int)pct, id);
if (counter >= 0)
{
int maxy = -999;
if (string.IsNullOrWhiteSpace(txtMaxY.Text))
{
maxy = -999;
}
else
{
maxy = Convert.ToInt16(txtMaxY.Text);
}
Debug.WriteLine("MAKE CHART " + counter.ToString());
//utilIntHx.SaveIntHxCharts(sql, Master.Master_studyID, id, Server.MapPath("~/stats/charts/"), rblPeriodType.SelectedValue, maxy);
utilIntHx.SaveIntHxCharts(sql, Master.Master_studyID, id, Server.MapPath("~/stats/charts/"), "Timepoint", maxy);
if (Master.Master_studyIDfull == 90000)
{
utilIntHx.SaveIntHxCharts(sql, Master.Master_studyID, id, Server.MapPath("~/stats/charts/"), "TxStart", maxy);
}
}
}
counter++;
}
e.UpdateProgress(100, "Complete.");
panelChart.Visible = true;
sql.Close();
}
protected void getDATADates_for_subjects_with_PROGRESS(object sender, EO.Web.ProgressTaskEventArgs e)
{
string mode = rblMode.SelectedValue;
DataTable dt_subj = new DataTable();
SQL_utils sql = new SQL_utils("backend");
int ddl_subjID = Convert.ToInt32(ddlNewID.SelectedValue);
string ID = sql.StringScalar_from_SQLstring("select ID from uwautism_research_backend..tblSubject where subjID=" + ddl_subjID.ToString());
if (mode == "single")
{
if (ddl_subjID > 0)
{
dt_subj = sql.DataTable_from_SQLstring("select subjID, ID + ' ' + groupname + ' ' + (case when studyID=1065 then coalesce('('+txgrp + ') ',' ') else ' ' end) + subjstatus + ' ' + coalesce(subjstatusdetail, '') as IDtxt " +
" from vwMasterStatus_S_txgrp where studyID=" + Master.Master_studyID.ToString() + " and subjID=" + ddl_subjID.ToString());
}
}
else if (mode == "ToDo" | mode == "Complete" | mode == "NeedFUP")
{
string s;
s = "select subjID, '[' + datachk + '] ' + ID + " +
" ' ' + groupname + ' ' + (case when studyID=1065 then coalesce('('+txgrp + ') ',' ') else ' ' end) + subjstatus + ' ' + coalesce(subjstatusdetail, '') as IDtxt " +
" from uwautism_research_backend..vwMasterStatus_S_txgrp where studyID = " + Master.Master_studyID.ToString() + " and datachk='" + mode + "' order by 2";
dt_subj = sql.DataTable_from_SQLstring(s);
}
else if (mode == "Active,Finished")
{
string s;
s = "select subjID, '[' + datachk + '] ' + ID + " +
" ' ' + groupname + ' ' + (case when studyID=1065 then coalesce('('+txgrp + ') ',' ') else ' ' end) + subjstatus + ' ' + coalesce(subjstatusdetail, '') as IDtxt " +
" from uwautism_research_backend..vwMasterStatus_S_txgrp where studyID = " + Master.Master_studyID.ToString() + " and subjstatus in ('Active','Finished') order by 2";
dt_subj = sql.DataTable_from_SQLstring(s);
}
else if (mode == "NOT Active,Finished")
{
string s;
s = "select subjID, '[' + datachk + '] ' + ID + " +
" ' ' + groupname + ' ' + (case when studyID=1065 then coalesce('('+txgrp + ') ',' ') else ' ' end) + subjstatus + ' ' + coalesce(subjstatusdetail, '') as IDtxt " +
" from uwautism_research_backend..vwMasterStatus_S_txgrp where studyID = " + Master.Master_studyID.ToString() + " and subjstatus NOT in ('Active','Finished') order by 2";
dt_subj = sql.DataTable_from_SQLstring(s);
}
sql.Close();
panelProgressBar.Visible = true;
int counter = 0;
float max = (float)dt_subj.Rows.Count;
foreach (DataRow row in dt_subj.Rows)
{
if (counter < 100)
{
string subjID = row["subjID"].ToString();
string title = row["IDtxt"].ToString();
getDATADates_by_Subject(subjID, false, title);
float pct = (float)counter / (float)max * 100;
e.UpdateProgress((int)pct);
}
counter++;
}
}