/// <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);
}