/// <summary>
/// Save a Previous PR work
/// </summary>
/// <param name="projectId">projectId</param>
/// <param name="section_assetId">section_assetId</param>
/// <param name="companyId">companyId</param>
private void SavePreviousPRWork(int projectId, int section_assetId, int companyId)
{
// Load Previous work - Point Repairs data (last sections work)
string workType = "Point Repairs";
WorkPointRepairsGateway workPointRepairsGateway = new WorkPointRepairsGateway();
workPointRepairsGateway.LoadTop1ByProjectIdAssetIdWorkType(projectId, section_assetId, workType, companyId);
int workId = workPointRepairsGateway.GetWorkIdTop1();
string clientId = ""; if (workPointRepairsGateway.GetClientId(workId) != "") clientId = workPointRepairsGateway.GetClientId(workId);
string measurementTakenBy = ""; if (workPointRepairsGateway.GetMeasurementTakenBy(workId) != "") measurementTakenBy = workPointRepairsGateway.GetMeasurementTakenBy(workId);
DateTime? repairConfirmationDate = null; if (workPointRepairsGateway.GetRepairConfirmationDate(workId).HasValue) repairConfirmationDate = workPointRepairsGateway.GetRepairConfirmationDate(workId);
bool bypassRequired = workPointRepairsGateway.GetBypassRequired(workId);
string roboticDistances = ""; if (workPointRepairsGateway.GetRoboticDistances(workId) != "") roboticDistances = workPointRepairsGateway.GetRoboticDistances(workId);
DateTime? proposedLiningDate = null; if (workPointRepairsGateway.GetProposedLiningDate(workId).HasValue) proposedLiningDate = workPointRepairsGateway.GetProposedLiningDate(workId);
DateTime? deadlineLiningDate = null; if (workPointRepairsGateway.GetDeadlineLiningDate(workId).HasValue) deadlineLiningDate = workPointRepairsGateway.GetDeadlineLiningDate(workId);
DateTime? finalVideoDate = null; if (workPointRepairsGateway.GetFinalVideoDate(workId).HasValue) finalVideoDate = workPointRepairsGateway.GetFinalVideoDate(workId);
int? estimatedJoints = null; if (workPointRepairsGateway.GetEstimatedJoints(workId).HasValue) estimatedJoints = workPointRepairsGateway.GetEstimatedJoints(workId);
int? jointsTestSealed = null; if (workPointRepairsGateway.GetJointsTestSealed(workId).HasValue) jointsTestSealed = workPointRepairsGateway.GetJointsTestSealed(workId);
bool issueIdentified = workPointRepairsGateway.GetIssueIdentified(workId);
bool issueLfs = workPointRepairsGateway.GetIssueLFS(workId);
bool issueClient = workPointRepairsGateway.GetIssueClient(workId);
bool issueSales = workPointRepairsGateway.GetIssueSales(workId);
bool issueGivenToClient = workPointRepairsGateway.GetIssueGivenToClient(workId);
bool issueResolved = workPointRepairsGateway.GetIssueResolved(workId);
bool issueInvestigation = workPointRepairsGateway.GetIssueInvestigation(workId);
string repairId = ""; if (workPointRepairsGateway.GetRepairID(workId) != "") repairId = workPointRepairsGateway.GetRepairID(workId);
// Load Previous work - General work data
WorkGateway workGateway = new WorkGateway();
workGateway.LoadByWorkId(workId, companyId);
int? libraryCategoriesId = null; if (workGateway.GetLibraryCategoriesId(workId).HasValue) libraryCategoriesId = workGateway.GetLibraryCategoriesId(workId);
string comments = workGateway.GetComments(workId);
string history = workGateway.GetHistory(workId);
// Save new work
WorkPointRepairs workPointRepairs = new WorkPointRepairs(null);
int newSectionWorkId = workPointRepairs.InsertDirect(projectId, section_assetId, libraryCategoriesId, clientId, measurementTakenBy, repairConfirmationDate, bypassRequired, roboticDistances, proposedLiningDate, deadlineLiningDate, finalVideoDate, estimatedJoints, jointsTestSealed, issueIdentified, issueLfs, issueClient, issueSales, issueGivenToClient, issueResolved, issueInvestigation, repairId, false, companyId, comments, history);
// Load Previous work - Save pr repair
WorkPointRepairsRepairGateway workPointRepairsRepairGateway = new WorkPointRepairsRepairGateway();
workPointRepairsRepairGateway.LoadByWorkId(workId, companyId);
foreach (WorkTDS.LFS_WORK_POINT_REPAIRS_REPAIRRow row in (WorkTDS.LFS_WORK_POINT_REPAIRS_REPAIRDataTable)workPointRepairsRepairGateway.Table)
{
string repairPointId = row.RepairPointID;
string type = ""; if (!row.IsTypeNull()) type = row.Type;
string reamDistance = ""; if (!row.IsReamDistanceNull()) reamDistance = row.ReamDistance;
DateTime? reamDate = null; if (!row.IsReamDateNull()) reamDate = row.ReamDate;
string linerDistance = ""; if (!row.IsLinerDistanceNull()) linerDistance = row.LinerDistance;
string direction = ""; if (!row.IsDirectionNull()) direction = row.Direction;
int? reinstates = null; if (!row.IsReinstatesNull()) reinstates = row.Reinstates;
string ltmh = ""; if (!row.IsLTMHNull()) ltmh = row.LTMH;
string vtmh = ""; if (!row.IsVTMHNull()) vtmh = row.VTMH;
string distance = ""; if (!row.IsDistanceNull()) distance = row.Distance;
string size_ = ""; if (!row.IsSize_Null()) size_ = row.Size_;
DateTime? installDate = null; if (!row.IsInstallDateNull()) installDate = row.InstallDate;
string mhShot = ""; if (!row.IsMHShotNull()) mhShot = row.MHShot;
string groutDistance = ""; if (!row.IsGroutDistanceNull()) groutDistance = row.GroutDistance;
DateTime? groutDate = null; if (!row.IsGroutDateNull()) groutDate = row.GroutDate;
string approval = ""; if (!row.IsApprovalNull()) approval = row.Approval;
bool extraRepair = row.ExtraRepair;
bool cancelled = row.Cancelled;
string commentsRepair = ""; if (!row.IsCommentsNull()) commentsRepair = row.Comments;
string defectQualifier = ""; if (!row.IsDefectQualifierNull()) defectQualifier = row.DefectQualifier;
string defecDetails = ""; if (!row.IsDefectDetailsNull()) defecDetails = row.DefectDetails;
string length = ""; if (!row.IsLengthNull()) length = row.Length;
DateTime? reinstateDate = null; if (!row.IsReinstateDateNull()) reinstateDate = row.ReinstateDate;
WorkPointRepairsRepair workPointRepairsRepair = new WorkPointRepairsRepair();
workPointRepairsRepair.InsertDirect(newSectionWorkId, repairPointId, type, reamDistance, reamDate, linerDistance, direction, reinstates, ltmh, vtmh, distance, size_, installDate, mhShot, groutDistance, groutDate, approval, extraRepair, cancelled, commentsRepair, false, companyId, defectQualifier, defectQualifier, length, reinstateDate);
}
// Load Previous work - Comments and History
SavePreviousComments(workId, workType, companyId, newSectionWorkId);
SavePreviousHistory(workId, workType, companyId, newSectionWorkId);
}
/// <summary>
/// Save a Previous RA work
/// </summary>
/// <param name="projectId">projectId</param>
/// <param name="section_assetId">section_assetId</param>
/// <param name="companyId">companyId</param>
private void SavePreviousRAWork(int projectId, int section_assetId, int companyId)
{
// Load Previous work - Rehab assessment data (last sections work)
string workType = "Rehab Assessment";
WorkRehabAssessmentGateway workRehabAssessmentGateway = new WorkRehabAssessmentGateway();
workRehabAssessmentGateway.LoadTop1ByProjectIdAssetIdWorkType(projectId, section_assetId, workType, companyId);
int workId = workRehabAssessmentGateway.GetWorkIdTop1();
DateTime? preFlushDate = null; if (workRehabAssessmentGateway.GetPreFlushDateTop1().HasValue) preFlushDate = workRehabAssessmentGateway.GetPreFlushDateTop1();
DateTime? preVideoDate = null; if (workRehabAssessmentGateway.GetPreVideoDateTop1().HasValue) preVideoDate = workRehabAssessmentGateway.GetPreVideoDateTop1();
// Load Previous work - General work data
WorkGateway workGateway = new WorkGateway();
workGateway.LoadByWorkId(workId, companyId);
int? libraryCategoriesId = null; if (workGateway.GetLibraryCategoriesId(workId).HasValue) libraryCategoriesId = workGateway.GetLibraryCategoriesId(workId);
string comments = workGateway.GetComments(workId);
string history = workGateway.GetHistory(workId);
// Save new work
WorkRehabAssessment workRehabAssessment = new WorkRehabAssessment(null);
int newSectionWorkId = workRehabAssessment.InsertDirect(projectId, section_assetId, libraryCategoriesId, preFlushDate, preVideoDate, false, companyId, comments, history);
// Load Previous work - Comments and History
SavePreviousComments(workId, workType, companyId, newSectionWorkId);
SavePreviousHistory(workId, workType, companyId, newSectionWorkId);
}
/// <summary>
/// Save a Previous JL work
/// </summary>
/// <param name="projectId">projectId</param>
/// <param name="section_assetId">section_assetId</param>
/// <param name="companyId">companyId</param>
private void SavePreviousJLWork(int projectId, int section_assetId, int companyId)
{
// Load Previous work - Junction Lining section data (last sections work)
string workType = "Junction Lining Section";
WorkJunctionLiningSectionGateway workJunctionLiningSectionGateway = new WorkJunctionLiningSectionGateway();
workJunctionLiningSectionGateway.LoadTop1ByProjectIdAssetIdWorkType(projectId, section_assetId, workType, companyId);
int workId = workJunctionLiningSectionGateway.GetWorkIdTop1();
int numLats = workJunctionLiningSectionGateway.GetNumLats(workId);
int notLinedYet = workJunctionLiningSectionGateway.GetNotLinedYet(workId);
Boolean allMeasured = workJunctionLiningSectionGateway.GetAllMeasured(workId);
string issueWithLaterals = workJunctionLiningSectionGateway.GetIssueWithLaterals(workId);
int notMeasuredYet = workJunctionLiningSectionGateway.GetNotMeasuredYet(workId);
int notDeliveredYet = workJunctionLiningSectionGateway.GetNotDeliveredYet(workId);
string trafficControl = ""; if (workJunctionLiningSectionGateway.GetTrafficControl(workId) != "") trafficControl = workJunctionLiningSectionGateway.GetTrafficControl(workId);
string trafficControlDetails = ""; if (workJunctionLiningSectionGateway.GetTrafficControlDetails(workId) != "") trafficControlDetails = workJunctionLiningSectionGateway.GetTrafficControlDetails(workId);
Boolean standardBypass = workJunctionLiningSectionGateway.GetStandardBypass(workId);
string standardBypassComments = ""; if (workJunctionLiningSectionGateway.GetStandardBypassComments(workId) != "") standardBypassComments = workJunctionLiningSectionGateway.GetStandardBypassComments(workId);
int availableToLine = workJunctionLiningSectionGateway.GetAvailableToLine(workId);
// Load Previous work - General work data
WorkGateway workGateway = new WorkGateway();
workGateway.LoadByWorkId(workId, companyId);
int? libraryCategoriesId = null; if (workGateway.GetLibraryCategoriesId(workId).HasValue) libraryCategoriesId = workGateway.GetLibraryCategoriesId(workId);
string comments = workGateway.GetComments(workId);
string history = workGateway.GetHistory(workId);
// Save new work
WorkJunctionLiningSection workJunctionLiningSection = new WorkJunctionLiningSection(null);
int newSectionWorkId = workJunctionLiningSection.InsertDirect(projectId, section_assetId, libraryCategoriesId, numLats, notLinedYet, allMeasured, issueWithLaterals, notMeasuredYet, notDeliveredYet, false, companyId, comments, history, trafficControl, trafficControlDetails, standardBypass, standardBypassComments, availableToLine);
// Load Previous work - Junction Lining Lateral data
WorkJunctionLiningLateralGateway workJunctionLiningLateralGateway = new WorkJunctionLiningLateralGateway();
workJunctionLiningLateralGateway.LoadBySectionWorkId(workId, companyId);
foreach (WorkTDS.LFS_WORK_JUNCTIONLINING_LATERALRow lateralRow in (WorkTDS.LFS_WORK_JUNCTIONLINING_LATERALDataTable)workJunctionLiningLateralGateway.Table)
{
WorkGateway workGatewayForLateral = new WorkGateway();
workGatewayForLateral.LoadByWorkId(lateralRow.WorkID, companyId);
int lateral_assetId = workGatewayForLateral.GetAssetId(lateralRow.WorkID);
DateTime? pipeLocated = null; if (!lateralRow.IsPipeLocatedNull()) pipeLocated = lateralRow.PipeLocated;
DateTime? sevicesLocated = null; if (!lateralRow.IsServicesLocatedNull()) sevicesLocated = lateralRow.ServicesLocated;
DateTime? coInstalled = null; if (!lateralRow.IsCoInstalledNull()) coInstalled = lateralRow.CoInstalled;
DateTime? backfilledConcrete = null; if (!lateralRow.IsBackfilledConcreteNull()) backfilledConcrete = lateralRow.BackfilledConcrete;
DateTime? backfilledSoil = null; if (!lateralRow.IsBackfilledSoilNull()) backfilledSoil = lateralRow.BackfilledSoil;
DateTime? grouted = null; if (!lateralRow.IsGroutedNull()) grouted = lateralRow.Grouted;
DateTime? cored = null; if (!lateralRow.IsCoredNull()) cored = lateralRow.Cored;
DateTime? prepped = null; if (!lateralRow.IsPreppedNull()) prepped = lateralRow.Prepped;
DateTime? measured = null; if (!lateralRow.IsMeasuredNull()) measured = lateralRow.Measured;
string linerSize = ""; if (!lateralRow.IsLinerSizeNull()) linerSize = lateralRow.LinerSize;
DateTime? inProcess = null; if (!lateralRow.IsInProcessNull()) inProcess = lateralRow.InProcess;
DateTime? inStock = null; if (!lateralRow.IsInStockNull()) inStock = lateralRow.InStock;
DateTime? delivered = null; if (!lateralRow.IsDeliveredNull()) delivered = lateralRow.Delivered;
int? buildRebuild = null; if (!lateralRow.IsBuildRebuildNull()) buildRebuild = lateralRow.BuildRebuild;
DateTime? preVideo = null; if (!lateralRow.IsPreVideoNull()) preVideo = lateralRow.PreVideo;
DateTime? linerInstalled = null; if (!lateralRow.IsLinerInstalledNull()) linerInstalled = lateralRow.LinerInstalled;
DateTime? finalVideo = null; if (!lateralRow.IsFinalVideoNull()) finalVideo = lateralRow.FinalVideo;
decimal? cost = null; if (!lateralRow.IsCostNull()) cost = lateralRow.Cost;
DateTime? videoInspection = null; if (!lateralRow.IsVideoInspectionNull()) videoInspection = lateralRow.VideoInspection;
bool coRequired = lateralRow.CoRequired;
bool pitRequired = lateralRow.PitRequired;
string coPitLocation = ""; if (!lateralRow.IsCoPitLocationNull()) coPitLocation = lateralRow.CoPitLocation;
bool postContractDigRequired = lateralRow.PostContractDigRequired;
DateTime? coCutDown = null; if (!lateralRow.IsCoCutDownNull()) coCutDown = lateralRow.CoCutDown;
DateTime? finalRestoration = null; if (!lateralRow.IsFinalRestorationNull()) finalRestoration = lateralRow.FinalRestoration;
string videoLengthToPropertyLine = ""; if (!lateralRow.IsVideoLengthToPropertyLineNull()) videoLengthToPropertyLine = lateralRow.VideoLengthToPropertyLine;
bool liningThruCo = lateralRow.LiningThruCo;
DateTime? noticeDelivered = null; if (!lateralRow.IsNoticeDeliveredNull()) noticeDelivered = lateralRow.NoticeDelivered;
string hamiltonInspectionNumber = ""; if (!lateralRow.IsHamiltonInspectionNumberNull()) hamiltonInspectionNumber = lateralRow.HamiltonInspectionNumber;
string flange = ""; if (!lateralRow.IsFlangeNull()) flange = lateralRow.Flange;
string gasket = ""; if (!lateralRow.IsGasketNull()) gasket = lateralRow.Gasket;
string depthOfLocated = ""; if (!lateralRow.IsDepthOfLocatedNull()) depthOfLocated = lateralRow.DepthOfLocated;
bool digRequiredPriorToLining = lateralRow.DigRequiredPriorToLining;
DateTime? digRequiredPriorToLiningCompleted = null; if (!lateralRow.IsDigRequiredPriorToLiningCompletedNull()) digRequiredPriorToLiningCompleted = lateralRow.DigRequiredPriorToLiningCompleted;
bool digRequiredAfterLining = lateralRow.DigRequiredAfterLining;
DateTime? digRequiredAfterLiningCompleted = null; if (!lateralRow.IsDigRequiredAfterLiningCompletedNull()) digRequiredAfterLiningCompleted = lateralRow.DigRequiredAfterLiningCompleted;
bool outOfScope = lateralRow.OutOfScope;
bool holdClientIssue = lateralRow.HoldClientIssue;
DateTime? holdClientIssueResolved = null; if (!lateralRow.IsHoldClientIssueResolvedNull()) holdClientIssueResolved = lateralRow.HoldClientIssueResolved;
bool holdLFSIssue = lateralRow.HoldLFSIssue;
DateTime? holdLFSIssueResolved = null; if (!lateralRow.IsHoldLFSIssueResolvedNull()) holdLFSIssueResolved = lateralRow.HoldLFSIssueResolved;
bool requiresRoboticPrep = lateralRow.LateralRequiresRoboticPrep;
DateTime? requiresRoboticPrepCompleted = null; if (!lateralRow.IsLateralRequiresRoboticPrepCompletedNull()) requiresRoboticPrepCompleted = lateralRow.LateralRequiresRoboticPrepCompleted;
string linerType = ""; if (!lateralRow.IsLinerTypeNull()) linerType = lateralRow.LinerType;
string prepType = ""; if (!lateralRow.IsPrepTypeNull()) prepType = lateralRow.PrepType;
bool dyeTestReq = lateralRow.DyeTestReq;
DateTime? dyeTestComplete = null; if (!lateralRow.IsDyeTestCompleteNull()) dyeTestComplete = lateralRow.DyeTestComplete;
string contractYear = ""; if (!lateralRow.IsContractYearNull()) contractYear = lateralRow.ContractYear;
WorkJunctionLiningLateral workJunctionLiningLateral = new WorkJunctionLiningLateral(null);
workJunctionLiningLateral.InsertDirect(projectId, lateral_assetId, newSectionWorkId, pipeLocated, sevicesLocated, coInstalled, backfilledConcrete, backfilledSoil, grouted, cored, prepped, measured, linerSize, inProcess, inStock, delivered, buildRebuild, 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, linerType, prepType, dyeTestReq, dyeTestComplete, contractYear);
}
// Load Previous work - Comments and History
SavePreviousComments(workId, workType, companyId, newSectionWorkId);
SavePreviousHistory(workId, workType, companyId, newSectionWorkId);
}
/// <summary>
/// Save a Previous FL work
/// </summary>
/// <param name="projectId">projectId</param>
/// <param name="section_assetId">section_assetId</param>
/// <param name="companyId">companyId</param>
private void SavePreviousFLWork(int projectId, int section_assetId, int companyId)
{
// Load Previous work - Full Length Lining data (last sections work)
string workType = "Full Length Lining";
WorkFullLengthLiningGateway workFullLengthLiningGateway = new WorkFullLengthLiningGateway();
workFullLengthLiningGateway.LoadTop1ByProjectIdAssetIdWorkType(projectId, section_assetId, workType, companyId);
int workId = workFullLengthLiningGateway.GetWorkIdTop1();
string clientId = ""; if (workFullLengthLiningGateway.GetClientId(workId) != "") clientId = workFullLengthLiningGateway.GetClientId(workId);
DateTime? proposedLiningDate = null; if (workFullLengthLiningGateway.GetProposedLiningDate(workId).HasValue) proposedLiningDate = workFullLengthLiningGateway.GetProposedLiningDate(workId);
DateTime? deadlineLiningDate = null; if (workFullLengthLiningGateway.GetDeadlineLiningDate(workId).HasValue) deadlineLiningDate = workFullLengthLiningGateway.GetDeadlineLiningDate(workId);
DateTime? p1Date = null; if (workFullLengthLiningGateway.GetP1Date(workId).HasValue) p1Date = workFullLengthLiningGateway.GetP1Date(workId);
DateTime? m1Date = null; if (workFullLengthLiningGateway.GetM1Date(workId).HasValue) m1Date = workFullLengthLiningGateway.GetM1Date(workId);
DateTime? m2Date = null; if (workFullLengthLiningGateway.GetM2Date(workId).HasValue) m2Date = workFullLengthLiningGateway.GetM2Date(workId);
DateTime? installDate = null; if (workFullLengthLiningGateway.GetInstallDate(workId).HasValue) installDate = workFullLengthLiningGateway.GetInstallDate(workId);
DateTime? finalVideoDate = null; if (workFullLengthLiningGateway.GetFinalVideoDate(workId).HasValue) finalVideoDate = workFullLengthLiningGateway.GetFinalVideoDate(workId);
bool issueIdentified = workFullLengthLiningGateway.GetIssueIdentified(workId);
bool issueLfs = workFullLengthLiningGateway.GetIssueLFS(workId);
bool issueClient = workFullLengthLiningGateway.GetIssueClient(workId);
bool issueSales = workFullLengthLiningGateway.GetIssueSales(workId);
bool issueGivenToClient = workFullLengthLiningGateway.GetIssueGivenToClient(workId);
bool issueResolved = workFullLengthLiningGateway.GetIssueResolved(workId);
bool issueInvestigation = workFullLengthLiningGateway.GetIssueInvestigation(workId);
// Load Previous work - Full Length Lining M1 data (last sections work)
FullLengthLiningWorkDetailsGateway fullLengthLiningWorkDetailsGateway = new FullLengthLiningWorkDetailsGateway();
fullLengthLiningWorkDetailsGateway.LoadByWorkIdAssetId(workId, section_assetId, companyId);
string measurementTakenBy = ""; if (fullLengthLiningWorkDetailsGateway.GetMeasurementTakenBy(workId) != "") measurementTakenBy = fullLengthLiningWorkDetailsGateway.GetMeasurementTakenBy(workId);
string trafficControl = ""; if (fullLengthLiningWorkDetailsGateway.GetTrafficControl(workId) != "") trafficControl = fullLengthLiningWorkDetailsGateway.GetTrafficControl(workId);
string siteDetails = ""; if (fullLengthLiningWorkDetailsGateway.GetSiteDetails(workId) != "") siteDetails = fullLengthLiningWorkDetailsGateway.GetSiteDetails(workId);
string accessType = ""; if (fullLengthLiningWorkDetailsGateway.GetAccessType(workId) != "") accessType = fullLengthLiningWorkDetailsGateway.GetAccessType(workId);
bool pipeSizeChange = fullLengthLiningWorkDetailsGateway.GetPipeSizeChange(workId);
bool standardByPass = fullLengthLiningWorkDetailsGateway.GetStandardBypass(workId);
string standardByPassComments = ""; if (fullLengthLiningWorkDetailsGateway.GetStandardBypassComments(workId) != "") standardByPassComments = fullLengthLiningWorkDetailsGateway.GetStandardBypassComments(workId);
string trafficControlDetails = ""; if (fullLengthLiningWorkDetailsGateway.GetTrafficControlDetails(workId) != "") trafficControlDetails = fullLengthLiningWorkDetailsGateway.GetTrafficControlDetails(workId);
string measurementType = ""; if (fullLengthLiningWorkDetailsGateway.GetMeasurementType(workId) != "") measurementType = fullLengthLiningWorkDetailsGateway.GetMeasurementType(workId);
string measurementFromMH = ""; if (fullLengthLiningWorkDetailsGateway.GetMeasurementFromMh(workId) != "") measurementFromMH = fullLengthLiningWorkDetailsGateway.GetMeasurementFromMh(workId);
string videoDoneFromMH = ""; if (fullLengthLiningWorkDetailsGateway.GetVideoDoneFromMh(workId) != "") videoDoneFromMH = fullLengthLiningWorkDetailsGateway.GetVideoDoneFromMh(workId);
string videoDoneToMH = ""; if (fullLengthLiningWorkDetailsGateway.GetVideoDoneToMh(workId) != "") videoDoneToMH = fullLengthLiningWorkDetailsGateway.GetVideoDoneToMh(workId);
// Load Previous work - Full Length Lining M2 data (last sections work)
string videoLength = ""; if (fullLengthLiningWorkDetailsGateway.GetVideoLength(workId) != "") videoLength = fullLengthLiningWorkDetailsGateway.GetVideoLength(workId);
string measurementTakenBy2 = ""; if (fullLengthLiningWorkDetailsGateway.GetMeasurementTakenByM2(workId) != "") measurementTakenBy2 = fullLengthLiningWorkDetailsGateway.GetMeasurementTakenByM2(workId);
bool dropPipe = fullLengthLiningWorkDetailsGateway.GetDropPipe(workId);
string dropPipeInvertDepth = ""; if (fullLengthLiningWorkDetailsGateway.GetDropPipeInvertDepth(workId) != "") dropPipeInvertDepth = fullLengthLiningWorkDetailsGateway.GetDropPipeInvertDepth(workId);
int? cappedLaterals = null; if (fullLengthLiningWorkDetailsGateway.GetCappedLaterals(workId).HasValue) cappedLaterals = fullLengthLiningWorkDetailsGateway.GetCappedLaterals(workId);
string lineWithID = ""; if (fullLengthLiningWorkDetailsGateway.GetLineWithId(workId) != "") lineWithID = fullLengthLiningWorkDetailsGateway.GetLineWithId(workId);
string hydrantAddress = ""; if (fullLengthLiningWorkDetailsGateway.GetHydrantAddress(workId) != "") hydrantAddress = fullLengthLiningWorkDetailsGateway.GetHydrantAddress(workId);
string hydroWireWithin10FtOfInversionMH = ""; if (fullLengthLiningWorkDetailsGateway.GetHydroWiredWithin10FtOfInversionMH(workId) != "") hydroWireWithin10FtOfInversionMH = fullLengthLiningWorkDetailsGateway.GetHydroWiredWithin10FtOfInversionMH(workId);
string distanceToInversionMH = ""; if (fullLengthLiningWorkDetailsGateway.GetDistanceToInversionMh(workId) != "") distanceToInversionMH = fullLengthLiningWorkDetailsGateway.GetDistanceToInversionMh(workId);
string surfaceGrade = ""; if (fullLengthLiningWorkDetailsGateway.GetSurfaceGrade(workId) != "") surfaceGrade = fullLengthLiningWorkDetailsGateway.GetSurfaceGrade(workId);
bool hydroPulley = fullLengthLiningWorkDetailsGateway.GetHydroPulley(workId);
bool fridgeCart = fullLengthLiningWorkDetailsGateway.GetFridgeCart(workId);
bool twoPump = fullLengthLiningWorkDetailsGateway.GetTwoPump(workId);
bool sixBypass = fullLengthLiningWorkDetailsGateway.GetSixBypass(workId);
bool scaffolding = fullLengthLiningWorkDetailsGateway.GetScaffolding(workId);
bool winchExtention = fullLengthLiningWorkDetailsGateway.GetWinchExtension(workId);
bool extraGenerator = fullLengthLiningWorkDetailsGateway.GetExtraGenerator(workId);
bool greyCableExtension = fullLengthLiningWorkDetailsGateway.GetGreyCableExtension(workId);
bool easementMats = fullLengthLiningWorkDetailsGateway.GetEasementMats(workId);
bool rampRequired = fullLengthLiningWorkDetailsGateway.GetRampRequired(workId);
bool cameraSkid = fullLengthLiningWorkDetailsGateway.GetCameraSkid(workId);
// Load Previous work - Full Length Lining P1 data (last sections work)
int? cxisRemoved = null; if (fullLengthLiningWorkDetailsGateway.GetCxisRemoved(workId).HasValue) fullLengthLiningWorkDetailsGateway.GetCxisRemoved(workId);
bool roboticPrepCompleted = fullLengthLiningWorkDetailsGateway.GetRoboticPrepCompleted(workId);
DateTime? roboticPrepCompletedDate = fullLengthLiningWorkDetailsGateway.GetRoboticPrepCompletedDate(workId);
bool p1Completed = fullLengthLiningWorkDetailsGateway.GetP1Completed(workId);
// Load Previous work - General work data
WorkGateway workGateway = new WorkGateway();
workGateway.LoadByWorkId(workId, companyId);
int? libraryCategoriesId = null; if (workGateway.GetLibraryCategoriesId(workId).HasValue) libraryCategoriesId = workGateway.GetLibraryCategoriesId(workId);
string comments = workGateway.GetComments(workId);
string history = workGateway.GetHistory(workId);
// Save new work
WorkFullLengthLining workFullLengthLining = new WorkFullLengthLining(null);
int newSectionWorkId = workFullLengthLining.InsertDirectFullWork(projectId, section_assetId, libraryCategoriesId, clientId, proposedLiningDate, deadlineLiningDate, p1Date, m1Date, m2Date, installDate, finalVideoDate, issueIdentified, issueLfs, issueClient, issueSales, issueGivenToClient, issueResolved, false, companyId, issueInvestigation, comments, history, cxisRemoved, roboticPrepCompleted, roboticPrepCompletedDate, measurementTakenBy, trafficControl, siteDetails, pipeSizeChange, standardByPass, standardByPassComments, trafficControlDetails, measurementType, measurementFromMH, videoDoneFromMH, videoDoneToMH, videoLength, measurementTakenBy2, dropPipe, dropPipeInvertDepth, cappedLaterals, lineWithID, hydrantAddress, hydroWireWithin10FtOfInversionMH, distanceToInversionMH, surfaceGrade, hydroPulley, fridgeCart, twoPump, sixBypass, scaffolding, winchExtention, extraGenerator, greyCableExtension, easementMats, rampRequired, cameraSkid, accessType, p1Completed);
// Load Previous work - Save fl laterals
WorkFullLengthLiningM1LateralGateway workFullLengthLiningM1LateralGateway = new WorkFullLengthLiningM1LateralGateway();
workFullLengthLiningM1LateralGateway.LoadByWorkId(workId, companyId);
foreach (WorkTDS.LFS_WORK_FULLLENGTHLINING_M1_LATERALRow lateralRow in (WorkTDS.LFS_WORK_FULLLENGTHLINING_M1_LATERALDataTable)workFullLengthLiningM1LateralGateway.Table)
{
int lateral = lateralRow.Lateral;
string videoDistance = ""; if (!lateralRow.IsVideoDistanceNull()) videoDistance = lateralRow.VideoDistance;
string clockPosition = ""; if (!lateralRow.IsClockPositionNull()) clockPosition = lateralRow.ClockPosition;
string distanceToCentre = ""; if (!lateralRow.IsDistanceToCentreNull()) distanceToCentre = lateralRow.DistanceToCentre;
string timeOpened = ""; if (!lateralRow.IsTimeOpenedNull()) timeOpened = lateralRow.TimeOpened;
string reverseSetup = ""; if (!lateralRow.IsReverseSetupNull()) reverseSetup = lateralRow.ReverseSetup;
DateTime? reinstate = null; if (!lateralRow.IsReinstateNull()) reinstate = lateralRow.Reinstate;
string lateralComments = ""; if (!lateralRow.IsCommentsNull()) lateralComments = lateralRow.Comments;
string clientInspectionNo = ""; if (!lateralRow.IsClientInspectionNoNull()) clientInspectionNo = lateralRow.ClientInspectionNo;
DateTime? v1Inspection = null; if (!lateralRow.IsV1InspectionNull()) v1Inspection = lateralRow.V1Inspection;
bool requiresRoboticPrep = lateralRow.RequiresRoboticPrep;
DateTime? requiresRoboticPrepDate = null; if (!lateralRow.IsRequiresRoboticPrepDateNull()) requiresRoboticPrepDate = lateralRow.RequiresRoboticPrepDate;
bool holdClientIssue = lateralRow.HoldClientIssue;
bool holdLFSIssue = lateralRow.HoldLFSIssue;
bool lineLateral = lateralRow.LineLateral;
bool dyeTestReq = lateralRow.DyeTestReq;
DateTime? dyeTestComplete = null; if (!lateralRow.IsDyeTestCompleteNull()) dyeTestComplete = lateralRow.DyeTestComplete;
string contractYear = lateralRow.ContractYear;
WorkFullLengthLiningM1Lateral workFullLengthLiningM1Lateral = new WorkFullLengthLiningM1Lateral();
workFullLengthLiningM1Lateral.InsertDirect(newSectionWorkId, lateral, videoDistance, clockPosition, distanceToCentre, timeOpened, reverseSetup, reinstate, lateralComments, false, companyId, clientInspectionNo, v1Inspection, requiresRoboticPrep, requiresRoboticPrepDate, holdClientIssue, holdLFSIssue, lineLateral, dyeTestReq, dyeTestComplete, contractYear);
}
// Load Previous work - Comments and History
SavePreviousComments(workId, workType, companyId, newSectionWorkId);
SavePreviousHistory(workId, workType, companyId, newSectionWorkId);
}
// ////////////////////////////////////////////////////////////////////////
// PRIVATE METHODS
//
/// <summary>
/// UpdateForReport
/// </summary>
/// <param name="unitType">unitType</param>
private void UpdateForReport(string unitType)
{
// Load comments
foreach (FlM1ReportTDS.M1ReportByClientRow row in (FlM1ReportTDS.M1ReportByClientDataTable)Table)
{
WorkGateway workGateway = new WorkGateway();
workGateway.LoadByWorkId(row.WorkID, row.COMPANY_ID);
row.M1Comments = workGateway.GetComments(row.WorkID);
}
// Update for unit type
FlM1LateralReportGateway flM1LateralReportGateway = new FlM1LateralReportGateway(Data);
flM1LateralReportGateway.ClearBeforeFill = false;
FlM1LateralReport flM1LateralReport = new FlM1LateralReport(Data);
foreach (FlM1ReportTDS.M1ReportByClientRow row in (FlM1ReportTDS.M1ReportByClientDataTable)Table)
{
if (!row.IsM1CommentsNull())
{
row.M1Comments = row.M1Comments.Replace("<br>", "\n");
}
Distance d;
if (unitType == "Metric")
{
if (!row.IsSize_Null())
{
if (Distance.IsValidDistance(row.Size_))
{
d = new Distance(row.Size_);
row.Size_ = d.ToStringInMil2();
}
}
if (!row.IsLengthNull())
{
if (Distance.IsValidDistance(row.Length))
{
d = new Distance(row.Length);
row.Length = d.ToStringInMet2();
}
}
if (!row.IsUSMHDepthNull())
{
if (Distance.IsValidDistance(row.USMHDepth))
{
d = new Distance(row.USMHDepth);
row.USMHDepth = d.ToStringInMet2();
}
}
if (!row.IsDSMHDepthNull())
{
if (Distance.IsValidDistance(row.DSMHDepth))
{
d = new Distance(row.DSMHDepth);
row.DSMHDepth = d.ToStringInMet2();
}
}
if (!row.IsUSMHMouth12Null())
{
if (Distance.IsValidDistance(row.USMHMouth12))
{
d = new Distance(row.USMHMouth12);
row.USMHMouth12 = d.ToStringInMil2();
}
}
if (!row.IsUSMHMouth1Null())
{
if (Distance.IsValidDistance(row.USMHMouth1))
{
d = new Distance(row.USMHMouth1);
row.USMHMouth1 = d.ToStringInMil2();
}
}
if (!row.IsUSMHMouth2Null())
{
if (Distance.IsValidDistance(row.USMHMouth2))
{
d = new Distance(row.USMHMouth2);
row.USMHMouth2 = d.ToStringInMil2();
}
}
if (!row.IsUSMHMouth3Null())
{
if (Distance.IsValidDistance(row.USMHMouth3))
{
d = new Distance(row.USMHMouth3);
row.USMHMouth3 = d.ToStringInMil2();
}
}
if (!row.IsUSMHMouth4Null())
{
if (Distance.IsValidDistance(row.USMHMouth4))
{
d = new Distance(row.USMHMouth4);
row.USMHMouth4 = d.ToStringInMil2();
}
}
if (!row.IsUSMHMouth5Null())
{
if (Distance.IsValidDistance(row.USMHMouth5))
{
d = new Distance(row.USMHMouth5);
row.USMHMouth5 = d.ToStringInMil2();
}
}
if (!row.IsDSMHMouth12Null())
{
if (Distance.IsValidDistance(row.DSMHMouth12))
{
d = new Distance(row.DSMHMouth12);
row.DSMHMouth12 = d.ToStringInMil2();
}
}
if (!row.IsDSMHMouth1Null())
{
if (Distance.IsValidDistance(row.DSMHMouth1))
{
d = new Distance(row.DSMHMouth1);
row.DSMHMouth1 = d.ToStringInMil2();
}
}
if (!row.IsDSMHMouth2Null())
{
if (Distance.IsValidDistance(row.DSMHMouth2))
{
d = new Distance(row.DSMHMouth2);
row.DSMHMouth2 = d.ToStringInMil2();
}
}
if (!row.IsDSMHMouth3Null())
{
if (Distance.IsValidDistance(row.DSMHMouth3))
{
d = new Distance(row.DSMHMouth3);
row.DSMHMouth3 = d.ToStringInMil2();
}
}
if (!row.IsDSMHMouth4Null())
{
if (Distance.IsValidDistance(row.DSMHMouth4))
{
d = new Distance(row.DSMHMouth4);
row.DSMHMouth4 = d.ToStringInMil2();
}
}
if (!row.IsDSMHMouth5Null())
{
if (Distance.IsValidDistance(row.DSMHMouth5))
{
d = new Distance(row.DSMHMouth5);
row.DSMHMouth5 = d.ToStringInMil2();
}
}
}
if (unitType == "Imperial")
{
if (!row.IsSize_Null())
{
if (Distance.IsValidDistance(row.Size_))
{
Distance distance = new Distance(row.Size_);
switch (distance.DistanceType)
{
case 2:
row.Size_ = distance.ToStringInEng1();
break;
case 3:
try
{
if (Convert.ToDouble(row.Size_) > 99)
{
double newSize_ = 0;
newSize_ = Convert.ToDouble(row.Size_) * 0.03937;
row.Size_ = Convert.ToString(Math.Ceiling(newSize_)) + "\"";
}
else
{
row.Size_ = row.Size_ + "\"";
}
}
catch
{
}
break;
case 4:
row.Size_ = distance.ToStringInEng1();
break;
case 5:
row.Size_ = distance.ToStringInEng1();
break;
}
}
}
if (!row.IsLengthNull())
{
d = new Distance(row.Length);
row.Length = d.ToStringInEng1();
}
if (!row.IsUSMHDepthNull())
{
if (Distance.IsValidDistance(row.USMHDepth))
{
Distance distance = new Distance(row.USMHDepth);
switch (distance.DistanceType)
{
case 2:
row.USMHDepth = distance.ToStringInEng1();
break;
case 3:
try
{
if (Convert.ToDouble(row.Size_) > 99)
{
double newUSMHDepth = 0;
newUSMHDepth = Convert.ToDouble(row.Size_) * 0.03937;
row.USMHDepth = Convert.ToString(Math.Ceiling(newUSMHDepth)) + "\"";
}
else
{
row.USMHDepth = row.USMHDepth + "\"";
}
}
catch
{
}
break;
case 4:
row.USMHDepth = distance.ToStringInEng1();
break;
case 5:
row.USMHDepth = distance.ToStringInEng1();
break;
}
}
}
if (!row.IsDSMHDepthNull())
{
if (Distance.IsValidDistance(row.DSMHDepth))
{
Distance distance = new Distance(row.DSMHDepth);
switch (distance.DistanceType)
{
case 2:
row.DSMHDepth = distance.ToStringInEng1();
break;
case 3:
try
{
if (Convert.ToDouble(row.Size_) > 99)
{
double newDSMHDepth = 0;
newDSMHDepth = Convert.ToDouble(row.Size_) * 0.03937;
row.DSMHDepth = Convert.ToString(Math.Ceiling(newDSMHDepth)) + "\"";
}
else
{
row.DSMHDepth = row.USMHDepth + "\"";
}
}
catch
{
}
break;
case 4:
row.DSMHDepth = distance.ToStringInEng1();
break;
case 5:
row.DSMHDepth = distance.ToStringInEng1();
break;
}
}
}
if (!row.IsUSMHMouth12Null())
{
if (Distance.IsValidDistance(row.USMHMouth12))
{
Distance distance = new Distance(row.USMHMouth12);
switch (distance.DistanceType)
{
case 2:
row.USMHMouth12 = distance.ToStringInEng1();
break;
case 3:
try
{
if (Convert.ToDouble(row.USMHMouth12) > 99)
{
double newSize_ = 0;
newSize_ = Convert.ToDouble(row.USMHMouth12) * 0.03937;
row.USMHMouth12 = Convert.ToString(Math.Ceiling(newSize_)) + "\"";
}
else
{
row.USMHMouth12 = row.USMHMouth12 + "\"";
}
}
catch
{
}
break;
case 4:
row.USMHMouth12 = distance.ToStringInEng1();
break;
case 5:
row.USMHMouth12 = distance.ToStringInEng1();
break;
}
}
}
if (!row.IsUSMHMouth1Null())
{
if (Distance.IsValidDistance(row.USMHMouth1))
{
Distance distance = new Distance(row.USMHMouth1);
switch (distance.DistanceType)
{
case 2:
row.USMHMouth1 = distance.ToStringInEng1();
break;
case 3:
try
{
if (Convert.ToDouble(row.USMHMouth1) > 99)
{
double newSize_ = 0;
newSize_ = Convert.ToDouble(row.USMHMouth1) * 0.03937;
row.USMHMouth1 = Convert.ToString(Math.Ceiling(newSize_)) + "\"";
}
else
{
row.USMHMouth1 = row.USMHMouth1 + "\"";
}
}
catch
{
}
break;
case 4:
row.USMHMouth1 = distance.ToStringInEng1();
break;
case 5:
row.USMHMouth1 = distance.ToStringInEng1();
break;
}
}
}
if (!row.IsUSMHMouth2Null())
{
if (Distance.IsValidDistance(row.USMHMouth2))
{
Distance distance = new Distance(row.USMHMouth2);
switch (distance.DistanceType)
{
case 2:
row.USMHMouth2 = distance.ToStringInEng1();
break;
case 3:
try
{
if (Convert.ToDouble(row.USMHMouth2) > 99)
{
double newSize_ = 0;
newSize_ = Convert.ToDouble(row.USMHMouth2) * 0.03937;
row.USMHMouth2 = Convert.ToString(Math.Ceiling(newSize_)) + "\"";
}
else
{
row.USMHMouth2 = row.USMHMouth2 + "\"";
}
}
catch
{
}
break;
case 4:
row.USMHMouth2 = distance.ToStringInEng1();
break;
case 5:
row.USMHMouth2 = distance.ToStringInEng1();
break;
}
}
}
if (!row.IsUSMHMouth3Null())
{
if (Distance.IsValidDistance(row.USMHMouth3))
{
Distance distance = new Distance(row.USMHMouth3);
switch (distance.DistanceType)
{
case 2:
row.USMHMouth3 = distance.ToStringInEng1();
break;
case 3:
try
{
if (Convert.ToDouble(row.USMHMouth3) > 99)
{
double newSize_ = 0;
newSize_ = Convert.ToDouble(row.USMHMouth3) * 0.03937;
row.USMHMouth3 = Convert.ToString(Math.Ceiling(newSize_)) + "\"";
}
else
{
row.USMHMouth3 = row.USMHMouth3 + "\"";
}
}
catch
{
}
break;
case 4:
row.USMHMouth3 = distance.ToStringInEng1();
break;
case 5:
row.USMHMouth3 = distance.ToStringInEng1();
break;
}
}
}
if (!row.IsUSMHMouth4Null())
{
if (Distance.IsValidDistance(row.USMHMouth4))
{
Distance distance = new Distance(row.USMHMouth4);
switch (distance.DistanceType)
{
case 2:
row.USMHMouth4 = distance.ToStringInEng1();
break;
case 3:
try
{
if (Convert.ToDouble(row.USMHMouth4) > 99)
{
double newSize_ = 0;
newSize_ = Convert.ToDouble(row.USMHMouth4) * 0.03937;
row.USMHMouth4 = Convert.ToString(Math.Ceiling(newSize_)) + "\"";
}
else
{
row.USMHMouth4 = row.USMHMouth4 + "\"";
}
}
catch
{
}
break;
case 4:
row.USMHMouth4 = distance.ToStringInEng1();
break;
case 5:
row.USMHMouth4 = distance.ToStringInEng1();
break;
}
}
}
if (!row.IsUSMHMouth5Null())
{
if (Distance.IsValidDistance(row.USMHMouth5))
{
Distance distance = new Distance(row.USMHMouth5);
switch (distance.DistanceType)
{
case 2:
row.USMHMouth5 = distance.ToStringInEng1();
break;
case 3:
try
{
if (Convert.ToDouble(row.USMHMouth5) > 99)
{
double newSize_ = 0;
newSize_ = Convert.ToDouble(row.USMHMouth5) * 0.03937;
row.USMHMouth5 = Convert.ToString(Math.Ceiling(newSize_)) + "\"";
}
else
{
row.USMHMouth5 = row.USMHMouth5 + "\"";
}
}
catch
{
}
break;
case 4:
row.USMHMouth5 = distance.ToStringInEng1();
break;
case 5:
row.USMHMouth5 = distance.ToStringInEng1();
break;
}
}
}
if (!row.IsDSMHMouth12Null())
{
if (Distance.IsValidDistance(row.DSMHMouth12))
{
Distance distance = new Distance(row.DSMHMouth12);
switch (distance.DistanceType)
{
case 2:
row.DSMHMouth12 = distance.ToStringInEng1();
break;
case 3:
try
{
if (Convert.ToDouble(row.DSMHMouth12) > 99)
{
double newSize_ = 0;
newSize_ = Convert.ToDouble(row.DSMHMouth12) * 0.03937;
row.DSMHMouth12 = Convert.ToString(Math.Ceiling(newSize_)) + "\"";
}
else
{
row.DSMHMouth12 = row.DSMHMouth12 + "\"";
}
}
catch
{
}
break;
case 4:
row.DSMHMouth12 = distance.ToStringInEng1();
break;
case 5:
row.DSMHMouth12 = distance.ToStringInEng1();
break;
}
}
}
if (!row.IsDSMHMouth1Null())
{
if (Distance.IsValidDistance(row.DSMHMouth1))
{
Distance distance = new Distance(row.DSMHMouth1);
switch (distance.DistanceType)
{
case 2:
row.DSMHMouth1 = distance.ToStringInEng1();
break;
case 3:
try
{
if (Convert.ToDouble(row.DSMHMouth1) > 99)
{
double newSize_ = 0;
newSize_ = Convert.ToDouble(row.DSMHMouth1) * 0.03937;
row.DSMHMouth1 = Convert.ToString(Math.Ceiling(newSize_)) + "\"";
}
else
{
row.DSMHMouth1 = row.DSMHMouth1 + "\"";
}
}
catch
{
}
break;
case 4:
row.DSMHMouth1 = distance.ToStringInEng1();
break;
case 5:
row.DSMHMouth1 = distance.ToStringInEng1();
break;
}
}
}
if (!row.IsDSMHMouth2Null())
{
if (Distance.IsValidDistance(row.DSMHMouth2))
{
Distance distance = new Distance(row.DSMHMouth2);
switch (distance.DistanceType)
{
case 2:
row.DSMHMouth2 = distance.ToStringInEng1();
break;
case 3:
try
{
if (Convert.ToDouble(row.DSMHMouth2) > 99)
{
double newSize_ = 0;
newSize_ = Convert.ToDouble(row.DSMHMouth2) * 0.03937;
row.DSMHMouth2 = Convert.ToString(Math.Ceiling(newSize_)) + "\"";
}
else
{
row.DSMHMouth2 = row.DSMHMouth2 + "\"";
}
}
catch
{
}
break;
case 4:
row.DSMHMouth2 = distance.ToStringInEng1();
break;
case 5:
row.DSMHMouth2 = distance.ToStringInEng1();
break;
}
}
}
if (!row.IsDSMHMouth3Null())
{
if (Distance.IsValidDistance(row.DSMHMouth3))
{
Distance distance = new Distance(row.DSMHMouth3);
switch (distance.DistanceType)
{
case 2:
row.DSMHMouth3 = distance.ToStringInEng1();
break;
case 3:
try
{
if (Convert.ToDouble(row.DSMHMouth3) > 99)
{
double newSize_ = 0;
newSize_ = Convert.ToDouble(row.DSMHMouth3) * 0.03937;
row.DSMHMouth3 = Convert.ToString(Math.Ceiling(newSize_)) + "\"";
}
else
{
row.DSMHMouth3 = row.DSMHMouth3 + "\"";
}
}
catch
{
}
break;
case 4:
row.DSMHMouth3 = distance.ToStringInEng1();
break;
case 5:
row.DSMHMouth3 = distance.ToStringInEng1();
break;
}
}
}
if (!row.IsDSMHMouth4Null())
{
if (Distance.IsValidDistance(row.DSMHMouth4))
{
Distance distance = new Distance(row.DSMHMouth4);
switch (distance.DistanceType)
{
case 2:
row.DSMHMouth4 = distance.ToStringInEng1();
break;
case 3:
try
{
if (Convert.ToDouble(row.DSMHMouth4) > 99)
{
double newSize_ = 0;
newSize_ = Convert.ToDouble(row.DSMHMouth4) * 0.03937;
row.DSMHMouth4 = Convert.ToString(Math.Ceiling(newSize_)) + "\"";
}
else
{
row.DSMHMouth4 = row.DSMHMouth4 + "\"";
}
}
catch
{
}
break;
case 4:
row.DSMHMouth4 = distance.ToStringInEng1();
break;
case 5:
row.DSMHMouth4 = distance.ToStringInEng1();
break;
}
}
}
if (!row.IsDSMHMouth5Null())
{
if (Distance.IsValidDistance(row.DSMHMouth5))
{
Distance distance = new Distance(row.DSMHMouth5);
switch (distance.DistanceType)
{
case 2:
row.DSMHMouth5 = distance.ToStringInEng1();
break;
case 3:
try
{
if (Convert.ToDouble(row.DSMHMouth5) > 99)
{
double newSize_ = 0;
newSize_ = Convert.ToDouble(row.DSMHMouth5) * 0.03937;
row.DSMHMouth5 = Convert.ToString(Math.Ceiling(newSize_)) + "\"";
}
else
{
row.DSMHMouth5 = row.DSMHMouth5 + "\"";
}
}
catch
{
}
break;
case 4:
row.DSMHMouth5 = distance.ToStringInEng1();
break;
case 5:
row.DSMHMouth5 = distance.ToStringInEng1();
break;
}
}
}
}
flM1LateralReportGateway.LoadByAssetId(row.AssetID, row.COMPANY_ID);
flM1LateralReport.UpdateForReport(row.FlowOrderID, unitType);
}
}
// ////////////////////////////////////////////////////////////////////////
// PRIVATE METHODS
//
/// <summary>
/// UpdateForReport
/// </summary>
/// <param name="unitType">unitType</param>
public void UpdateForReport(string unitType)
{
// Load comments
foreach (FlM1ReportTDS.M2_SECTIONRow row in (FlM1ReportTDS.M2_SECTIONDataTable)Table)
{
WorkGateway workGateway = new WorkGateway();
workGateway.LoadByWorkId(row.WorkID, row.COMPANY_ID);
row.Comments = workGateway.GetComments(row.WorkID);
Distance d;
if (unitType == "Metric")
{
if (!row.IsSize_Null())
{
d = new Distance(row.Size_);
row.Size_ = d.ToStringInMet2();
}
if (!row.IsVideoLengthNull())
{
d = new Distance(row.VideoLength);
row.VideoLength = d.ToStringInMet2();
}
if (!row.IsSurfaceGradeNull())
{
if (row.SurfaceGrade == "0-3 ft")
{
row.SurfaceGrade = "0-0.91 m";
}
if (row.SurfaceGrade == "3-6 ft")
{
row.SurfaceGrade = "0.91-1.83 m";
}
if (row.SurfaceGrade == "6 ft +")
{
row.SurfaceGrade = "1.83 m +";
}
}
}
if (unitType == "Imperial")
{
if (!row.IsSize_Null())
{
if (Distance.IsValidDistance(row.Size_))
{
Distance distance = new Distance(row.Size_);
switch (distance.DistanceType)
{
case 2:
row.Size_ = distance.ToStringInEng1();
break;
case 3:
if (Convert.ToDouble(row.Size_) > 99)
{
double newSize_ = 0;
newSize_ = Convert.ToDouble(row.Size_) * 0.03937;
row.Size_ = Convert.ToString(Math.Ceiling(newSize_)) + "\"";
}
else
{
row.Size_ = row.Size_ + "\"";
}
break;
case 4:
row.Size_ = distance.ToStringInEng1();
break;
case 5:
row.Size_ = distance.ToStringInEng1();
break;
}
}
}
if (!row.IsVideoLengthNull())
{
d = new Distance(row.VideoLength);
row.VideoLength = d.ToStringInEng1();
}
}
}
// Update for unit type
//foreach (FlM1ReportTDS.M2_SECTIONRow row in (FlM1ReportTDS.M2_SECTIONDataTable)Table)
//{
//Distance d;
//if (unitType == "Metric")
//{
// if (!row.IsSize_Null())
// {
// d = new Distance(row.Size_);
// row.Size_ = d.ToStringInMet2();
// }
// if (!row.IsVideoLengthNull())
// {
// d = new Distance(row.VideoLength);
// row.VideoLength = d.ToStringInMet2();
// }
// if (!row.IsSurfaceGradeNull())
// {
// if (row.SurfaceGrade == "0-3 ft")
// {
// row.SurfaceGrade = "0-0.91 m";
// }
// if (row.SurfaceGrade == "3-6 ft")
// {
// row.SurfaceGrade = "0.91-1.83 m";
// }
// if (row.SurfaceGrade == "6 ft +")
// {
// row.SurfaceGrade = "1.83 m +";
// }
// }
//}
//if (unitType == "Imperial")
//{
// if (!row.IsSize_Null())
// {
// if (Distance.IsValidDistance(row.Size_))
// {
// Distance distance = new Distance(row.Size_);
// switch (distance.DistanceType)
// {
// case 2:
// row.Size_ = distance.ToStringInEng1();
// break;
// case 3:
// if (Convert.ToDouble(row.Size_) > 99)
// {
// double newSize_ = 0;
// newSize_ = Convert.ToDouble(row.Size_) * 0.03937;
// row.Size_ = Convert.ToString(Math.Ceiling(newSize_)) + "\"";
// }
// else
// {
// row.Size_ = row.Size_ + "\"";
// }
// break;
// case 4:
// row.Size_ = distance.ToStringInEng1();
// break;
// case 5:
// row.Size_ = distance.ToStringInEng1();
// break;
// }
// }
// }
// if (!row.IsVideoLengthNull())
// {
// d = new Distance(row.VideoLength);
// row.VideoLength = d.ToStringInEng1();
// }
//}
//}
}
// ////////////////////////////////////////////////////////////////////////
// PRIVATE METHODS
//
/// <summary>
/// UpdateForReport
/// </summary>
/// <param name="unitType">unitType</param>
private void UpdateForReport(string unitType)
{
// Load comments
foreach (FlM1LateralReportTDS.M1ReportByClientRow row in (FlM1LateralReportTDS.M1ReportByClientDataTable)Table)
{
WorkGateway workGateway = new WorkGateway();
workGateway.LoadByWorkId(row.WorkID, row.COMPANY_ID);
row.M1Comments = workGateway.GetComments(row.WorkID);
}
// Update for unit type
FlM1LateralLateralReportGateway flM1LateralReportGateway = new FlM1LateralLateralReportGateway(Data);
flM1LateralReportGateway.ClearBeforeFill = false;
FlM1LateralLateralReport flM1LateralReport = new FlM1LateralLateralReport(Data);
foreach (FlM1LateralReportTDS.M1ReportByClientRow row in (FlM1LateralReportTDS.M1ReportByClientDataTable)Table)
{
flM1LateralReportGateway.LoadByAssetId(row.AssetID, row.COMPANY_ID);
flM1LateralReport.UpdateForReport(row.FlowOrderID, unitType);
}
}