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); } }
// ///////////////////////////////////////////////////////////////////////////////////////////////////// // STEP3 - JLINER // // //////////////////////////////////////////////////////////////////////// // STEP3 - JLINER - EVENTS // protected void grdJliner2_RowDeleting(object sender, GridViewDeleteEventArgs e) { // grdJliner2 Gridview, if the gridview is edition mode if (grdJliner2.EditIndex >= 0) { grdJliner2.UpdateRow(grdJliner2.EditIndex, true); } // Delete jliner Guid id = new Guid(((Label)grdJliner2.Rows[e.RowIndex].Cells[0].FindControl("lblId")).Text); int refId = Int32.Parse(((Label)grdJliner2.Rows[e.RowIndex].Cells[1].FindControl("lblRefId")).Text); int companyId = Int32.Parse(((Label)grdJliner2.Rows[e.RowIndex].Cells[2].FindControl("lblCOMPANY_ID")).Text); JlinerAddJunctionLiner2 model = new JlinerAddJunctionLiner2(jlinerAddTDS); model.Delete(id, refId, companyId); // ... delete comments JlinerAddJunctionLiner2CommentGateway jlinerAddJunctionLiner2CommentGateway = new JlinerAddJunctionLiner2CommentGateway(jlinerAddTDS); jlinerAddJunctionLiner2CommentGateway.LoadAllByIdRefId(id, refId, companyId); JlinerAddJunctionLiner2Comment jlinerAddJunctionLiner2Comment = new JlinerAddJunctionLiner2Comment(jlinerAddJunctionLiner2CommentGateway.Data); jlinerAddJunctionLiner2Comment.DeleteAllCommentsForAJliner(id, refId, companyId); // Save dataset Session["jlinerAddTDS"] = jlinerAddTDS; }