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); } }
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 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 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 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(); }
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(); }
protected int UpdateSubjset() { var subj_csv = uwac.trk.dataops.GetCSV(gridLkupSubj.GridView.GetSelectedFieldValues(gridLkupSubj.KeyFieldName)); if (subj_csv != null) { string subjset_pk = (Request.QueryString["subjset_pk"] != null) ? Request.QueryString["subjset_pk"] : "0"; string subjset = txtSubjset.Text; string subjsetdetails = txtSubjsetdetails.Text; SQL_utils sql = new SQL_utils("data"); List <SqlParameter> ps = new List <SqlParameter>(); ps.Add(sql.CreateParam("subjset_pk", subjset_pk, "int")); ps.Add(sql.CreateParam("studyID", Master.Master_studyID.ToString(), "int")); ps.Add(sql.CreateParam("subjset", subjset, "text")); ps.Add(sql.CreateParam("subjsetdetails", subjsetdetails, "text")); ps.Add(sql.CreateParam("sel_subj", subj_csv, "text")); ps.Add(sql.CreateParam("out", "", "int", "output")); int newsubjset_pk = sql.NonQuery_from_ProcName("dp.spSubjSet_UPDATE", ps, "out"); sql.Close(); return(newsubjset_pk); } else { return(0); } }
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 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."; } }
//public static void UpdateM(Mdata m) public static void RemoveFld(int fldpk) { SQL_utils sql = new SQL_utils(); List <SqlParameter> ps = new List <SqlParameter>(); ps.Add(sql.CreateParam("fldpk", fldpk.ToString(), "int")); sql.NonQuery_from_ProcName("dp.spFld_remove", ps); sql.Close(); }
protected void btnImportFromNDAR_OnClick(object sender, EventArgs e) { SQL_utils sql = new SQL_utils("data"); SqlParameter p = sql.CreateParam("NDAR_DSE", (DataTable)Session["LoadStructureFromNDAR"]); sql.NonQuery_from_ProcName("spNDAR_Insert_DSE", p); sql.Close(); }
public static void UpdateField(Myfield field) { SQL_utils sql = new SQL_utils(); string fldpk = field.fldpk; string fldtypepk = field.fldtypepk; string fieldlabel = field.fieldlabel; string fieldvaluesetID = field.fieldvaluesetID; string missval = field.missval; string minval = field.minval; string maxval = field.maxval; string regex = field.regex; string regexdesc = field.regexdesc; string validlist = field.validlist; string InAnalysis = field.InAnalysis; string RelItem = field.RelItem; string RelAgreeThreshold = field.RelAgreeThreshold; List <SqlParameter> ps = new List <SqlParameter>(); ps.Add(sql.CreateParam("fldpk", fldpk, "int")); ps.Add(sql.CreateParam("fldtypepk", fldtypepk, "int")); ps.Add(sql.CreateParam("fieldlabel", fieldlabel, "text")); ps.Add(sql.CreateParam("missval", missval, "text")); ps.Add(sql.CreateParam("minval", minval, "int")); ps.Add(sql.CreateParam("maxval", maxval, "int")); ps.Add(sql.CreateParam("regex", regex, "text")); ps.Add(sql.CreateParam("regexdesc", regexdesc, "text")); ps.Add(sql.CreateParam("validlist", validlist, "text")); ps.Add(sql.CreateParam("InAnalysis", InAnalysis, "int")); ps.Add(sql.CreateParam("RelItem", RelItem, "int")); ps.Add(sql.CreateParam("RelAgreeThreshold", RelAgreeThreshold, "text")); if (fieldvaluesetID == "") { ps.Add(sql.CreateParam("fieldvaluesetID", "-999", "int")); } else { ps.Add(sql.CreateParam("fieldvaluesetID", fieldvaluesetID, "int")); } sql.NonQuery_from_ProcName("def.spEdit_Fld2", ps); sql.Close(); }
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(); }
public static string SaveToDB(string shortname) { NDAR.NDAR_DataStructure ds = NDAR.GetNDARDataStructure(shortname); DataTable dse = NDAR.NDARDataStructureElements_to_DataTable(ds); string results = ""; //lblInfo.Text = "nrow = {" + dse.Rows.Count.ToString() + "}"; SQL_utils sql = new SQL_utils(); //Check is NDAR_DS exists int n_ds = sql.IntScalar_from_SQLstring( String.Format("select count(*) from NDAR_DS where shortname='{0}'", shortname)); if (n_ds == 0) { // then insert DSE string code = String.Format("insert into ndar_ds (shortname, title, datatype, status ) values ('{0}', '{1}','{2}','{3}')" , ds.shortName, ds.title, ds.dataType, ds.status); sql.NonQuery_from_SQLstring(code); } //Check is NDAR_DS exists int n_dse = sql.IntScalar_from_SQLstring( String.Format("select count(*) from NDAR_DSE where shortname='{0}'", shortname)); if (n_dse > 0) { sql.NonQuery_from_SQLstring(String.Format("delete from NDAR_DSE where shortname='{0}'", shortname)); } SqlParameter p = sql.CreateParam("NDAR_DSE", dse); try { sql.NonQuery_from_ProcName("spNDAR_Insert_DSE", p); results = "Successfully imported " + shortname; } catch (Exception ex) { results = "Error: " + ex.Message; } sql.Close(); return(results); }
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); }
protected void btnSaveUWfields_Click(object sender, EventArgs e) { DataTable dt = GetUWfields(); //ViewState["uwfldpos"] = dt; //gvTest.DataSource = dt; //gvTest.DataBind(); SQL_utils sql = new SQL_utils("data"); SqlParameter p = sql.CreateParam("tbl", dt); sql.NonQuery_from_ProcName("spNDAR_DSE_updateUWfld", p); sql.Close(); LoadDataStructure(shortName); }
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 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(); }
protected void btnNew_Click(object sender, EventArgs e) { string err = ""; if (txtFN.Text == "") { err += " first name;"; } if (txtLN.Text == "") { err += "last name; "; } if (txtDOB.Text == "") { err += " DOB;"; } if (txtID.Text == "") { err += " ID;"; } if (err != "") { lblERR.Text = String.Format("You must enter: {0}", err); } else { lblERR.Text = ""; SQL_utils sql = new SQL_utils("backend"); List <SqlParameter> ps = new List <SqlParameter>(); ps.Add(sql.CreateParam("fn", txtFN.Text.ToString(), "text")); ps.Add(sql.CreateParam("ln", txtLN.Text.ToString(), "text")); ps.Add(sql.CreateParam("dob", txtDOB.Text.ToString(), "text")); ps.Add(sql.CreateParam("id", txtID.Text.ToString(), "text")); sql.NonQuery_from_ProcName("spCreateSubject_UWACScoring", ps); Response.Redirect("UWACscoring_subjects.aspx"); } }
protected void UpdateCurrentDistribution(string mode) { List <string> x = new List <string> { "-1", "1" }; List <string> grps = new List <string> { "A", "B", "C", "D" }; if (x.Contains(txtAge.Text) & x.Contains(txtDQ.Text) & x.Contains(txtGender.Text) & x .Contains(txtUW.Text) & x.Contains(txtUCD.Text) & x.Contains(txtTOT.Text) & grps.Contains(ddlGRP.SelectedValue) ) { SQL_utils sql = new SQL_utils("backend"); List <SqlParameter> ps = new List <SqlParameter>(); ps.Add(sql.CreateParam("grp", ddlGRP.SelectedValue.ToString(), "text")); ps.Add(sql.CreateParam("lev1", txtAge.Text, "int")); ps.Add(sql.CreateParam("lev2", txtDQ.Text, "int")); ps.Add(sql.CreateParam("lev3", txtGender.Text, "int")); ps.Add(sql.CreateParam("lev4", txtUW.Text, "int")); ps.Add(sql.CreateParam("lev5", txtUCD.Text, "int")); ps.Add(sql.CreateParam("mode", mode, "text")); sql.NonQuery_from_ProcName("spUPDATE_tmpTadpole_Randomization_Strata", ps); LoadInfo(); lblInfo.Text = ""; } else { lblInfo.Text = "Complete the subject profile."; } }
protected void btnClone_OnClick(object sender, EventArgs e) { Debug.Print("btnClone_OnClick " + System.DateTime.Now.ToString()); SQL_utils sql = new SQL_utils("data"); List <SqlParameter> ps = new List <SqlParameter>(); ps.Add(sql.CreateParam("dataproj_pk", Request.QueryString["pk"], "int")); ps.Add(sql.CreateParam("newdataproj_pk", "0", "int", "output")); int newdataproj_pk = sql.NonQuery_from_ProcName("dp.CloneDataProject", ps, "newdataproj_pk"); sql.Close(); if (newdataproj_pk > 0) { Response.Redirect("Edit.aspx?pk=" + newdataproj_pk.ToString()); } }
protected void DeleteRecord(object sender, EventArgs e) { SQL_utils sql = new SQL_utils("data"); List <SqlParameter> ps = new List <SqlParameter>(); ps.Add(sql.CreateParam("studymeasID", ddl_studymeasID.SelectedValue, "int")); ps.Add(sql.CreateParam("pk", ddl_IDdelete.SelectedValue, "int")); sql.NonQuery_from_ProcName("spDEF_DELETE_to_XML_RAW", ps); Populate_ID_DDLs(); btnReset.Visible = false; panelDelete.Visible = false; btnDelete.Visible = false; txtDelete.Text = ""; UpdatePanel01.Update(); }
public static void SaveChartImage(Chart chart, string filepath, string ChartType, string ChartDetails, int studyID, string id) { string filename = filepath + ChartType + ChartDetails + studyID.ToString() + id + ".png"; chart.SaveImage(filename); Debug.WriteLine("Saving..." + filename); //Log this chart SQL_utils sql = new SQL_utils(); List <SqlParameter> ps = new List <SqlParameter>(); ps.Add(sql.CreateParam("ChartType", ChartType, "text")); ps.Add(sql.CreateParam("ChartDetail", ChartDetails, "text")); ps.Add(sql.CreateParam("studyID", studyID.ToString(), "int")); ps.Add(sql.CreateParam("id", id, "text")); sql.NonQuery_from_ProcName("dp.spChartLog_BySubject_INSERT", ps); }
public static void UpdateREV(string p1, string p2, string p3) { double calcrev; Double.TryParse(p3, out calcrev); if (calcrev >= 0) { SQL_utils sql = new SQL_utils("backend"); List <SqlParameter> ps = new List <SqlParameter>(); ps.Add(sql.CreateParam("budgetNbr", p1, "text")); ps.Add(sql.CreateParam("mo", p2, "text")); ps.Add(sql.CreateParam("calcREV", p3, "int")); sql.NonQuery_from_ProcName("fin.spREV_FutureMo_UPDATE", ps); sql.Close(); } }
public static void UpdateFTE(string p1, string p2, string p3, string p4) { 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")); sql.NonQuery_from_ProcName("fin.spFTE_FutureMo_UPDATE", ps); sql.Close(); } }
protected void btnSubmit_Click(object sender, EventArgs e) { SQL_utils sql = new SQL_utils("backend"); List <SqlParameter> ps = new List <SqlParameter>(); ps.Add(sql.CreateParam("idtype", ddlIDtype.SelectedValue, "text")); ps.Add(sql.CreateParam("idissuedby", txtIssuedBy.Text, "text")); ps.Add(sql.CreateParam("idnumber", txtIDnumber.Text, "text")); ps.Add(sql.CreateParam("idexpiredate", txtIDexpiredate.Text, "text")); ps.Add(sql.CreateParam("fname", txtfirst.Text, "text")); ps.Add(sql.CreateParam("mname", txtmiddle.Text, "text")); ps.Add(sql.CreateParam("lname", txtlast.Text, "text")); ps.Add(sql.CreateParam("dob", txtdob.Text, "text")); ps.Add(sql.CreateParam("currentemail", txtemail.Text, "text")); sql.NonQuery_from_ProcName("spNETIDinfo_INSERT", ps); GridView gv = new GridView(); DataTable dt = sql.DataTable_from_SQLstring("exec spNETIDinfo_SELECT"); if (dt.Rows.Count > 0) { panel_input.Visible = false; gv.DataSource = dt; gv.DataBind(); panel_submitted.Controls.Add(gv); panel_submitted.Visible = true; } else { lblVerify.Text = "The may have been a problem saving your info. Contact Jeff at 425-478-0920."; panel_submitted.Visible = true; } }
public static void UpdateOBJ(string p1, string p2, string p3, string p4) { double calcobj; Double.TryParse(p4, out calcobj); if (calcobj >= 0) { SQL_utils sql = new SQL_utils("backend"); List <SqlParameter> ps = new List <SqlParameter>(); ps.Add(sql.CreateParam("ObjCode", p1, "text")); ps.Add(sql.CreateParam("budgetNbr", p2, "text")); ps.Add(sql.CreateParam("mo", p3, "text")); ps.Add(sql.CreateParam("calcOBJ", p4, "int")); sql.NonQuery_from_ProcName("fin.spOBJ_FutureMo_UPDATE", ps); sql.Close(); } }
protected void ResetForm(object sender, EventArgs e) { SQL_utils sql = new SQL_utils("data"); List <SqlParameter> ps = new List <SqlParameter>(); ps.Add(sql.CreateParam("studymeasID", ddl_studymeasID.SelectedValue, "int")); ps.Add(sql.CreateParam("pk", ddl_ID.SelectedValue, "int")); sql.NonQuery_from_ProcName("spDEF_RESET_Verified_to_0", ps); Populate_ID_DDLs(); btnReset.Visible = false; panelDelete.Visible = false; btnDelete.Visible = false; txtDelete.Text = ""; error_label.Text = ""; UpdatePanel01.Update(); }
//protected void btnSave_Click(object sender, EventArgs e) //{ // DataTable dt = NDAR.LoadFullDataStructureList("NDAR"); // SaveAllDataStructures(dt); //} //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 gvScroll_RowCommand(object sender, GridViewCommandEventArgs e) { //save DSE here if (e.CommandName == "Import flds") { NDAR.NDAR_DataStructure ds = NDAR.GetNDARDataStructure(e.CommandArgument.ToString()); DataTable dse = NDAR.NDARDataStructureElements_to_DataTable(ds); //lblInfo.Text = "nrow = {" + dse.Rows.Count.ToString() + "}"; SQL_utils sql = new SQL_utils(); SqlParameter p = sql.CreateParam("NDAR_DSE", dse); sql.NonQuery_from_ProcName("spNDAR_Insert_DSE", p); //GridView gv_Fields = new GridView(); //gv_Fields.DataSource = dse; //gv_Fields.DataBind(); //Panel_dataElements.Controls.Add(gv_Fields); //Panel_dataElements.Visible = true; } }
protected void MovePersonIntoStudy() { #region Move Person Into Study int nPersonID = Convert.ToInt32(hidPersonID.Value); int nStudyID = Convert.ToInt32(cboStudyID.Value); int nGroupID = Convert.ToInt32(cboGroupID.Value); string sID = txtSubjectID.Value; string sReturnValue = "0"; string sSubjectID = "0"; //SqlCommand oCmd = new SqlCommand(); //oCmd.Connection = Master.SqlConn; //oCmd.CommandText = "trk.spCreateSubject_WEB"; //oCmd.CommandTimeout = 90; //oCmd.CommandType = CommandType.StoredProcedure; //oCmd.Parameters.Add(new SqlParameter("@PersonID", SqlDbType.Int, 4, ParameterDirection.Input, true, 0, 0, "", DataRowVersion.Current, nPersonID)); //oCmd.Parameters.Add(new SqlParameter("@StudyID", SqlDbType.Int, 4, ParameterDirection.Input, true, 0, 0, "", DataRowVersion.Current, nStudyID)); //oCmd.Parameters.Add(new SqlParameter("@GroupID", SqlDbType.Int, 4, ParameterDirection.Input, true, 0, 0, "", DataRowVersion.Current, nGroupID)); //oCmd.Parameters.Add(new SqlParameter("@ID", SqlDbType.VarChar, 100, ParameterDirection.Input, true, 0, 0, "", DataRowVersion.Current, sID)); //oCmd.Parameters.Add(new SqlParameter("@SubjectID", SqlDbType.Int, 4, ParameterDirection.Output, true, 0, 0, "", DataRowVersion.Current, DBNull.Value)); //oCmd.Parameters.Add(new SqlParameter("@ReturnValue", SqlDbType.Int, 4, ParameterDirection.ReturnValue, true, 0, 0, "", DataRowVersion.Current, DBNull.Value)); if (nGroupID > 0 & nStudyID > 0 & nPersonID > 0 & sID.Length > 0) { lblInfo.Text = "OK: " + nGroupID.ToString() + " " + nStudyID.ToString() + " " + nPersonID.ToString() + " " + sID; try { //oCmd.ExecuteNonQuery(); //NEW VERSION IF NEEDED SQL_utils sql = new SQL_utils("backend"); List <SqlParameter> ps = new List <SqlParameter>(); ps.Add(sql.CreateParam("PersonID", nPersonID.ToString(), "int")); ps.Add(sql.CreateParam("StudyID", nStudyID.ToString(), "int")); ps.Add(sql.CreateParam("GroupID", nGroupID.ToString(), "int")); ps.Add(sql.CreateParam("ID", sID, "text")); ps.Add(sql.CreateParam("SubjectID", "0", "int", "output")); int newsubjID = sql.NonQuery_from_ProcName("trk.spCreateSubject_WEB", ps, "SubjectID"); sSubjectID = newsubjID.ToString(); } catch (Exception) { } } else { lblInfo.Text = nGroupID.ToString() + " " + nStudyID.ToString() + " " + nPersonID.ToString() + " " + sID; } //sReturnValue = oCmd.Parameters["@ReturnValue"].Value.ToString(); //sSubjectID = oCmd.Parameters["@SubjectID"].Value.ToString(); //if (sReturnValue == "0") if (sSubjectID != "0") { Response.Redirect(@"~/Track/Subject.aspx?subjID=" + sSubjectID); } else { HtmlTableRow oTr = new HtmlTableRow(); HtmlTableCell oTd = new HtmlTableCell(); HtmlGenericControl oSpan = new HtmlGenericControl("span"); oSpan.Attributes["class"] = "error"; oTd.Controls.Add(oSpan); oTr.Cells.Add(oTd); tblMaster.Rows.Insert(1, oTr); switch (sReturnValue) { case "1": oSpan.InnerHtml = "The Person you selected is already a Subject in the Study you selected."; break; case "2": oSpan.InnerHtml = "The ID you entered already exists in the Study you selected."; break; case "3": oSpan.InnerHtml = "The Person you selected has an ID in other related Studies that is different than the ID you entered."; break; case "4": oSpan.InnerHtml = "The ID you entered has already been used to identify a subject in a related study. This ID number is reserved for the same person it was applied to in the related study. Please select a different ID number."; break; case "5": oSpan.InnerHtml = "A Parent-Main subject must first be added to this household."; break; case "6": oSpan.InnerHtml = "Only 1 Proband subject per household is allowed."; break; case "7": oSpan.InnerHtml = "Only 1 Parent-Main subject per household is allowed."; break; case "8": oSpan.InnerHtml = "An internal error occurred in creating the Subject."; break; } } #endregion }