/// <summary> /// UpdateForProcess /// </summary> /// <param name="companyId">companyId</param> public void UpdateForReport(int companyId) { SectionGateway sectionGateway = new SectionGateway(); JlinerGateway jlinerGateway = new JlinerGateway(sectionGateway.Data); Jliner jliner = new Jliner(sectionGateway.Data); sectionGateway.ClearBeforeFill = false; jlinerGateway.ClearBeforeFill = false; SectionTDS.LFS_JUNCTION_LINER2Row lfsJunctionLiner2Row; foreach (JlinertoBuildReportTDS.JLinersToBuildRow jLinersToBuildRow in ((JlinertoBuildReportTDS.JLinersToBuildDataTable)Table)) { // Load sections try { sectionGateway.GetRow(jLinersToBuildRow.ID); } catch { sectionGateway.LoadById(jLinersToBuildRow.ID, companyId); } // Load laterals try { lfsJunctionLiner2Row = (SectionTDS.LFS_JUNCTION_LINER2Row) jlinerGateway.GetRow(jLinersToBuildRow.ID, jLinersToBuildRow.RefID); } catch { jlinerGateway.LoadByIdCompanyId(jLinersToBuildRow.ID, companyId); lfsJunctionLiner2Row = (SectionTDS.LFS_JUNCTION_LINER2Row) jlinerGateway.GetRow(jLinersToBuildRow.ID, jLinersToBuildRow.RefID); } // Update InProcess lfsJunctionLiner2Row.InProcess = DateTime.Now; lfsJunctionLiner2Row.BuildRebuild++; } //Update try { sectionGateway.Update(); } catch (Exception ex) { throw new Exception(ex.Message); } }
/// <summary> /// Save to Section and Jliner rows /// </summary> /// <param name="sectionTDS">sectionTDS</param> public void Save(SectionTDS sectionTDS) { FlatSectionJlinerTDS flatSectionJlinerChanges = (FlatSectionJlinerTDS)Data.GetChanges(); if (flatSectionJlinerChanges.FlatSectionJliner.Rows.Count > 0) { SectionGateway sectionGateway = new SectionGateway(sectionTDS); LiquiForce.LFSLive.BL.CWP.Section.Section section = new LiquiForce.LFSLive.BL.CWP.Section.Section(sectionTDS); JlinerGateway jlinerGateway = new JlinerGateway(sectionTDS); Jliner jliner = new Jliner(sectionTDS); JlinerCommentGateway jlinerCommentGateway = new JlinerCommentGateway(sectionTDS); JlinerComments jlinerComments = new JlinerComments(jlinerCommentGateway.Data); JlinerHistoryGateway jlinerHistoryGateway = new JlinerHistoryGateway(sectionTDS); JlinerHistory jlinerHistory = new JlinerHistory(jlinerHistoryGateway.Data); sectionGateway.ClearBeforeFill = false; jlinerGateway.ClearBeforeFill = false; jlinerCommentGateway.ClearBeforeFill = false; jlinerHistoryGateway.ClearBeforeFill = false; foreach (FlatSectionJlinerTDS.FlatSectionJlinerRow flatSectionJlinerRow in (FlatSectionJlinerTDS.FlatSectionJlinerDataTable)flatSectionJlinerChanges.FlatSectionJliner) { // Load section and jliner // ... Load section try { //... Search section row sectionGateway.GetRow(flatSectionJlinerRow.ID); } catch { //... Load section and section's jliners sectionGateway.LoadById(flatSectionJlinerRow.ID, flatSectionJlinerRow.COMPANY_ID); jlinerGateway.LoadByIdCompanyId(flatSectionJlinerRow.ID, flatSectionJlinerRow.COMPANY_ID); jlinerCommentGateway.LoadById(flatSectionJlinerRow.ID, flatSectionJlinerRow.COMPANY_ID); jlinerHistoryGateway.LoadById(flatSectionJlinerRow.ID, flatSectionJlinerRow.COMPANY_ID); } // Update // ... Update jliner string address = ""; if (!flatSectionJlinerRow.IsNull("Address")) address = flatSectionJlinerRow.Address; DateTime? pipeLocated = null; if (!flatSectionJlinerRow.IsNull("PipeLocated")) pipeLocated = flatSectionJlinerRow.PipeLocated; DateTime? servicesLocated = null; if (!flatSectionJlinerRow.IsNull("ServicesLocated")) servicesLocated = flatSectionJlinerRow.ServicesLocated; DateTime? coInstalled = null; if (!flatSectionJlinerRow.IsNull("CoInstalled")) coInstalled = flatSectionJlinerRow.CoInstalled; DateTime? backfilledConcrete = null; if (!flatSectionJlinerRow.IsNull("BackfilledConcrete")) backfilledConcrete = flatSectionJlinerRow.BackfilledConcrete; DateTime? backfilledSoil = null; if (!flatSectionJlinerRow.IsNull("BackfilledSoil")) backfilledSoil = flatSectionJlinerRow.BackfilledSoil; DateTime? grouted = null; if (!flatSectionJlinerRow.IsNull("Grouted")) grouted = flatSectionJlinerRow.Grouted; DateTime? cored = null; if (!flatSectionJlinerRow.IsNull("Cored")) cored = flatSectionJlinerRow.Cored; DateTime? prepped = null; if (!flatSectionJlinerRow.IsNull("Prepped")) prepped = flatSectionJlinerRow.Prepped; DateTime? measured = null; if (!flatSectionJlinerRow.IsNull("Measured")) measured = flatSectionJlinerRow.Measured; string linerSize = ""; if (!flatSectionJlinerRow.IsNull("LinerSize")) linerSize = flatSectionJlinerRow.LinerSize; DateTime? inProcess = null; if (!flatSectionJlinerRow.IsNull("Inprocess")) inProcess = flatSectionJlinerRow.InProcess; DateTime? inStock = null; if (!flatSectionJlinerRow.IsNull("InStock")) inStock = flatSectionJlinerRow.InStock; DateTime? delivered = null; if (!flatSectionJlinerRow.IsNull("Delivered")) delivered = flatSectionJlinerRow.Delivered; DateTime? preVideo = null; if (!flatSectionJlinerRow.IsNull("PreVideo")) preVideo = flatSectionJlinerRow.PreVideo; DateTime? linerInstalled = null; if (!flatSectionJlinerRow.IsNull("LinerInstalled")) linerInstalled = flatSectionJlinerRow.LinerInstalled; DateTime? finalVideo = null; if (!flatSectionJlinerRow.IsNull("FinalVideo")) finalVideo = flatSectionJlinerRow.FinalVideo; double? distanceFromUSMH = null; if (!flatSectionJlinerRow.IsNull("DistanceFromUSMH")) distanceFromUSMH = flatSectionJlinerRow.DistanceFromUSMH; double? distanceFromDSMH = null; if (!flatSectionJlinerRow.IsNull("DistanceFromDSMH")) distanceFromDSMH = flatSectionJlinerRow.DistanceFromDSMH; string history = ""; if (!flatSectionJlinerRow.IsNull("History")) history = flatSectionJlinerRow.History; string map = ""; string issue = flatSectionJlinerRow.Issue; decimal? cost = null; if (!flatSectionJlinerRow.IsNull("Cost")) cost = flatSectionJlinerRow.Cost; bool deleted = flatSectionJlinerRow.Deleted; // ... Delete all comments and history for a jliner if (deleted) { jlinerComments.DeleteAllCommentsForAJliner(flatSectionJlinerRow.ID, flatSectionJlinerRow.RefID, flatSectionJlinerRow.COMPANY_ID); jlinerHistory.DeleteAllHistoryForAJliner(flatSectionJlinerRow.ID, flatSectionJlinerRow.RefID, flatSectionJlinerRow.COMPANY_ID); } DateTime? videoInspection = null; if (!flatSectionJlinerRow.IsNull("VideoInspection")) videoInspection = flatSectionJlinerRow.VideoInspection; bool coRequired = flatSectionJlinerRow.CoRequired; bool pitRequired = flatSectionJlinerRow.PitRequired; string coPitLocation = ""; if (!flatSectionJlinerRow.IsNull("CoPitLocation")) coPitLocation = flatSectionJlinerRow.CoPitLocation; bool postContractDigRequired = flatSectionJlinerRow.PostContractDigRequired; DateTime? coCutDown = null; if (!flatSectionJlinerRow.IsNull("CoCutDown")) coCutDown = flatSectionJlinerRow.CoCutDown; DateTime? finalRestoration = null; if (!flatSectionJlinerRow.IsNull("FinalRestoration")) finalRestoration = flatSectionJlinerRow.FinalRestoration; string clientLateralId = ""; if (!flatSectionJlinerRow.IsNull("ClientLateralID")) clientLateralId = flatSectionJlinerRow.ClientLateralID; string videoLengthToPropertyLine = ""; if (!flatSectionJlinerRow.IsNull("VideoLengthToPropertyLine")) videoLengthToPropertyLine = flatSectionJlinerRow.VideoLengthToPropertyLine; bool liningThruCo = flatSectionJlinerRow.LiningThruCo; string hamiltonInspectionNumber = ""; if (!flatSectionJlinerRow.IsNull("HamiltonInspectionNumber")) hamiltonInspectionNumber = flatSectionJlinerRow.HamiltonInspectionNumber; DateTime? noticeDelivered = null; if (!flatSectionJlinerRow.IsNull("NoticeDelivered")) noticeDelivered = flatSectionJlinerRow.NoticeDelivered; jliner.Update(flatSectionJlinerRow.ID, flatSectionJlinerRow.RefID, flatSectionJlinerRow.COMPANY_ID, flatSectionJlinerRow.DetailID, address, pipeLocated, servicesLocated, coInstalled, backfilledConcrete, backfilledSoil, grouted, cored, prepped, measured, linerSize, inProcess, inStock, delivered, preVideo, linerInstalled, finalVideo, distanceFromUSMH, distanceFromDSMH,map, issue, cost, deleted, videoInspection, coRequired, pitRequired, coPitLocation, postContractDigRequired, coCutDown, finalRestoration, clientLateralId, videoLengthToPropertyLine, liningThruCo, hamiltonInspectionNumber, noticeDelivered); // ... Update section section.UpdateJliners(flatSectionJlinerRow.ID, flatSectionJlinerRow.COMPANY_ID); } } }
/// <summary> /// Update - JLiner /// </summary> public void Update() { JlinerGateway jlinerGateway = new JlinerGateway(Data); JlinerCommentGateway jlinerCommentGateway = new JlinerCommentGateway(Data); DataTable sectionChanges = Table.GetChanges(); DataTable jlinerChanges = jlinerGateway.Table.GetChanges(); DataTable jlinerCommentChanges = jlinerCommentGateway.Table.GetChanges(); if ((sectionChanges == null) && (jlinerChanges == null) && (jlinerCommentChanges == null)) return; try { DB.Open(); DB.BeginTransaction(); Adapter.InsertCommand.Transaction = DB.Transaction; Adapter.UpdateCommand.Transaction = DB.Transaction; Adapter.DeleteCommand.Transaction = DB.Transaction; jlinerGateway.Adapter.InsertCommand.Transaction = DB.Transaction; jlinerGateway.Adapter.UpdateCommand.Transaction = DB.Transaction; jlinerGateway.Adapter.DeleteCommand.Transaction = DB.Transaction; jlinerCommentGateway.Adapter.InsertCommand.Transaction = DB.Transaction; jlinerCommentGateway.Adapter.UpdateCommand.Transaction = DB.Transaction; jlinerCommentGateway.Adapter.DeleteCommand.Transaction = DB.Transaction; if ((sectionChanges != null) && (sectionChanges.Rows.Count > 0)) { Adapter.Update(sectionChanges); } if ((jlinerChanges != null) && (jlinerChanges.Rows.Count > 0)) { jlinerGateway.Adapter.Update(jlinerChanges); } if ((jlinerCommentChanges != null) && (jlinerCommentChanges.Rows.Count > 0)) { jlinerCommentGateway.Adapter.Update(jlinerCommentChanges); } DB.CommitTransaction(); } catch (DBConcurrencyException dBConcurrencyException) { DB.RollbackTransaction(); throw new Exception("Concurrency error: Another user already updated the data you are working on. Your operation has been cancelled.", dBConcurrencyException); } catch (SqlException sqlException) { DB.RollbackTransaction(); byte severityLevel = sqlException.Class; if (severityLevel <= 16) { throw new Exception("Low severity error. Your operation has been cancelled. SQL Error " + severityLevel + "."); } if ((severityLevel >= 17) && (severityLevel <= 19)) { throw new Exception("Mid severity error. Your operation has been cancelled. SQL Error " + severityLevel + "."); } if (severityLevel >= 20) { throw new Exception("High severity error. Your operation has been cancelled. SQL Error " + severityLevel + "."); } } catch (Exception e) { DB.RollbackTransaction(); throw new Exception("Unknow error. Your operation has been cancelled.", e); } finally { DB.Close(); } }
/// <summary> /// Save a JL Work /// </summary> /// <param name="originalId">originalId</param> /// <param name="projectId">projectId</param> /// <param name="section_assetId">section_assetId</param> /// <param name="numLats">numLats</param> /// <param name="notLinedYet">notLinedYet</param> /// <param name="allMeasured">allMeasured</param> /// <param name="issueWithLaterals">issueWithLaterals</param> /// <param name="notMeasuredYet">notMeasuredYet</param> /// <param name="notDeliveredYet">notDeliveredYet</param> /// <param name="countryId">countryId</param> /// <param name="provinceId">provinceId</param> /// <param name="countyId">countyId</param> /// <param name="cityId">cityId</param> /// <param name="companyId">companyId</param> private void SaveJLWork(Guid originalId, int section_assetId, int numLats, int notLinedYet, bool allMeasured, string issueWithLaterals, int notMeasuredYet, int notDeliveredYet, int projectId, Int64? countryId, Int64? provinceId, Int64? countyId, Int64? cityId, int companyId) { // Insert Junction Lining Section WorkJunctionLiningSection workJunctionLiningSection = new WorkJunctionLiningSection(null); int sectionWorkId = workJunctionLiningSection.InsertDirect(projectId, section_assetId, null, numLats, notLinedYet, allMeasured, issueWithLaterals, notMeasuredYet, notDeliveredYet, false, companyId, "", "", "", "", false, "", 0); // Insert Junction Lining Laterals SectionTDS sectionTDS = new SectionTDS(); SectionGateway sectionGateway = new SectionGateway(sectionTDS); sectionGateway.LoadById(originalId, companyId); JlinerGateway jlinerGateway = new JlinerGateway(sectionTDS); jlinerGateway.LoadByIdCompanyId(originalId, companyId); foreach (SectionTDS.LFS_JUNCTION_LINER2Row row in (SectionTDS.LFS_JUNCTION_LINER2DataTable)jlinerGateway.Table) { string lateralID = ""; if (!row.IsDetailIDNull()) lateralID = row.DetailID; string address = ""; if (!row.IsAddressNull()) address = row.Address; string distanceFromUSMH = ""; if (!row.IsDistanceFromUSMHNull()) distanceFromUSMH = row.DistanceFromUSMH.ToString(); string distanceFromDSMH = ""; if (!row.IsDistanceFromDSMHNull()) distanceFromDSMH = row.DistanceFromDSMH.ToString(); DateTime? pipeLocated = null; if (!row.IsPipeLocatedNull()) pipeLocated = row.PipeLocated; DateTime? servicesLocated = null; if (!row.IsServicesLocatedNull()) servicesLocated = row.ServicesLocated; DateTime? coInstalled = null; if (!row.IsCoInstalledNull()) coInstalled = row.CoInstalled; DateTime? backfilledConcrete = null; if (!row.IsBackfilledConcreteNull()) backfilledConcrete = row.BackfilledConcrete; DateTime? backfilledSoil = null; if (!row.IsBackfilledSoilNull()) backfilledSoil = row.BackfilledSoil; DateTime? grouted = null; if (!row.IsGroutedNull()) grouted = row.Grouted; DateTime? cored = null; if (!row.IsCoredNull()) cored = row.Cored; DateTime? prepped = null; if (!row.IsPreppedNull()) prepped = row.Prepped; DateTime? measured = null; if (!row.IsMeasuredNull()) measured = row.Measured; string linerSize = ""; if (!row.IsLinerSizeNull()) linerSize = row.LinerSize; DateTime? inProcess = null; if (!row.IsInProcessNull()) inProcess = row.InProcess; DateTime? inStock = null; if (!row.IsInStockNull()) inStock = row.InStock; DateTime? delivered = null; if (!row.IsDeliveredNull()) delivered = row.Delivered; int? buildRebuid = null; if (!row.IsBuildRebuildNull()) buildRebuid = row.BuildRebuild; DateTime? preVideo = null; if (!row.IsPreVideoNull()) preVideo = row.PreVideo; DateTime? linerInstalled = null; if (!row.IsLinerInstalledNull()) linerInstalled = row.LinerInstalled; DateTime? finalVideo = null; if (!row.IsFinalVideoNull()) finalVideo = row.FinalVideo; string map = ""; if (!row.IsMapNull()) map = row.Map; decimal? cost = null; if (!row.IsCostNull()) cost = row.Cost; DateTime? videoInspection = null; if (!row.IsVideoInspectionNull()) videoInspection = row.VideoInspection; bool coRequired = row.CoRequired; bool pitRequired = row.PitRequired; string coPitLocation = ""; if (!row.IsCoPitLocationNull()) coPitLocation = row.CoPitLocation; bool postContractDigRequired = row.PostContractDigRequired; string comments = ""; if (!row.IsCommentsNull()) comments = row.Comments; string history = ""; if (!row.IsHistoryNull()) history = row.History; DateTime? coCutDown = null; if (!row.IsCoCutDownNull()) coCutDown = row.CoCutDown; DateTime? finalRestoration = null; if (!row.IsFinalRestorationNull()) finalRestoration = row.FinalRestoration; string clientLateralId = ""; if (!row.IsClientLateralIDNull()) clientLateralId = row.ClientLateralID; string videoLengthToPropertyLine = ""; if (!row.IsVideoLengthToPropertyLineNull()) videoLengthToPropertyLine = row.VideoLengthToPropertyLine; bool liningThruCo = row.LiningThruCo; DateTime? noticeDelivered = null; if (!row.IsNoticeDeliveredNull()) noticeDelivered = row.NoticeDelivered; string hamiltonInspectionNumber = ""; if (!row.IsHamiltonInspectionNumberNull()) hamiltonInspectionNumber = row.HamiltonInspectionNumber; bool dyeTestReq = row.DyeTestReq; DateTime? dyeTestComplete = null; if (!row.IsDyeTestCompleteNull()) dyeTestComplete = row.DyeTestComplete; // Fields only presents in new Junction lining string flange = ""; string gasket = ""; string connectionType = ""; string depthOfLocated = ""; bool digRequiredPriorToLining = false; DateTime? digRequiredPriorToLiningCompleted = null; bool digRequiredAfterLining = false; DateTime? digRequiredAfterLiningCompleted = null; bool outOfScope = false; bool holdClientIssue = false; DateTime? holdClientIssueResolved = null; bool holdLFSIssue = false; DateTime? holdLFSIssueResolved = null; bool requiresRoboticPrep = false; DateTime? requiresRoboticPrepCompleted = null; ProjectGateway projectGateway = new ProjectGateway(); projectGateway.LoadByProjectId(projectId); int clientId = projectGateway.GetClientID(projectId); // Insert into LFS Asset Lateral LfsAssetSewerLateral lfsAssetSewerLateral = new LfsAssetSewerLateral(null); int lateralAssetId = lfsAssetSewerLateral.InsertDirect(countryId, provinceId, countyId, cityId, section_assetId, address, lateralID, "", "", "", "", "Live", "", distanceFromUSMH, distanceFromDSMH, "", false, companyId, connectionType); // Insert into LFS Asset Lateral Client LfsAssetSewerLateralClient lfsAssetSewerLateralClient = new LfsAssetSewerLateralClient(null); lfsAssetSewerLateralClient.InsertDirect(lateralAssetId, clientId, clientLateralId, false, companyId); // Insert into Work Junction Lining Lateral WorkJunctionLiningLateral workJunctionLiningLateral = new WorkJunctionLiningLateral(null); int workLateral = workJunctionLiningLateral.InsertDirect(projectId, lateralAssetId, sectionWorkId, pipeLocated, servicesLocated, coInstalled, backfilledConcrete, backfilledSoil, grouted, cored, prepped, measured, linerSize, inProcess, inStock, delivered, buildRebuid, preVideo, linerInstalled, finalVideo, cost, videoInspection, coRequired, pitRequired, coPitLocation, postContractDigRequired, coCutDown, finalRestoration, false, companyId, comments, history, videoLengthToPropertyLine, liningThruCo, noticeDelivered, hamiltonInspectionNumber, flange, gasket, depthOfLocated, digRequiredPriorToLining, digRequiredPriorToLiningCompleted, digRequiredAfterLining, digRequiredAfterLiningCompleted, outOfScope, holdClientIssue, holdClientIssueResolved, holdLFSIssue, holdLFSIssueResolved, requiresRoboticPrep, requiresRoboticPrepCompleted, "", "", dyeTestReq, dyeTestComplete, ""); // Insert into Work Comments JlinerCommentGateway jlinerCommentGateway = new JlinerCommentGateway(sectionTDS); jlinerCommentGateway.LoadByIdRefId(originalId, row.RefID, companyId); foreach (SectionTDS.LFS_JUNCTION_LINER2_COMMENTRow rowComment in (SectionTDS.LFS_JUNCTION_LINER2_COMMENTDataTable)jlinerCommentGateway.Table) { int loginId = rowComment.LoginID; DateTime dateTime_ = rowComment.DateTime_; string comment = rowComment.Comment; WorkCommentsGateway workCommentsGateway = new WorkCommentsGateway(); workCommentsGateway.LoadByWorkIdWorkType(workLateral, companyId, "Junction Lining Lateral"); WorkComments workComments = new WorkComments(workCommentsGateway.Data); workComments.Insert(workLateral, 0, "Junction Lining Lateral", "Bulk Upload Comments", loginId, dateTime_, comment, null, false, companyId, false, "Junction Lining"); // Update Comments workCommentsGateway.Update(); } // Insert into Work History JlinerHistoryGateway jlinerHistoryGateway = new JlinerHistoryGateway(sectionTDS); jlinerHistoryGateway.LoadByIdRefId(originalId, row.RefID, companyId); foreach (SectionTDS.LFS_JUNCTION_LINER2_HISTORYRow rowHistory in (SectionTDS.LFS_JUNCTION_LINER2_HISTORYDataTable)jlinerHistoryGateway.Table) { int loginId = rowHistory.LoginID; DateTime dateTime_H = rowHistory.DateTime_; string history_ = rowHistory.History; WorkHistoryGateway workHistoryGateway = new WorkHistoryGateway(); workHistoryGateway.LoadByWorkIdWorkType(workLateral, companyId, "Junction Lining Lateral"); WorkHistory workHistory = new WorkHistory(workHistoryGateway.Data); workHistory.Insert(workLateral, 0, "Junction Lining Lateral", "Bulk Upload History", loginId, dateTime_H, history_, null, false, companyId, false, "Junction Lining"); // Update History workHistoryGateway.Update(); } } }
// //////////////////////////////////////////////////////////////////////// // EVENTS // protected void Page_Load(object sender, EventArgs e) { // Register client scripts this.RegisterClientScripts(); if (!IsPostBack) { // Security check if (!(Convert.ToBoolean(Session["sgLFS_APP_VIEW"]) && Convert.ToBoolean(Session["sgLFS_APP_EDIT"]))) { Response.Redirect("./../../error_page.aspx?error=" + "You are not authorized to view this page. Contact your system administrator."); } // Validate query string if (((string)Request.QueryString["source_page"] == null) || ((string)Request.QueryString["client"] == null)) { Response.Redirect("./../../error_page.aspx?error=" + "Invalid query string in flat_section_jliner_edit.aspx"); } // Tag page hdfCurrentClient.Value = (string)Request.QueryString["client"]; hdfLoginId.Value = Convert.ToInt32(Session["loginID"]).ToString(); hdfId.Value = Convert.ToString(Request.QueryString["rowId"]); hdfRefId.Value = Convert.ToString(Request.QueryString["rowRefId"]); hdfCompanyId.Value = Convert.ToString(Request.QueryString["rowCompanyId"]); hdfAdminPermission.Value = Convert.ToBoolean(Session["sgLFS_APP_ADMIN"]).ToString(); hdfUpdate.Value = "yes"; // Prepare initial data Session.Remove("commentsDummy"); // ... Names for UserList int companyId = Int32.Parse(hdfCompanyId.Value); LoginGateway loginGateway = new LoginGateway(); loginGateway.LoadByLoginId(Convert.ToInt32(hdfLoginId.Value), companyId); hdfCreatedBy.Value = loginGateway.GetLastName(Convert.ToInt32(hdfLoginId.Value), companyId) + " " + loginGateway.GetFirstName(Convert.ToInt32(hdfLoginId.Value), companyId); hdfCreationDateTime.Value = DateTime.Now.ToString(); // If comming from // ... flat_section_jliner_summary.aspx if (Request.QueryString["source_page"] == "flat_section_jliner_summary.aspx" || Request.QueryString["source_page"] == "flat_section_jliner_edit.aspx") { StoreNavigatorState(); ViewState["update"] = Request.QueryString["update"]; Session["rowFocus"] = Convert.ToInt32(Request.QueryString["rowFocus"].ToString()); // ... Load comments to edit sectionTDS = new SectionTDS(); flatSectionJlinerTDS = (FlatSectionJlinerTDS)Session["flatSectionJlinerTDS"]; SectionGateway sectionGateway = new SectionGateway(sectionTDS); sectionGateway.LoadById(new Guid(hdfId.Value), Convert.ToInt32(hdfCompanyId.Value)); JlinerGateway jlinerGateway = new JlinerGateway(sectionTDS); jlinerGateway.LoadByIdCompanyIdRefId(new Guid(hdfId.Value), Convert.ToInt32(hdfCompanyId.Value), Convert.ToInt32(hdfRefId.Value)); FlatSectionJlinerJuntionLiner2CommentGateway flatSectionJlinerJuntionLiner2CommentGateway = new FlatSectionJlinerJuntionLiner2CommentGateway(flatSectionJlinerTDS); flatSectionJlinerJuntionLiner2CommentGateway.LoadAllByIdRefId(new Guid(hdfId.Value), Convert.ToInt32(hdfRefId.Value), Convert.ToInt32(hdfCompanyId.Value)); FlatSectionJlinerJuntionLiner2Comment flatSectionJlinerJuntionLiner2Comment = new FlatSectionJlinerJuntionLiner2Comment(flatSectionJlinerJuntionLiner2CommentGateway.Data); flatSectionJlinerJuntionLiner2Comment.UpdateForProcess(); // ... Load history for transfers FlatSectionJlinerJuntionLiner2HistoryGateway flatSectionJlinerJuntionLiner2HistoryGateway = new FlatSectionJlinerJuntionLiner2HistoryGateway(flatSectionJlinerTDS); flatSectionJlinerJuntionLiner2HistoryGateway.LoadAllByIdRefId(new Guid(hdfId.Value), Convert.ToInt32(hdfRefId.Value), Convert.ToInt32(hdfCompanyId.Value)); // ... Store datasets Session["sectionTDS"] = sectionTDS; Session["flatSectionJlinerTDS"] = flatSectionJlinerTDS; comments = flatSectionJlinerTDS.JuntionLiner2Comment; Session["comments"] = comments; } } else { // Restore datasets sectionTDS = (SectionTDS)Session["sectionTDS"]; flatSectionJlinerTDS = (FlatSectionJlinerTDS)Session["flatSectionJlinerTDS"]; Session["flatSectionJlinerTDS"] = flatSectionJlinerTDS; comments = flatSectionJlinerTDS.JuntionLiner2Comment; Session["comments"] = comments; } }
/// <summary> /// DeleteDirect /// </summary> /// <param name="id">id</param> /// <param name="refId">refId</param> /// <param name="companyId">companyId</param> public void DeleteDirect(Guid id, int refId, int companyId) { JlinerGateway jlinerGateway = new JlinerGateway(null); jlinerGateway.Delete(id, refId, companyId); }
/// <summary> /// Update direct /// </summary> /// <param name="originalId">originalId</param> /// <param name="originalRefId">originalRefId</param> /// <param name="originalCompanyId">originalCompanyId</param> /// <param name="originalDetailId">originalDetailId</param> /// <param name="originalAddress">originalAddress</param> /// <param name="originalPipeLocated">originalPipeLocated</param> /// <param name="originalServicesLocated">originalServicesLocated</param> /// <param name="originalCoInstalled">originalCoInstalled</param> /// <param name="originalBackfilledConcrete">originalBackfilledConcrete</param> /// <param name="originalBackfilledSoil">originalBackfilledSoil</param> /// <param name="originalGrouted">originalGrouted</param> /// <param name="originalCored">originalCored</param> /// <param name="originalPrepped">originalPrepped</param> /// <param name="originalMeasured">originalMeasured</param> /// <param name="originalLinerSize">originalLinerSize</param> /// <param name="originalInProcess">originalInProcess</param> /// <param name="originalInStock">originalInStock</param> /// <param name="originalDelivered">originalDelivered</param> /// <param name="originalBuildRebuild">originalBuildRebuild</param> /// <param name="originalPreVideo">originalPreVideo</param> /// <param name="originalLinerInstalled">originalLinerInstalled</param> /// <param name="originalFinalVideo">originalFinalVideo</param> /// <param name="originalDistanceFromUSMH">originalDistanceFromUSMH</param> /// <param name="originalDistanceFromDSMH">originalDistanceFromDSMH</param> /// <param name="originalMap">originalMap</param> /// <param name="originalIssue">originalIssue</param> /// <param name="originalCost">originalCost</param> /// <param name="originalDeleted">originalDeleted</param> /// <param name="originalVideoInspection">originalVideoInspection</param> /// <param name="originalCoRequired">originalCoRequired</param> /// <param name="originalPitRequired">originalPitRequired</param> /// <param name="originalCoPitLocation">originalCoPitLocation</param> /// <param name="originalPostContractDigRequired">originalPostContractDigRequired</param> /// <param name="originalComments">originalComments</param> /// <param name="originalHistory">originalHistory</param> /// <param name="originalCoCutDown">originalCoCutDown</param> /// <param name="originalFinalRestoration">originalFinalRestoration</param> /// <param name="originalClientLateralID">originalClientLateralID</param> /// <param name="originalVideoLengthToPropertyLine">originalVideoLengthToPropertyLine</param> /// <param name="originalLiningThruCo">originalLiningThruCo</param> /// <param name="originalHamiltonInspectionNumber">originalHamiltonInspectionNumber</param> /// <param name="originalNoticeDelivered">originalNoticeDelivered</param> /// /// <param name="newId">newId</param> /// <param name="newRefId">newRefId</param> /// <param name="newCompanyId">newCompanyId</param> /// <param name="newDetailId">newDetailId</param> /// <param name="newAddress">newAddress</param> /// <param name="newPipeLocated">newPipeLocated</param> /// <param name="newServicesLocated">newServicesLocated</param> /// <param name="newCoInstalled">newCoInstalled</param> /// <param name="newBackfilledConcrete">newBackfilledConcrete</param> /// <param name="newBackfilledSoil">newBackfilledSoil</param> /// <param name="newGrouted">newGrouted</param> /// <param name="newCored">newCored</param> /// <param name="newPrepped">newPrepped</param> /// <param name="newMeasured">newMeasured</param> /// <param name="newLinerSize">newLinerSize</param> /// <param name="newInProcess">newInProcess</param> /// <param name="newInStock">newInStock</param> /// <param name="newDelivered">newDelivered</param> /// <param name="newBuildRebuild">newBuildRebuild</param> /// <param name="newPreVideo">newPreVideo</param> /// <param name="newLinerInstalled">newLinerInstalled</param> /// <param name="newFinalVideo">newFinalVideo</param> /// <param name="newDistanceFromUSMH">newDistanceFromUSMH</param> /// <param name="newDistanceFromDSMH">newDistanceFromDSMH</param> /// <param name="newMap">newMap</param> /// <param name="newIssue">newIssue</param> /// <param name="newCost">newCost</param> /// <param name="newDeleted">newDeleted</param> /// <param name="newVideoInspection">newVideoInspection</param> /// <param name="newCoRequired">newCoRequired</param> /// <param name="newPitRequired">newPitRequired</param> /// <param name="newCoPitLocation">newCoPitLocation</param> /// <param name="newPostContractDigRequired">newPostContractDigRequired</param> /// <param name="newComments">newComments</param> /// <param name="newHistory">newHistory</param> /// <param name="newCoCutDown">newCoCutDown</param> /// <param name="newFinalRestoration">newFinalRestoration</param> /// <param name="newClientLateralID">newClientLateralID</param> /// <param name="newVideoLengthToPropertyLine">newVideoLengthToPropertyLine</param> /// <param name="newLiningThruCo">newLiningThruCo</param> /// <param name="newHamiltonInspectionNumber">newHamiltonInspectionNumber</param> /// <param name="newNoticeDelivered">newNoticeDelivered</param> public void UpdateDirect(Guid originalId, int originalRefId, int originalCompanyId, string originalDetailId, string originalAddress, DateTime? originalPipeLocated, DateTime? originalServicesLocated, DateTime? originalCoInstalled, DateTime? originalBackfilledConcrete, DateTime? originalBackfilledSoil, DateTime? originalGrouted, DateTime? originalCored, DateTime? originalPrepped, DateTime? originalMeasured, string originalLinerSize, DateTime? originalInProcess, DateTime? originalInStock, DateTime? originalDelivered, int? originalBuildRebuild, DateTime? originalPreVideo, DateTime? originalLinerInstalled, DateTime? originalFinalVideo, double? originalDistanceFromUSMH, double? originalDistanceFromDSMH, string originalMap, string originalIssue, decimal? originalCost, bool originalDeleted, DateTime? originalVideoInspection, bool originalCoRequired, bool originalPitRequired, string originalCoPitLocation, bool originalPostContractDigRequired, string originalComments, string originalHistory, DateTime? originalCoCutDown, DateTime? originalFinalRestoration, string originalClientLateralID, string originalVideoLengthToPropertyLine, bool originalLiningThruCo, string originalHamiltonInspectionNumber, DateTime? originalNoticeDelivered, Guid newId, int newRefId, int newCompanyId, string newDetailId, string newAddress, DateTime? newPipeLocated, DateTime? newServicesLocated, DateTime? newCoInstalled, DateTime? newBackfilledConcrete, DateTime? newBackfilledSoil, DateTime? newGrouted, DateTime? newCored, DateTime? newPrepped, DateTime? newMeasured, string newLinerSize, DateTime? newInProcess, DateTime? newInStock, DateTime? newDelivered, int? newBuildRebuild, DateTime? newPreVideo, DateTime? newLinerInstalled, DateTime? newFinalVideo, double? newDistanceFromUSMH, double? newDistanceFromDSMH, string newMap, string newIssue, decimal? newCost, bool newDeleted, DateTime? newVideoInspection, bool newCoRequired, bool newPitRequired, string newCoPitLocation, bool newPostContractDigRequired, string newComments, string newHistory, DateTime? newCoCutDown, DateTime? newFinalRestoration, string newClientLateralID, string newVideoLengthToPropertyLine, bool newLiningThruCo, string newHamiltonInspectionNumber, DateTime? newNoticeDelivered) { JlinerGateway jlinerGateway = new JlinerGateway(null); jlinerGateway.Update(originalId, originalRefId, originalCompanyId, originalDetailId, originalAddress, originalPipeLocated, originalServicesLocated, originalCoInstalled, originalBackfilledConcrete, originalBackfilledSoil, originalGrouted, originalCored, originalPrepped, originalMeasured, originalLinerSize, originalInProcess, originalInStock, originalDelivered, originalBuildRebuild, originalPreVideo, originalLinerInstalled, originalFinalVideo, originalDistanceFromUSMH, originalDistanceFromDSMH, originalMap, originalIssue, originalCost, originalDeleted, originalVideoInspection, originalCoRequired, originalPitRequired, originalCoPitLocation, originalPostContractDigRequired, originalComments, originalHistory, originalCoCutDown, originalFinalRestoration, originalClientLateralID, originalVideoLengthToPropertyLine, originalLiningThruCo, originalHamiltonInspectionNumber, originalNoticeDelivered, newId, newRefId, newCompanyId, newDetailId, newAddress, newPipeLocated, newServicesLocated, newCoInstalled, newBackfilledConcrete, newBackfilledSoil, newGrouted, newCored, newPrepped, newMeasured, newLinerSize, newInProcess, newInStock, newDelivered, newBuildRebuild, newPreVideo, newLinerInstalled, newFinalVideo, newDistanceFromUSMH, newDistanceFromDSMH, newMap, newIssue, newCost, newDeleted, newVideoInspection, newCoRequired, newPitRequired, newCoPitLocation, newPostContractDigRequired, newComments, newHistory, newCoCutDown, newFinalRestoration, newClientLateralID, newVideoLengthToPropertyLine, newLiningThruCo, newHamiltonInspectionNumber, newNoticeDelivered); }
/// <summary> /// Insert direct /// </summary> /// <param name="id">id</param> /// <param name="refId">refId</param> /// <param name="companyId">companyId</param> /// <param name="detailId">detailId</param> /// <param name="address">address</param> /// <param name="pipeLocated">pipeLocated</param> /// <param name="servicesLocated">servicesLocated</param> /// <param name="coInstalled">coInstalled</param> /// <param name="backfilledConcrete">backfilledConcrete</param> /// <param name="backfilledSoil">backfilledSoil</param> /// <param name="grouted">grouted</param> /// <param name="cored">cored</param> /// <param name="prepped">prepped</param> /// <param name="measured">measured</param> /// <param name="linerSize">linerSize</param> /// <param name="inProcess">inProcess</param> /// <param name="inStock">inStock</param> /// <param name="delivered">delivered</param> /// <param name="buildRebuild">buildRebuild</param> /// <param name="preVideo">preVideo</param> /// <param name="linerInstalled">linerInstalled</param> /// <param name="finalVideo">finalVideo</param> /// <param name="distanceFromUSMH">distanceFromUSMH</param> /// <param name="distanceFromDSMH">distanceFromDSMH</param> /// <param name="map">map</param> /// <param name="issue">issue</param> /// <param name="cost">cost</param> /// <param name="deleted">deleted</param> /// <param name="videoInspection">videoInspection</param> /// <param name="coRequired">coRequired</param> /// <param name="pitRequired">pitRequired</param> /// <param name="coPitLocation">coPitLocation</param> /// <param name="postContractDigRequired">postContractDigRequired</param> /// <param name="comments">comments</param> /// <param name="history">history</param> /// <param name="coCutDown">coCutDown</param> /// <param name="finalRestoration">finalRestoration</param> /// <param name="clientLateralID">clientLateralID</param> /// <param name="videoLengthToPropertyLine">videoLengthToPropertyLine</param> /// <param name="liningThruCo">liningThruCo</param> /// <param name="hamiltonInspectionNumber">hamiltonInspectionNumber</param> /// <param name="noticeDelivered">noticeDelivered</param> public void InsertDirect(Guid id, int refId, int companyId, string detailId, string address, DateTime? pipeLocated, DateTime? servicesLocated, DateTime? coInstalled, DateTime? backfilledConcrete, DateTime? backfilledSoil, DateTime? grouted, DateTime? cored, DateTime? prepped, DateTime? measured, string linerSize, DateTime? inProcess, DateTime? inStock, DateTime? delivered, int? buildRebuild, DateTime? preVideo, DateTime? linerInstalled, DateTime? finalVideo, double? distanceFromUSMH, double? distanceFromDSMH, string map, string issue, decimal? cost, bool deleted, DateTime? videoInspection, bool coRequired, bool pitRequired, string coPitLocation, bool postContractDigRequired, string comments, string history, DateTime? coCutDown, DateTime? finalRestoration, string clientLateralID, string videoLengthToPropertyLine, bool liningThruCo, string hamiltonInspectionNumber, DateTime? noticeDelivered) { JlinerGateway jlinerGateway = new JlinerGateway(null); jlinerGateway.Insert(id, refId, companyId, detailId, address, pipeLocated, servicesLocated, coInstalled, backfilledConcrete, backfilledSoil, grouted, cored, prepped, measured, linerSize, inProcess, inStock, delivered, buildRebuild, preVideo, linerInstalled, finalVideo, distanceFromUSMH, distanceFromDSMH, map, issue, cost, deleted, videoInspection, coRequired, pitRequired, coPitLocation, postContractDigRequired, comments, history, coCutDown, finalRestoration, clientLateralID, videoLengthToPropertyLine, liningThruCo, hamiltonInspectionNumber, noticeDelivered); }