protected void btnNew_OnCLick(object sender, EventArgs e)
{
SQL_utils sql = new SQL_utils("backend");
List <SqlParameter> ps = new List <SqlParameter>();
string measname = txtName.Value.ToString();
ps.Add(sql.CreateParam("measname", txtName.Value.ToString(), "text"));
ps.Add(sql.CreateParam("measfullname", txtNameFull.Value.ToString(), "text"));
ps.Add(sql.CreateParam("newmeasureID", "0", "int", "output"));
int newmeasID = 0;
try
{
newmeasID = sql.NonQuery_from_ProcName("trk.spStudyDesign__CreateNewMeasure", ps, "newmeasureID");
}
catch (Exception ex)
{
}
if (newmeasID > 0)
{
lblNewMeasName.Text = measname;
panelMeasure.Visible = false;
panelTable.Visible = true;
hidNewMeasID.Value = newmeasID.ToString();
}
sql.Close();
}
public static string UpdateFTEx(string p1, string p2, string p3, string p4, string colIndex, string mode)
{
double newsubtotal = 0;
double fte;
Double.TryParse(p4, out fte);
if (fte >= 0)
{
SQL_utils sql = new SQL_utils("backend");
List <SqlParameter> ps = new List <SqlParameter>();
ps.Add(sql.CreateParam("idnbr", p1, "text"));
ps.Add(sql.CreateParam("budgetNbr", p2, "text"));
ps.Add(sql.CreateParam("mo", p3, "text"));
ps.Add(sql.CreateParam("calcFTE", p4, "float"));
ps.Add(sql.CreateParam("mode", mode, "text"));
newsubtotal = sql.DoubleScalar_from_ProcName("fin.spFTE_FutureMo_UPDATE", ps);
//sql.NonQuery_from_ProcName("fin.spFTE_FutureMo_UPDATE", ps);
sql.Close();
}
string output = string.Format("{0},{1},{2}", p2, colIndex, newsubtotal);
return(output);
}
protected void btnDeleteStaffFromBudget_Click(object sender, EventArgs e)
{
string staff = ddlStaff.SelectedValue;
if (utilSelect2.numselected(selBudgets) == 1 & ddlStaff.SelectedValue != "--select specific staff to edit--")
{
SQL_utils sql = new SQL_utils("backend");
List <SqlParameter> ps = new List <SqlParameter>();
ps.Add(sql.CreateParam("FirstMiddleLastName", staff, "text"));
ps.Add(sql.CreateParam("budgetNbr", utilSelect2.getselected_ListVal(selBudgets)[0], "text"));
sql.NonQuery_from_ProcName("fin.spFTE_FutureMo_DELETE", ps);
sql.Close();
}
else
{
string err = "";
if (ddlStaff.SelectedValue == "--select specific staff to edit--")
{
err += " Select a staff member.";
}
if (utilSelect2.numselected(selBudgets) != 1)
{
err += " Select a sinlgle budget.";
}
lblError.Text = err;
lblError.Visible = true;
ToggleVisibility("none");
}
}
protected void GetRptData(string d1, string d2, Panel panel)
{
panel.Controls.Clear();
SQL_utils sql = new SQL_utils("backend");
List <SqlParameter> ps = new List <SqlParameter>();
ps.Add(sql.CreateParam("d1", d1, "date"));
ps.Add(sql.CreateParam("d2", d2, "date"));
DataSet ds = sql.DataSet_from_ProcName("ac.spValant_CHDD_annual_report", ps);
foreach (DataTable dt in ds.Tables)
{
GridView gv = new GridView();
//Grid gv = new Grid();
gv.RowDataBound += new GridViewRowEventHandler(gv_RowDataBound);
gv.DataSource = dt;
gv.DataBind();
panel.Controls.Add(gv);
Literal lit = new Literal();
lit.Text = "<br/><br/>";
panel.Controls.Add(lit);
}
}
protected void btnNewTable_OnCLick(object sender, EventArgs e)
{
int newmeasID = Convert.ToInt32(hidNewMeasID.Value.ToString());
if (newmeasID > 0)
{
SQL_utils sql = new SQL_utils("data");
List <SqlParameter> ps = new List <SqlParameter>();
string tblname = txtTblName.Value.ToString().Replace("ALL_", "");
ps.Add(sql.CreateParam("tbl", "ALL_" + tblname, "text"));
ps.Add(sql.CreateParam("abbr", txtAbbr.Value.ToString(), "text"));
ps.Add(sql.CreateParam("measureID", newmeasID.ToString(), "int"));
try
{
sql.NonQuery_from_ProcName("def.spPopulate_NEW_Tbl_and_Flds", ps);
}
catch (Exception ex)
{
}
sql.Close();
}
txtName.Value = "";
txtNameFull.Value = "";
panelMeasure.Visible = true;
panelTable.Visible = false;
hidNewMeasID.Value = "-1";
}
protected void getTimepointDates_by_Subject(string subjID)
{
SQL_utils sql = new SQL_utils();
string IDtxt = ddlNewID.SelectedItem.Text;
List <SqlParameter> ps = new List <SqlParameter>();
ps.Add(sql.CreateParam("studyIDfull", Master.Master_studyIDfull.ToString(), "int"));
ps.Add(sql.CreateParam("subjID", subjID, "int"));
DataTable dt = sql.DataTable_from_ProcName("def.spTimepointDates_by_Subject", ps);
if (dt.Rows.Count > 0)
{
ogrid.DataSource = dt;
ogrid.DataBind();
panelGrid.Visible = true;
}
//if (ds.Tables[1].Rows.Count > 0) {
// ogrid2.DataSource = ds.Tables[1];
// ogrid2.DataBind();
// ogrid2.Visible = true;
//}
sql.Close();
}
protected void SaveFx(string shortName)
{
SQL_utils sql = new SQL_utils("data");
string fromtopos = txtFromToPos.Text;
int from = 0; int to = 0;
if (fromtopos.Contains('-'))
{
string[] pos = fromtopos.Split('-');
from = Convert.ToInt16(pos[0]);
to = Convert.ToInt16(pos[1]);
}
else
{
from = Convert.ToInt16(fromtopos);
}
if (from > 0)
{
List <SqlParameter> p = new List <SqlParameter>();
p.Add(sql.CreateParam("shortName", shortName, "text"));
p.Add(sql.CreateParam("fx", txtFx.Text, "text"));
p.Add(sql.CreateParam("params", txtParams.Text, "text"));
p.Add(sql.CreateParam("from", from.ToString(), "int"));
p.Add(sql.CreateParam("to", to.ToString(), "int"));
sql.NonQuery_from_ProcName("spNDAR_AddFx", p);
}
else
{
lblInfo.Text = "Enter valid From-To positions.";
}
}
protected void btnGetCounts_Click(object sender, EventArgs e)
{
UpdatePanel_O_CheckBoxes p = (UpdatePanel_O_CheckBoxes)panelChk.FindControl("study1");
string studies = p.GetChecked_as_CSV();
SQL_utils sql = new SQL_utils("backend");
List <SqlParameter> ps = new List <SqlParameter>();
ps.Add(sql.CreateParam("datebeg", txtD1.Text, "date"));
ps.Add(sql.CreateParam("dateend", txtD2.Text, "date"));
ps.Add(sql.CreateParam("studies", studies, "text"));
DataTable dt = sql.DataTable_from_ProcName("spTracking_Sessions_Counts", ps);
gv.DataSource = dt;
gv.DataBind();
if (studies.Contains("1076") | studies.Contains("1077"))
{
List <SqlParameter> psTadpole = new List <SqlParameter>();
psTadpole.Add(sql.CreateParam("datebeg", txtD1.Text, "date"));
psTadpole.Add(sql.CreateParam("dateend", txtD2.Text, "date"));
DataTable dtTadpole = sql.DataTable_from_ProcName("spTracking_Sessions_Counts_TadpoleTX_hrs", psTadpole);
gvTadpole.DataSource = dtTadpole;
gvTadpole.DataBind();
}
}
protected void Refresh_Gridview_EditStaff(int staffID)
{
LoadUWAC_ADinfo(staffID);
//populate the staff details
if (oConn.State == ConnectionState.Closed)
{
oConn.ConnectionString = ConfigurationManager.ConnectionStrings["TRACKING_CONN_STRING"].ToString();
oConn.Open();
}
SQL_utils sql = new SQL_utils("backend");
List <SqlParameter> ps = new List <SqlParameter>();
ps.Add(sql.CreateParam("labID", int.Parse(DDL_SelectLabID.SelectedItem.Value).ToString(), "int"));
ps.Add(sql.CreateParam("staffID", staffID.ToString(), "int"));
DataTable dtStaffDetails = sql.DataTable_from_ProcName("spSEC_LabGroup_Staff_details_for_EDIT", ps);
Gridview_EditStaff.DataSource = dtStaffDetails;
Gridview_EditStaff.DataBind();
Panel_EditStaff.Visible = true;
Gridview_EditStaff.Visible = true;
}
protected void LoadCoderPairDetails(string sql_params)
{
string[] str_ps = sql_params.Split(',');
SQL_utils sql = new SQL_utils();
List <SqlParameter> ps = new List <SqlParameter>();
ps.Add(sql.CreateParam("orig_studymeasID", str_ps[0], "int"));
ps.Add(sql.CreateParam("rel_studymeasID", str_ps[1], "int"));
ps.Add(sql.CreateParam("rel_pkval", str_ps[2], "int"));
DataSet ds = sql.DataSet_from_ProcName("spRELv2_GET_items__for_coderpair", ps);
for (int i = 0; i < 3; i++) //3 datatables to process
{
GridView gv_coderpair_details = (GridView)UpdatePanel_coderpair_single.ContentTemplateContainer.FindControl("gv_coderpair_details" + i.ToString());
gv_coderpair_details.DataSource = ds.Tables[i]; //dt;
gv_coderpair_details.DataBind();
}
sql.Close();
UpdatePanel_coderpair_single.Visible = true;
}
protected void MoveRecord(object sender, EventArgs e)
{
SQL_utils sql = new SQL_utils("data");
List <SqlParameter> ps = new List <SqlParameter>();
ps.Add(sql.CreateParam("old_studymeasID", ddl_studymeasID.SelectedValue, "int"));
ps.Add(sql.CreateParam("new_studymeasID", ddl_Studymeas_New.SelectedValue, "int"));
ps.Add(sql.CreateParam("pk", ddl_IDmove.SelectedValue, "int"));
sql.NonQuery_from_ProcName("spDEF__Update_StudymeasID_for_entered_Measure", ps);
sql.Close();
Populate_ID_DDLs();
btnReset.Visible = false;
panelDelete.Visible = false;
btnDelete.Visible = false;
txtDelete.Text = "";
lbl_Studymeas_New.Visible = false;
ddl_Studymeas_New.Visible = false;
btnMove.Visible = false;
UpdatePanel01.Update();
}
public static int UpdateDataproject(string pk, int studyID, int subjset_pk, string projTitle, string projSummary
, string meas_csv, string vars_csv, string inthx_csv)
{
pk = (String.IsNullOrEmpty(pk)) ? "0" : pk;
inthx_csv = (inthx_csv == null) ? "": inthx_csv;
SQL_utils sql = new SQL_utils("data");
List <SqlParameter> ps = new List <SqlParameter>();
ps.Add(sql.CreateParam("dataproj_pk", pk, "int"));
ps.Add(sql.CreateParam("studyID", studyID.ToString(), "int"));
ps.Add(sql.CreateParam("subjset_pk", subjset_pk.ToString(), "int"));
ps.Add(sql.CreateParam("projTitle", projTitle, "text"));
ps.Add(sql.CreateParam("projSummary", projSummary, "text"));
ps.Add(sql.CreateParam("supervisor_staffID", "0", "int"));
ps.Add(sql.CreateParam("sel_meas", meas_csv, "text"));
ps.Add(sql.CreateParam("sel_vars", vars_csv, "text"));
ps.Add(sql.CreateParam("sel_inthx", inthx_csv, "text"));
ps.Add(sql.CreateParam("out", "", "int", "output"));
int newdataproj_pk = sql.NonQuery_from_ProcName("dp.spDataProject_UPDATE3", ps, "out");
sql.Close();
return(newdataproj_pk);
}
protected void GetData(string mo, string mode)
{
SQL_utils sql = new SQL_utils("FinMart");
string txtimportDate = sql.StringScalar_from_SQLstring("select convert(varchar,min(imported_from_EDW),0) from fin.tblEDWData ");
importDate.Text = String.Format("Imported on {0}", txtimportDate);
List <SqlParameter> ps = new List <SqlParameter>();
ps.Add(sql.CreateParam("yrmo", mo, "text"));
ps.Add(sql.CreateParam("mode", mode, "text"));
DataTable dt = sql.DataTable_from_ProcName("fin.spGetTabularMonth", ps);
string tblinfo = (dt.HasRows()) ? "" : " - No data returned.";
Label l = new Label();
l.Text = String.Format("<br/><br/>{0} {1}", mo, tblinfo);
l.Font.Size = 12;
if (dt == null)
{
if (mode == "core")
{
panel1.Controls.Add(l);
}
else if (mode == "gift")
{
panel2.Controls.Add(l);
}
}
else
{
GridView gv = new GridView();
gv.RowCreated += new GridViewRowEventHandler(grid_RowCreated);
gv.RowDataBound += new GridViewRowEventHandler(grid_RowDataBound);
gv.DataSource = dt;
gv.DataBind();
if (mode == "core")
{
panel1.Controls.Add(l);
panel1.Controls.Add(gv);
}
else if (mode == "gift")
{
panel2.Controls.Add(l);
panel2.Controls.Add(gv);
}
}
sql.Close();
}
protected void getDATADates_by_Subject(string subjID, bool showIntHx, string title)
{
SQL_utils sql = new SQL_utils();
string IDtxt = ddlNewID.SelectedItem.Text;
List <SqlParameter> ps = new List <SqlParameter>();
ps.Add(sql.CreateParam("studyIDfull", Master.Master_studyIDfull.ToString(), "int"));
ps.Add(sql.CreateParam("subjID", subjID, "int"));
DataTable dt = sql.DataTable_from_ProcName("def.spDATADates_by_Subject", ps);
//see this for why it wasn't working in production:
//http://stackoverflow.com/questions/7933830/asp-net-charting-control-not-working-on-production-server
//I set the ChartImageHandler value in ISS to:
//storage=memory;timeout=20;deleteAfterServicing=true;
//System.Web.UI.DataVisualization.Charting.Chart chart =
//utilMSCharts.MSGeom("point", dt, "datedone", "rnk", "measname",
//"date", "numeric",
// "chartname", "Subject DATA Dates: " + IDtxt, "Date", "Measure", -999, -999, -999, -999, 1100, 800, "mytooltip");
//if (chart != null)
//{
// panelCharts.Controls.Add(chart);
//}
//else
//{
// //there was an error
//}
string chartname = "chart" + subjID.ToString();
string lchart = "";
lchart = utilCharts.Highcharts_Line(chartname, dt, "datedone", "rnk", "measname", "date", "Subject DATA Dates: " + title,
"Admin Date", "Measure", 900, 500, "delink");
Literal lit = new Literal();
lit.Text = lchart;
panelCharts.Controls.Add(lit);
string ID = sql.StringScalar_from_SQLstring("select ID from uwautism_research_backend..tblSubject where subjID=" + subjID);
if (showIntHx)
{
DisplayIntHxCharts(Master.Master_studyID, ID);
}
sql.Close();
}
protected void GUID_fileinfo(string stage)
{
SQL_utils sql = new SQL_utils();
string proc = "NDAR..spNDAR_WEB_GUID_to_create_MULTIPLE_by_study";
string mode = "_new_guid";
if (rblMode.SelectedValue == "convert")
{
proc = "NDAR..spNDAR_WEB_GUID_to_convert_INVGUID_MULTIPLE_by_study";
mode = "_convert_INVGUID";
}
string consent = "skip_consent";
if (chkConsent.Checked)
{
consent = "use_consent";
}
List <SqlParameter> ps = new List <SqlParameter>();
ps.Add(sql.CreateParam("studyID", Master.Master_studyID.ToString(), "int"));
ps.Add(sql.CreateParam("useconsent", consent, "text"));
DataSet ds = sql.DataSet_from_ProcName(proc, ps);
if (stage == "displayinfo")
{
GridView gv = new GridView();
gv.BorderStyle = BorderStyle.None;
gv.BorderColor = Color.White;
gv.DataSource = ds.Tables[0];
gv.DataBind();
panelGuidFileInfo.ContentTemplateContainer.Controls.Add(gv);
GridView gv2 = new GridView();
gv2.BorderStyle = BorderStyle.None;
gv2.BorderColor = Color.White;
gv2.DataSource = ds.Tables[1];
gv2.DataBind();
panelGuidFileInfo.ContentTemplateContainer.Controls.Add(gv2);
panelGuidFileInfo.Update();
}
else if (stage == "savefile")
{
string datetime = SpreadsheetGearUtils.DateTime_for_filename();
SpreadsheetGearUtils.SaveDataTableToFile(ds.Tables[0], Master.Master_studyname + mode + datetime, "csv");
}
sql.Close();
}
protected DataTable GetAddressData()
{
SQL_utils sql = new SQL_utils("backend");
List <SqlParameter> ps = new List <SqlParameter>();
ps.Add(sql.CreateParam("studyID", Master.Master_studyID.ToString(), "int"));
ps.Add(sql.CreateParam("type", "2", "int")); //1=all subjects, 2=main contacts
ps.Add(sql.CreateParam("include", "1", "int"));
DataTable dt = sql.DataTable_from_ProcName("spSubject_Addresses", ps);
return(dt);
}
protected void FindStorageUnits(object sender, System.EventArgs e)
{
//SqlCommand oCmd = new SqlCommand();
//SqlDataAdapter oAdapter = new SqlDataAdapter(oCmd);
//oTable = new DataTable();
//oCmd.Connection = Master.SqlConn;
//oCmd.CommandTimeout = 90;
//oCmd.CommandType = CommandType.StoredProcedure;
//oCmd.CommandText = "spSearchStorageUnits";
//oCmd.Parameters.AddWithValue("@StudyID", selStudyID.SelectedValue);
//oCmd.Parameters.AddWithValue("@ID", txtSubjID.Text.Trim());
//oCmd.Parameters.AddWithValue("@StorageLocationID", selStorageLocationID.SelectedValue);
//oCmd.Parameters.AddWithValue("@StorageContentID", selStorageContent.SelectedValue);
//if (oCmd.Parameters["@ID"].Value.ToString() == "") {oCmd.Parameters["@ID"].Value = DBNull.Value;}
//if (oCmd.Parameters["@StorageLocationID"].Value.ToString() == "-1") {oCmd.Parameters["@StorageLocationID"].Value = DBNull.Value;}
//if (oCmd.Parameters["@StorageContentID"].Value.ToString() == "-1") {oCmd.Parameters["@StorageContentID"].Value = DBNull.Value;}
//oAdapter.Fill(oTable);
SQL_utils sql = new SQL_utils("backend");
List <SqlParameter> ps = new List <SqlParameter>();
ps.Add(sql.CreateParam("StudyID", selStudyID.SelectedValue, "int"));
ps.Add(sql.CreateParam("ID", txtSubjID.Text.Trim(), "text"));
ps.Add(sql.CreateParam("StorageLocationID", selStorageLocationID.SelectedValue, "int"));
ps.Add(sql.CreateParam("StorageContentID", selStorageContent.SelectedValue, "int"));
DataTable oTable = sql.DataTable_from_ProcName("spSearchStorageUnits", ps);
if (oTable.Rows.Count > 0)
{
tblSearchResults.DataSource = oTable;
tblSearchResults.DataBind();
tblSearchResults.Style["display"] = "inline";
tdErrMsg.Style["display"] = "none";
}
else
{
tblSearchResults.Style["display"] = "none";
tdErrMsg.Style["display"] = "inline";
tdErrMsg.Style["color"] = "#ff0000";
tdErrMsg.InnerHtml = "There were no results that matched your search.";
}
}
protected void LogDownload(string filename)
{
SQL_utils sql = new SQL_utils();
//Log the Download
List <SqlParameter> ps2 = new List <SqlParameter>();
ps2.Add(sql.CreateParam("dataproj_pk", Request.QueryString["pk"], "int"));
ps2.Add(sql.CreateParam("filename", filename, "text"));
sql.NonQuery_from_ProcName("dp.spLogDownload", ps2);
sql.Close();
}
protected void btnNewFld_submit_Click(object sender, EventArgs e)
{
SQL_utils sql = new SQL_utils("data");
List <SqlParameter> ps = new List <SqlParameter>();
ps.Add(sql.CreateParam("measureID", ddlMeas.SelectedValue.ToString(), "int"));
ps.Add(sql.CreateParam("ord_pos", newOrdpos.Text, "float"));
ps.Add(sql.CreateParam("fldname", newFldname.Text, "text"));
ps.Add(sql.CreateParam("fielddatatype", newFieldDatatype.SelectedValue, "text"));
ps.Add(sql.CreateParam("fielddatatypelength", newFieldDatatypelength.Text, "int"));
//TURNED OFF JULY 2018 TOFIX
//sql.NonQuery_from_ProcName("def.Fld_INSERT_from_web", ps);
}
public static DataSet GetIntHxData(SQL_utils sql, int dataproj_pk)
{
List <DataTable> tbls = new List <DataTable>();
if (sql.SqlConnection.State != ConnectionState.Open)
{
sql.SqlConnection.Open();
}
List <SqlParameter> ps = new List <SqlParameter>();
ps.Add(sql.CreateParam("dataproj_pk", dataproj_pk.ToString(), "int"));
DataSet ds = sql.DataSet_from_ProcName("[dp].[IntHx_SUMMARIZE]", ps);
if (ds != null)
{
int counter = 0;
foreach (DataTable dt in ds.Tables)
{
if (counter == 0)
{
dt.TableName = "IntHx Settings";
}
else
{
dt.TableName = "IntHx_" + counter.ToString();
}
counter++;
}
}
return(ds);
}
protected void btnGetAddresses_Click(object sender, EventArgs e)
{
UpdatePanel_O_CheckBoxes p = (UpdatePanel_O_CheckBoxes)panelChk.FindControl("study1");
string studies = p.GetChecked_as_CSV();
SQL_utils sql = new SQL_utils("backend");
List <SqlParameter> ps = new List <SqlParameter>();
ps.Add(sql.CreateParam("studies", studies, "text"));
DataTable dt = sql.DataTable_from_ProcName("spTracking_Subj_AddressList", ps);
dt.TableName = "Subject Addresses";
string datenow = DateTime.Now.Year.ToString() + ((DateTime.Now.Month < 10) ? "0" : "") + DateTime.Now.Month.ToString() + ((DateTime.Now.Day < 10) ? "0" : "") + DateTime.Now.Day.ToString();
string hrminnow = ((DateTime.Now.Hour < 10) ? "0" : "") + DateTime.Now.Hour.ToString() + ((DateTime.Now.Minute < 10) ? "0" : "") + DateTime.Now.Minute.ToString();
string filename = "UWAC_Subject_Addresses_" + datenow + "_" + hrminnow; //TODO
SpreadsheetGearUtils.SaveDataTableToExcel(dt, filename, "xlsx");
}
protected bool UpdateSelectedGroups()
{
if (rblPlotsBy.SelectedValue != "Single Subject")
{
bool hasgrps = true;
gvSelector gv = (gvSelector)gvSubjects_container.FindControlRecursive("gvSubjects");
//GridView gv = (GridView)gvSubjects_container.FindControlRecursive("gvSubjects");
string csv = gvSelector.CSVpairs_GetSelectedSubjects(gv);
if (csv == "")
{
lblSelectSubjects.Visible = true;
hasgrps = false;
}
else
{
lblSelectSubjects.Visible = false;
SQL_utils sql = new SQL_utils();
sql.NonQuery_from_ProcName("dp.spGrp_select", sql.CreateParam("grpIDssID", csv, "text"));
sql.Close();
}
return(hasgrps);
}
else
{
return(true);
}
}
protected void SaveAllDataStructures(DataTable dt)
{
SQL_utils sql = new SQL_utils();
SqlParameter p = sql.CreateParam("NDAR_DS", dt);
sql.NonQuery_from_ProcName("spNDAR_Insert_DS", p);
}
protected void RefreshGrid(Grid grid, string procname, string hhID)
{
SQL_utils sql = new SQL_utils("backend");
DataTable dt = sql.DataTable_from_ProcName(procname, sql.CreateParam("householdID", hhID, "int"));
LoadGrid(grid, dt);
sql.Close();
}
public static DataTable NDAR_DSE_with_Matching_UWFlds(string shortName)
{
SQL_utils sql = new SQL_utils("data");
DataTable dt = sql.DataTable_from_ProcName("def.spNDAR_MatchedFlds", sql.CreateParam("shortname", shortName, "text"));
return(dt);
}
public static DataSet Get_MIND_IntHx_v2_Data_by_ID(SQL_utils sql, int studyID, string id, string periodtype)
{
//SQL_utils sql = new SQL_utils();
if (studyID >= 10000)
{
RescoreIntHx(sql, studyID);
}
List <SqlParameter> ps = new List <SqlParameter>();
ps.Add(sql.CreateParam("studyID", studyID.ToString(), "int"));
ps.Add(sql.CreateParam("ID", id, "text"));
ps.Add(sql.CreateParam("periodtype", periodtype, "text"));
DataSet ds = sql.DataSet_from_ProcName("spSCORE_ALL_MIND_IntHx_vers2_STACKED__getdata_for_CHARTS_2018", ps);
List <string> tblnames = new List <string> {
"Weekly by TYPE",
"Weekly by CAT",
"Weekly by ALL",
//"Period by TYPE",
//"Period By CAT",
//"Period by ALL" ,
"dt_admindates",
"dt_colors0",
"dt_colors1",
"dt_colors2"
};
int counter = 0;
if (ds != null)
{
foreach (DataTable dt in ds.Tables)
{
dt.TableName = tblnames[counter];
counter++;
}
}
return(ds);
}
protected void btnLinkMatched_Click(object sender, EventArgs e)
{
shortName = Request.QueryString["shortName"];
SQL_utils sql = new SQL_utils();
List <SqlParameter> ps = new List <SqlParameter>();
ps.Add(sql.CreateParam("shortname", shortName, "text"));
ps.Add(sql.CreateParam("mode", "link", "text"));
sql.NonQuery_from_ProcName("def.spNDAR_matching_UWflds", ps);
sql.Close();
LoadDataStructure(shortName);
}
protected void SaveSubject(object source, EventArgs e)
{
SQL_utils sql = new SQL_utils("backend");
List <SqlParameter> ps = new List <SqlParameter>();
ps.Add(sql.CreateParam("subjid", hidSubjID.Value.ToString(), "int"));
ps.Add(sql.CreateParam("Notes", txtNotes.Text.ToString(), "text"));
ps.Add(sql.CreateParam("ssID", cboSS.Value.ToString(), "int"));
ps.Add(sql.CreateParam("ssdID", cboSSD.Value.ToString(), "int"));
sql.NonQuery_from_ProcName("trk.spSubject_Update", ps);
sql.Close();
GetSubjectInfo(ID);
}
private void Page_Load(object sender, System.EventArgs e)
{
sql = new SQL_utils("backend");
int nPersonID = Convert.ToInt32(Request.QueryString["personID"].ToString());
DataTable dt = sql.DataTable_from_ProcName("spGetPersonInfoByPersonID", sql.CreateParam("personID", nPersonID.ToString(), "int"));
string sJSOutput = "";
if (IsPostBack)
{
// MovePersonIntoStudy();
}
if (dt != null)
{
DataRow row = dt.Rows[0];
string fullname = row["FullName"].ToString();
//string fullname = dt.AsEnumerable().Select(f => f.Field<string>("FullName")).ToString();
lblName.Text = fullname;
tdTitle.InnerHtml = "Create Subject: " + fullname;
//txtPersonName.Value = fullname;
hidPersonID.Value = nPersonID.ToString();
}
else
{
//oReader.Close();
tblMaster.Rows.Clear();
HtmlTableRow oTr = new HtmlTableRow();
HtmlTableCell oTd = new HtmlTableCell();
tblMaster.Attributes["class"] = "";
oTr.Cells.Add(oTd);
tblMaster.Rows.Add(oTr);
oTd.InnerHtml = "The Person ID you supplied is not valid.";
}
LoadMaxIDs();
// LoadOtherIDs(nPersonID);
//if (!IsPostBack)
//{
// LoadGroups();
//}
//DropDownList ddlSite = gridOtherID.Templates[1].Container.FindControl("ddlSite") as DropDownList;
//ddlSite.DataSource = sql_Site;
//ddlSite.DataBind();
sql.Close();
}
//protected void ddlSubjStatus2_SelectedIndexChanged(object sender, EventArgs e)
//{
// //UpdateSSD();
//}
// protected void UpdateSSD()
//{
// //string x = ddlSubjStatus2.SelectedValue.ToString();
// //SQL_utils sql = new SQL_utils("backend");
// //DataTable dt = sql.DataTable_from_SQLstring("select 0 subjstatusdetailID, '--select status detail--' subjstatusdetail union " +
// // " select subjstatusdetailID, subjstatusdetail from tblSubjStatusDetail_Lkup " +
// // " where subjstatusdetailID in " +
// // " (select subjstatusdetailID from tblSubjStatusAndDetail where subjstatusID = " + x + ")");
// //ddlSubjStatusDetail2.DataSource = dt;
// //ddlSubjStatusDetail2.DataTextField = "subjstatusdetail";
// //ddlSubjStatusDetail2.DataValueField = "subjstatusdetailID";
// //ddlSubjStatusDetail2.DataBind();
// //panelSubjectInfo.Update();
// //sql.Close();
//}
// protected void ddlSubjStatus2_TextChanged(object sender, EventArgs e)
// {
// UpdateSSD();
// }
protected void btnUpdateSS_Click(object sender, EventArgs e)
{
UpdatePanel("panelSubjectInfo");
SQL_utils sql = new SQL_utils("backend");
HiddenField hidSSD = (HiddenField)Page.FindControlRecursive("hidSSD");
string ssd = hidSSD.Value;
if (ssd != "" | txtNotes.Text != "")
//if (ddlSSD.SelectedValue.ToString() != "")
{
if (ssd == "")
{
ssd = "-1"; //if ssd is blank then set to -1 so that the orig value is retained in the stored proc
}
//note that it is blank because the SSD dropdown is not populated until the SS is selected
List <SqlParameter> ps = new List <SqlParameter>();
ps.Add(sql.CreateParam("subjID", Request.QueryString["subjID"], "int"));
ps.Add(sql.CreateParam("subjstatusID", ddlSS.SelectedValue.ToString(), "int"));
ps.Add(sql.CreateParam("subjstatusdetailID", ssd, "int"));
ps.Add(sql.CreateParam("notes", txtNotes.Text, "text"));
sql.NonQuery_from_ProcName("hh.spSubject_MODIFY", ps);
//panelEditSS.Visible = false;
//btnUpdateSS.Visible = false;
//btnEditSS.Visible = true;
//reset selected index to -1
ddlSS.SelectedIndex = -1;
ddlSSD.SelectedIndex = -1;
Response.Redirect("subject.aspx?subjID=" + Request.QueryString["subjID"]);
}
//LoadSubjectInfo(Request.QueryString["subjID"]);
sql.Close();
}
