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++; } }