/// //////////////////////////////////////////////////////////////////////// /// METHODS /// // // PostPageChanges // private void PostPageChanges() { //--- Post lfs master area changes TDSLFSRecord.LFS_MASTER_AREARow lfsMasterAreaRow = tdsLfsRecord.LFS_MASTER_AREA.FindByIDCOMPANY_ID(new Guid(tbxID.Text), Convert.ToInt32(Session["companyID"])); if (tbxClientID.Text.Trim() != "") lfsMasterAreaRow.ClientID = tbxClientID.Text.Trim(); else lfsMasterAreaRow.SetClientIDNull(); if (tbxSubArea.Text.Trim() != "") lfsMasterAreaRow.SubArea = tbxSubArea.Text.Trim(); else lfsMasterAreaRow.SetSubAreaNull(); if (tbxStreet.Text.Trim() != "") lfsMasterAreaRow.Street = tbxStreet.Text.Trim(); else lfsMasterAreaRow.SetStreetNull(); if (tbxUSMH.Text.Trim() != "") lfsMasterAreaRow.USMH = tbxUSMH.Text.Trim(); else lfsMasterAreaRow.SetUSMHNull(); if (tbxDSMH.Text.Trim() != "") lfsMasterAreaRow.DSMH = tbxDSMH.Text.Trim(); else lfsMasterAreaRow.SetDSMHNull(); if (tbxSize_.Text.Trim() != "") lfsMasterAreaRow.Size_ = tbxSize_.Text.Trim(); else lfsMasterAreaRow.SetSize_Null(); if (tbxScaledLength.Text.Trim() != "") lfsMasterAreaRow.ScaledLength = tbxScaledLength.Text.Trim(); else lfsMasterAreaRow.SetScaledLengthNull(); if (tbxP1Date.Text.Trim() != "") lfsMasterAreaRow.P1Date = DateTime.Parse(tbxP1Date.Text.Trim()); else lfsMasterAreaRow.SetP1DateNull(); //--- update DistanceFromDSMH foreach (TDSLFSRecord.LFS_JUNCTION_LINER2Row lfsJunctionLiner2Row in tdsLfsRecord.LFS_JUNCTION_LINER2) { if (!lfsJunctionLiner2Row.IsDistanceFromUSMHNull() && lfsJunctionLiner2Row.DistanceFromUSMH >= 0) { Distance length = new Distance(tbxActualLength.Text.Trim()) - new Distance(lfsJunctionLiner2Row.DistanceFromUSMH.ToString()); lfsJunctionLiner2Row.DistanceFromDSMH = length.ToDoubleInEng3(); } } if (tbxActualLength.Text.Trim() != "") lfsMasterAreaRow.ActualLength = tbxActualLength.Text.Trim(); else lfsMasterAreaRow.SetActualLengthNull(); if (tbxLiveLats.Text.Trim() != "") lfsMasterAreaRow.LiveLats = Double.Parse(tbxLiveLats.Text.Trim()); else lfsMasterAreaRow.SetLiveLatsNull(); if (tbxCXIsRemoved.Text.Trim() != "") lfsMasterAreaRow.CXIsRemoved = tbxCXIsRemoved.Text.Trim(); else lfsMasterAreaRow.SetCXIsRemovedNull(); if (tbxM1Date.Text.Trim() != "") lfsMasterAreaRow.M1Date = DateTime.Parse(tbxM1Date.Text.Trim()); else lfsMasterAreaRow.SetM1DateNull(); if (tbxM2Date.Text.Trim() != "") lfsMasterAreaRow.M2Date = DateTime.Parse(tbxM2Date.Text.Trim()); else lfsMasterAreaRow.SetM2DateNull(); if (tbxInstallDate.Text.Trim() != "") lfsMasterAreaRow.InstallDate = DateTime.Parse(tbxInstallDate.Text.Trim()); else lfsMasterAreaRow.SetInstallDateNull(); if (tbxFinalVideo.Text.Trim() != "") lfsMasterAreaRow.FinalVideo = DateTime.Parse(tbxFinalVideo.Text.Trim()); else lfsMasterAreaRow.SetFinalVideoNull(); if (tbxComments.Text.Trim() != "") lfsMasterAreaRow.Comments = tbxComments.Text.Trim(); else lfsMasterAreaRow.SetCommentsNull(); lfsMasterAreaRow.IssueIdentified = cbxIssueIdentified.Checked; lfsMasterAreaRow.IssueResolved = cbxIssueResolved.Checked; lfsMasterAreaRow.FullLengthLining = cbxFullLengthLining.Checked; lfsMasterAreaRow.SubcontractorLining = cbxSubcontractorLining.Checked; lfsMasterAreaRow.OutOfScopeInArea = cbxOutOfScopeInArea.Checked; lfsMasterAreaRow.IssueGivenToBayCity = cbxIssueGivenToBayCity.Checked; if (tbxConfirmedSize.Text.Trim() != "") lfsMasterAreaRow.ConfirmedSize = Int32.Parse(tbxConfirmedSize.Text.Trim()); else lfsMasterAreaRow.SetConfirmedSizeNull(); if (tbxInstallRate.Text.Trim() != "") lfsMasterAreaRow.InstallRate = Decimal.Parse(tbxInstallRate.Text.Trim()); else lfsMasterAreaRow.SetInstallRateNull(); if (tbxDeadlineDate.Text.Trim() != "") lfsMasterAreaRow.DeadlineDate = DateTime.Parse(tbxDeadlineDate.Text.Trim()); else lfsMasterAreaRow.SetDeadlineDateNull(); if (tbxProposedLiningDate.Text.Trim() != "") lfsMasterAreaRow.ProposedLiningDate = DateTime.Parse(tbxProposedLiningDate.Text.Trim()); else lfsMasterAreaRow.SetProposedLiningDateNull(); lfsMasterAreaRow.SalesIssue = cbxSalesIssue.Checked; lfsMasterAreaRow.LFSIssue = cbxLFSIssue.Checked; lfsMasterAreaRow.ClientIssue = cbxClientIssue.Checked; if (tbxActualLength.Text.Trim() != "") lfsMasterAreaRow.SteelTapeThruPipe = tbxActualLength.Text.Trim(); else lfsMasterAreaRow.SetSteelTapeThruPipeNull(); // SYNCHRONIZED //--- update ScaledLength1 Distance doubleDistance = new Distance(tbxScaledLength.Text.Trim()); if (tbxScaledLength.Text.Trim() != "") lfsMasterAreaRow.ScaledLength1 = doubleDistance.ToFeetDouble(); else lfsMasterAreaRow.SetScaledLength1Null(); //--- Update m2 tables' reverse setup foreach (TDSLFSRecord.LFS_M2_TABLESRow lfsM2TablesRow in tdsLfsRecord.LFS_M2_TABLES) { if (!lfsM2TablesRow.IsDistanceToCentreOfLateralNull()) { lfsM2TablesRow.ReverseSetup = Distance.Subtract(lfsMasterAreaRow.IsActualLengthNull() ? "" : lfsMasterAreaRow.ActualLength, lfsM2TablesRow.DistanceToCentreOfLateral); } } //--- Store dataset lfs record Session["tdsLfsRecord"] = tdsLfsRecord; }
private void PostPageChanges() { // [COMMENTED ROWS BELOW INTENDED FOR MAINTANANCE - DO NOT DELETE] // Post lfs master area changes TDSLFSRecord.LFS_MASTER_AREARow lfsMasterAreaRow = tdsLfsRecord.LFS_MASTER_AREA.FindByIDCOMPANY_ID(new Guid(tbxID.Text), Convert.ToInt32(Session["companyID"])); if (tbxClientID.Text.Trim() != "") lfsMasterAreaRow.ClientID = tbxClientID.Text.Trim(); else lfsMasterAreaRow.SetClientIDNull(); if (tbxSubArea.Text.Trim() != "") lfsMasterAreaRow.SubArea = tbxSubArea.Text.Trim(); else lfsMasterAreaRow.SetSubAreaNull(); if (tbxStreet.Text.Trim() != "") lfsMasterAreaRow.Street = tbxStreet.Text.Trim(); else lfsMasterAreaRow.SetStreetNull(); if (tbxUSMH.Text.Trim() != "") lfsMasterAreaRow.USMH = tbxUSMH.Text.Trim(); else lfsMasterAreaRow.SetUSMHNull(); if (tbxDSMH.Text.Trim() != "") lfsMasterAreaRow.DSMH = tbxDSMH.Text.Trim(); else lfsMasterAreaRow.SetDSMHNull(); if (tbxSize_.Text.Trim() != "") lfsMasterAreaRow.Size_ = tbxSize_.Text.Trim(); else lfsMasterAreaRow.SetSize_Null(); if (tbxScaledLength.Text.Trim() != "") lfsMasterAreaRow.ScaledLength = tbxScaledLength.Text.Trim(); else lfsMasterAreaRow.SetScaledLengthNull(); if (tbxP1Date.Text.Trim() != "") lfsMasterAreaRow.P1Date = DateTime.Parse(tbxP1Date.Text.Trim()); else lfsMasterAreaRow.SetP1DateNull(); // update DistanceFromDSMH foreach (TDSLFSRecord.LFS_JUNCTION_LINER2Row lfsJunctionLiner2Row in tdsLfsRecord.LFS_JUNCTION_LINER2) { if (!lfsJunctionLiner2Row.IsDistanceFromUSMHNull() && lfsJunctionLiner2Row.DistanceFromUSMH >= 0) { Distance length = new Distance(tbxActualLength.Text.Trim()) - new Distance(lfsJunctionLiner2Row.DistanceFromUSMH.ToString()); lfsJunctionLiner2Row.DistanceFromDSMH = length.ToDoubleInEng3(); } } if (tbxActualLength.Text.Trim() != "") lfsMasterAreaRow.ActualLength = tbxActualLength.Text.Trim(); else lfsMasterAreaRow.SetActualLengthNull(); if (tbxLiveLats.Text.Trim() != "") lfsMasterAreaRow.LiveLats = Double.Parse(tbxLiveLats.Text.Trim()); else lfsMasterAreaRow.SetLiveLatsNull(); if (tbxCXIsRemoved.Text.Trim() != "") lfsMasterAreaRow.CXIsRemoved = tbxCXIsRemoved.Text.Trim(); else lfsMasterAreaRow.SetCXIsRemovedNull(); if (tbxM1Date.Text.Trim() != "") lfsMasterAreaRow.M1Date = DateTime.Parse(tbxM1Date.Text.Trim()); else lfsMasterAreaRow.SetM1DateNull(); if (tbxM2Date.Text.Trim() != "") lfsMasterAreaRow.M2Date = DateTime.Parse(tbxM2Date.Text.Trim()); else lfsMasterAreaRow.SetM2DateNull(); if (tbxInstallDate.Text.Trim() != "") lfsMasterAreaRow.InstallDate = DateTime.Parse(tbxInstallDate.Text.Trim()); else lfsMasterAreaRow.SetInstallDateNull(); if (tbxFinalVideo.Text.Trim() != "") lfsMasterAreaRow.FinalVideo = DateTime.Parse(tbxFinalVideo.Text.Trim()); else lfsMasterAreaRow.SetFinalVideoNull(); if (tbxComments.Text.Trim() != "") lfsMasterAreaRow.Comments = tbxComments.Text.Trim(); else lfsMasterAreaRow.SetCommentsNull(); lfsMasterAreaRow.IssueIdentified = cbxIssueIdentified.Checked; lfsMasterAreaRow.IssueResolved = cbxIssueResolved.Checked; lfsMasterAreaRow.FullLengthLining = cbxFullLengthLining.Checked; lfsMasterAreaRow.SubcontractorLining = cbxSubcontractorLining.Checked; lfsMasterAreaRow.OutOfScopeInArea = cbxOutOfScopeInArea.Checked; lfsMasterAreaRow.IssueGivenToBayCity = cbxIssueGivenToBayCity.Checked; if (tbxConfirmedSize.Text.Trim() != "") lfsMasterAreaRow.ConfirmedSize = Int32.Parse(tbxConfirmedSize.Text.Trim()); else lfsMasterAreaRow.SetConfirmedSizeNull(); if (tbxInstallRate.Text.Trim() != "") lfsMasterAreaRow.InstallRate = Decimal.Parse(tbxInstallRate.Text.Trim()); else lfsMasterAreaRow.SetInstallRateNull(); if (tbxDeadlineDate.Text.Trim() != "") lfsMasterAreaRow.DeadlineDate = DateTime.Parse(tbxDeadlineDate.Text.Trim()); else lfsMasterAreaRow.SetDeadlineDateNull(); if (tbxProposedLiningDate.Text.Trim() != "") lfsMasterAreaRow.ProposedLiningDate = DateTime.Parse(tbxProposedLiningDate.Text.Trim()); else lfsMasterAreaRow.SetProposedLiningDateNull(); lfsMasterAreaRow.SalesIssue = cbxSalesIssue.Checked; lfsMasterAreaRow.LFSIssue = cbxLFSIssue.Checked; lfsMasterAreaRow.ClientIssue = cbxClientIssue.Checked; lfsMasterAreaRow.InvestigationIssue = cbxInvestigationIssue.Checked; lfsMasterAreaRow.PointLining = cbxPointLining.Checked; lfsMasterAreaRow.Grouting = cbxGrouting.Checked; lfsMasterAreaRow.LateralLining = cbxLateralLining.Checked; //if (tbxVacExDate.Text.Trim() != "") lfsMasterAreaRow.VacExDate = DateTime.Parse(tbxVacExDate.Text.Trim()); else lfsMasterAreaRow.SetVacExDateNull(); //if (tbxPusherDate.Text.Trim() != "") lfsMasterAreaRow.PusherDate = DateTime.Parse(tbxPusherDate.Text.Trim()); else lfsMasterAreaRow.SetPusherDateNull(); //if (tbxLinerOrdered.Text.Trim() != "") lfsMasterAreaRow.LinerOrdered = DateTime.Parse(tbxLinerOrdered.Text.Trim()); else lfsMasterAreaRow.SetLinerOrderedNull(); //if (tbxRestoration.Text.Trim() != "") lfsMasterAreaRow.Restoration = DateTime.Parse(tbxRestoration.Text.Trim()); else lfsMasterAreaRow.SetRestorationNull(); //if (tbxGroutDate.Text.Trim() != "") lfsMasterAreaRow.GroutDate = DateTime.Parse(tbxGroutDate.Text.Trim()); else lfsMasterAreaRow.SetGroutDateNull(); lfsMasterAreaRow.JLiner = cbxJLiner.Checked; lfsMasterAreaRow.RehabAssessment = cbxRehabAssessment.Checked; if (tbxEstimatedJoints.Text.Trim() != "") lfsMasterAreaRow.EstimatedJoints = Int32.Parse(tbxEstimatedJoints.Text.Trim()); else lfsMasterAreaRow.SetEstimatedJointsNull(); //if (tbxJointsTestSealed.Text.Trim() != "") lfsMasterAreaRow.JointsTestSealed = Int32.Parse(tbxJointsTestSealed.Text.Trim()); else lfsMasterAreaRow.SetJointsTestSealedNull(); if (tbxPreFlushDate.Text.Trim() != "") lfsMasterAreaRow.PreFlushDate = DateTime.Parse(tbxPreFlushDate.Text.Trim()); else lfsMasterAreaRow.SetPreFlushDateNull(); if (tbxPreVideoDate.Text.Trim() != "") lfsMasterAreaRow.PreVideoDate = DateTime.Parse(tbxPreVideoDate.Text.Trim()); else lfsMasterAreaRow.SetPreVideoDateNull(); //if (tbxUSMHMN.Text.Trim() != "") lfsMasterAreaRow.USMHMN = tbxUSMHMN.Text.Trim(); else lfsMasterAreaRow.SetUSMHMNNull(); //if (tbxDSMHMN.Text.Trim() != "") lfsMasterAreaRow.DSMHMN = tbxDSMHMN.Text.Trim(); else lfsMasterAreaRow.SetDSMHMNNull(); //if (tbxUSMHDepth.Text.Trim() != "") lfsMasterAreaRow.USMHDepth = tbxUSMHDepth.Text.Trim(); else lfsMasterAreaRow.SetUSMHDepthNull(); //if (tbxDSMHDepth.Text.Trim() != "") lfsMasterAreaRow.DSMHDepth = tbxDSMHDepth.Text.Trim(); else lfsMasterAreaRow.SetDSMHDepthNull(); //if (tbxMeasurementsTakenBy.Text.Trim() != "") lfsMasterAreaRow.MeasurementsTakenBy = tbxMeasurementsTakenBy.Text.Trim(); else lfsMasterAreaRow.SetMeasurementsTakenByNull(); if (tbxActualLength.Text.Trim() != "") lfsMasterAreaRow.SteelTapeThruPipe = tbxActualLength.Text.Trim(); else lfsMasterAreaRow.SetSteelTapeThruPipeNull(); // SYNCHRONIZED //if (tbxUSMHAtMouth1200.Text.Trim() != "") lfsMasterAreaRow.USMHAtMouth1200 = Double.Parse(tbxUSMHAtMouth1200.Text.Trim()); else lfsMasterAreaRow.SetUSMHAtMouth1200Null(); //if (tbxUSMHAtMouth100.Text.Trim() != "") lfsMasterAreaRow.USMHAtMouth100 = Double.Parse(tbxUSMHAtMouth100.Text.Trim()); else lfsMasterAreaRow.SetUSMHAtMouth100Null(); //if (tbxUSMHAtMouth200.Text.Trim() != "") lfsMasterAreaRow.USMHAtMouth200 = Double.Parse(tbxUSMHAtMouth200.Text.Trim()); else lfsMasterAreaRow.SetUSMHAtMouth200Null(); //if (tbxUSMHAtMouth300.Text.Trim() != "") lfsMasterAreaRow.USMHAtMouth300 = Double.Parse(tbxUSMHAtMouth300.Text.Trim()); else lfsMasterAreaRow.SetUSMHAtMouth300Null(); //if (tbxUSMHAtMouth400.Text.Trim() != "") lfsMasterAreaRow.USMHAtMouth400 = Double.Parse(tbxUSMHAtMouth400.Text.Trim()); else lfsMasterAreaRow.SetUSMHAtMouth400Null(); //if (tbxUSMHAtMouth500.Text.Trim() != "") lfsMasterAreaRow.USMHAtMouth500 = Double.Parse(tbxUSMHAtMouth500.Text.Trim()); else lfsMasterAreaRow.SetUSMHAtMouth500Null(); //if (tbxDSMHAtMouth1200.Text.Trim() != "") lfsMasterAreaRow.DSMHAtMouth1200 = Double.Parse(tbxDSMHAtMouth1200.Text.Trim()); else lfsMasterAreaRow.SetDSMHAtMouth1200Null(); //if (tbxDSMHAtMouth100.Text.Trim() != "") lfsMasterAreaRow.DSMHAtMouth100 = Double.Parse(tbxDSMHAtMouth100.Text.Trim()); else lfsMasterAreaRow.SetDSMHAtMouth100Null(); //if (tbxDSMHAtMouth200.Text.Trim() != "") lfsMasterAreaRow.DSMHAtMouth200 = Double.Parse(tbxDSMHAtMouth200.Text.Trim()); else lfsMasterAreaRow.SetDSMHAtMouth200Null(); //if (tbxDSMHAtMouth300.Text.Trim() != "") lfsMasterAreaRow.DSMHAtMouth300 = Double.Parse(tbxDSMHAtMouth300.Text.Trim()); else lfsMasterAreaRow.SetDSMHAtMouth300Null(); //if (tbxDSMHAtMouth400.Text.Trim() != "") lfsMasterAreaRow.DSMHAtMouth400 = Double.Parse(tbxDSMHAtMouth400.Text.Trim()); else lfsMasterAreaRow.SetDSMHAtMouth400Null(); //if (tbxDSMHAtMouth500.Text.Trim() != "") lfsMasterAreaRow.DSMHAtMouth500 = Double.Parse(tbxDSMHAtMouth500.Text.Trim()); else lfsMasterAreaRow.SetDSMHAtMouth500Null(); //if (tbxHydrantAddress.Text.Trim() != "") lfsMasterAreaRow.HydrantAddress = tbxHydrantAddress.Text.Trim(); else lfsMasterAreaRow.SetHydrantAddressNull(); //if (tbxDistanceToInversionMH.Text.Trim() != "") lfsMasterAreaRow.DistanceToInversionMH = tbxDistanceToInversionMH.Text.Trim(); else lfsMasterAreaRow.SetDistanceToInversionMHNull(); //lfsMasterAreaRow.RampsRequired = cbxRampsRequired.Checked; //if (ddlDegreeOfTrafficControl.SelectedValue != "") lfsMasterAreaRow.DegreeOfTrafficControl = ddlDegreeOfTrafficControl.SelectedValue; else lfsMasterAreaRow.SetDegreeOfTrafficControlNull(); // LOOKUP //lfsMasterAreaRow.StandarBypass = cbxStandarBypass.Checked; //if (tbxHydroWireDetails.Text.Trim() != "") lfsMasterAreaRow.HydroWireDetails = tbxHydroWireDetails.Text.Trim(); else lfsMasterAreaRow.SetHydroWireDetailsNull(); //if (tbxPipeMaterialType.Text.Trim() != "") lfsMasterAreaRow.PipeMaterialType = tbxPipeMaterialType.Text.Trim(); else lfsMasterAreaRow.SetPipeMaterialTypeNull(); //if (tbxCappedLaterals.Text.Trim() != "") lfsMasterAreaRow.CappedLaterals = Int32.Parse(tbxCappedLaterals.Text.Trim()); else lfsMasterAreaRow.SetCappedLateralsNull(); //lfsMasterAreaRow.RoboticPrepRequired = cbxRoboticPrepRequired.Checked; //lfsMasterAreaRow.PipeSizeChange = cbxPipeSizeChange.Checked; //if (tbxM1Comments.Text.Trim() != "") lfsMasterAreaRow.M1Comments = tbxM1Comments.Text.Trim(); else lfsMasterAreaRow.SetM1CommentsNull(); //if (tbxVideoDoneFrom.Text.Trim() != "") lfsMasterAreaRow.VideoDoneFrom = tbxVideoDoneFrom.Text.Trim(); else lfsMasterAreaRow.SetVideoDoneFromNull(); //if (tbxToManhole.Text.Trim() != "") lfsMasterAreaRow.ToManhole = tbxToManhole.Text.Trim(); else lfsMasterAreaRow.SetToManholeNull(); //if (tbxCutterDescriptionDuringMeasuring.Text.Trim() != "") lfsMasterAreaRow.CutterDescriptionDuringMeasuring = tbxCutterDescriptionDuringMeasuring.Text.Trim(); else lfsMasterAreaRow.SetCutterDescriptionDuringMeasuringNull(); lfsMasterAreaRow.FullLengthPointLiner = cbxFullLengthPointLiner.Checked; //lfsMasterAreaRow.BypassRequired = cbxBypassRequired.Checked; //if (tbxRoboticDistances.Text.Trim() != "") lfsMasterAreaRow.RoboticDistances = tbxRoboticDistances.Text.Trim(); else lfsMasterAreaRow.SetRoboticDistancesNull(); //if (tbxTrafficControlDetails.Text.Trim() != "") lfsMasterAreaRow.TrafficControlDetails = tbxTrafficControlDetails.Text.Trim(); else lfsMasterAreaRow.SetTrafficControlDetailsNull(); //if (tbxLineWithID.Text.Trim() != "") lfsMasterAreaRow.LineWithID = tbxLineWithID.Text.Trim(); else lfsMasterAreaRow.SetLineWithIDNull(); //lfsMasterAreaRow.SchoolZone = cbxSchoolZone.Checked; //lfsMasterAreaRow.RestaurantArea = cbxRestaurantArea.Checked; //lfsMasterAreaRow.CarwashLaundromat = cbxCarwashLaundromat.Checked; //lfsMasterAreaRow.HydroPulley = cbxHydroPulley.Checked; //lfsMasterAreaRow.FridgeCart = cbxFridgeCart.Checked; //lfsMasterAreaRow.TwoInchPump = cbxTwoInchPump.Checked; //lfsMasterAreaRow.SixInchBypass = cbxSixInchBypass.Checked; //lfsMasterAreaRow.Scaffolding = cbxScaffolding.Checked; //lfsMasterAreaRow.WinchExtension = cbxWinchExtension.Checked; //lfsMasterAreaRow.ExtraGenerator = cbxExtraGenerator.Checked; //lfsMasterAreaRow.GreyCableExtension = cbxGreyCableExtension.Checked; //lfsMasterAreaRow.EasementMats = cbxEasementMats.Checked; //if (ddlMeasurementType.SelectedValue != "") lfsMasterAreaRow.MeasurementType = ddlMeasurementType.SelectedValue; else lfsMasterAreaRow.SetMeasurementTypeNull(); // LOOKUP //lfsMasterAreaRow.DropPipe = cbxDropPipe.Checked; //if (tbxDropPipeInvertDepth.Text.Trim() != "") lfsMasterAreaRow.DropPipeInvertDepth = tbxDropPipeInvertDepth.Trim(); else lfsMasterAreaRow.SetDropPipeInvertDepthNull(); //lfsMasterAreaRow.Deleted; //if (tbxMeasuredFromManhole.Text.Trim() != "") lfsMasterAreaRow.MeasuredFromManhole = tbxMeasuredFromManhole.Text.Trim(); else lfsMasterAreaRow.SetMeasuredFromManholeNull(); //if (ddlMainLined.SelectedValue != "") lfsMasterAreaRow.MainLined = ddlMainLined.SelectedValue; else lfsMasterAreaRow.SetMainLinedNull(); //if (ddlBenchingIssue.SelectedValue != "") lfsMasterAreaRow.BenchingIssue = ddlBenchingIssue.SelectedValue; else lfsMasterAreaRow.SetBenchingIssueNull(); if (tbxHistory.Text.Trim() != "") lfsMasterAreaRow.History = tbxHistory.Text.Trim(); if (tbxCity.Text.Trim() != "") lfsMasterAreaRow.City = tbxCity.Text.Trim(); if (tbxProvState.Text.Trim() != "") lfsMasterAreaRow.ProvState = tbxProvState.Text.Trim(); // update ScaledLength1 Distance doubleDistance = new Distance(tbxScaledLength.Text.Trim()); if (tbxScaledLength.Text.Trim() != "") lfsMasterAreaRow.ScaledLength1 = doubleDistance.ToFeetDouble(); else lfsMasterAreaRow.SetScaledLength1Null(); // Update m2 tables' reverse setup foreach (TDSLFSRecord.LFS_M2_TABLESRow lfsM2TablesRow in tdsLfsRecord.LFS_M2_TABLES) { if (!lfsM2TablesRow.IsDistanceToCentreOfLateralNull()) { lfsM2TablesRow.ReverseSetup = Distance.Subtract(lfsMasterAreaRow.IsActualLengthNull() ? "" : lfsMasterAreaRow.ActualLength, lfsM2TablesRow.DistanceToCentreOfLateral); } } // Store dataset lfs record Session["tdsLfsRecord"] = tdsLfsRecord; }
private void PostPageChanges() { //--- Post lfs master area changes TDSLFSRecord.LFS_MASTER_AREARow lfsMasterAreaRow = tdsLfsRecord.LFS_MASTER_AREA.FindByIDCOMPANY_ID(new Guid(tbxID.Text), Convert.ToInt32(Session["companyID"])); if (tbxStreet.Text.Trim() != "") lfsMasterAreaRow.Street = tbxStreet.Text.Trim(); else lfsMasterAreaRow.SetStreetNull(); if (tbxUSMH.Text.Trim() != "") lfsMasterAreaRow.USMH = tbxUSMH.Text.Trim(); else lfsMasterAreaRow.SetUSMHNull(); if (tbxDSMH.Text.Trim() != "") lfsMasterAreaRow.DSMH = tbxDSMH.Text.Trim(); else lfsMasterAreaRow.SetDSMHNull(); if (tbxSize_.Text.Trim() != "") lfsMasterAreaRow.Size_ = tbxSize_.Text.Trim(); else lfsMasterAreaRow.SetSize_Null(); if (tbxScaledLength.Text.Trim() != "") lfsMasterAreaRow.ScaledLength = tbxScaledLength.Text.Trim(); else lfsMasterAreaRow.SetScaledLengthNull(); if (tbxP1Date.Text.Trim() != "") lfsMasterAreaRow.P1Date = DateTime.Parse(tbxP1Date.Text.Trim()); else lfsMasterAreaRow.SetP1DateNull(); //--- update DistanceFromDSMH foreach (TDSLFSRecord.LFS_JUNCTION_LINER2Row lfsJunctionLiner2Row in tdsLfsRecord.LFS_JUNCTION_LINER2) { if (!lfsJunctionLiner2Row.IsDistanceFromUSMHNull() && lfsJunctionLiner2Row.DistanceFromUSMH >= 0) { Distance length = new Distance(tbxActualLength.Text.Trim()) - new Distance(lfsJunctionLiner2Row.DistanceFromUSMH.ToString()); lfsJunctionLiner2Row.DistanceFromDSMH = length.ToDoubleInEng3(); } } if (tbxActualLength.Text.Trim() != "") lfsMasterAreaRow.ActualLength = tbxActualLength.Text.Trim(); else lfsMasterAreaRow.SetActualLengthNull(); if (tbxM1Date.Text.Trim() != "") lfsMasterAreaRow.M1Date = DateTime.Parse(tbxM1Date.Text.Trim()); else lfsMasterAreaRow.SetM1DateNull(); if (tbxFinalVideo.Text.Trim() != "") lfsMasterAreaRow.FinalVideo = DateTime.Parse(tbxFinalVideo.Text.Trim()); else lfsMasterAreaRow.SetFinalVideoNull(); if (tbxComments.Text.Trim() != "") lfsMasterAreaRow.Comments = tbxComments.Text.Trim(); else lfsMasterAreaRow.SetCommentsNull(); if (tbxConfirmedSize.Text.Trim() != "") lfsMasterAreaRow.ConfirmedSize = Int32.Parse(tbxConfirmedSize.Text.Trim()); else lfsMasterAreaRow.SetConfirmedSizeNull(); if (tbxUSMHMN.Text.Trim() != "") lfsMasterAreaRow.USMHMN = tbxUSMHMN.Text.Trim(); else lfsMasterAreaRow.SetUSMHMNNull(); if (tbxDSMHMN.Text.Trim() != "") lfsMasterAreaRow.DSMHMN = tbxDSMHMN.Text.Trim(); else lfsMasterAreaRow.SetDSMHMNNull(); if (tbxMeasurementsTakenBy.Text.Trim() != "") lfsMasterAreaRow.MeasurementsTakenBy = tbxMeasurementsTakenBy.Text.Trim(); else lfsMasterAreaRow.SetMeasurementsTakenByNull(); if (tbxActualLength.Text.Trim() != "") lfsMasterAreaRow.SteelTapeThruPipe = tbxActualLength.Text.Trim(); else lfsMasterAreaRow.SetSteelTapeThruPipeNull(); // SYNCHRONIZED if (ddlDegreeOfTrafficControl.SelectedValue != "") lfsMasterAreaRow.DegreeOfTrafficControl = ddlDegreeOfTrafficControl.SelectedValue; else lfsMasterAreaRow.SetDegreeOfTrafficControlNull(); if (tbxPipeMaterialType.Text.Trim() != "") lfsMasterAreaRow.PipeMaterialType = tbxPipeMaterialType.Text.Trim(); else lfsMasterAreaRow.SetPipeMaterialTypeNull(); lfsMasterAreaRow.RoboticPrepRequired = cbxRoboticPrepRequired.Checked; lfsMasterAreaRow.BypassRequired = cbxBypassRequired.Checked; if (tbxRoboticDistances.Text.Trim() != "") lfsMasterAreaRow.RoboticDistances = tbxRoboticDistances.Text.Trim(); else lfsMasterAreaRow.SetRoboticDistancesNull(); lfsMasterAreaRow.IssueIdentified = cbxIssueIdentified.Checked; lfsMasterAreaRow.LFSIssue = cbxLFSIssue.Checked; lfsMasterAreaRow.SalesIssue = cbxSalesIssue.Checked; lfsMasterAreaRow.InvestigationIssue = cbxInvestigationIssue.Checked; lfsMasterAreaRow.IssueResolved = cbxIssueResolved.Checked; lfsMasterAreaRow.IssueGivenToBayCity = cbxIssueGivenToBayCity.Checked; lfsMasterAreaRow.ClientIssue = cbxClientIssue.Checked; //--- update ScaledLength1 Distance doubleDistance = new Distance(tbxScaledLength.Text.Trim()); if (tbxScaledLength.Text.Trim() != "") lfsMasterAreaRow.ScaledLength1 = doubleDistance.ToFeetDouble(); else lfsMasterAreaRow.SetScaledLength1Null(); //--- Update m2 tables' reverse setup foreach (TDSLFSRecord.LFS_M2_TABLESRow lfsM2TablesRow in tdsLfsRecord.LFS_M2_TABLES) { if (!lfsM2TablesRow.IsDistanceToCentreOfLateralNull()) { lfsM2TablesRow.ReverseSetup = Distance.Subtract(lfsMasterAreaRow.IsActualLengthNull() ? "" : lfsMasterAreaRow.ActualLength, lfsM2TablesRow.DistanceToCentreOfLateral); } } //--- Store dataset lfs record Session["tdsLfsRecord"] = tdsLfsRecord; }
private void PostPageChanges() { //--- [COMMENTED ROWS BELOW INTENDED FOR MAINTANANCE - DO NOT DELETE] //--- Post lfs master area changes int companyId = Convert.ToInt32(Session["companyID"]); TDSLFSRecord.LFS_MASTER_AREARow lfsMasterAreaRow = tdsLfsRecord.LFS_MASTER_AREA.FindByIDCOMPANY_ID(newId, companyId); LFSMasterAreaGateway lfsMasterAreaGateway = new LFSMasterAreaGateway(); lfsMasterAreaRow.ID = lfsMasterAreaGateway.GetNewId(); lfsMasterAreaRow.COMPANY_ID = companyId; lfsMasterAreaRow.RecordID = tbxRecordID.Text.Trim(); if (tbxClientID.Text.Trim() != "") lfsMasterAreaRow.ClientID = tbxClientID.Text.Trim(); lfsMasterAreaRow.COMPANIES_ID = Int32.Parse(ddlCOMPANIES_ID.SelectedItem.Value); if (tbxSubArea.Text.Trim() != "") lfsMasterAreaRow.SubArea = tbxSubArea.Text.Trim(); if (tbxStreet.Text.Trim() != "") lfsMasterAreaRow.Street = tbxStreet.Text.Trim(); if (tbxUSMH.Text.Trim() != "") lfsMasterAreaRow.USMH = tbxUSMH.Text.Trim(); if (tbxDSMH.Text.Trim() != "") lfsMasterAreaRow.DSMH = tbxDSMH.Text.Trim(); if (tbxSize_.Text.Trim() != "") lfsMasterAreaRow.Size_ = tbxSize_.Text.Trim(); if (tbxScaledLength.Text.Trim() != "") lfsMasterAreaRow.ScaledLength = tbxScaledLength.Text.Trim(); if (tbxP1Date.Text.Trim() != "") lfsMasterAreaRow.P1Date = DateTime.Parse(tbxP1Date.Text.Trim()); if (tbxActualLength.Text.Trim() != "") lfsMasterAreaRow.ActualLength = tbxActualLength.Text.Trim(); if (tbxLiveLats.Text.Trim() != "") lfsMasterAreaRow.LiveLats = Double.Parse(tbxLiveLats.Text.Trim()); if (tbxCXIsRemoved.Text.Trim() != "") lfsMasterAreaRow.CXIsRemoved = tbxCXIsRemoved.Text.Trim(); if (tbxM1Date.Text.Trim() != "") lfsMasterAreaRow.M1Date = DateTime.Parse(tbxM1Date.Text.Trim()); if (tbxM2Date.Text.Trim() != "") lfsMasterAreaRow.M2Date = DateTime.Parse(tbxM2Date.Text.Trim()); if (tbxInstallDate.Text.Trim() != "") lfsMasterAreaRow.InstallDate = DateTime.Parse(tbxInstallDate.Text.Trim()); if (tbxFinalVideo.Text.Trim() != "") lfsMasterAreaRow.FinalVideo = DateTime.Parse(tbxFinalVideo.Text.Trim()); if (tbxComments.Text.Trim() != "") lfsMasterAreaRow.Comments = tbxComments.Text.Trim(); lfsMasterAreaRow.IssueIdentified = cbxIssueIdentified.Checked; lfsMasterAreaRow.IssueResolved = cbxIssueResolved.Checked; lfsMasterAreaRow.FullLengthLining = cbxFullLengthLining.Checked; lfsMasterAreaRow.SubcontractorLining = cbxSubcontractorLining.Checked; lfsMasterAreaRow.OutOfScopeInArea = cbxOutOfScopeInArea.Checked; lfsMasterAreaRow.IssueGivenToBayCity = cbxIssueGivenToBayCity.Checked; if (tbxConfirmedSize.Text.Trim() != "") lfsMasterAreaRow.ConfirmedSize = Int32.Parse(tbxConfirmedSize.Text.Trim()); if (tbxInstallRate.Text.Trim() != "") lfsMasterAreaRow.InstallRate = Decimal.Parse(tbxInstallRate.Text.Trim()); if (tbxDeadlineDate.Text.Trim() != "") lfsMasterAreaRow.DeadlineDate = DateTime.Parse(tbxDeadlineDate.Text.Trim()); if (tbxProposedLiningDate.Text.Trim() != "") lfsMasterAreaRow.ProposedLiningDate = DateTime.Parse(tbxProposedLiningDate.Text.Trim()); lfsMasterAreaRow.SalesIssue = cbxSalesIssue.Checked; lfsMasterAreaRow.LFSIssue = cbxLFSIssue.Checked; lfsMasterAreaRow.ClientIssue = cbxClientIssue.Checked; lfsMasterAreaRow.InvestigationIssue = cbxInvestigationIssue.Checked; lfsMasterAreaRow.PointLining = cbxPointLining.Checked; lfsMasterAreaRow.Grouting = cbxGrouting.Checked; lfsMasterAreaRow.LateralLining = cbxLateralLining.Checked; //if (tbxVacExDate.Text.Trim() != "") lfsMasterAreaRow.VacExDate = DateTime.Parse(tbxVacExDate.Text.Trim()); //if (tbxPusherDate.Text.Trim() != "") lfsMasterAreaRow.PusherDate = DateTime.Parse(tbxPusherDate.Text.Trim()); //if (tbxLinerOrdered.Text.Trim() != "") lfsMasterAreaRow.LinerOrdered = DateTime.Parse(tbxLinerOrdered.Text.Trim()); //if (tbxRestoration.Text.Trim() != "") lfsMasterAreaRow.Restoration = DateTime.Parse(tbxRestoration.Text.Trim()); //if (tbxGroutDate.Text.Trim() != "") lfsMasterAreaRow.GroutDate = DateTime.Parse(tbxGroutDate.Text.Trim()); lfsMasterAreaRow.JLiner = cbxJLiner.Checked; lfsMasterAreaRow.RehabAssessment = cbxRehabAssessment.Checked; if (tbxEstimatedJoints.Text.Trim() != "") lfsMasterAreaRow.EstimatedJoints = Int32.Parse(tbxEstimatedJoints.Text.Trim()); //if (tbxJointsTestSealed.Text.Trim() != "") lfsMasterAreaRow.JointsTestSealed = Int32.Parse(tbxJointsTestSealed.Text.Trim()); if (tbxPreFlushDate.Text.Trim() != "") lfsMasterAreaRow.PreFlushDate = DateTime.Parse(tbxPreFlushDate.Text.Trim()); if (tbxPreVideoDate.Text.Trim() != "") lfsMasterAreaRow.PreVideoDate = DateTime.Parse(tbxPreVideoDate.Text.Trim()); //if (tbxUSMHMN.Text.Trim() != "") lfsMasterAreaRow.USMHMN = tbxUSMHMN.Text.Trim(); //if (tbxDSMHMN.Text.Trim() != "") lfsMasterAreaRow.DSMHMN = tbxDSMHMN.Text.Trim(); //if (tbxUSMHDepth.Text.Trim() != "") lfsMasterAreaRow.USMHDepth = tbxUSMHDepth.Text.Trim(); //if (tbxDSMHDepth.Text.Trim() != "") lfsMasterAreaRow.DSMHDepth = tbxDSMHDepth.Text.Trim(); //if (tbxMeasurementsTakenBy.Text.Trim() != "") lfsMasterAreaRow.MeasurementsTakenBy = tbxMeasurementsTakenBy.Text.Trim(); if (tbxActualLength.Text.Trim() != "") lfsMasterAreaRow.SteelTapeThruPipe = tbxActualLength.Text.Trim(); // SYNCHRONIZED //if (tbxUSMHAtMouth1200.Text.Trim() != "") lfsMasterAreaRow.USMHAtMouth1200 = Double.Parse(tbxUSMHAtMouth1200.Text.Trim()); //if (tbxUSMHAtMouth100.Text.Trim() != "") lfsMasterAreaRow.USMHAtMouth100 = Double.Parse(tbxUSMHAtMouth100.Text.Trim()); //if (tbxUSMHAtMouth200.Text.Trim() != "") lfsMasterAreaRow.USMHAtMouth200 = Double.Parse(tbxUSMHAtMouth200.Text.Trim()); //if (tbxUSMHAtMouth300.Text.Trim() != "") lfsMasterAreaRow.USMHAtMouth300 = Double.Parse(tbxUSMHAtMouth300.Text.Trim()); //if (tbxUSMHAtMouth400.Text.Trim() != "") lfsMasterAreaRow.USMHAtMouth400 = Double.Parse(tbxUSMHAtMouth400.Text.Trim()); //if (tbxUSMHAtMouth500.Text.Trim() != "") lfsMasterAreaRow.USMHAtMouth500 = Double.Parse(tbxUSMHAtMouth500.Text.Trim()); //if (tbxDSMHAtMouth1200.Text.Trim() != "") lfsMasterAreaRow.DSMHAtMouth1200 = Double.Parse(tbxDSMHAtMouth1200.Text.Trim()); //if (tbxDSMHAtMouth100.Text.Trim() != "") lfsMasterAreaRow.DSMHAtMouth100 = Double.Parse(tbxDSMHAtMouth100.Text.Trim()); //if (tbxDSMHAtMouth200.Text.Trim() != "") lfsMasterAreaRow.DSMHAtMouth200 = Double.Parse(tbxDSMHAtMouth200.Text.Trim()); //if (tbxDSMHAtMouth300.Text.Trim() != "") lfsMasterAreaRow.DSMHAtMouth300 = Double.Parse(tbxDSMHAtMouth300.Text.Trim()); //if (tbxDSMHAtMouth400.Text.Trim() != "") lfsMasterAreaRow.DSMHAtMouth400 = Double.Parse(tbxDSMHAtMouth400.Text.Trim()); //if (tbxDSMHAtMouth500.Text.Trim() != "") lfsMasterAreaRow.DSMHAtMouth500 = Double.Parse(tbxDSMHAtMouth500.Text.Trim()); //if (tbxHydrantAddress.Text.Trim() != "") lfsMasterAreaRow.HydrantAddress = tbxHydrantAddress.Text.Trim(); //if (tbxDistanceToInversionMH.Text.Trim() != "") lfsMasterAreaRow.DistanceToInversionMH = tbxDistanceToInversionMH.Text.Trim(); lfsMasterAreaRow.RampsRequired = false; //lfsMasterAreaRow.DegreeOfTrafficControl // LOOKUP lfsMasterAreaRow.StandarBypass = false; //if (tbxHydroWireDetails.Text.Trim() != "") lfsMasterAreaRow.HydroWireDetails = tbxHydroWireDetails.Text.Trim(); //if (tbxPipeMaterialType.Text.Trim() != "") lfsMasterAreaRow.PipeMaterialType = tbxPipeMaterialType.Text.Trim(); //if (tbxCappedLaterals.Text.Trim() != "") lfsMasterAreaRow.CappedLaterals = Int32.Parse(tbxCappedLaterals.Text.Trim()); lfsMasterAreaRow.RoboticPrepRequired = false; lfsMasterAreaRow.PipeSizeChange = false; //if (tbxM1Comments.Text.Trim() != "") lfsMasterAreaRow.M1Comments = tbxM1Comments.Text.Trim(); //if (tbxVideoDoneFrom.Text.Trim() != "") lfsMasterAreaRow.VideoDoneFrom = tbxVideoDoneFrom.Text.Trim(); //if (tbxToManhole.Text.Trim() != "") lfsMasterAreaRow.ToManhole = tbxToManhole.Text.Trim(); //if (tbxCutterDescriptionDuringMeasuring.Text.Trim() != "") lfsMasterAreaRow.CutterDescriptionDuringMeasuring = tbxCutterDescriptionDuringMeasuring.Text.Trim(); lfsMasterAreaRow.FullLengthPointLiner = cbxFullLengthPointLiner.Checked; lfsMasterAreaRow.BypassRequired = false; //if (tbxRoboticDistances.Text.Trim() != "") lfsMasterAreaRow.RoboticDistances = tbxRoboticDistances.Text.Trim(); //if (tbxTrafficControlDetails.Text.Trim() != "") lfsMasterAreaRow.TrafficControlDetails = tbxTrafficControlDetails.Text.Trim(); else lfsMasterAreaRow.SetTrafficControlDetailsNull(); //if (tbxLineWithID.Text.Trim() != "") lfsMasterAreaRow.LineWithID = tbxLineWithID.Text.Trim(); else lfsMasterAreaRow.SetLineWithIDNull(); lfsMasterAreaRow.SchoolZone = false; lfsMasterAreaRow.RestaurantArea = false; lfsMasterAreaRow.CarwashLaundromat = false; lfsMasterAreaRow.HydroPulley = false; lfsMasterAreaRow.FridgeCart = false; lfsMasterAreaRow.TwoInchPump = false; lfsMasterAreaRow.SixInchBypass = false; lfsMasterAreaRow.Scaffolding = false; lfsMasterAreaRow.WinchExtension = false; lfsMasterAreaRow.ExtraGenerator = false; lfsMasterAreaRow.GreyCableExtension = false; lfsMasterAreaRow.EasementMats = false; //lfsMasterAreaRow.MeasurementType // LOOKUP lfsMasterAreaRow.DropPipe = false; //if (tbxDropPipeInvertDepth.Text.Trim() != "") lfsMasterAreaRow.DropPipeInvertDepth = tbxDropPipeInvertDepth.Trim(); else lfsMasterAreaRow.SetDropPipeInvertDepthNull(); lfsMasterAreaRow.Deleted = false; //if (tbxMeasuredFromManhole.Text.Trim() != "") lfsMasterAreaRow.MeasuredFromManhole = tbxMeasuredFromManhole.Text.Trim(); else lfsMasterAreaRow.SetMeasuredFromManholeNull(); //if (ddlMainLined.SelectedValue != "") lfsMasterAreaRow.MainLined = ddlMainLined.SelectedValue; else lfsMasterAreaRow.SetMainLinedNull(); //if (ddlBenchingIssue.SelectedValue != "") lfsMasterAreaRow.BenchingIssue = ddlBenchingIssue.SelectedValue; else lfsMasterAreaRow.SetBenchingIssueNull(); lfsMasterAreaRow.Archived = false; if (tbxHistory.Text.Trim() != "") lfsMasterAreaRow.History = tbxHistory.Text.Trim(); lfsMasterAreaRow.NumLats = 0; lfsMasterAreaRow.NotLinedYet = 0; lfsMasterAreaRow.AllMeasured = false; if (tbxCity.Text.Trim() != "") lfsMasterAreaRow.City = tbxCity.Text.Trim(); if (tbxProvState.Text.Trim() != "") lfsMasterAreaRow.ProvState = tbxProvState.Text.Trim(); //--- update ScaledLength1 Distance doubleDistance = new Distance(tbxScaledLength.Text.Trim()); if (tbxScaledLength.Text.Trim() != "") lfsMasterAreaRow.ScaledLength1 = doubleDistance.ToFeetDouble(); else lfsMasterAreaRow.SetScaledLength1Null(); //--- Store dataset lfs record Session["tdsLfsRecord"] = tdsLfsRecord; }