/// <summary>
/// UpdateForReport
/// </summary>
public void UpdateForReport()
{
foreach (JltoBuildReportTDS.JLToBuildRow jlToBuildRow in ((JltoBuildReportTDS.JLToBuildDataTable)Table))
{
// Load work
WorkGateway workGateway = new WorkGateway();
workGateway.LoadByProjectIdAssetIdWorkType(jlToBuildRow.ProjectID, jlToBuildRow.AssetID, "Junction Lining Lateral", jlToBuildRow.COMPANY_ID);
int workId = workGateway.GetWorkId(jlToBuildRow.AssetID, "Junction Lining Lateral", jlToBuildRow.ProjectID);
// Load Laterals in work
WorkJunctionLiningLateralGateway workJunctionLiningLateralGateway = new WorkJunctionLiningLateralGateway();
workJunctionLiningLateralGateway.LoadByWorkId(workId, jlToBuildRow.COMPANY_ID);
// Load original data
DateTime? originalPipeLocated = workJunctionLiningLateralGateway.GetPipeLocated(workId);
int sectionWorkId = workJunctionLiningLateralGateway.GetSectionWorkID(workId);
DateTime? originalServicesLocated = workJunctionLiningLateralGateway.GetServicesLocated(workId);
DateTime? originalCoInstalled = workJunctionLiningLateralGateway.GetCoInstalled(workId);
DateTime? originalBackfilledConcrete = workJunctionLiningLateralGateway.GetBackfilledConcrete(workId);
DateTime? originalBackfilledSoil = workJunctionLiningLateralGateway.GetBackfilledSoil(workId);
DateTime? originalGrouted = workJunctionLiningLateralGateway.GetGrouted(workId);
DateTime? originalCored = workJunctionLiningLateralGateway.GetCored(workId);
DateTime? originalPrepped = workJunctionLiningLateralGateway.GetPrepped(workId);
DateTime? originalMeasured = workJunctionLiningLateralGateway.GetMeasured(workId);
string originalLinerSize = workJunctionLiningLateralGateway.GetLinerSize(workId);
DateTime? originalInProcess = workJunctionLiningLateralGateway.GetInProcess(workId);
DateTime? originalInStock = workJunctionLiningLateralGateway.GetInStock(workId);
DateTime? originalDelivered = workJunctionLiningLateralGateway.GetDelivered(workId);
int? originalBuildRebuild = workJunctionLiningLateralGateway.GetBuildRebuild(workId);
DateTime? originalPreVideo = workJunctionLiningLateralGateway.GetPreVideo(workId);
DateTime? originalLinerInstalled = workJunctionLiningLateralGateway.GetLinerInstalled(workId);
DateTime? originalFinalVideo = workJunctionLiningLateralGateway.GetFinalVideo(workId);
decimal? originalCost = workJunctionLiningLateralGateway.GetCost(workId);
DateTime? originalVideoInspection = workJunctionLiningLateralGateway.GetVideoInspection(workId);
bool originalCoRequired = workJunctionLiningLateralGateway.GetCoRequired(workId);
bool originalPitRequired = workJunctionLiningLateralGateway.GetPitRequired(workId);
string originalCoPitLocation = workJunctionLiningLateralGateway.GetCoPitLocation(workId);
bool originalPostContractDigRequired = workJunctionLiningLateralGateway.GetPostContractDigRequired(workId);
DateTime? originalCoCutDown = workJunctionLiningLateralGateway.GetCoCutDown(workId);
DateTime? originalFinalRestoration = workJunctionLiningLateralGateway.GetFinalRestoration(workId);
string originalVideoLengthToPropertyLine = workJunctionLiningLateralGateway.GetVideoLengthToPropertyLine(workId);
bool originalLiningThruCo = workJunctionLiningLateralGateway.GetLiningThruCo(workId);
DateTime? originalNoticeDelivered = workJunctionLiningLateralGateway.GetNoticeDelivered(workId);
string originalHamiltonInspectionNumber = workJunctionLiningLateralGateway.GetHamiltonInspectionNumber(workId);
string originalFlange = workJunctionLiningLateralGateway.GetFlange(workId);
string originalGasket = workJunctionLiningLateralGateway.GetGasket(workId);
string originalDepthOfLocated = workJunctionLiningLateralGateway.GetDepthOfLocated(workId);
bool originalDigRequiredPriorToLining = workJunctionLiningLateralGateway.GetDigRequiredPriorToLining(workId);
DateTime? originalDigRequiredPriorToLiningCompleted = workJunctionLiningLateralGateway.GetDigRequiredPriorToLiningCompleted(workId);
bool originalDigRequiredAfterLining = workJunctionLiningLateralGateway.GetDigRequiredAfterLining(workId);
DateTime? originalDigRequiredAfterLiningCompleted = workJunctionLiningLateralGateway.GetDigRequiredAfterLiningCompleted(workId);
bool originalOutOfScope = workJunctionLiningLateralGateway.GetOutOfScope(workId);
bool originalHoldClientIssue = workJunctionLiningLateralGateway.GetHoldClientIssue(workId);
DateTime? originalHoldClientIssueResolved = workJunctionLiningLateralGateway.GetHoldClientIssueResolved(workId);
bool originalHoldLFSIssue = workJunctionLiningLateralGateway.GetHoldLFSIssue(workId);
DateTime? originalHoldLFSIssueResolved = workJunctionLiningLateralGateway.GetHoldLFSIssueResolved(workId);
bool originalRequiresRoboticPrep = workJunctionLiningLateralGateway.GetLateralRequiresRoboticPrep(workId);
DateTime? originalRequiresRoboticPrepCompleted = workJunctionLiningLateralGateway.GetLateralRequiresRoboticPrepCompleted(workId);
string originalLinerType = workJunctionLiningLateralGateway.GetLinerType(workId);
string originalPrepType = workJunctionLiningLateralGateway.GetPrepType(workId);
bool originalDyeTestReq = workJunctionLiningLateralGateway.GetDyeTestReq(workId);
DateTime? originalDyeTestComplete = workJunctionLiningLateralGateway.GetDyeTestComplete(workId);
string originalContractYear = workJunctionLiningLateralGateway.GetContractYear(workId);
// New data
DateTime? newPipeLocated = originalPipeLocated;
DateTime? newServicesLocated = originalServicesLocated;
DateTime? newCoInstalled = originalCoInstalled;
DateTime? newBackfilledConcrete = originalBackfilledConcrete;
DateTime? newBackfilledSoil = originalBackfilledSoil;
DateTime? newGrouted = originalGrouted;
DateTime? newCored = originalCored;
DateTime? newPrepped = originalPrepped;
DateTime? newMeasured = originalMeasured;
string newLinerSize = originalLinerSize;
DateTime? newInProcess = DateTime.Now;
DateTime? newInStock = originalInStock;
DateTime? newDelivered = originalDelivered;
DateTime? newPreVideo = originalPreVideo;
DateTime? newLinerInstalled = originalLinerInstalled;
DateTime? newFinalVideo = originalFinalVideo;
decimal? newCost = originalCost;
DateTime? newVideoInspection = originalVideoInspection;
bool newCoRequired = originalCoRequired;
bool newPitRequired = originalPitRequired;
string newCoPitLocation = originalCoPitLocation;
bool newPostContractDigRequired = originalPostContractDigRequired;
DateTime? newCoCutDown = originalCoCutDown;
DateTime? newFinalRestoration = originalFinalRestoration;
int? newBuildRebuild = (int)originalBuildRebuild + 1;
string newVideoLengthToPropertyLine = originalVideoLengthToPropertyLine;
bool newLiningThruCo = originalLiningThruCo;
DateTime? newNoticeDelivered = originalNoticeDelivered;
string newHamiltonInspectionNumber = originalHamiltonInspectionNumber;
string newFlange = originalFlange;
string newGasket = originalGasket;
string newDepthOfLocated = originalDepthOfLocated;
bool newDigRequiredPriorToLining = originalDigRequiredPriorToLining;
DateTime? newDigRequiredPriorToLiningCompleted = originalDigRequiredPriorToLiningCompleted;
bool newDigRequiredAfterLining = originalDigRequiredAfterLining;
DateTime? newDigRequiredAfterLiningCompleted = originalDigRequiredAfterLiningCompleted;
bool newOutOfScope = originalOutOfScope;
bool newHoldClientIssue = originalHoldClientIssue;
DateTime? newHoldClientIssueResolved = originalHoldClientIssueResolved;
bool newHoldLFSIssue = originalHoldLFSIssue;
DateTime? newHoldLFSIssueResolved = originalHoldLFSIssueResolved;
bool newRequiresRoboticPrep = originalRequiresRoboticPrep;
DateTime? newRequiresRoboticPrepCompleted = originalRequiresRoboticPrepCompleted;
string newLinerType = originalLinerType;
string newPrepType = originalPrepType;
bool newDyeTestReq = originalDyeTestReq;
DateTime? newDyeTestComplete = originalDyeTestComplete;
string newContractYear = originalContractYear;
// Update Lateral
WorkJunctionLiningLateral workJunctionLiningLateral = new WorkJunctionLiningLateral(null);
workJunctionLiningLateral.UpdateDirect(workId, sectionWorkId, originalPipeLocated, originalServicesLocated, originalCoInstalled, originalBackfilledConcrete, originalBackfilledSoil, originalGrouted, originalCored, originalPrepped, originalMeasured, originalLinerSize, originalInProcess, originalInStock, originalDelivered, originalBuildRebuild, originalPreVideo, originalLinerInstalled, originalFinalVideo, originalCost, originalVideoInspection, originalCoRequired, originalPitRequired, originalCoPitLocation, originalPostContractDigRequired, originalCoCutDown, originalFinalRestoration, false, jlToBuildRow.COMPANY_ID, originalVideoLengthToPropertyLine, originalLiningThruCo, originalNoticeDelivered, originalHamiltonInspectionNumber, originalFlange, originalGasket, originalDepthOfLocated, originalDigRequiredPriorToLining, originalDigRequiredPriorToLiningCompleted, originalDigRequiredAfterLining, originalDigRequiredAfterLiningCompleted, originalOutOfScope, originalHoldClientIssue, originalHoldClientIssueResolved, originalHoldLFSIssue, originalHoldLFSIssueResolved, originalRequiresRoboticPrep, originalRequiresRoboticPrepCompleted, originalLinerType, originalPrepType, originalDyeTestReq, originalDyeTestComplete, newPipeLocated, newServicesLocated, newCoInstalled, newBackfilledConcrete, newBackfilledSoil, newGrouted, newCored, newPrepped, newMeasured, newLinerSize, newInProcess, newInStock, newDelivered, newBuildRebuild, newPreVideo, newLinerInstalled, newFinalVideo, newCost, newVideoInspection, newCoRequired, newPitRequired, newCoPitLocation, newPostContractDigRequired, newCoCutDown, newFinalRestoration, jlToBuildRow.COMPANY_ID, newVideoLengthToPropertyLine, newLiningThruCo, newNoticeDelivered, newHamiltonInspectionNumber, newFlange, newGasket, newDepthOfLocated, newDigRequiredPriorToLining, newDigRequiredPriorToLiningCompleted, newDigRequiredAfterLining, newDigRequiredAfterLiningCompleted, newOutOfScope, newHoldClientIssue, newHoldClientIssueResolved, newHoldLFSIssue, newHoldLFSIssueResolved, newRequiresRoboticPrep, newRequiresRoboticPrepCompleted, newLinerType, newPrepType, newDyeTestReq, newDyeTestComplete, originalContractYear, newContractYear);
}
}
/// <summary>
/// UpdateJLLaterals
/// </summary>
/// <param name="currentProjectId">currentProjectId</param>
/// <param name="lateral_assetId">lateral_assetId</param>
/// <param name="companyId">companyId</param>
/// <param name="clientInspectionNo">clientInspectionNo</param>
/// <param name="requiresRoboticPrep">requiresRoboticPrep</param>
/// <param name="requiresRoboticPrepDate">requiresRoboticPrepDate</param>
/// <param name="holdClientIssue">holdClientIssue</param>
/// <param name="holdLFSIssue">holdLFSIssue</param>
/// <param name="flange">flange</param>
/// <param name="dyeTestReq">dyeTestReq</param>
/// <param name="dyeTestComplete">dyeTestComplete</param>
private void UpdateJLLaterals(int currentProjectId, int lateral_assetId, int companyId, string clientInspectionNo, bool requiresRoboticPrep, DateTime? requiresRoboticPrepDate, bool holdClientIssue, bool holdLFSIssue, string flange, bool dyeTestReq, DateTime? dyeTestComplete, string contractYear)
{
// Load work id
WorkGateway workGateway = new WorkGateway();
workGateway.LoadByProjectIdAssetIdWorkType(currentProjectId, lateral_assetId, "Junction Lining Lateral", companyId);
if (workGateway.Table.Rows.Count > 0)
{
int workId = workGateway.GetWorkId(lateral_assetId, "Junction Lining Lateral", currentProjectId);
if (workId > 0)
{
WorkJunctionLiningLateralGateway workJunctionLiningLateralGateway = new WorkJunctionLiningLateralGateway();
workJunctionLiningLateralGateway.LoadByWorkId(workId, companyId);
// Load original data
int originalSectionWorkId = workJunctionLiningLateralGateway.GetSectionWorkID(workId);
DateTime? originalPipeLocated = workJunctionLiningLateralGateway.GetPipeLocated(workId);
DateTime? originalServicesLocated = workJunctionLiningLateralGateway.GetServicesLocated(workId);
DateTime? originalCoInstalled = workJunctionLiningLateralGateway.GetCoInstalled(workId);
DateTime? originalBackfilledConcrete = workJunctionLiningLateralGateway.GetBackfilledConcrete(workId);
DateTime? originalBackfilledSoil = workJunctionLiningLateralGateway.GetBackfilledSoil(workId);
DateTime? originalGrouted = workJunctionLiningLateralGateway.GetGrouted(workId);
DateTime? originalCored = workJunctionLiningLateralGateway.GetCored(workId);
DateTime? originalPrepped = workJunctionLiningLateralGateway.GetPrepped(workId);
DateTime? originalMeasured = workJunctionLiningLateralGateway.GetMeasured(workId);
string originalLinerSize = workJunctionLiningLateralGateway.GetLinerSize(workId);
DateTime? originalInProcess = workJunctionLiningLateralGateway.GetInProcess(workId);
DateTime? originalInStock = workJunctionLiningLateralGateway.GetInStock(workId);
DateTime? originalDelivered = workJunctionLiningLateralGateway.GetDelivered(workId);
int? originalBuildRebuild = workJunctionLiningLateralGateway.GetBuildRebuild(workId);
DateTime? originalPreVideo = workJunctionLiningLateralGateway.GetPreVideo(workId);
DateTime? originalLinerInstalled = workJunctionLiningLateralGateway.GetLinerInstalled(workId);
DateTime? originalFinalVideo = workJunctionLiningLateralGateway.GetFinalVideo(workId);
decimal? originalCost = workJunctionLiningLateralGateway.GetCost(workId);
DateTime? originalVideoInspection = workJunctionLiningLateralGateway.GetVideoInspection(workId);
bool originalCoRequired = workJunctionLiningLateralGateway.GetCoRequired(workId);
bool originalPitRequired = workJunctionLiningLateralGateway.GetPitRequired(workId);
string originalCoPitLocation = workJunctionLiningLateralGateway.GetCoPitLocation(workId);
bool originalPostContractDigRequired = workJunctionLiningLateralGateway.GetPostContractDigRequired(workId);
DateTime? originalCoCutDown = workJunctionLiningLateralGateway.GetCoCutDown(workId);
DateTime? originalFinalRestoration = workJunctionLiningLateralGateway.GetFinalRestoration(workId);
string originalVideoLengthToPropertyLine = workJunctionLiningLateralGateway.GetVideoLengthToPropertyLine(workId);
bool originalLiningThruCo = workJunctionLiningLateralGateway.GetLiningThruCo(workId);
DateTime? originalNoticeDelivered = workJunctionLiningLateralGateway.GetNoticeDelivered(workId);
string originalHamiltonInspectionNumber = workJunctionLiningLateralGateway.GetHamiltonInspectionNumber(workId);
string originalFlange = workJunctionLiningLateralGateway.GetFlange(workId);
string originalGasket = workJunctionLiningLateralGateway.GetGasket(workId);
string originalDepthOfLocated = workJunctionLiningLateralGateway.GetDepthOfLocated(workId);
bool originalDigRequiredPriorToLining = workJunctionLiningLateralGateway.GetDigRequiredPriorToLining(workId);
DateTime? originalDigRequiredPriorToLiningCompleted = workJunctionLiningLateralGateway.GetDigRequiredPriorToLiningCompleted(workId);
bool originalDigRequiredAfterLining = workJunctionLiningLateralGateway.GetDigRequiredAfterLining(workId);
DateTime? originalDigRequiredAfterLiningCompleted = workJunctionLiningLateralGateway.GetDigRequiredAfterLiningCompleted(workId);
bool originalOutOfScope = workJunctionLiningLateralGateway.GetOutOfScope(workId);
bool originalHoldClientIssue = workJunctionLiningLateralGateway.GetHoldClientIssue(workId);
DateTime? originalHoldClientIssueResolved = workJunctionLiningLateralGateway.GetHoldClientIssueResolved(workId);
bool originalHoldLFSIssue = workJunctionLiningLateralGateway.GetHoldLFSIssue(workId);
DateTime? originalHoldLFSIssueResolved = workJunctionLiningLateralGateway.GetHoldLFSIssueResolved(workId);
bool originalRequiresRoboticPrep = workJunctionLiningLateralGateway.GetLateralRequiresRoboticPrep(workId);
DateTime? originalRequiresRoboticPrepCompleted = workJunctionLiningLateralGateway.GetLateralRequiresRoboticPrepCompleted(workId);
string originalLinerType = workJunctionLiningLateralGateway.GetLinerType(workId);
string originalPrepType = workJunctionLiningLateralGateway.GetPrepType(workId);
bool originalDyeTestReq = workJunctionLiningLateralGateway.GetDyeTestReq(workId);
DateTime? originalDyeTestComplete = null; if (workJunctionLiningLateralGateway.GetDyeTestComplete(workId).HasValue) originalDyeTestComplete = workJunctionLiningLateralGateway.GetDyeTestComplete(workId);
string originalContractYear = workJunctionLiningLateralGateway.GetContractYear(workId);
// New data
string newClientInspectionNo = clientInspectionNo;
bool newRequiresRoboticPrep = requiresRoboticPrep;
DateTime? newRequiresRoboticPrepCompleted = null; if (requiresRoboticPrepDate.HasValue) newRequiresRoboticPrepCompleted = requiresRoboticPrepDate;
bool newHoldClientIssue = holdClientIssue;
bool newHoldLFSIssue = holdLFSIssue;
bool newDyeTetRepair = dyeTestReq;
DateTime? newDyeTestComplete = null; if (dyeTestComplete.HasValue) newDyeTestComplete = dyeTestComplete;
string newContractYear = contractYear;
// Update work
WorkJunctionLiningLateral workJunctionLiningLateral = new WorkJunctionLiningLateral(null);
workJunctionLiningLateral.UpdateDirect(workId, originalSectionWorkId, originalPipeLocated, originalServicesLocated, originalCoInstalled, originalBackfilledConcrete, originalBackfilledSoil, originalGrouted, originalCored, originalPrepped, originalMeasured, originalLinerSize, originalInProcess, originalInStock, originalDelivered, originalBuildRebuild, originalPreVideo, originalLinerInstalled, originalFinalVideo, originalCost, originalVideoInspection, originalCoRequired, originalPitRequired, originalCoPitLocation, originalPostContractDigRequired, originalCoCutDown, originalFinalRestoration, false, companyId, originalVideoLengthToPropertyLine, originalLiningThruCo, originalNoticeDelivered, originalHamiltonInspectionNumber, originalFlange, originalGasket, originalDepthOfLocated, originalDigRequiredPriorToLining, originalDigRequiredPriorToLiningCompleted, originalDigRequiredAfterLining, originalDigRequiredAfterLiningCompleted, originalOutOfScope, originalHoldClientIssue, originalHoldClientIssueResolved, originalHoldLFSIssue, originalHoldLFSIssueResolved, originalRequiresRoboticPrep, originalRequiresRoboticPrepCompleted, originalLinerType, originalPrepType, originalDyeTestReq, originalDyeTestComplete, originalPipeLocated, originalServicesLocated, originalCoInstalled, originalBackfilledConcrete, originalBackfilledSoil, originalGrouted, originalCored, originalPrepped, originalMeasured, originalLinerSize, originalInProcess, originalInStock, originalDelivered, originalBuildRebuild, originalPreVideo, originalLinerInstalled, originalFinalVideo, originalCost, originalVideoInspection, originalCoRequired, originalPitRequired, originalCoPitLocation, originalPostContractDigRequired, originalCoCutDown, originalFinalRestoration, companyId, originalVideoLengthToPropertyLine, originalLiningThruCo, originalNoticeDelivered, newClientInspectionNo, flange, originalGasket, originalDepthOfLocated, originalDigRequiredPriorToLining, originalDigRequiredPriorToLiningCompleted, originalDigRequiredAfterLining, originalDigRequiredAfterLiningCompleted, originalOutOfScope, newHoldClientIssue, originalHoldClientIssueResolved, newHoldLFSIssue, originalHoldLFSIssueResolved, newRequiresRoboticPrep, newRequiresRoboticPrepCompleted, originalLinerType, originalPrepType, newDyeTetRepair, newDyeTestComplete, originalContractYear, newContractYear);
}
}
}
