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 WorkUpdate() { // Get general variables int projectId = Int32.Parse(hdfCurrentProject.Value.Trim()); int companyId = Convert.ToInt32(Session["companyID"]); FlatSectionJl flatSectionJl = new FlatSectionJl(flatSectionJlTDS); DataView dataViewFlatSectionJl = new DataView(flatSectionJlTDS.FlatSectionJl); dataViewFlatSectionJl.RowFilter = "(Selected = 1) AND (Deleted = 0)"; foreach (DataRowView row in dataViewFlatSectionJl) { int workId = Int32.Parse(row["WorkID"].ToString()); int assetId = Int32.Parse(row["AssetID"].ToString()); string workType = "Junction Lining Lateral"; // Get original variables WorkGateway workGateway = new WorkGateway(); workGateway.LoadByWorkId(workId, companyId); string originalWorkType = workGateway.GetWorkTypeOriginal(workId); int? originalLibraryCategoriesId = workGateway.GetLibraryCategoriesIdOriginal(workId); string originalComment = workGateway.GetCommentsOriginal(workId); string originalHistory = workGateway.GetHistoryOriginal(workId); // Get new comment WorkCommentsGateway workCommentsGateway = new WorkCommentsGateway(); workCommentsGateway.LoadByWorkIdWorkType(workId, companyId, "Junction Lining Lateral"); WorkComments workComments = new WorkComments(workCommentsGateway.Data); string newComments = workComments.GetAllComments(workId, companyId, workCommentsGateway.Table.Rows.Count, "\n"); // Get new history WorkHistoryGateway workHistoryGateway = new WorkHistoryGateway(); workHistoryGateway.LoadByWorkIdWorkType(workId, companyId, "Junction Lining Lateral"); WorkHistory workHistory = new WorkHistory(workHistoryGateway.Data); string newHistory = workHistory.GetAllHistory(workId, companyId, workHistoryGateway.Table.Rows.Count, "\n"); Work work = new Work(null); work.UpdateDirect(workId, projectId, assetId, originalWorkType, originalLibraryCategoriesId, false, companyId, originalComment, originalHistory, workId, projectId, assetId, originalWorkType, originalLibraryCategoriesId, false, companyId, newComments, newHistory); flatSectionJl.UpdateCommentsHistoryForSummaryEdit(workId, workType, companyId); } }