/// <summary> /// UpdateCommentsHistoryForSummaryEdit /// </summary> /// <param name="jlWorkId">jlWorkId</param> /// <param name="workType">workType</param> /// <param name="companyId">companyId</param> /// <returns>comments</returns> public void UpdateCommentsHistoryForSummaryEdit(int jlWorkId, string workType, int companyId) { foreach (FlatSectionJlTDS.FlatSectionJlRow row in (FlatSectionJlTDS.FlatSectionJlDataTable)Table) { WorkGateway workGateway = new WorkGateway(); workGateway.LoadByWorkId(jlWorkId, companyId); int assetId = workGateway.GetAssetId(jlWorkId); int projectId = workGateway.GetProjectId(jlWorkId); if (row.AssetID == assetId) { // Update Comments // ... Get raWorkId int raWorkId = 0; WorkGateway raWorkGateway = new WorkGateway(); raWorkGateway.LoadByProjectIdAssetIdWorkType(projectId, row.Section_, "Rehab Assessment", companyId); if (raWorkGateway.Table.Rows.Count > 0) { raWorkId = raWorkGateway.GetWorkId(row.Section_, "Rehab Assessment", projectId); } // ... Get flWorkId int flWorkId = 0; WorkGateway flWorkGateway = new WorkGateway(); flWorkGateway.LoadByProjectIdAssetIdWorkType(projectId, row.Section_, "Full Length Lining", companyId); if (flWorkGateway.Table.Rows.Count > 0) { flWorkId = flWorkGateway.GetWorkId(row.Section_, "Full Length Lining", projectId); } // ... Load All Comments FlatSectionJLAllComments flatSectionJLAllComments = new FlatSectionJLAllComments(); flatSectionJLAllComments.LoadAllByJlWorkIdFlWorkIdRaWorkId(jlWorkId, flWorkId, raWorkId, companyId); row.Comments = flatSectionJLAllComments.GetJLOrFLOrRAComments(companyId, flatSectionJLAllComments.Table.Rows.Count, "\n"); // Add M1 comments WorkFullLengthLiningM1LateralGateway workFullLengthLiningM1LateralGateway = new WorkFullLengthLiningM1LateralGateway(); workFullLengthLiningM1LateralGateway.LoadByWorkIdLateral(flWorkId, row.AssetID, companyId); if (workFullLengthLiningM1LateralGateway.Table.Rows.Count > 0) { string m1LateralComments = workFullLengthLiningM1LateralGateway.GetComments(flWorkId, row.AssetID); if (m1LateralComments != "") { row.Comments = row.Comments + "\n\nType: M1 Lateral Comments\nComment: " + m1LateralComments; } } WorkFullLengthLiningM1Gateway workFullLengthLiningM1Gateway = new WorkFullLengthLiningM1Gateway(); workFullLengthLiningM1Gateway.LoadByWorkId(flWorkId, companyId); if (workFullLengthLiningM1Gateway.Table.Rows.Count > 0) { string trafficControlDetails = workFullLengthLiningM1Gateway.GetTrafficControlDetails(flWorkId); if (trafficControlDetails != "") { row.Comments = row.Comments + "\n\nType: Traffic Control Details\nComment: " + trafficControlDetails ; } string standardByPassComments = workFullLengthLiningM1Gateway.GetStandardBypassComments(flWorkId); if (standardByPassComments != "") { row.Comments = row.Comments + "\n\nType: Standard Bypass Comments\nComment: " + standardByPassComments ; } } if (!row.IsCommentsNull()) { row.Comments = row.Comments.Replace("<br>", "\n"); } // Update History FlatSectionJLAllHistory flatSectionJLAllHistory = new FlatSectionJLAllHistory(); flatSectionJLAllHistory.LoadAllByJlWorkIdFlWorkIdRaWorkId(jlWorkId, flWorkId, raWorkId, companyId); row.History = flatSectionJLAllHistory.GetJLOrFLOrRAHistory(companyId, flatSectionJLAllHistory.Table.Rows.Count, "\n"); if (!row.IsHistoryNull()) { row.History = row.History.Replace("<br>", "\n"); } } } }
/// <summary> /// UpdateFieldsForSections /// </summary> /// <param name="projectId">projectId</param> /// <param name="companyId">companyId</param> private void UpdateFieldsForSections(int projectId, int companyId) { foreach (FlatSectionJlTDS.FlatSectionJlRow row in (FlatSectionJlTDS.FlatSectionJlDataTable)Table) { int jlWorkId = row.WorkID; // ... Get raWorkId int raWorkId = 0; WorkGateway raWorkGateway = new WorkGateway(); raWorkGateway.LoadByProjectIdAssetIdWorkType(projectId, row.Section_, "Rehab Assessment", companyId); if (raWorkGateway.Table.Rows.Count > 0) { raWorkId = raWorkGateway.GetWorkId(row.Section_, "Rehab Assessment", projectId); } // ... Get flWorkId int flWorkId = 0; WorkGateway flWorkGateway = new WorkGateway(); flWorkGateway.LoadByProjectIdAssetIdWorkType(projectId, row.Section_, "Full Length Lining", companyId); if (flWorkGateway.Table.Rows.Count > 0) { flWorkId = flWorkGateway.GetWorkId(row.Section_, "Full Length Lining", projectId); } // ... Load All Comments FlatSectionJLAllComments flatSectionJLAllComments = new FlatSectionJLAllComments(); flatSectionJLAllComments.LoadAllByJlWorkIdFlWorkIdRaWorkId(jlWorkId, flWorkId, raWorkId, companyId); row.Comments = flatSectionJLAllComments.GetJLOrFLOrRAComments(companyId, flatSectionJLAllComments.Table.Rows.Count, "\n"); // Add M1 comments WorkFullLengthLiningM1LateralGateway workFullLengthLiningM1LateralGateway = new WorkFullLengthLiningM1LateralGateway(); workFullLengthLiningM1LateralGateway.LoadByWorkIdLateral(flWorkId, row.AssetID, companyId); if (workFullLengthLiningM1LateralGateway.Table.Rows.Count > 0) { string m1LateralComments = workFullLengthLiningM1LateralGateway.GetComments(flWorkId, row.AssetID); if (m1LateralComments != "") { row.Comments = row.Comments + "\n\nType: M1 Lateral Comments\nComment: " + m1LateralComments ; } } WorkFullLengthLiningM1Gateway workFullLengthLiningM1Gateway = new WorkFullLengthLiningM1Gateway(); workFullLengthLiningM1Gateway.LoadByWorkId(flWorkId, companyId); if (workFullLengthLiningM1Gateway.Table.Rows.Count > 0) { string trafficControlDetails = workFullLengthLiningM1Gateway.GetTrafficControlDetails(flWorkId); if (trafficControlDetails != "") { row.Comments = row.Comments + "\n\nType: Traffic Control Details\nComment: " + trafficControlDetails; } string standardByPassComments = workFullLengthLiningM1Gateway.GetStandardBypassComments(flWorkId); if (standardByPassComments != "") { row.Comments = row.Comments + "\n\nType: Standard Bypass Comments\nComment: " + standardByPassComments ; } string measurementFromMH = "USMH"; if (workFullLengthLiningM1Gateway.GetMeasurementFromMh(flWorkId) != "") measurementFromMH = workFullLengthLiningM1Gateway.GetMeasurementFromMh(flWorkId); if (measurementFromMH == "DSMH") { string auxDistanceFromUSMH = row.DistanceFromUSMH; row.DistanceFromUSMH = row.DistanceFromDSMH; row.DistanceFromDSMH = auxDistanceFromUSMH; } } if (!row.IsCommentsNull()) { row.Comments = row.Comments.Replace("<br>", "\n"); } // Update History FlatSectionJLAllHistory flatSectionJLAllHistory = new FlatSectionJLAllHistory(); flatSectionJLAllHistory.LoadAllByJlWorkIdFlWorkIdRaWorkId(jlWorkId, flWorkId, raWorkId, companyId); row.History = flatSectionJLAllHistory.GetJLOrFLOrRAHistory(companyId, flatSectionJLAllHistory.Table.Rows.Count, "\n"); if (!row.IsHistoryNull()) { row.History = row.History.Replace("<br>", "\n"); } // Update FlowOrderID if (!row.IsFlowOrderIDNull()) { row.LateralID = row.FlowOrderID + "-JL-" + row.LateralID; } else { row.LateralID = "JL-" + row.LateralID; } // Update MainSize if (!row.IsMainSizeNull()) { try { if (Distance.IsValidDistance(row.MainSize)) { Distance distance = new Distance(row.MainSize); switch (distance.DistanceType) { case 2: row.MainSize = distance.ToStringInEng1(); break; case 3: if (Convert.ToDouble(row.MainSize) > 99) { double newMainSize = 0; newMainSize = Convert.ToDouble(row.MainSize) * 0.03937; row.MainSize = Convert.ToString(Math.Ceiling(newMainSize)) + "\""; } else { row.MainSize = row.MainSize + "\""; } break; case 4: row.MainSize = distance.ToStringInEng1(); break; case 5: row.MainSize = distance.ToStringInEng1(); break; } } } catch { } } } }
/// <summary> /// Update Fll Work /// </summary> /// <param name="workId">workId</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="originalSubArea">originalSubArea</param> /// <param name="originalTrafficControl">originalTrafficControl</param> /// <param name="originalTrafficControlDetails">originalTrafficControlDetails</param> /// <param name="originalStandardBypass">originalStandardBypass</param> /// <param name="originalStandardBypassComments">originalStandardBypassComments</param> /// <param name="newTrafficControl">newTrafficControl</param> /// <param name="newTrafficControlDetails">newTrafficControlDetails</param> /// <param name="newStandardBypass">newStandardBypass</param> /// <param name="newStandardBypassComments">newStandardBypassComments</param> /// <param name="companyId">companyId</param> private void UpdateFllWork(int assetId, int projectId, string originalTrafficControl, string originalTrafficControlDetails, bool originalStandardBypass, string originalStandardBypassComments, string newTrafficControl, string newTrafficControlDetails, bool newStandardBypass, string newStandardBypassComments, int companyId) { if ((originalTrafficControlDetails != newTrafficControlDetails) || (originalStandardBypassComments != newStandardBypassComments) || (originalTrafficControl != newTrafficControl) || (originalStandardBypass != newStandardBypass)) { int workIdFll = 0; WorkGateway workGateway = new WorkGateway(); workGateway.LoadByProjectIdAssetIdWorkType(projectId, assetId, "Full Length Lining", companyId); if (workGateway.Table.Rows.Count > 0) { // Get WorkId workIdFll = workGateway.GetWorkId(assetId, "Full Length Lining", projectId); WorkFullLengthLiningM1Gateway workFullLengthLiningM1Gateway = new WorkFullLengthLiningM1Gateway(); workFullLengthLiningM1Gateway.LoadByWorkId(workIdFll, companyId); // Original values string originalMeasurementTakenBy = workFullLengthLiningM1Gateway.GetMeasurementTakenBy(workIdFll); string originalSiteDetails = workFullLengthLiningM1Gateway.GetSiteDetails(workIdFll); bool originalPipeSizeChange = workFullLengthLiningM1Gateway.GetPipeSizeChange(workIdFll); string originalMeasurementType = workFullLengthLiningM1Gateway.GetMeasurementType(workIdFll); string originalMeasurementFromMh = workFullLengthLiningM1Gateway.GetMeasurementFromMh(workIdFll); string originalVideoDoneFromMh = workFullLengthLiningM1Gateway.GetVideoDoneFromMh(workIdFll); string originalVideoDoneToMh = workFullLengthLiningM1Gateway.GetVideoDoneToMh(workIdFll); bool originalDeleted = workFullLengthLiningM1Gateway.GetDeleted(workIdFll); string originalAccessType = workFullLengthLiningM1Gateway.GetAccessType(workIdFll); // Update M1 fullLengthLining WorkFullLengthLiningM1 workFullLengthLiningM1 = new WorkFullLengthLiningM1(null); workFullLengthLiningM1.UpdateDirect(workIdFll, originalMeasurementTakenBy, originalTrafficControl, originalSiteDetails, originalPipeSizeChange, originalStandardBypass, originalStandardBypassComments, originalTrafficControlDetails, originalMeasurementType, originalMeasurementFromMh, originalVideoDoneFromMh, originalVideoDoneToMh, originalDeleted, companyId, originalAccessType, workIdFll, originalMeasurementTakenBy, newTrafficControl, originalSiteDetails, originalPipeSizeChange, newStandardBypass, newStandardBypassComments, newTrafficControlDetails, originalMeasurementType, originalMeasurementFromMh, originalVideoDoneFromMh, originalVideoDoneToMh, originalDeleted, companyId, originalAccessType); } else { // Create FLL Work WorkFullLengthLining workFullLengthLining = new WorkFullLengthLining(null); workIdFll = workFullLengthLining.InsertDirectEmptyWorks(projectId, assetId, null, "", null, null, null, null, null, null, null, false, false, false, false, false, false, false, companyId, false, "", ""); WorkFullLengthLiningM1Gateway workFullLengthLiningM1Gateway = new WorkFullLengthLiningM1Gateway(); workFullLengthLiningM1Gateway.LoadByWorkId(workIdFll, companyId); // Original values string originalMeasurementTakenBy = workFullLengthLiningM1Gateway.GetMeasurementTakenBy(workIdFll); string originalSiteDetails = workFullLengthLiningM1Gateway.GetSiteDetails(workIdFll); bool originalPipeSizeChange = workFullLengthLiningM1Gateway.GetPipeSizeChange(workIdFll); string originalMeasurementType = workFullLengthLiningM1Gateway.GetMeasurementType(workIdFll); string originalMeasurementFromMh = workFullLengthLiningM1Gateway.GetMeasurementFromMh(workIdFll); string originalVideoDoneFromMh = workFullLengthLiningM1Gateway.GetVideoDoneFromMh(workIdFll); string originalVideoDoneToMh = workFullLengthLiningM1Gateway.GetVideoDoneToMh(workIdFll); bool originalDeleted = workFullLengthLiningM1Gateway.GetDeleted(workIdFll); string originalAccessType = workFullLengthLiningM1Gateway.GetAccessType(workIdFll); // Update M1 fullLengthLining WorkFullLengthLiningM1 workFullLengthLiningM1 = new WorkFullLengthLiningM1(null); workFullLengthLiningM1.UpdateDirect(workIdFll, originalMeasurementFromMh, originalTrafficControl, originalSiteDetails, originalPipeSizeChange, originalStandardBypass, originalStandardBypassComments, originalTrafficControlDetails, originalMeasurementType, originalMeasurementFromMh, originalVideoDoneFromMh, originalVideoDoneToMh, originalDeleted, companyId, originalAccessType, workIdFll, originalMeasurementTakenBy, newTrafficControl, originalSiteDetails, originalPipeSizeChange, newStandardBypass, newStandardBypassComments, newTrafficControlDetails, originalMeasurementType, originalMeasurementFromMh, originalVideoDoneFromMh, originalVideoDoneToMh, originalDeleted, companyId, originalAccessType); } } }