protected void ogrid_detail_UpdateCommand(object sender, GridRecordEventArgs e)
{
if (detail_tbl != "")
{
Hashtable hash = e.Record;
string detail_pkval = hash["detail_pk"].ToString();
hash.Add(detail_pk, detail_pkval);
// Add studyID whether we need it or not. Because the oGrid_InsertData will only
// process fields that are part of the underlying table, no harm in including it.
if (hash.ContainsKey("studyID"))
{
hash["studyID"] = Master.Master_studyID.ToString();
}
else
{
hash.Add("studyID", Master.Master_studyID.ToString());
}
oboutGrid_utils o = new oboutGrid_utils();
string output = o.oGrid_UpdateData(hash, detail_tbl, "uwautism_research_backend", schema, detail_pk);
lblOutput_detail.Text = output;
LoadDetail(schema, master_tbl, master_pk, detail_tbl, detail_pk, master_pkvalue, usestudy);
}
}
protected void UpdateSingleField(int fldpk, string fldname, int layout_section, int layout_row, int layout_col, string fieldlabel, string aspxfieldlabeltext,
int fldtypepk, string missval, int width_label, int width_box)
{
Hashtable hash = new Hashtable();
hash.Add("fldpk", fldpk);
hash.Add("fldname", fldname);
hash.Add("layout_section", layout_section);
hash.Add("layout_row", layout_row);
hash.Add("layout_col", layout_col);
hash.Add("fieldlabel", fieldlabel);
hash.Add("aspxfieldlabeltext", aspxfieldlabeltext);
hash.Add("fldtypepk", fldtypepk);
hash.Add("missval", missval);
hash.Add("width_label", width_label);
hash.Add("width_box", width_box);
string result = "";
if (fldpk > 0)
{
oboutGrid_utils o = new oboutGrid_utils();
result = o.oGrid_UpdateData(hash, "Fld", "data", "def", "fldpk");
}
}
protected void gridM_UpdateCommand(object sender, GridRecordEventArgs e)
{
try
{
string x = "";
oboutGrid_utils o = new oboutGrid_utils();
if (gridM.SelectedRecords != null)
{
int[] recs = GetSelectedRecords(gridM, "studymeassubjID");
x = o.oGrid_UpdateData(e.Record, "tblstudymeassubj", "backend", "dbo", "studymeassubjID", recs);
}
else
{
x = o.oGrid_UpdateData(e.Record, "tblstudymeassubj", "backend", "dbo", "studymeassubjID");
}
}
catch (Exception ex) {
string x = ex.Message;
}
//LoadSubjectInfo(ddlID.SelectedValue);
//gridM.DataBind();
}
protected void gridEmail_InsertCommand(object sender, GridRecordEventArgs e)
{
oboutGrid_utils o = new oboutGrid_utils();
o.oGrid_InsertData(e.Record, "tblEmail", "backend", "dbo", "householdID", GetHouseholdID());
//RefreshGrid(gridEmail, "hh.spEmail_by_HouseholdID", Request.QueryString["hhID"]);
}
protected void gridContacts_UpdateCommand(object sender, GridRecordEventArgs e)
{
Hashtable hash = (Hashtable)e.Record;
oboutGrid_utils o = new oboutGrid_utils();
string result = o.oGrid_UpdateData(hash, "tContact", "backend", "ac", "contactID");
}
protected void Grid_MyBudgets_UpdateCommand(object sender, GridRecordEventArgs e)
{
oboutGrid_utils o = new oboutGrid_utils();
Hashtable hash = (Hashtable)e.Record;
string x = o.oGrid_UpdateData(hash, "MyBudget", "backend", "fin", "mybudgetpk");
LoadMyBudgets();
}
protected void GridMeta_Budget_UpdateCommand(object sender, GridRecordEventArgs e)
{
oboutGrid_utils o = new oboutGrid_utils();
Hashtable hash = (Hashtable)e.Record;
string result = o.oGrid_UpdateData(hash, "meta_budget", "backend", "fin", "budgetNbr");
}
protected void gridContacts_InsertCommand(object sender, GridRecordEventArgs e)
{
Hashtable hash = (Hashtable)e.Record;
oboutGrid_utils o = new oboutGrid_utils();
string foo = o.oGrid_InsertData(hash, "tContact", "backend", "ac", "contactID", 0);
}
protected void gridLogContact_InsertCommand(object sender, GridRecordEventArgs e)
{
oboutGrid_utils o = new oboutGrid_utils();
e.Record["studyID"] = Master.Master_studyID;
o.oGrid_InsertData(e.Record, "tblLogContact", "backend", "dbo", "householdID", GetHouseholdID());
//RefreshGrid(gridLogContact, "hh.spLogContact_by_HouseholdID", Request.QueryString["hhID"]);
}
protected void UpdateRecordAll(object sender, GridRecordEventArgs e)
{
//SQL_utils sql = new SQL_utils();
oboutGrid_utils o = new oboutGrid_utils();
o.oGrid_UpdateData(e.Record, "const_MIND_IntHXv2_TxAll", "data", "dbo", "txallID");
//sql.Close();
}
protected void gridOtherID_UpdateCommand(object sender, Obout.Grid.GridRecordEventArgs e)
{
try
{
string x = "";
oboutGrid_utils o = new oboutGrid_utils();
x = o.oGrid_UpdateData(e.Record, "tblOtherID", "backend", "dbo", "otherID_pk");
}
catch (Exception) { }
}
protected void gridM_UpdateCommand(object sender, GridRecordEventArgs e)
{
try
{
string x = "";
oboutGrid_utils o = new oboutGrid_utils();
x = o.oGrid_UpdateData(e.Record, "tblstudymeassubj", "backend", "dbo", "studymeassubjID");
}
catch (Exception) { }
}
protected void gridEmail_DeleteCommand(object sender, GridRecordEventArgs e)
{
int pk = Convert.ToInt32(e.Record["emailID"]);
if (pk > 0)
{
oboutGrid_utils o = new oboutGrid_utils();
o.oGrid_DeleteData("tblEmail", "backend", "dbo", "emailID", pk);
RefreshGrid(gridEmail, "hh.spEmail_by_HouseholdID", Request.QueryString["hhID"]);
}
}
protected void ogrid_UpdateCommand(object sender, GridRecordEventArgs e)
{
try
{
string x = "";
oboutGrid_utils o = new oboutGrid_utils();
x = o.oGrid_UpdateData(e.Record, "tbltimepointsubj", "backend", "dbo", "tpsID");
getTimepointDates_by_Subject(ddlNewID.SelectedValue.ToString());
}
catch (Exception) { }
}
protected void gridCPT_UpdateCommand(object sender, Obout.Grid.GridRecordEventArgs e)
{
string x = "";
if (e.RecordsCollection != null)
{
foreach (Hashtable rec in e.RecordsCollection)
{
oboutGrid_utils o = new oboutGrid_utils();
x = o.oGrid_UpdateData(rec, "enumCPT", "backend", "ac", "pk");
}
}
else if (e.Record != null)
{
oboutGrid_utils o = new oboutGrid_utils();
x = o.oGrid_UpdateData(e.Record, "enumCPT", "backend", "ac", "pk");
}
}
protected void gridOtherID_InsertCommand(object sender, GridRecordEventArgs e)
{
int personID = Convert.ToInt32(Request.QueryString["personID"]);
int otherIDsiteID = Convert.ToInt32(e.Record["otherIDsiteID"]);
if (personID > 0 & otherIDsiteID > 0)
{
try
{
string x = "";
oboutGrid_utils o = new oboutGrid_utils();
e.Record["personID"] = personID;
x = o.oGrid_InsertData(e.Record, "tblOtherID", "backend", "dbo");
}
catch (Exception) { }
}
}
protected void GridTxType_UpdateCommand(object sender, Obout.Grid.GridRecordEventArgs e)
{
string x = "";
if (e.RecordsCollection != null)
{
foreach (Hashtable rec in e.RecordsCollection)
{
oboutGrid_utils o = new oboutGrid_utils();
x = o.oGrid_UpdateData(rec, "const_MIND_IntHXv2_TxType", "data", "dbo", "txtypeID");
}
}
else if (e.Record != null)
{
oboutGrid_utils o = new oboutGrid_utils();
x = o.oGrid_UpdateData(e.Record, "const_MIND_IntHXv2_TxType", "data", "dbo", "txtypeID");
}
lblInfo.Text = x;
}
protected void gridloginfo_UpdateCommand(object sender, GridRecordEventArgs e)
{
oboutGrid_utils o = new oboutGrid_utils();
o.oGrid_UpdateData(e.Record, "tblloginfo", "backend", "dbo", "loginfoID");
}
protected void gridPhone_UpdateCommand(object sender, GridRecordEventArgs e)
{
oboutGrid_utils o = new oboutGrid_utils();
o.oGrid_UpdateData(e.Record, "tblPhoneNumber", "backend", "dbo", "phoneID");
}
protected void gridEmail_UpdateCommand(object sender, GridRecordEventArgs e)
{
oboutGrid_utils o = new oboutGrid_utils();
o.oGrid_UpdateData(e.Record, "tblEmail", "backend", "dbo", "emailID");
}
protected void gridC_UpdateCommand(object sender, GridRecordEventArgs e)
{
oboutGrid_utils o = new oboutGrid_utils();
o.oGrid_UpdateData(e.Record, "tblSubjConsent", "backend", "dbo", "SubjConsentID");
}
protected void gridLogContact_UpdateCommand(object sender, GridRecordEventArgs e)
{
oboutGrid_utils o = new oboutGrid_utils();
o.oGrid_UpdateData(e.Record, "tblLogContact", "backend", "dbo", "logcontactID");
}
protected void gridAddress_UpdateCommand(object sender, GridRecordEventArgs e)
{
oboutGrid_utils o = new oboutGrid_utils();
o.oGrid_UpdateData(e.Record, "tblAddress", "backend", "dbo", "addressID");
}
