/// <summary> /// Delete /// </summary> /// <param name="workId">workId</param> /// <param name="companyId">companyId</param> public void Delete(int workId, int companyId) { 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) { workPointRepairsRepairGateway.Delete(workId, row.RepairPointID, companyId); } }
/// <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); }