// // cvActualLength_ServerValidate // private void cvActualLength_ServerValidate(object source, System.Web.UI.WebControls.ServerValidateEventArgs args) { cvActualLength.ErrorMessage = ""; bool isValid = true; if (Distance.IsValidDistance(args.Value.Trim()) || tbxActualLength.Text.Trim() == "") { foreach (TDSLFSRecord.LFS_JUNCTION_LINER2Row lfsJunctionLiner2Row in tdsLfsRecord.LFS_JUNCTION_LINER2) { if (!lfsJunctionLiner2Row.IsDistanceFromUSMHNull() && lfsJunctionLiner2Row.DistanceFromUSMH >= 0) { Distance length = new Distance(tbxActualLength.Text.ToString()) - new Distance(lfsJunctionLiner2Row.DistanceFromUSMH.ToString()); if (length.ToDoubleInEng3() < 0) { isValid = false; cvActualLength.ErrorMessage = "Actual Length must be greater than the Distance From USMH of its laterals"; } } } args.IsValid = isValid; } else { cvActualLength.ErrorMessage = "Invalid data"; args.IsValid = false; } }
/// //////////////////////////////////////////////////////////////////////// /// 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; }
protected void cvRehabilitationDataChimneyDiameterAdd_ServerValidate(object source, ServerValidateEventArgs args) { if (args.Value.Trim() != "") { // Initialize CustomValidator cvRehabilitationDataChimneyDiameterAdd = (CustomValidator)source; GridViewRow gridRow = (GridViewRow)cvRehabilitationDataChimneyDiameterAdd.NamingContainer; string shapeAdd = ((DropDownList)gridRow.FindControl("ddlShapeAdd")).SelectedValue; args.IsValid = true; // Control of format if ((!Distance.IsValidDistance(args.Value)) && (shapeAdd == "Round")) { cvRehabilitationDataChimneyDiameterAdd.Text = "Invalid format. (please use X'Y\", or X\", or Xft Yin, or X.Y, or X.Ym, or X.Ymm)"; args.IsValid = false; } // Control of distance > 0 if ((args.IsValid) && (shapeAdd == "Round")) { Distance distance = new Distance(args.Value); if (distance.ToDoubleInEng3() < 0) { cvRehabilitationDataChimneyDiameterAdd.Text = "Invalid measurement. (must be equal or greater than 0)"; args.IsValid = false; } } } }
protected void cvDistance_ServerValidate(object source, ServerValidateEventArgs args) { if (args.Value.Trim() != "") { // Initialize CustomValidator cvDistance = (CustomValidator)source; args.IsValid = true; // Control of format if (!Distance.IsValidDistance(args.Value)) { cvDistance.Text = "Invalid format. (please use X'Y\", or Xft Yin, or X.Y, or X.Ym, or X.Ymm)"; args.IsValid = false; } // Control of distance > 0 if (args.IsValid) { Distance distance = new Distance(args.Value); if (distance.ToDoubleInEng3() < 0) { cvDistance.Text = "Invalid distance. (must be equal or greater than 0)"; args.IsValid = false; } } } }
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; }
/// //////////////////////////////////////////////////////////////////////// /// 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 (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 (tbxM1Date.Text.Trim() != "") lfsMasterAreaRow.M1Date = DateTime.Parse(tbxM1Date.Text.Trim()); else lfsMasterAreaRow.SetM1DateNull(); if (tbxConfirmedSize.Text.Trim() != "") lfsMasterAreaRow.ConfirmedSize = Int32.Parse(tbxConfirmedSize.Text.Trim()); else lfsMasterAreaRow.SetConfirmedSizeNull(); //--- update DistanceFromDSMH foreach (TDSLFSRecord.LFS_JUNCTION_LINER2Row lfsJunctionLiner2Row in tdsLfsRecord.LFS_JUNCTION_LINER2) { if (!lfsJunctionLiner2Row.IsDistanceFromUSMHNull() && lfsJunctionLiner2Row.DistanceFromUSMH >= 0) { Distance length = new Distance(tbxSteelTapeThruPipe.Text.Trim()) - new Distance(lfsJunctionLiner2Row.DistanceFromUSMH.ToString()); lfsJunctionLiner2Row.DistanceFromDSMH = length.ToDoubleInEng3(); } } if (tbxSteelTapeThruPipe.Text.Trim() != "") lfsMasterAreaRow.ActualLength = tbxSteelTapeThruPipe.Text.Trim(); else lfsMasterAreaRow.SetActualLengthNull(); // SYNCHRONIZED 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 (tbxSteelTapeThruPipe.Text.Trim() != "") lfsMasterAreaRow.SteelTapeThruPipe = tbxSteelTapeThruPipe.Text.Trim(); else lfsMasterAreaRow.SetSteelTapeThruPipeNull(); 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(); 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(); lfsMasterAreaRow.RoboticPrepRequired = cbxRoboticPrepRequired.Checked; lfsMasterAreaRow.PipeSizeChange = cbxPipeSizeChange.Checked; if (tbxM1Comments.Text.Trim() != "") lfsMasterAreaRow.M1Comments = tbxM1Comments.Text.Trim(); else lfsMasterAreaRow.SetM1CommentsNull(); 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; lfsMasterAreaRow.DropPipe = cbxDropPipe.Checked; if (tbxDropPipeInvertDepth.Text.Trim() != "") lfsMasterAreaRow.DropPipeInvertDepth = tbxDropPipeInvertDepth.Text.Trim(); else lfsMasterAreaRow.SetDropPipeInvertDepthNull(); //--- 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; }
// // Subtract // public static string Subtract(string arg1, string arg2) { if (IsValidDistance(arg1) && IsValidDistance(arg2)) { Distance result = new Distance(); Distance distance1 = new Distance(arg1); Distance distance2 = new Distance(arg2); result = distance1 - distance2; return result.ToString(); } else { return "Invalid distance"; } }
// // Distance operator - // public static Distance operator -(Distance arg1, Distance arg2) { if ((arg1.type != 0) && (arg2.type != 0)) { Distance result = new Distance(); arg2.sign = (arg2.sign == "+") ? "-" : "+"; result = arg1 + arg2; return result; } else { throw(new Exception ("Subtract operations are only supported in this format X' Y\"")); } }
// // Distance operator + // public static Distance operator +(Distance arg1, Distance arg2) { /*if ((arg1.type == (int) distanceType.eng1) && (arg2.type == (int) distanceType.eng1)) {*/ if ((arg1.type != 0) && (arg2.type != 0)) { Distance result = new Distance(); int resultInInches; int arg1InInches = (arg1.feet1 * 12) + arg1.inches1; int arg2InInches = (arg2.feet1 * 12) + arg2.inches1; if ((arg1InInches == 0) && (arg2InInches == 0)) { return result; } if (arg1.sign == arg2.sign) { result.sign = arg1.sign; resultInInches = arg1InInches + arg2InInches; } else { if (arg1InInches == arg2InInches) { result.sign = "+"; resultInInches = 0; } else if (arg1InInches > arg2InInches) { result.sign = arg1.sign; resultInInches = arg1InInches - arg2InInches; } else { result.sign = arg2.sign; resultInInches = arg2InInches - arg1InInches; } } result.feet1 = resultInInches / 12; result.inches1 = resultInInches % 12; result.feet2 = resultInInches / (double)12; result.meters = (result.feet1 * 12 * 0.0254) + (result.inches1 * 0.0254); result.millimeters = result.meters * 1000; return result; } else { throw(new Exception ("Add operations are only supported in this format X' Y\"")); } }