//COMPANY_ID /// <summary> /// Delete /// </summary> /// <param name="projectId">projectId</param> /// <param name="sectionId">sectionId</param> /// <param name="companyId">companyId</param> public void Delete(int projectId, int assetId, int companyId) { WorkRehabAssessmentGateway workRehabAssessmentGateway = new WorkRehabAssessmentGateway(); WorkRehabAssessment workRehabAssessment = new WorkRehabAssessment(workRehabAssessmentGateway.Data); WorkFullLengthLiningGateway workFullLengthLiningGateway = new WorkFullLengthLiningGateway(); WorkFullLengthLining workFullLengthLining = new WorkFullLengthLining(workFullLengthLiningGateway.Data); WorkJunctionLiningSectionGateway workJunctionLiningSectionGateway = new WorkJunctionLiningSectionGateway(); WorkJunctionLiningSection workJunctionLiningSection = new WorkJunctionLiningSection(workJunctionLiningSectionGateway.Data); int workIdRA = GetWorkId(projectId, assetId, "Rehab Assessment", companyId); if (workIdRA != 0) workRehabAssessment.DeleteDirect(workIdRA, companyId); int workIdFL = GetWorkId(projectId, assetId, "Full Length Lining", companyId); if (workIdFL != 0) workFullLengthLining.DeleteDirect(workIdFL, companyId); int workIdJL = GetWorkId(projectId, assetId, "Junction Lining Section", companyId); if (workIdJL != 0) workJunctionLiningSection.DeleteDirect(workIdJL, companyId); LfsAssetSewerSectionGateway lfsAssetSewerSectionGateway = new LfsAssetSewerSectionGateway(); lfsAssetSewerSectionGateway.LoadByAssetId(assetId, companyId); LfsAssetSewerSection lfsAssetSewerSection = new LfsAssetSewerSection(lfsAssetSewerSectionGateway.Data); // Update lfs asset lfsAssetSewerSection.DeleteDirect(assetId, companyId); }
/// <summary> /// DeleteDirectRaOnly /// </summary> /// <param name="workId">workId</param> /// <param name="assetId">assetId</param> /// <param name="companyId">companyId</param> public void DeleteDirectRaOnly(int workId, int assetId, int companyId) { // Delete work WorkRehabAssessment workRehabAssessment = new WorkRehabAssessment(null); workRehabAssessment.DeleteDirect(workId, companyId); // Delete section LfsAssetSewerSection lfsAssetSewerSection = new LfsAssetSewerSection(null); lfsAssetSewerSection.DeleteDirect(assetId, companyId); }
/// <summary> /// DeleteDirectAll /// </summary> /// <param name="projectId">projectId</param> /// <param name="assetId">assetId</param> /// <param name="companyId">companyId</param> public void DeleteDirectAll(int projectId, int assetId, int companyId) { int workIdRa = GetWorkId(projectId, assetId, "Rehab Assessment", companyId); int workIdFll = GetWorkId(projectId, assetId, "Full Length Lining", companyId); // Delete work WorkRehabAssessment workRehabAssessment = new WorkRehabAssessment(null); workRehabAssessment.DeleteDirect(workIdRa, companyId); // Delete work WorkFullLengthLining workFullLengthLining = new WorkFullLengthLining(null); workFullLengthLining.DeleteDirect(workIdFll, companyId); // Delete section LfsAssetSewerSection lfsAssetSewerSection = new LfsAssetSewerSection(null); lfsAssetSewerSection.DeleteDirect(assetId, companyId); }
// //////////////////////////////////////////////////////////////////////// // PRIVATE METHODS // /// <summary> /// UpdateWork /// </summary> /// <param name="countryId">countryId</param> /// <param name="provinceId">provinceId</param> /// <param name="countyId">countyId</param> /// <param name="cityId">cityId</param> /// <param name="workId">workId</param> /// <param name="originalClientId">originalClientId</param> /// <param name="originalProposedLiningDate">originalProposedLiningDate</param> /// <param name="originalDeadlineLiningDate">originalDeadlineLiningDate</param> /// <param name="originalP1Date">originalP1Date</param> /// <param name="originalM1Date">originalM1Date</param> /// <param name="originalM2Date">originalM2Date</param> /// <param name="originalInstallDate">originalInstallDate</param> /// <param name="originalFinalVideoDate">originalFinalVideoDate</param> /// <param name="originalIssueIdentified">originalIssueIdentified</param> /// <param name="originalIssueLFS">originalIssueLFS</param> /// <param name="originalIssueClient">originalIssueClient</param> /// <param name="originalIssueSales">originalIssueSales</param> /// <param name="originalIssueGivenToClient">originalIssueGivenToClient</param> /// <param name="originalIssueResolved">originalIssueResolved</param> /// <param name="originalIssueInvestigation">originalIssueInvestigation</param> /// <param name="originalCxisRemoved">originalCxisRemoved</param> /// <param name="originalRoboticPrepCompleted">originalRoboticPrepCompleted</param> /// <param name="originalRoboticPrepCompletedDate">originalRoboticPrepCompletedDate</param> /// <param name="originalMeasurementTakenBy">originalMeasurementTakenBy</param> /// <param name="originalMaterials">originalMaterials</param> /// <param name="originalTrafficControl">originalTrafficControl</param> /// <param name="originalSiteDetails">originalSiteDetails</param> /// <param name="originalPipeSizeChange">originalPipeSizeChange</param> /// <param name="originalStandardBypass">originalStandardBypass</param> /// <param name="originalStandardBypassComments">originalStandardBypassComments</param> /// <param name="originalTrafficControlDetails">originalTrafficControlDetails</param> /// <param name="originalMeasurementType">originalMeasurementType</param> /// <param name="originalMeasurementFromMh">originalMeasurementFromMh</param> /// <param name="originalVideoDoneFromMh">originalVideoDoneFromMh</param> /// <param name="originalVideoDoneToMh">originalVideoDoneToMh</param> /// <param name="originalMeasurementTakenByM2">originalMeasurementTakenByM2</param> /// <param name="originalDropPipe">originalDropPipe</param> /// <param name="originalDropPipeInvertDepth">originalDropPipeInvertDepth</param> /// <param name="originalCappedLaterals">originalCappedLaterals</param> /// <param name="originalLineWithId">originalLineWithId</param> /// <param name="originalHydrantAddress">originalHydrantAddress</param> /// <param name="originalHydroWireWithin10FtOfInversionMH">originalHydroWireWithin10FtOfInversionMH</param> /// <param name="originalDistanceToInversionMh">originalDistanceToInversionMh</param> /// <param name="originalSurfaceGrade">originalSurfaceGrade</param> /// <param name="originalHydroPulley">originalHydroPulley</param> /// <param name="originalFridgeCart">originalFridgeCart</param> /// <param name="originalTwoPump">originalTwoPump</param> /// <param name="originalSixBypass">originalSixBypass</param> /// <param name="originalScaffolding">originalScaffolding</param> /// <param name="originalWinchExtension">originalWinchExtension</param> /// <param name="originalExtraGenerator">originalExtraGenerator</param> /// <param name="originalGreyCableExtension">originalGreyCableExtension</param> /// <param name="originalEasementMats">originalEasementMats</param> /// <param name="originalRampRequired">originalRampRequired</param> /// <param name="originalVideoLength">originalVideoLength</param> /// <param name="originalComments">originalComments</param> /// <param name="originalPreFlushDate">originalPreFlushDate</param> /// <param name="originalPreVideoDate">originalPreVideoDate</param> /// <param name="originalRaWorkId">originalRaWorkId</param> /// <param name="originalDeleted">originalDeleted</param> /// <param name="originalCompanyId">originalCompanyId</param> /// <param name="originalCameraSkid">originalCameraSkid</param> /// <param name="originalAccessType">originalAccessType</param> /// <param name="originalP1Completed">originalP1Completed</param> /// /// <param name="newClientId">newClientId</param> /// <param name="newProposedLiningDate">newProposedLiningDate</param> /// <param name="newDeadlineLiningDate">newDeadlineLiningDate</param> /// <param name="newP1Date">newP1Date</param> /// <param name="newM1Date">newM1Date</param> /// <param name="newM2Date">newM2Date</param> /// <param name="newInstallDate">newInstallDate</param> /// <param name="newFinalVideoDate">newFinalVideoDate</param> /// <param name="newIssueIdentified">newIssueIdentified</param> /// <param name="newIssueLFS">newIssueLFS</param> /// <param name="newIssueClient">newIssueClient</param> /// <param name="newIssueSales">newIssueSales</param> /// <param name="newIssueGivenToClient">newIssueGivenToClient</param> /// <param name="newIssueResolved">newIssueResolved</param> /// <param name="newIssueInvestigation">newIssueInvestigation</param> /// <param name="newCxisRemoved">newCxisRemoved</param> /// <param name="newRoboticPrepCompleted">newRoboticPrepCompleted</param> /// <param name="newRoboticPrepCompletedDate">newRoboticPrepCompletedDate</param> /// <param name="newMeasurementTakenBy">newMeasurementTakenBy</param> /// <param name="newMaterials">newMaterials</param> /// <param name="newTrafficControl">newTrafficControl</param> /// <param name="newSiteDetails">newSiteDetails</param> /// <param name="newPipeSizeChange">newPipeSizeChange</param> /// <param name="newStandardBypass">newStandardBypass</param> /// <param name="newStandardBypassComments">newStandardBypassComments</param> /// <param name="newTrafficControlDetails">newTrafficControlDetails</param> /// <param name="newMeasurementType">newMeasurementType</param> /// <param name="newMeasurementFromMh">newMeasurementFromMh</param> /// <param name="newVideoDoneFromMh">newVideoDoneFromMh</param> /// <param name="newVideoDoneToMh">newVideoDoneToMh</param> /// <param name="newMeasurementTakenByM2">newMeasurementTakenByM2</param> /// <param name="newDropPipe">newDropPipe</param> /// <param name="newDropPipeInvertDepth">newDropPipeInvertDepth</param> /// <param name="newCappedLaterals">newCappedLaterals</param> /// <param name="newLineWithId">newLineWithId</param> /// <param name="newHydrantAddress">newHydrantAddress</param> /// <param name="newHydroWireWithin10FtOfInversionMH">newHydroWireWithin10FtOfInversionMH</param> /// <param name="newDistanceToInversionMh">newDistanceToInversionMh</param> /// <param name="newSurfaceGrade">newSurfaceGrade</param> /// <param name="newHydroPulley">newHydroPulley</param> /// <param name="newFridgeCart">newFridgeCart</param> /// <param name="newTwoPump">newTwoPump</param> /// <param name="newSixBypass">newSixBypass</param> /// <param name="newScaffolding">newScaffolding</param> /// <param name="newWinchExtension">newWinchExtension</param> /// <param name="newExtraGenerator">newExtraGenerator</param> /// <param name="newGreyCableExtension">newGreyCableExtension</param> /// <param name="newEasementMats">newEasementMats</param> /// <param name="newRampRequired">newRampRequired</param> /// <param name="newVideoLength">newVideoLength</param> /// <param name="newComments">newComments</param> /// <param name="newPreFlushDate">newPreFlushDate</param> /// <param name="newPreVideoDate">newPreVideoDate</param> /// <param name="newRaWorkId">newRaWorkId</param> /// <param name="sectionAssetId">sectionAssetId</param> /// <param name="newDeleted">newDeleted</param> /// <param name="newCompanyId">newCompanyId</param> /// <param name="newCameraSkid">newCameraSkid</param> /// <param name="newAccessType">newAccessType</param> /// <param name="newP1Completed">newP1Completed</param> private void UpdateWork(Int64? countryId, Int64? provinceId, Int64? countyId, Int64? cityId, int workId, string originalClientId, DateTime? originalProposedLiningDate, DateTime? originalDeadlineLiningDate, DateTime? originalP1Date, DateTime? originalM1Date, DateTime? originalM2Date, DateTime? originalInstallDate, DateTime? originalFinalVideoDate, bool originalIssueIdentified, bool originalIssueLFS, bool originalIssueClient, bool originalIssueSales, bool originalIssueGivenToClient, bool originalIssueResolved, bool originalIssueInvestigation, int? originalCxisRemoved, bool originalRoboticPrepCompleted, DateTime? originalRoboticPrepCompletedDate, string originalMeasurementTakenBy, string originalTrafficControl, string originalSiteDetails, bool originalPipeSizeChange, bool originalStandardBypass, string originalStandardBypassComments, string originalTrafficControlDetails, string originalMeasurementType, string originalMeasurementFromMh, string originalVideoDoneFromMh, string originalVideoDoneToMh, string originalMeasurementTakenByM2, bool originalDropPipe, string originalDropPipeInvertDepth, int? originalCappedLaterals, string originalLineWithId, string originalHydrantAddress, string originalHydroWireWithin10FtOfInversionMH, string originalDistanceToInversionMh, string originalSurfaceGrade, bool originalHydroPulley, bool originalFridgeCart, bool originalTwoPump, bool originalSixBypass, bool originalScaffolding, bool originalWinchExtension, bool originalExtraGenerator, bool originalGreyCableExtension, bool originalEasementMats, bool originalRampRequired, string originalVideoLength, string originalComments,DateTime? originalPreFlushDate, DateTime? originalPreVideoDate, int originalRaWorkId, bool originalDeleted, int originalCompanyId, string originalMaterials, bool originalCameraSkid, string originalAccessType, bool originalP1Completed, string newClientId, DateTime? newProposedLiningDate, DateTime? newDeadlineLiningDate, DateTime? newP1Date, DateTime? newM1Date, DateTime? newM2Date, DateTime? newInstallDate, DateTime? newFinalVideoDate, bool newIssueIdentified, bool newIssueLFS, bool newIssueClient, bool newIssueSales, bool newIssueGivenToClient, bool newIssueResolved, bool newIssueInvestigation, int? newCxisRemoved, bool newRoboticPrepCompleted, DateTime? newRoboticPrepCompletedDate, string newMeasurementTakenBy, string newMaterials, string newTrafficControl, string newSiteDetails, bool newPipeSizeChange, bool newStandardBypass, string newStandardBypassComments, string newTrafficControlDetails, string newMeasurementType, string newMeasurementFromMh, string newVideoDoneFromMh, string newVideoDoneToMh, string newMeasurementTakenByM2, bool newDropPipe, string newDropPipeInvertDepth, int? newCappedLaterals, string newLineWithId, string newHydrantAddress, string newHydroWireWithin10FtOfInversionMH, string newDistanceToInversionMh, string newSurfaceGrade, bool newHydroPulley, bool newFridgeCart, bool newTwoPump, bool newSixBypass, bool newScaffolding, bool newWinchExtension, bool newExtraGenerator, bool newGreyCableExtension, bool newEasementMats, bool newRampRequired, string newVideoLength, string newComments, DateTime? newPreFlushDate, DateTime? newPreVideoDate, int newRaWorkId, int sectionAssetId, bool newDeleted, int newCompanyId, bool newCameraSkid, string newAccessType, bool newP1Completed) { WorkFullLengthLining workFullLengthLining = new WorkFullLengthLining(null); workFullLengthLining.UpdateDirect(sectionAssetId, workId, originalClientId, originalProposedLiningDate, originalDeadlineLiningDate, originalP1Date, originalM1Date, originalM2Date, originalInstallDate, originalFinalVideoDate, originalIssueIdentified, originalIssueLFS, originalIssueClient, originalIssueSales, originalIssueGivenToClient, originalIssueResolved, originalIssueInvestigation, originalCxisRemoved, originalRoboticPrepCompleted, originalRoboticPrepCompletedDate, originalMeasurementTakenBy, originalTrafficControl, originalSiteDetails, originalPipeSizeChange, originalStandardBypass, originalStandardBypassComments, originalTrafficControlDetails, originalMeasurementType, originalMeasurementFromMh, originalVideoDoneFromMh, originalVideoDoneToMh, originalMeasurementTakenByM2, originalDropPipe, originalDropPipeInvertDepth, originalCappedLaterals, originalLineWithId, originalHydrantAddress, originalHydroWireWithin10FtOfInversionMH, originalDistanceToInversionMh, originalSurfaceGrade, originalHydroPulley, originalFridgeCart, originalTwoPump, originalSixBypass, originalScaffolding, originalWinchExtension, originalExtraGenerator, originalGreyCableExtension, originalEasementMats, originalRampRequired, originalVideoLength, originalDeleted, originalCompanyId, originalCameraSkid, originalAccessType, originalP1Completed, workId, newClientId, newProposedLiningDate, newDeadlineLiningDate, newP1Date, newM1Date, newM2Date, newInstallDate, newFinalVideoDate, newIssueIdentified, newIssueLFS, newIssueClient, newIssueSales, newIssueGivenToClient, newIssueResolved, newIssueInvestigation, newCxisRemoved, newRoboticPrepCompleted, newRoboticPrepCompletedDate, newMeasurementTakenBy, newTrafficControl, newSiteDetails, newPipeSizeChange, newStandardBypass, newStandardBypassComments, newTrafficControlDetails, newMeasurementType, newMeasurementFromMh, newVideoDoneFromMh, newVideoDoneToMh, newMeasurementTakenByM2, newDropPipe, newDropPipeInvertDepth, newCappedLaterals, newDistanceToInversionMh, newLineWithId, newHydrantAddress, newHydroWireWithin10FtOfInversionMH, newSurfaceGrade, newHydroPulley, newFridgeCart, newTwoPump, newSixBypass, newScaffolding, newWinchExtension, newExtraGenerator, newGreyCableExtension, newEasementMats, newRampRequired, newVideoLength, newDeleted, newCompanyId, newCameraSkid, newAccessType, newP1Completed); if (originalRaWorkId != 0) { WorkRehabAssessment workRehabAssessment = new WorkRehabAssessment(null); workRehabAssessment.UpdateDirect(originalRaWorkId, originalPreFlushDate, originalPreVideoDate, false, originalCompanyId, newRaWorkId, newPreFlushDate, newPreVideoDate, false, newCompanyId); } }
/// <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 RA work /// </summary> /// <param name="projectId">projectId</param> /// <param name="section_assetId">section_assetId</param> /// <param name="companyId">companyId</param> /// <param name="rehabAssessmentPrevWork">rehabAssessmentPrevWork</param> /// <param name="fullLengthLiningPrevWork">fullLengthLiningPrevWork</param> /// <param name="pointRepairsPrevWork">pointRepairsPrevWork</param> /// <param name="junctionLiningPrevWork">junctionLiningPrevWork</param> private void SaveRAWork(int projectId, int section_assetId, int companyId, bool rehabAssessmentPrevWork, bool fullLengthLiningPrevWork, bool pointRepairsPrevWork, bool junctionLiningPrevWork, bool rehabAssessmentNewWork, bool fullLengthLiningNewWork, bool pointRepairsNewWork, bool junctionLiningNewWork) { // If there is no previous work if (!rehabAssessmentPrevWork) { WorkRehabAssessment workRehabAssessment = new WorkRehabAssessment(null); workRehabAssessment.InsertDirect(projectId, section_assetId, null, null, null, false, companyId, "", ""); } else { // Copy selected works SavePreviousRAWork(projectId, section_assetId, companyId); if (fullLengthLiningPrevWork && !fullLengthLiningNewWork) SavePreviousFLWork(projectId, section_assetId, companyId); if (pointRepairsPrevWork && !pointRepairsNewWork) SavePreviousPRWork(projectId, section_assetId, companyId); if (junctionLiningPrevWork && !junctionLiningNewWork) SavePreviousJLWork(projectId, section_assetId, companyId); } }
/// <summary> /// UpdateDirect /// </summary> /// <param name="countryId">countryId</param> /// <param name="provinceId">provinceId</param> /// <param name="countyId">countyId</param> /// <param name="cityId">cityId</param> /// <param name="projectId">projectId</param> /// <param name="sectionAssetId">sectionAssetId</param> /// <param name="companyId">companyId</param> public void Save(Int64? countryId, Int64? provinceId, Int64? countyId, Int64? cityId, int projectId, int sectionAssetId, int companyId) { PointRepairsTDS pointRepairsChanges = (PointRepairsTDS)Data.GetChanges(); if (pointRepairsChanges.WorkDetails.Rows.Count > 0) { PointRepairsWorkDetailsGateway pointRepairsWorkDetailsGateway = new PointRepairsWorkDetailsGateway(pointRepairsChanges); // Update sections foreach (PointRepairsTDS.WorkDetailsRow workDetailsRow in (PointRepairsTDS.WorkDetailsDataTable)pointRepairsChanges.WorkDetails) { // Unchanged values int workId = workDetailsRow.WorkID; // Original values string originalClientId = pointRepairsWorkDetailsGateway.GetClientIdOriginal(workId); string originalMeasurementTakenBy = pointRepairsWorkDetailsGateway.GetMeasurementTakenByOriginal(workId); DateTime? originalRepairConfirmationDate = pointRepairsWorkDetailsGateway.GetRepairConfirmationDateOriginal(workId); bool originalBypassRequired = pointRepairsWorkDetailsGateway.GetBypassRequiredOriginal(workId); string originalRoboticDistances = pointRepairsWorkDetailsGateway.GetRoboticDistancesOriginal(workId); DateTime? originalProposedLiningDate = pointRepairsWorkDetailsGateway.GetProposedLiningDateOriginal(workId); DateTime? originalDeadlineLiningDate = pointRepairsWorkDetailsGateway.GetDeadlineLiningDateOriginal(workId); DateTime? originalFinalVideoDate = pointRepairsWorkDetailsGateway.GetFinalVideoDateOriginal(workId); int? originalEstimatedJoints = pointRepairsWorkDetailsGateway.GetEstimatedJointsOriginal(workId); int? originalJointsTestSealed = pointRepairsWorkDetailsGateway.GetJointsTestSealedOriginal(workId); bool originalIssueIdentified = pointRepairsWorkDetailsGateway.GetIssueIdentifiedOriginal(workId); bool originalIssueLFS = pointRepairsWorkDetailsGateway.GetIssueLFSOriginal(workId); bool originalIssueClient = pointRepairsWorkDetailsGateway.GetIssueClientOriginal(workId); bool originalIssueSales = pointRepairsWorkDetailsGateway.GetIssueSalesOriginal(workId); bool originalIssueGivenToClient = pointRepairsWorkDetailsGateway.GetIssueGivenToClientOriginal(workId); bool originalIssueResolved = pointRepairsWorkDetailsGateway.GetIssueResolvedOriginal(workId); bool originalIssueInvestigation = pointRepairsWorkDetailsGateway.GetIssueInvestigationOriginal(workId); // New variables string newClientId = pointRepairsWorkDetailsGateway.GetClientId(workId); string newMeasurementTakenBy = pointRepairsWorkDetailsGateway.GetMeasurementTakenBy(workId); DateTime? newRepairConfirmationDate = pointRepairsWorkDetailsGateway.GetRepairConfirmationDate(workId); bool newBypassRequired = pointRepairsWorkDetailsGateway.GetBypassRequired(workId); string newRoboticDistances = pointRepairsWorkDetailsGateway.GetRoboticDistances(workId); DateTime? newProposedLiningDate = pointRepairsWorkDetailsGateway.GetProposedLiningDate(workId); DateTime? newDeadlineLiningDate = pointRepairsWorkDetailsGateway.GetDeadlineLiningDate(workId); DateTime? newFinalVideoDate = pointRepairsWorkDetailsGateway.GetFinalVideoDate(workId); int? newEstimatedJoints = pointRepairsWorkDetailsGateway.GetEstimatedJoints(workId); int? newJointsTestSealed = pointRepairsWorkDetailsGateway.GetJointsTestSealed(workId); bool newIssueIdentified = pointRepairsWorkDetailsGateway.GetIssueIdentified(workId); bool newIssueLFS = pointRepairsWorkDetailsGateway.GetIssueLFS(workId); bool newIssueClient = pointRepairsWorkDetailsGateway.GetIssueClient(workId); bool newIssueSales = pointRepairsWorkDetailsGateway.GetIssueSales(workId); bool newIssueGivenToClient = pointRepairsWorkDetailsGateway.GetIssueGivenToClient(workId); bool newIssueResolved = pointRepairsWorkDetailsGateway.GetIssueResolved(workId); bool newIssueInvestigation = pointRepairsWorkDetailsGateway.GetIssueInvestigation(workId); // ... RA DateTime? originalPreFlushDate = pointRepairsWorkDetailsGateway.GetPreFlushDateOriginal(workId); DateTime? originalPreVideoDate = pointRepairsWorkDetailsGateway.GetPreVideoDateOriginal(workId); // ... FLL P1 DateTime? originalP1Date = pointRepairsWorkDetailsGateway.GetP1DateOriginal(workId); int? originalCxisRemoved = pointRepairsWorkDetailsGateway.GetCxisRemovedOriginal(workId); // ... FLL M1 string originalTrafficControl = pointRepairsWorkDetailsGateway.GetTrafficControlOriginal(workId); string originalMaterial = pointRepairsWorkDetailsGateway.GetMaterialOriginal(workId); // ... FLL M2 string originalVideoLength = pointRepairsWorkDetailsGateway.GetVideoLengthOriginal(workId); // ... P1 DateTime? newP1Date = pointRepairsWorkDetailsGateway.GetP1Date(workId); int? newCxisRemoved = pointRepairsWorkDetailsGateway.GetCxisRemoved(workId); string newTrafficControl = pointRepairsWorkDetailsGateway.GetTrafficControl(workId); string newMaterial = pointRepairsWorkDetailsGateway.GetMaterial(workId); // ... M2 string newVideoLength = pointRepairsWorkDetailsGateway.GetVideoLength(workId); // ... RA DateTime? newPreFlushDate = pointRepairsWorkDetailsGateway.GetPreFlushDate(workId); DateTime? newPreVideoDate = pointRepairsWorkDetailsGateway.GetPreVideoDate(workId); // ... FLL WorkID int workIdFll = 0; if (!workDetailsRow.IsWorkIDFLLNull()) workIdFll = workDetailsRow.WorkIDFLL; int workIdRa = 0; if (!workDetailsRow.IsWorkIDRANull()) workIdRa = workDetailsRow.WorkIDRA; if (workIdFll != 0) // ... Has Fll work { FullLengthLiningWorkDetailsGateway fullLengthLiningWorkDetailsGateway = new FullLengthLiningWorkDetailsGateway(); fullLengthLiningWorkDetailsGateway.LoadByWorkIdAssetId(workIdFll, sectionAssetId, companyId); // Original values string originalClientIdFLL = fullLengthLiningWorkDetailsGateway.GetClientIdOriginal(workIdFll); DateTime? originalProposedLiningDateFLL = fullLengthLiningWorkDetailsGateway.GetProposedLiningDateOriginal(workIdFll); DateTime? originalDeadlineLiningDateFLL = fullLengthLiningWorkDetailsGateway.GetDeadlineLiningDateOriginal(workIdFll); DateTime? originalM1Date = fullLengthLiningWorkDetailsGateway.GetM1DateOriginal(workIdFll); DateTime? originalM2Date = fullLengthLiningWorkDetailsGateway.GetM2DateOriginal(workIdFll); DateTime? originalInstallDate = fullLengthLiningWorkDetailsGateway.GetInstallDateOriginal(workIdFll); DateTime? originalFinalVideoDateFLL = fullLengthLiningWorkDetailsGateway.GetFinalVideoDateOriginal(workIdFll); bool originalIssueIdentifiedFLL = fullLengthLiningWorkDetailsGateway.GetIssueIdentifiedOriginal(workIdFll); bool originalIssueLFSFLL = fullLengthLiningWorkDetailsGateway.GetIssueLFSOriginal(workIdFll); bool originalIssueClientFLL = fullLengthLiningWorkDetailsGateway.GetIssueClientOriginal(workIdFll); bool originalIssueSalesFLL = fullLengthLiningWorkDetailsGateway.GetIssueSalesOriginal(workIdFll); bool originalIssueGivenToClientFLL = fullLengthLiningWorkDetailsGateway.GetIssueGivenToClientOriginal(workIdFll); bool originalIssueResolvedFLL = fullLengthLiningWorkDetailsGateway.GetIssueResolvedOriginal(workIdFll); bool originalIssueInvestigationFLL = fullLengthLiningWorkDetailsGateway.GetIssueInvestigationOriginal(workIdFll); bool originalRoboticPrepCompleted = fullLengthLiningWorkDetailsGateway.GetRoboticPrepCompletedOriginal(workIdFll); DateTime? originalRoboticPrepCompletedDate = fullLengthLiningWorkDetailsGateway.GetRoboticPrepCompletedDateOriginal(workIdFll); bool originalP1Completed = fullLengthLiningWorkDetailsGateway.GetP1CompletedOriginal(workIdFll); // M1 data string originalMeasurementTakenByFLL = fullLengthLiningWorkDetailsGateway.GetMeasurementTakenByOriginal(workIdFll); string originalSiteDetails = fullLengthLiningWorkDetailsGateway.GetSiteDetailsOriginal(workIdFll); bool originalPipeSizeChange = fullLengthLiningWorkDetailsGateway.GetPipeSizeChangeOriginal(workIdFll); bool originalStandardBypass = fullLengthLiningWorkDetailsGateway.GetStandardBypassOriginal(workIdFll); string originalStandardBypassComments = fullLengthLiningWorkDetailsGateway.GetStandardBypassCommentsOriginal(workIdFll); string originalTrafficControlDetails = fullLengthLiningWorkDetailsGateway.GetTrafficControlDetailsOriginal(workIdFll); string originalMeasurementType = fullLengthLiningWorkDetailsGateway.GetMeasurementTypeOriginal(workIdFll); string originalMeasurementFromMh = fullLengthLiningWorkDetailsGateway.GetMeasurementFromMhOriginal(workIdFll); string originalVideoDoneFromMh = fullLengthLiningWorkDetailsGateway.GetVideoDoneFromMhOriginal(workIdFll); string originalVideoDoneToMh = fullLengthLiningWorkDetailsGateway.GetVideoDoneToMhOriginal(workIdFll); string originalAccessType = fullLengthLiningWorkDetailsGateway.GetAccessTypeOriginal(workIdFll); // M2 data string originalMeasurementTakenByM2 = fullLengthLiningWorkDetailsGateway.GetMeasurementTakenByM2Original(workIdFll); bool originalDropPipe = fullLengthLiningWorkDetailsGateway.GetDropPipeOriginal(workIdFll); string originalDropPipeInvertDepth = fullLengthLiningWorkDetailsGateway.GetDropPipeInvertDepthOriginal(workIdFll); int? originalCappedLaterals = fullLengthLiningWorkDetailsGateway.GetCappedLateralsOriginal(workIdFll); string originalLineWithId = fullLengthLiningWorkDetailsGateway.GetLineWithIdOriginal(workIdFll); string originalHydrantAddress = fullLengthLiningWorkDetailsGateway.GetHydrantAddressOriginal(workIdFll); string originalHydroWireWithin10FtOfInversionMH = fullLengthLiningWorkDetailsGateway.GetHydroWiredWithin10FtOfInversionMHOriginal(workIdFll); string originalDistanceToInversionMh = fullLengthLiningWorkDetailsGateway.GetDistanceToInversionMhOriginal(workIdFll); string originalSurfaceGrade = fullLengthLiningWorkDetailsGateway.GetSurfaceGradeOriginal(workIdFll); bool originalHydroPulley = fullLengthLiningWorkDetailsGateway.GetHydroPulleyOriginal(workIdFll); bool originalFridgeCart = fullLengthLiningWorkDetailsGateway.GetFridgeCartOriginal(workIdFll); bool originalTwoPump = fullLengthLiningWorkDetailsGateway.GetTwoPumpOriginal(workIdFll); bool originalSixBypass = fullLengthLiningWorkDetailsGateway.GetSixBypassOriginal(workIdFll); bool originalScaffolding = fullLengthLiningWorkDetailsGateway.GetScaffoldingOriginal(workIdFll); bool originalWinchExtension = fullLengthLiningWorkDetailsGateway.GetWinchExtensionOriginal(workIdFll); bool originalExtraGenerator = fullLengthLiningWorkDetailsGateway.GetExtraGeneratorOriginal(workIdFll); bool originalGreyCableExtension = fullLengthLiningWorkDetailsGateway.GetGreyCableExtensionOriginal(workIdFll); bool originalEasementMats = fullLengthLiningWorkDetailsGateway.GetEasementMatsOriginal(workIdFll); bool originalRampRequired = fullLengthLiningWorkDetailsGateway.GetRampRequiredOriginal(workIdFll); bool originalCameraSkid = fullLengthLiningWorkDetailsGateway.GetCameraSkidOriginal(workIdFll); // Comments string originalComments = fullLengthLiningWorkDetailsGateway.GetCommentsOriginal(workIdFll); // New variables string newClientIdFLL = fullLengthLiningWorkDetailsGateway.GetClientId(workIdFll); DateTime? newProposedLiningDateFLL = fullLengthLiningWorkDetailsGateway.GetProposedLiningDate(workIdFll); DateTime? newDeadlineLiningDateFLL = fullLengthLiningWorkDetailsGateway.GetDeadlineLiningDate(workIdFll); DateTime? newM1Date = fullLengthLiningWorkDetailsGateway.GetM1Date(workIdFll); DateTime? newM2Date = fullLengthLiningWorkDetailsGateway.GetM2Date(workIdFll); DateTime? newInstallDate = fullLengthLiningWorkDetailsGateway.GetInstallDate(workIdFll); DateTime? newFinalVideoDateFLL = fullLengthLiningWorkDetailsGateway.GetFinalVideoDate(workIdFll); bool newIssueIdentifiedFLL = fullLengthLiningWorkDetailsGateway.GetIssueIdentified(workIdFll); bool newIssueLFSFLL = fullLengthLiningWorkDetailsGateway.GetIssueLFS(workIdFll); bool newIssueClientFLL = fullLengthLiningWorkDetailsGateway.GetIssueClient(workIdFll); bool newIssueSalesFLL = fullLengthLiningWorkDetailsGateway.GetIssueSales(workIdFll); bool newIssueGivenToClientFLL = fullLengthLiningWorkDetailsGateway.GetIssueGivenToClient(workIdFll); bool newIssueResolvedFLL = fullLengthLiningWorkDetailsGateway.GetIssueResolved(workIdFll); bool newIssueInvestigationFLL = fullLengthLiningWorkDetailsGateway.GetIssueInvestigation(workIdFll); bool newRoboticPrepCompleted = fullLengthLiningWorkDetailsGateway.GetRoboticPrepCompleted(workIdFll); DateTime? newRoboticPrepCompletedDate = fullLengthLiningWorkDetailsGateway.GetRoboticPrepCompletedDate(workIdFll); bool newP1Completed = fullLengthLiningWorkDetailsGateway.GetP1Completed(workIdFll); // M1 string newMeasurementTakenByFLL = fullLengthLiningWorkDetailsGateway.GetMeasurementTakenBy(workIdFll); string newSiteDetails = fullLengthLiningWorkDetailsGateway.GetSiteDetails(workIdFll); bool newPipeSizeChange = fullLengthLiningWorkDetailsGateway.GetPipeSizeChange(workIdFll); bool newStandardBypass = fullLengthLiningWorkDetailsGateway.GetStandardBypass(workIdFll); string newStandardBypassComments = fullLengthLiningWorkDetailsGateway.GetStandardBypassComments(workIdFll); string newTrafficControlDetails = fullLengthLiningWorkDetailsGateway.GetTrafficControlDetails(workIdFll); string newMeasurementType = fullLengthLiningWorkDetailsGateway.GetMeasurementType(workIdFll); string newMeasurementFromMh = fullLengthLiningWorkDetailsGateway.GetMeasurementFromMh(workIdFll); string newVideoDoneFromMh = fullLengthLiningWorkDetailsGateway.GetVideoDoneFromMh(workIdFll); string newVideoDoneToMh = fullLengthLiningWorkDetailsGateway.GetVideoDoneToMh(workIdFll); string newAccessType = fullLengthLiningWorkDetailsGateway.GetAccessType(workIdFll); // M2 string newMeasurementTakenByM2 = fullLengthLiningWorkDetailsGateway.GetMeasurementTakenByM2(workIdFll); bool newDropPipe = fullLengthLiningWorkDetailsGateway.GetDropPipe(workIdFll); string newDropPipeInvertDepth = fullLengthLiningWorkDetailsGateway.GetDropPipeInvertDepth(workIdFll); int? newCappedLaterals = fullLengthLiningWorkDetailsGateway.GetCappedLaterals(workIdFll); string newLineWithId = fullLengthLiningWorkDetailsGateway.GetLineWithId(workIdFll); string newHydrantAddress = fullLengthLiningWorkDetailsGateway.GetHydrantAddress(workIdFll); string newHydroWireWithin10FtOfInversionMH = fullLengthLiningWorkDetailsGateway.GetHydroWiredWithin10FtOfInversionMH(workIdFll); string newDistanceToInversionMh = fullLengthLiningWorkDetailsGateway.GetDistanceToInversionMh(workIdFll); string newSurfaceGrade = fullLengthLiningWorkDetailsGateway.GetSurfaceGrade(workIdFll); bool newHydroPulley = fullLengthLiningWorkDetailsGateway.GetHydroPulley(workIdFll); bool newFridgeCart = fullLengthLiningWorkDetailsGateway.GetFridgeCart(workIdFll); bool newTwoPump = fullLengthLiningWorkDetailsGateway.GetTwoPump(workIdFll); bool newSixBypass = fullLengthLiningWorkDetailsGateway.GetSixBypass(workIdFll); bool newScaffolding = fullLengthLiningWorkDetailsGateway.GetScaffolding(workIdFll); bool newWinchExtension = fullLengthLiningWorkDetailsGateway.GetWinchExtension(workIdFll); bool newExtraGenerator = fullLengthLiningWorkDetailsGateway.GetExtraGenerator(workIdFll); bool newGreyCableExtension = fullLengthLiningWorkDetailsGateway.GetGreyCableExtension(workIdFll); bool newEasementMats = fullLengthLiningWorkDetailsGateway.GetEasementMats(workIdFll); bool newRampRequired = fullLengthLiningWorkDetailsGateway.GetRampRequired(workIdFll); bool newCameraSkid = fullLengthLiningWorkDetailsGateway.GetCameraSkid(workIdFll); // comments string newComments = fullLengthLiningWorkDetailsGateway.GetComments(workIdFll); // ... Update work UpdateFllWork(sectionAssetId, countryId, provinceId, countyId, cityId, workIdFll, originalClientIdFLL, originalProposedLiningDateFLL, originalDeadlineLiningDateFLL, originalP1Date, originalM1Date, originalM2Date, originalInstallDate, originalFinalVideoDateFLL, originalIssueIdentifiedFLL, originalIssueLFSFLL, originalIssueClientFLL, originalIssueSalesFLL, originalIssueGivenToClientFLL, originalIssueResolvedFLL, originalIssueInvestigationFLL, originalCxisRemoved, originalRoboticPrepCompleted, originalRoboticPrepCompletedDate, originalMeasurementTakenByFLL, originalTrafficControl, originalSiteDetails, originalPipeSizeChange, originalStandardBypass, originalStandardBypassComments, originalTrafficControlDetails, originalMeasurementType, originalMeasurementFromMh, originalVideoDoneFromMh, originalVideoDoneToMh, originalVideoLength, originalComments, false, companyId, originalMaterial, originalAccessType, originalP1Completed, newClientIdFLL, originalProposedLiningDateFLL, originalDeadlineLiningDateFLL, newP1Date, newM1Date, originalM2Date, originalInstallDate, originalFinalVideoDateFLL, originalIssueIdentifiedFLL, originalIssueLFSFLL, originalIssueClientFLL, originalIssueSalesFLL, originalIssueGivenToClientFLL, originalIssueResolvedFLL, originalIssueInvestigationFLL, newCxisRemoved, newRoboticPrepCompleted, newRoboticPrepCompletedDate, newMeasurementTakenByFLL, newMaterial, newTrafficControl, newSiteDetails, newPipeSizeChange, newStandardBypass, newStandardBypassComments, newTrafficControlDetails, newMeasurementType, newMeasurementFromMh, newVideoDoneFromMh, newVideoDoneToMh, newVideoLength, newComments, false, companyId, newAccessType, newP1Completed); } else { if (newP1Date.HasValue || newCxisRemoved.HasValue || newMaterial != "" || newTrafficControl != "" || newVideoLength != "") // Insert Fll work { WorkFullLengthLining workFullLengthLining = new WorkFullLengthLining(null); workIdFll = workFullLengthLining.InsertDirectEmptyWorks(projectId, sectionAssetId, null, "", null, null, null, null, null, null, null, false, false, false, false, false, false, false, companyId, false, "", ""); FullLengthLiningWorkDetailsGateway fullLengthLiningWorkDetailsGateway = new FullLengthLiningWorkDetailsGateway(); fullLengthLiningWorkDetailsGateway.LoadByWorkIdAssetId(workIdFll, sectionAssetId, companyId); // Original values string originalClientIdFLL = fullLengthLiningWorkDetailsGateway.GetClientIdOriginal(workIdFll); DateTime? originalProposedLiningDateFLL = fullLengthLiningWorkDetailsGateway.GetProposedLiningDateOriginal(workIdFll); DateTime? originalDeadlineLiningDateFLL = fullLengthLiningWorkDetailsGateway.GetDeadlineLiningDateOriginal(workIdFll); DateTime? originalM1Date = fullLengthLiningWorkDetailsGateway.GetM1DateOriginal(workIdFll); DateTime? originalM2Date = fullLengthLiningWorkDetailsGateway.GetM2DateOriginal(workIdFll); DateTime? originalInstallDate = fullLengthLiningWorkDetailsGateway.GetInstallDateOriginal(workIdFll); DateTime? originalFinalVideoDateFLL = fullLengthLiningWorkDetailsGateway.GetFinalVideoDateOriginal(workIdFll); bool originalIssueIdentifiedFLL = fullLengthLiningWorkDetailsGateway.GetIssueIdentifiedOriginal(workIdFll); bool originalIssueLFSFLL = fullLengthLiningWorkDetailsGateway.GetIssueLFSOriginal(workIdFll); bool originalIssueClientFLL = fullLengthLiningWorkDetailsGateway.GetIssueClientOriginal(workIdFll); bool originalIssueSalesFLL = fullLengthLiningWorkDetailsGateway.GetIssueSalesOriginal(workIdFll); bool originalIssueGivenToClientFLL = fullLengthLiningWorkDetailsGateway.GetIssueGivenToClientOriginal(workIdFll); bool originalIssueResolvedFLL = fullLengthLiningWorkDetailsGateway.GetIssueResolvedOriginal(workIdFll); bool originalIssueInvestigationFLL = fullLengthLiningWorkDetailsGateway.GetIssueInvestigationOriginal(workIdFll); bool originalRoboticPrepCompleted = fullLengthLiningWorkDetailsGateway.GetRoboticPrepCompletedOriginal(workIdFll); DateTime? originalRoboticPrepCompletedDate = fullLengthLiningWorkDetailsGateway.GetRoboticPrepCompletedDateOriginal(workIdFll); bool originalP1Completed = fullLengthLiningWorkDetailsGateway.GetP1CompletedOriginal(workIdFll); // M1 data string originalMeasurementTakenByFLL = fullLengthLiningWorkDetailsGateway.GetMeasurementTakenByOriginal(workIdFll); string originalSiteDetails = fullLengthLiningWorkDetailsGateway.GetSiteDetailsOriginal(workIdFll); bool originalPipeSizeChange = fullLengthLiningWorkDetailsGateway.GetPipeSizeChangeOriginal(workIdFll); bool originalStandardBypass = fullLengthLiningWorkDetailsGateway.GetStandardBypassOriginal(workIdFll); string originalStandardBypassComments = fullLengthLiningWorkDetailsGateway.GetStandardBypassCommentsOriginal(workIdFll); string originalTrafficControlDetails = fullLengthLiningWorkDetailsGateway.GetTrafficControlDetailsOriginal(workIdFll); string originalMeasurementType = fullLengthLiningWorkDetailsGateway.GetMeasurementTypeOriginal(workIdFll); string originalMeasurementFromMh = fullLengthLiningWorkDetailsGateway.GetMeasurementFromMhOriginal(workIdFll); string originalVideoDoneFromMh = fullLengthLiningWorkDetailsGateway.GetVideoDoneFromMhOriginal(workIdFll); string originalVideoDoneToMh = fullLengthLiningWorkDetailsGateway.GetVideoDoneToMhOriginal(workIdFll); string originalAccessType = fullLengthLiningWorkDetailsGateway.GetAccessTypeOriginal(workIdFll); // M2 data string originalMeasurementTakenByM2 = fullLengthLiningWorkDetailsGateway.GetMeasurementTakenByM2Original(workIdFll); bool originalDropPipe = fullLengthLiningWorkDetailsGateway.GetDropPipeOriginal(workIdFll); string originalDropPipeInvertDepth = fullLengthLiningWorkDetailsGateway.GetDropPipeInvertDepthOriginal(workIdFll); int? originalCappedLaterals = fullLengthLiningWorkDetailsGateway.GetCappedLateralsOriginal(workIdFll); string originalLineWithId = fullLengthLiningWorkDetailsGateway.GetLineWithIdOriginal(workIdFll); string originalHydrantAddress = fullLengthLiningWorkDetailsGateway.GetHydrantAddressOriginal(workIdFll); string originalHydroWireWithin10FtOfInversionMH = fullLengthLiningWorkDetailsGateway.GetHydroWiredWithin10FtOfInversionMHOriginal(workIdFll); string originalDistanceToInversionMh = fullLengthLiningWorkDetailsGateway.GetDistanceToInversionMhOriginal(workIdFll); string originalSurfaceGrade = fullLengthLiningWorkDetailsGateway.GetSurfaceGradeOriginal(workIdFll); bool originalHydroPulley = fullLengthLiningWorkDetailsGateway.GetHydroPulleyOriginal(workIdFll); bool originalFridgeCart = fullLengthLiningWorkDetailsGateway.GetFridgeCartOriginal(workIdFll); bool originalTwoPump = fullLengthLiningWorkDetailsGateway.GetTwoPumpOriginal(workIdFll); bool originalSixBypass = fullLengthLiningWorkDetailsGateway.GetSixBypassOriginal(workIdFll); bool originalScaffolding = fullLengthLiningWorkDetailsGateway.GetScaffoldingOriginal(workIdFll); bool originalWinchExtension = fullLengthLiningWorkDetailsGateway.GetWinchExtensionOriginal(workIdFll); bool originalExtraGenerator = fullLengthLiningWorkDetailsGateway.GetExtraGeneratorOriginal(workIdFll); bool originalGreyCableExtension = fullLengthLiningWorkDetailsGateway.GetGreyCableExtensionOriginal(workIdFll); bool originalEasementMats = fullLengthLiningWorkDetailsGateway.GetEasementMatsOriginal(workIdFll); bool originalRampRequired = fullLengthLiningWorkDetailsGateway.GetRampRequiredOriginal(workIdFll); bool originalCameraSkid = fullLengthLiningWorkDetailsGateway.GetCameraSkidOriginal(workIdFll); // Comments string originalComments = fullLengthLiningWorkDetailsGateway.GetCommentsOriginal(workIdFll); // New variables string newClientIdFLL = fullLengthLiningWorkDetailsGateway.GetClientId(workIdFll); DateTime? newProposedLiningDateFLL = fullLengthLiningWorkDetailsGateway.GetProposedLiningDate(workIdFll); DateTime? newDeadlineLiningDateFLL = fullLengthLiningWorkDetailsGateway.GetDeadlineLiningDate(workIdFll); DateTime? newM1Date = fullLengthLiningWorkDetailsGateway.GetM1Date(workIdFll); DateTime? newM2Date = fullLengthLiningWorkDetailsGateway.GetM2Date(workIdFll); DateTime? newInstallDate = fullLengthLiningWorkDetailsGateway.GetInstallDate(workIdFll); DateTime? newFinalVideoDateFLL = fullLengthLiningWorkDetailsGateway.GetFinalVideoDate(workIdFll); bool newIssueIdentifiedFLL = fullLengthLiningWorkDetailsGateway.GetIssueIdentified(workIdFll); bool newIssueLFSFLL = fullLengthLiningWorkDetailsGateway.GetIssueLFS(workIdFll); bool newIssueClientFLL = fullLengthLiningWorkDetailsGateway.GetIssueClient(workIdFll); bool newIssueSalesFLL = fullLengthLiningWorkDetailsGateway.GetIssueSales(workIdFll); bool newIssueGivenToClientFLL = fullLengthLiningWorkDetailsGateway.GetIssueGivenToClient(workIdFll); bool newIssueResolvedFLL = fullLengthLiningWorkDetailsGateway.GetIssueResolved(workIdFll); bool newIssueInvestigationFLL = fullLengthLiningWorkDetailsGateway.GetIssueInvestigation(workIdFll); bool newRoboticPrepCompleted = fullLengthLiningWorkDetailsGateway.GetRoboticPrepCompleted(workIdFll); DateTime? newRoboticPrepCompletedDate = fullLengthLiningWorkDetailsGateway.GetRoboticPrepCompletedDate(workIdFll); bool newP1Completed = fullLengthLiningWorkDetailsGateway.GetP1Completed(workIdFll); // M1 string newMeasurementTakenByFLL = fullLengthLiningWorkDetailsGateway.GetMeasurementTakenBy(workIdFll); string newSiteDetails = fullLengthLiningWorkDetailsGateway.GetSiteDetails(workIdFll); bool newPipeSizeChange = fullLengthLiningWorkDetailsGateway.GetPipeSizeChange(workIdFll); bool newStandardBypass = fullLengthLiningWorkDetailsGateway.GetStandardBypass(workIdFll); string newStandardBypassComments = fullLengthLiningWorkDetailsGateway.GetStandardBypassComments(workIdFll); string newTrafficControlDetails = fullLengthLiningWorkDetailsGateway.GetTrafficControlDetails(workIdFll); string newMeasurementType = fullLengthLiningWorkDetailsGateway.GetMeasurementType(workIdFll); string newMeasurementFromMh = fullLengthLiningWorkDetailsGateway.GetMeasurementFromMh(workIdFll); string newVideoDoneFromMh = fullLengthLiningWorkDetailsGateway.GetVideoDoneFromMh(workIdFll); string newVideoDoneToMh = fullLengthLiningWorkDetailsGateway.GetVideoDoneToMh(workIdFll); string newAccessType = fullLengthLiningWorkDetailsGateway.GetAccessType(workIdFll); // M2 string newMeasurementTakenByM2 = fullLengthLiningWorkDetailsGateway.GetMeasurementTakenByM2(workIdFll); bool newDropPipe = fullLengthLiningWorkDetailsGateway.GetDropPipe(workIdFll); string newDropPipeInvertDepth = fullLengthLiningWorkDetailsGateway.GetDropPipeInvertDepth(workIdFll); int? newCappedLaterals = fullLengthLiningWorkDetailsGateway.GetCappedLaterals(workIdFll); string newLineWithId = fullLengthLiningWorkDetailsGateway.GetLineWithId(workIdFll); string newHydrantAddress = fullLengthLiningWorkDetailsGateway.GetHydrantAddress(workIdFll); string newHydroWireWithin10FtOfInversionMH = fullLengthLiningWorkDetailsGateway.GetHydroWiredWithin10FtOfInversionMH(workIdFll); string newDistanceToInversionMh = fullLengthLiningWorkDetailsGateway.GetDistanceToInversionMh(workIdFll); string newSurfaceGrade = fullLengthLiningWorkDetailsGateway.GetSurfaceGrade(workIdFll); bool newHydroPulley = fullLengthLiningWorkDetailsGateway.GetHydroPulley(workIdFll); bool newFridgeCart = fullLengthLiningWorkDetailsGateway.GetFridgeCart(workIdFll); bool newTwoPump = fullLengthLiningWorkDetailsGateway.GetTwoPump(workIdFll); bool newSixBypass = fullLengthLiningWorkDetailsGateway.GetSixBypass(workIdFll); bool newScaffolding = fullLengthLiningWorkDetailsGateway.GetScaffolding(workIdFll); bool newWinchExtension = fullLengthLiningWorkDetailsGateway.GetWinchExtension(workIdFll); bool newExtraGenerator = fullLengthLiningWorkDetailsGateway.GetExtraGenerator(workIdFll); bool newGreyCableExtension = fullLengthLiningWorkDetailsGateway.GetGreyCableExtension(workIdFll); bool newEasementMats = fullLengthLiningWorkDetailsGateway.GetEasementMats(workIdFll); bool newRampRequired = fullLengthLiningWorkDetailsGateway.GetRampRequired(workIdFll); bool newCameraSkid = fullLengthLiningWorkDetailsGateway.GetCameraSkid(workIdFll); // comments string newComments = fullLengthLiningWorkDetailsGateway.GetComments(workIdFll); // ... Update work UpdateFllWork(sectionAssetId, countryId, provinceId, countyId, cityId, workIdFll, originalClientIdFLL, originalProposedLiningDateFLL, originalDeadlineLiningDateFLL, originalP1Date, originalM1Date, originalM2Date, originalInstallDate, originalFinalVideoDateFLL, originalIssueIdentifiedFLL, originalIssueLFSFLL, originalIssueClientFLL, originalIssueSalesFLL, originalIssueGivenToClientFLL, originalIssueResolvedFLL, originalIssueInvestigationFLL, originalCxisRemoved, originalRoboticPrepCompleted, originalRoboticPrepCompletedDate, originalMeasurementTakenByFLL, originalTrafficControl, originalSiteDetails, originalPipeSizeChange, originalStandardBypass, originalStandardBypassComments, originalTrafficControlDetails, originalMeasurementType, originalMeasurementFromMh, originalVideoDoneFromMh, originalVideoDoneToMh, originalVideoLength, originalComments, false, companyId, originalMaterial, originalAccessType, originalP1Completed, newClientIdFLL, originalProposedLiningDateFLL, originalDeadlineLiningDateFLL, newP1Date, newM1Date, originalM2Date, originalInstallDate, originalFinalVideoDateFLL, originalIssueIdentifiedFLL, originalIssueLFSFLL, originalIssueClientFLL, originalIssueSalesFLL, originalIssueGivenToClientFLL, originalIssueResolvedFLL, originalIssueInvestigationFLL, newCxisRemoved, newRoboticPrepCompleted, newRoboticPrepCompletedDate, newMeasurementTakenByFLL, newMaterial, newTrafficControl, newSiteDetails, newPipeSizeChange, newStandardBypass, newStandardBypassComments, newTrafficControlDetails, newMeasurementType, newMeasurementFromMh, newVideoDoneFromMh, newVideoDoneToMh, newVideoLength, newComments, false, companyId, newAccessType, newP1Completed); } } if (workIdRa != 0) // ... Has Fll work { UpdateRaWork(workIdRa, originalPreFlushDate, originalPreVideoDate, newPreFlushDate, newPreVideoDate, companyId); } else { if (newPreFlushDate.HasValue || newPreVideoDate.HasValue) // Insert RA work { WorkRehabAssessment workRehabAssessment = new WorkRehabAssessment(null); workIdRa = workRehabAssessment.InsertDirect(projectId, sectionAssetId, null, newPreFlushDate, newPreVideoDate, false, companyId, "", ""); UpdateRaWork(workIdRa, originalPreFlushDate, originalPreVideoDate, newPreFlushDate, newPreVideoDate, companyId); } } // Update work WorkPointRepairs workPointRepairs = new WorkPointRepairs(null); workPointRepairs.UpdateDirect(sectionAssetId, workId, originalClientId, originalMeasurementTakenBy, originalRepairConfirmationDate, originalBypassRequired, originalRoboticDistances, originalProposedLiningDate, originalDeadlineLiningDate, originalFinalVideoDate, originalEstimatedJoints, originalJointsTestSealed, originalIssueIdentified, originalIssueLFS, originalIssueClient, originalIssueSales, originalIssueGivenToClient, originalIssueResolved, originalIssueInvestigation, "", false, companyId, workId, newClientId, newMeasurementTakenBy, newRepairConfirmationDate, newBypassRequired, newRoboticDistances, newProposedLiningDate, newDeadlineLiningDate, newFinalVideoDate, newEstimatedJoints, newJointsTestSealed, newIssueIdentified, newIssueLFS, newIssueClient, newIssueSales, newIssueGivenToClient, newIssueResolved, newIssueInvestigation, "", false, companyId); // Get original variables WorkGateway workGateway = new WorkGateway(); workGateway.LoadByWorkId(workId, companyId); string originalWorkType = workGateway.GetWorkTypeOriginal(workId); int? originalLibraryCategoriesId = workGateway.GetLibraryCategoriesIdOriginal(workId); string originalComment = workGateway.GetCommentsOriginal(workId); string originalHistory = workGateway.GetHistoryOriginal(workId); //Get new comment WorkCommentsGateway workCommentsGateway = new WorkCommentsGateway(); workCommentsGateway.LoadByAssetIdWorkTypeProjectId(sectionAssetId, companyId, "Point Repairs", projectId); WorkComments workComments = new WorkComments(workCommentsGateway.Data); string newComment = workComments.GetCommentsSummary(companyId, workCommentsGateway.Table.Rows.Count, "\n"); Work work = new Work(null); work.UpdateDirect(workId, projectId, sectionAssetId, originalWorkType, originalLibraryCategoriesId, false, companyId, originalComment, originalHistory, workId, projectId, sectionAssetId, originalWorkType, originalLibraryCategoriesId, false, companyId, newComment, originalHistory); } } }
/// <summary> /// UpdateRaWork /// </summary> /// <param name="workId">workId</param> /// <param name="originalPreFlushDate">originalPreFlushDate</param> /// <param name="originalPreVideoDate">originalPreVideoDate</param> /// <param name="newPreFlushDate">newPreFlushDate</param> /// <param name="newPreVideoDate">newPreVideoDate</param> /// <param name="companyId">companyId</param> private void UpdateRaWork(int workId, DateTime? originalPreFlushDate, DateTime? originalPreVideoDate, DateTime? newPreFlushDate, DateTime? newPreVideoDate, int companyId) { WorkRehabAssessment workRehabAssessment = new WorkRehabAssessment(null); workRehabAssessment.UpdateDirect(workId, originalPreFlushDate, originalPreVideoDate, false, companyId, workId, newPreFlushDate, newPreVideoDate, false, companyId); }
/// <summary> /// SaveRAWork /// </summary> /// <param name="projectId">projectId</param> /// <param name="section_assetId">section_assetId</param> /// <param name="companyId">companyId</param> /// <param name="subArea">subArea</param> /// <param name="comments">comments</param> /// <param name="loginId">loginId</param> private void SaveRAWork(DataMigrationTDS.DataMigrationRow row, int projectId, int section_assetId, int companyId, string comments, int loginId) { DateTime dateTime_ = DateTime.Now; string commentsToWork = ""; DateTime? preFlushDate = null; if (!row.IsPreFlushDateNull()) preFlushDate = row.PreFlushDate; DateTime? preVideoDate = null; if (!row.IsPreVideoDateNull()) preVideoDate = row.PreVideoDate; if (comments != "") { // ... Get user name LoginGateway loginGateway = new LoginGateway(); loginGateway.LoadByLoginId(loginId, companyId); string user = loginGateway.GetLastName(loginId, companyId) + " " + loginGateway.GetFirstName(loginId, companyId); // ... Form the comment string commentsToWork = commentsToWork + dateTime_ + "\n" + "(" + user.Trim() + ") \n Subject: Bulk Upload Comments \n Comment: " + comments; } WorkRehabAssessment workRehabAssessment = new WorkRehabAssessment(null); int workId = workRehabAssessment.InsertDirect(projectId, section_assetId, null, preFlushDate, preVideoDate, false, companyId, commentsToWork, ""); if (comments != "") { WorkCommentsGateway workCommentsGateway = new WorkCommentsGateway(); workCommentsGateway.LoadByWorkIdWorkType(workId, companyId, "Rehab Assessment"); WorkComments workComments = new WorkComments(workCommentsGateway.Data); workComments.Insert(workId, 0, "Rehab Assessment", "Bulk Upload Comments", loginId, DateTime.Now, comments, null, false, companyId, false, "Rehab Assessment"); // UpdateComments workCommentsGateway.Update(); } }