private void UpdateDatabase() { DB.Open(); DB.BeginTransaction(); try { int companyId = Int32.Parse(hdfCompanyId.Value); // Update Comments and History FlatSectionJlCommentDetails flatSectionJlCommentDetails = new FlatSectionJlCommentDetails(flatSectionJlTDS); flatSectionJlCommentDetails.Save(companyId); FlatSectionJlHistoryDetails flatSectionJlHistoryDetails = new FlatSectionJlHistoryDetails(flatSectionJlTDS); flatSectionJlHistoryDetails.Save(companyId); // Update FlatSectionJl for new Comments int workId = Int32.Parse(hdfWorkId.Value.Trim()); string workType = "Junction Lining Lateral"; FlatSectionJl flatSectionJl = new FlatSectionJl(flatSectionJlTDS); flatSectionJl.UpdateCommentsHistoryForSummaryEdit(workId, workType, companyId); JlNavigator jlNavigator = new JlNavigator(jlNavigatorTDS); jlNavigator.UpdateComments(workId, workType, companyId); Session["flatSectionJlTDS"] = flatSectionJlTDS; Session["jlNavigatorTDS"] = jlNavigatorTDS; DB.CommitTransaction(); } catch (Exception ex) { DB.RollbackTransaction(); string url = string.Format("./../../error_page.aspx?error={0}", ex.Message.Replace('\n', ' ')); Response.Redirect(url); } }
private void UpdateDatabase() { // Get ids & location int projectId = Int32.Parse(hdfCurrentProject.Value.Trim()); int companyId = Int32.Parse(Session["companyID"].ToString()); // Load project ProjectGateway projectGateway = new ProjectGateway(); projectGateway.LoadByProjectId(projectId); // Get location Int64 countryId = projectGateway.GetCountryID(projectId); Int64? provinceId = null; if (projectGateway.GetProvinceID(projectId).HasValue) provinceId = (Int64)projectGateway.GetProvinceID(projectId); Int64? countyId = null; if (projectGateway.GetCountyID(projectId).HasValue) countyId = (Int64)projectGateway.GetCountyID(projectId); Int64? cityId = null; if (projectGateway.GetCityID(projectId).HasValue) cityId = (Int64)projectGateway.GetCityID(projectId); // Save DB.Open(); DB.BeginTransaction(); try { FlatSectionJl flatSectionJl = new FlatSectionJl(flatSectionJlTDS); if (Convert.ToBoolean(ViewState["UpdateComments"])) { // Update Comments FlatSectionJlCommentDetails flatSectionJlCommentDetails = new FlatSectionJlCommentDetails(flatSectionJlTDS); flatSectionJlCommentDetails.Save(companyId); // Update works WorkUpdate(); } else { flatSectionJl.UpdateDirect(countryId, provinceId, countyId, cityId, projectId, companyId); } DB.CommitTransaction(); flatSectionJlTDS.AcceptChanges(); // Store datasets Session["flatSectionJlTDS"] = flatSectionJlTDS; } catch (Exception ex) { DB.RollbackTransaction(); string url = string.Format("./../../error_page.aspx?error={0}", ex.Message.Replace('\n', ' ')); Response.Redirect(url); } }