// ////////////////////////////////////////////////////////////////////////
// PRIVATE METHODS
//
/// <summary>
/// UpdateFllWork
/// </summary>
/// <param name="sectionAssetId">sectionAssetId</param>
/// <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="originalIssue">originalIssue</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="originalRoboticPrepDate">originalRoboticPrepDate</param>
/// <param name="originalVideoLength">originalVideoLength</param>
/// <param name="originalComments">originalComments</param>
/// <param name="originalDeleted">originalDeleted</param>
/// <param name="originalCompanyId">originalCompanyId</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="newIssue">newIssue</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="newVideoLength">newVideoLength</param>
/// <param name="newComments">newComments</param>
/// <param name="newDeleted">newDeleted</param>
/// <param name="newCompanyId">newCompanyId</param>
/// <param name="newAccessType">newAccessType</param>
/// <param name="newP1Completed">newP1Completed</param>
private void UpdateFllWork(int sectionAssetId, 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 originalVideoLength, string originalComments, bool originalDeleted, int originalCompanyId, string originalMaterials, 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 newVideoLength, string newComments, bool newDeleted, int newCompanyId, string newAccessType, bool newP1Completed)
{
if (newSiteDetails == "(Select a Site Detail)") newSiteDetails = "Not applicable";
// Update P1 fullLengthLining
WorkFullLengthLiningP1 workFullLengthLiningP1 = new WorkFullLengthLiningP1(null);
workFullLengthLiningP1.UpdateDirect(workId, originalCxisRemoved, originalRoboticPrepCompleted, originalRoboticPrepCompletedDate, originalDeleted, originalCompanyId, originalP1Completed, workId, newCxisRemoved, newRoboticPrepCompleted, newRoboticPrepCompletedDate, newDeleted, newCompanyId, newP1Completed);
// Update M1 fullLengthLining
WorkFullLengthLiningM1 workFullLengthLiningM1 = new WorkFullLengthLiningM1(null);
workFullLengthLiningM1.UpdateDirect(workId, originalMeasurementFromMh, originalTrafficControl, originalSiteDetails, originalPipeSizeChange, originalStandardBypass, originalStandardBypassComments, originalTrafficControlDetails, originalMeasurementType, originalMeasurementFromMh, originalVideoDoneFromMh, originalVideoDoneToMh, originalDeleted, originalCompanyId, originalAccessType, workId, newMeasurementTakenBy, newTrafficControl, newSiteDetails, newPipeSizeChange, newStandardBypass, newStandardBypassComments, newTrafficControlDetails, newMeasurementType, newMeasurementFromMh, newVideoDoneFromMh, newVideoDoneToMh, newDeleted, newCompanyId, newAccessType);
// Update M2 fullLengthLining (VideoLength)
WorkFullLengthLiningM2 workFullLengthLiningM2 = new WorkFullLengthLiningM2(null);
workFullLengthLiningM2.UpdateVideoLengthDirect(sectionAssetId, workId, originalVideoLength, originalDeleted, originalCompanyId, workId, newVideoLength, newDeleted, newCompanyId);
// Update fullLengthLining
WorkFullLengthLiningGateway workFullLengthLiningGateway = new WorkFullLengthLiningGateway(null);
workFullLengthLiningGateway.Update(workId, originalClientId, originalProposedLiningDate, originalDeadlineLiningDate, originalP1Date, originalM1Date, originalM2Date, originalInstallDate, originalFinalVideoDate, originalIssueIdentified, originalIssueLFS, originalIssueClient, originalIssueSales, originalIssueGivenToClient, originalIssueResolved, originalDeleted, originalCompanyId, originalIssueInvestigation, workId, newClientId, newProposedLiningDate, newDeadlineLiningDate, newP1Date, newM1Date, newM2Date, newInstallDate, newFinalVideoDate, newIssueIdentified, newIssueLFS, newIssueClient, newIssueSales, newIssueGivenToClient, newIssueResolved, newIssueInvestigation, newDeleted, newCompanyId);
}
/// <summary>
/// UpdateDirect
/// </summary>
/// <param name="sectionAssetId">sectionAssetId</param>
/// <param name="originalWorkId">originalWorkId</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="originalFinalVideo">originalFinalVideo</param>
/// <param name="originalIssueIdentified">originalIssueIdentified</param>
/// <param name="originalLfsIssue">originalLfsIssue</param>
/// <param name="originalClientIssue">originalClientIssue</param>
/// <param name="originalSalesIssue">originalSalesIssue</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="originalMeasurementsTakenBy">originalMeasurementsTakenBy</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="originalLineWidthId">originalLineWidthId</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="originalRampsRequired">originalRampsRequired</param>
/// <param name="originalVideoLength">originalVideoLength</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="newWorkId">newWorkId</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="newFinalVideo">newFinalVideo</param>
/// <param name="newIssueIdentified">newIssueIdentified</param>
/// <param name="newLfsIssue">newLfsIssue</param>
/// <param name="newClientIssue">newClientIssue</param>
/// <param name="newSalesIssue">newSalesIssue</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="newMeasurementsTakenBy">newMeasurementsTakenBy</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="newLineWidthId">newLineWidthId</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="newRampsRequired">newRampsRequired</param>
/// <param name="newVideoLength">newVideoLength</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>
public void UpdateDirect(int sectionAssetId, int originalWorkId, string originalClientId, DateTime? originalProposedLiningDate, DateTime? originalDeadlineLiningDate, DateTime? originalP1Date, DateTime? originalM1Date, DateTime? originalM2Date, DateTime? originalInstallDate, DateTime? originalFinalVideo, bool originalIssueIdentified, bool originalLfsIssue, bool originalClientIssue, bool originalSalesIssue, bool originalIssueGivenToClient, bool originalIssueResolved, bool originalIssueInvestigation, int? originalCxisRemoved, bool originalRoboticPrepCompleted, DateTime? originalRoboticPrepCompletedDate, string originalMeasurementsTakenBy, 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 originalLineWidthId, 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 originalRampsRequired, string originalVideoLength, bool originalDeleted, int originalCompanyId, bool originalCameraSkid, string originalAccessType, bool originalP1Completed, int newWorkId, string newClientId, DateTime? newProposedLiningDate, DateTime? newDeadlineLiningDate, DateTime? newP1Date, DateTime? newM1Date, DateTime? newM2Date, DateTime? newInstallDate, DateTime? newFinalVideo, bool newIssueIdentified, bool newLfsIssue, bool newClientIssue, bool newSalesIssue, bool newIssueGivenToClient, bool newIssueResolved, bool newIssueInvestigation, int? newCxisRemoved, bool newRoboticPrepCompleted, DateTime? newRoboticPrepCompletedDate, string newMeasurementsTakenBy, 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 newDistanceToInversionMh, string newLineWidthId, string newHydrantAddress, string newHydroWireWithin10FtOfInversionMH, string newSurfaceGrade, bool newHydroPulley, bool newFridgeCart, bool newTwoPump, bool newSixBypass, bool newScaffolding, bool newWinchExtension, bool newExtraGenerator, bool newGreyCableExtension, bool newEasementMats, bool newRampsRequired, string newVideoLength, bool newDeleted, int newCompanyId, bool newCameraSkid, string newAccessType, bool newP1Completed)
{
// Update P1 fullLengthLining
WorkFullLengthLiningP1 workFullLengthLiningP1 = new WorkFullLengthLiningP1(null);
workFullLengthLiningP1.UpdateDirect(originalWorkId, originalCxisRemoved, originalRoboticPrepCompleted, originalRoboticPrepCompletedDate, originalDeleted, originalCompanyId, originalP1Completed, newWorkId, newCxisRemoved, newRoboticPrepCompleted, newRoboticPrepCompletedDate, newDeleted, newCompanyId, newP1Completed);
// Update M1 fullLengthLining
WorkFullLengthLiningM1 workFullLengthLiningM1 = new WorkFullLengthLiningM1(null);
workFullLengthLiningM1.UpdateDirect(originalWorkId, originalMeasurementsTakenBy, originalTrafficControl, originalSiteDetails, originalPipeSizeChange, originalStandardByPass, originalStandardBypassComments, originalTrafficControlDetails, originalMeasurementType, originalMeasurementFromMh, originalVideoDoneFromMh, originalVideoDoneToMh, originalDeleted, originalCompanyId, originalAccessType, newWorkId, newMeasurementsTakenBy, newTrafficControl, newSiteDetails, newPipeSizeChange, newStandardByPass, newStandardBypassComments, newTrafficControlDetails, newMeasurementType, newMeasurementFromMh, newVideoDoneFromMh, newVideoDoneToMh, newDeleted, newCompanyId, newAccessType);
// Update M2 fullLengthLining
WorkFullLengthLiningM2 workFullLengthLiningM2 = new WorkFullLengthLiningM2(null);
workFullLengthLiningM2.UpdateDirect(sectionAssetId, originalWorkId, originalVideoLength, originalMeasurementTakenByM2, originalDropPipe, originalDropPipeInvertDepth, originalCappedLaterals, originalLineWidthId, originalHydrantAddress, originalHydroWireWithin10FtOfInversionMH, originalDistanceToInversionMh, originalSurfaceGrade, originalHydroPulley, originalFridgeCart, originalTwoPump, originalSixBypass, originalScaffolding, originalWinchExtension, originalExtraGenerator, originalGreyCableExtension, originalEasementMats, originalRampsRequired, originalDeleted, originalCompanyId, originalCameraSkid, newWorkId, newVideoLength, newMeasurementTakenByM2, newDropPipe, newDropPipeInvertDepth, newCappedLaterals, newLineWidthId, newHydrantAddress, newHydroWireWithin10FtOfInversionMH, newDistanceToInversionMh, newSurfaceGrade, newHydroPulley, newFridgeCart, newTwoPump, newSixBypass, newScaffolding, newWinchExtension, newExtraGenerator, newGreyCableExtension, newEasementMats, newRampsRequired, newDeleted, newCompanyId, newCameraSkid);
// Update fullLengthLining
WorkFullLengthLiningGateway workFullLengthLiningGateway = new WorkFullLengthLiningGateway(null);
workFullLengthLiningGateway.Update(originalWorkId, originalClientId, originalProposedLiningDate, originalDeadlineLiningDate, originalP1Date, originalM1Date, originalM2Date, originalInstallDate, originalFinalVideo, originalIssueIdentified, originalLfsIssue, originalClientIssue, originalSalesIssue, originalIssueGivenToClient, originalIssueResolved, originalDeleted, originalCompanyId, originalIssueInvestigation, newWorkId, newClientId, newProposedLiningDate, newDeadlineLiningDate, newP1Date, newM1Date, newM2Date, newInstallDate, newFinalVideo, newIssueIdentified, newLfsIssue, newClientIssue, newSalesIssue, newIssueGivenToClient, newIssueResolved, newIssueInvestigation, newDeleted, newCompanyId);
}