private void PostPageChanges()
{
// Get selected id
string recordId = hdfRecordId.Value;
Guid id = new Guid(hdfSelectedId.Value);
int companyId = Int32.Parse(Session["companyID"].ToString());
JlinerAddMasterArea jlinerAddMasterArea = new JlinerAddMasterArea(jlinerAddTDS);
jlinerAddMasterArea.UpdateJliners(id, companyId);
Session["jlinerAddTDS"] = jlinerAddTDS;
}
private void UpdateDatabase()
{
DB.Open();
DB.BeginTransaction();
try
{
Guid id = new Guid(hdfSelectedId.Value);
int companyId = Int32.Parse(Session["companyID"].ToString());
// Save jliner2
JlinerAddJunctionLiner2 jlinerAddJunctionLiner2 = new JlinerAddJunctionLiner2(jlinerAddTDS);
jlinerAddJunctionLiner2.Save(id, companyId);
// Save section
JlinerAddMasterArea jlinerAddMasterArea = new JlinerAddMasterArea(jlinerAddTDS);
jlinerAddMasterArea.Save(id, companyId);
// Save jliner2comments
JlinerAddJunctionLiner2Comment jlinerAddJunctionLiner2Comment = new JlinerAddJunctionLiner2Comment(jlinerAddTDS);
jlinerAddJunctionLiner2Comment.Save(id, companyId);
DB.CommitTransaction();
// Store datasets
jlinerAddTDS.AcceptChanges();
Session["jlinerAddTDS"] = jlinerAddTDS;
}
catch (Exception ex)
{
DB.RollbackTransaction();
string url = string.Format("./../../error_page.aspx?error={0}", ex.Message.Replace('\n', ' '));
Response.Redirect(url);
}
}
private bool GetRecordId()
{
bool idIsSelected = false;
int companyId = Int32.Parse(Session["companyID"].ToString());
JlinerAddMasterArea jlinerAddMasterArea = new JlinerAddMasterArea(jlinerAddTDS);
// Update rows
foreach (GridViewRow row in grdSection.Rows)
{
Guid id = new Guid(((Label)row.FindControl("lblID")).Text);
string recordId = ((Label)row.FindControl("lblRecordId")).Text;
bool selected = ((CheckBox)row.FindControl("cbxSelected")).Checked;
string street = ((Label)row.FindControl("lblStreetGrid")).Text;
string actualLength = ((Label)row.FindControl("lblActualLengthGrid")).Text;
string usmh = ((Label)row.FindControl("lblUsmh")).Text;
string dsmh = ((Label)row.FindControl("lblDsmh")).Text;
jlinerAddMasterArea.Update(id, companyId, selected);
// ... Save selected project
if (selected)
{
hdfRecordId.Value = recordId;
hdfSelectedId.Value = id.ToString();
hdfStreet.Value = street;
hdfActualLength.Value = actualLength;
hdfUsmh.Value = usmh;
hdfDsmh.Value = dsmh;
idIsSelected = true;
}
}
return idIsSelected;
}
