protected void ogrid_detail_InsertCommand(object sender, GridRecordEventArgs e)
{
if (detail_tbl != "")
{
Hashtable hash = e.Record;
hash.Remove("master_pk");
hash.Add(master_pk, master_pkvalue.ToString());
// 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_InsertData(hash, detail_tbl, "uwautism_research_backend", schema, detail_pk, 0);
lblOutput.Text = output;
LoadDetail(schema, master_tbl, master_pk, detail_tbl, detail_pk, master_pkvalue, usestudy);
}
}
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_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 Grid_MyBudgets_InsertCommand(object sender, GridRecordEventArgs e)
{
oboutGrid_utils o = new oboutGrid_utils();
Hashtable hash = (Hashtable)e.Record;
string x = o.oGrid_InsertData(hash, "MyBudget", "backend", "fin", "mybudgetpk", 0);
LoadMyBudgets();
}
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) { }
}
}