Ejemplo n.º 1
0
        private void LoadManholeStructureData(int assetId)
        {
            ManholeRehabilitationManholeDetailsGateway manholeRehabilitationManholeDetailsGateway = new ManholeRehabilitationManholeDetailsGateway(manholeRehabilitationTDS);
            if (manholeRehabilitationManholeDetailsGateway.Table.Rows.Count > 0)
            {
                // ... Round shape
                // ... ... Chimney
                tbxRehabilitationDataChimneyDiameter.Text = GetDistance(new Distance(manholeRehabilitationManholeDetailsGateway.GetTopDiameter(assetId)));
                lblRoudChimneyDiameterLabel.Text = tbxRehabilitationDataChimneyDiameter.Text;
                tbxRehabilitationDataChimneyDepth.Text = GetDistance(new Distance(manholeRehabilitationManholeDetailsGateway.GetTopDepth(assetId)));
                lblRoudChimneyDepthLabel.Text = tbxRehabilitationDataChimneyDepth.Text;

                ckbxRehabilitationDataChimneyFloor.Checked = false;
                tbxRehabilitationDataChimneyFloor.Text = "";
                if (manholeRehabilitationManholeDetailsGateway.GetTopFloor(assetId) != "")
                {
                    ckbxRehabilitationDataChimneyFloor.Checked = true;
                    tbxRehabilitationDataChimneyFloor.Text = GetDistance(new Distance(manholeRehabilitationManholeDetailsGateway.GetTopFloor(assetId)));
                }

                ckbxRehabilitationDataChimneyCeiling.Checked = false;
                tbxRehabilitationDataChimneyCeiling.Text = "";
                if (manholeRehabilitationManholeDetailsGateway.GetTopCeiling(assetId) != "")
                {
                    ckbxRehabilitationDataChimneyCeiling.Checked = true;
                    tbxRehabilitationDataChimneyCeiling.Text = GetDistance(new Distance(manholeRehabilitationManholeDetailsGateway.GetTopCeiling(assetId)));
                    lblRoudChimneyCeilingLabel.Text = tbxRehabilitationDataChimneyCeiling.Text;
                }

                ckbxRehabilitationDataChimneyBenching.Checked = false;
                tbxRehabilitationDataChimneyBenching.Text = "";
                if (manholeRehabilitationManholeDetailsGateway.GetTopBenching(assetId) != "")
                {
                    ckbxRehabilitationDataChimneyBenching.Checked = true;
                    tbxRehabilitationDataChimneyBenching.Text = GetDistance(new Distance(manholeRehabilitationManholeDetailsGateway.GetTopBenching(assetId)));
                }

                tbxRehabilitationDataChimneySurfaceArea.Text = GetDistance(new Distance(manholeRehabilitationManholeDetailsGateway.GetTopSurfaceArea(assetId)));
                lblRoundChimneySurfaceAreaLabel.Text = tbxRehabilitationDataChimneySurfaceArea.Text;

                // ... ... Barrel
                tbxRehabilitationDataBarrelDiameter.Text = GetDistance(new Distance(manholeRehabilitationManholeDetailsGateway.GetDownDiameter(assetId)));
                lblRoudBarrelDiameterLabel.Text = tbxRehabilitationDataBarrelDiameter.Text;
                tbxRehabilitationDataBarrelDepth.Text = GetDistance(new Distance(manholeRehabilitationManholeDetailsGateway.GetDownDepth(assetId)));
                lblRoudBarrelDepthLabel.Text = tbxRehabilitationDataBarrelDepth.Text;

                ckbxRehabilitationDataBarrelFloor.Checked = false;
                tbxRehabilitationDataBarrelFloor.Text = "";
                if (manholeRehabilitationManholeDetailsGateway.GetDownFloor(assetId) != "")
                {
                    ckbxRehabilitationDataBarrelFloor.Checked = true;
                    tbxRehabilitationDataBarrelFloor.Text = GetDistance(new Distance(manholeRehabilitationManholeDetailsGateway.GetDownFloor(assetId)));
                }

                ckbxRehabilitationDataBarrelCeiling.Checked = false;
                tbxRehabilitationDataBarrelCeiling.Text = "";
                if (manholeRehabilitationManholeDetailsGateway.GetDownCeiling(assetId) != "")
                {
                    ckbxRehabilitationDataBarrelCeiling.Checked = true;
                    tbxRehabilitationDataBarrelCeiling.Text = GetDistance(new Distance(manholeRehabilitationManholeDetailsGateway.GetDownCeiling(assetId)));
                    lblRoundBarrelCeilingLabel.Text = tbxRehabilitationDataBarrelCeiling.Text;
                }

                ckbxRehabilitationDataBarrelBenching.Checked = false;
                tbxRehabilitationDataBarrelBenching.Text = "";
                if (manholeRehabilitationManholeDetailsGateway.GetDownBenching(assetId) != "")
                {
                    ckbxRehabilitationDataBarrelBenching.Checked = true;
                    tbxRehabilitationDataBarrelBenching.Text = GetDistance(new Distance(manholeRehabilitationManholeDetailsGateway.GetDownBenching(assetId)));
                }

                tbxRehabilitationDataBarrelSurfaceArea.Text = GetDistance(new Distance(manholeRehabilitationManholeDetailsGateway.GetDownSurfaceArea(assetId)));
                lblRoundBarrelSurfaceAreaLabel.Text = tbxRehabilitationDataBarrelSurfaceArea.Text;

                if (manholeRehabilitationManholeDetailsGateway.GetManholeRugs(assetId).HasValue)
                {
                    ddlRehabilitationDataRoundManholeRugs.SelectedValue = manholeRehabilitationManholeDetailsGateway.GetManholeRugs(assetId).ToString();
                }
                else
                {
                    ddlRehabilitationDataRoundManholeRugs.SelectedIndex = 1;
                }

                // ... ... Totals
                tbxRehabilitationDataRoundTotalDepth.Text = GetDistance(new Distance(manholeRehabilitationManholeDetailsGateway.GetTotalDepth(assetId)));
                lblRoundTotalDepthLabel.Text = tbxRehabilitationDataRoundTotalDepth.Text;
                tbxRehabilitationDataRoundTotalSurfaceArea.Text = GetDistance(new Distance(manholeRehabilitationManholeDetailsGateway.GetTotalSurfaceArea(assetId)));
                lblRoundTotalSurfaceArea.Text = tbxRehabilitationDataRoundTotalSurfaceArea.Text;

                // ... Rectangular Shape
                // ... ... Rectangular 1
                tbxRehabilitationDataRectangle1LongSide.Text = GetDistance(new Distance(manholeRehabilitationManholeDetailsGateway.GetRectangle1LongSide(assetId)));
                lblRectangular1LongSideLabel.Text = tbxRehabilitationDataRectangle1LongSide.Text;
                tbxRehabilitationDataRectangle1ShortSide.Text = GetDistance(new Distance(manholeRehabilitationManholeDetailsGateway.GetRectangle1ShortSide(assetId)));
                lblRectangular1ShortSideLabel.Text = tbxRehabilitationDataRectangle1ShortSide.Text;
                tbxRehabilitationDataRectangle1Depth.Text = GetDistance(new Distance(manholeRehabilitationManholeDetailsGateway.GetTopDepth(assetId)));
                lblRectangular1DephtLabel.Text = tbxRehabilitationDataRectangle1Depth.Text;

                ckbxRehabilitationDataRectangle1Floor.Checked = false;
                tbxRehabilitationDataRectangle1Floor.Text = "";
                if (manholeRehabilitationManholeDetailsGateway.GetTopFloor(assetId) != "")
                {
                    ckbxRehabilitationDataRectangle1Floor.Checked = true;
                    tbxRehabilitationDataRectangle1Floor.Text = GetDistance(new Distance(manholeRehabilitationManholeDetailsGateway.GetTopFloor(assetId)));
                }

                ckbxRehabilitationDataRectangle1Ceiling.Checked = false;
                tbxRehabilitationDataRectangle1Ceiling.Text = "";
                if (manholeRehabilitationManholeDetailsGateway.GetTopCeiling(assetId) != "")
                {
                    ckbxRehabilitationDataRectangle1Ceiling.Checked = true;
                    tbxRehabilitationDataRectangle1Ceiling.Text = GetDistance(new Distance(manholeRehabilitationManholeDetailsGateway.GetTopCeiling(assetId)));
                    lblRectangular1CeilingLabel.Text = tbxRehabilitationDataRectangle1Ceiling.Text;
                }

                ckbxRehabilitationDataRectangle1Benching.Checked = false;
                tbxRehabilitationDataRectangle1Benching.Text = "";
                if (manholeRehabilitationManholeDetailsGateway.GetTopBenching(assetId) != "")
                {
                    ckbxRehabilitationDataRectangle1Benching.Checked = true;
                    tbxRehabilitationDataRectangle1Benching.Text = GetDistance(new Distance(manholeRehabilitationManholeDetailsGateway.GetTopBenching(assetId)));
                }

                tbxRehabilitationDataRectangle1SurfaceArea.Text = GetDistance(new Distance(manholeRehabilitationManholeDetailsGateway.GetTopSurfaceArea(assetId)));
                lblRectangle1SurfaceAreaLabel.Text = tbxRehabilitationDataRectangle1SurfaceArea.Text;

                // ... ... Rectangular 2
                tbxRehabilitationDataRectangle2LongSide.Text = GetDistance(new Distance(manholeRehabilitationManholeDetailsGateway.GetRectangle2LongSide(assetId)));
                lblRectangle2LongSideLabel.Text = tbxRehabilitationDataRectangle2LongSide.Text;
                tbxRehabilitationDataRectangle2ShortSide.Text = GetDistance(new Distance(manholeRehabilitationManholeDetailsGateway.GetRectangle2ShortSide(assetId)));
                lblRectangular2ShortSideLabel.Text = tbxRehabilitationDataRectangle2ShortSide.Text;
                tbxRehabilitationDataRectangle2Depth.Text = GetDistance(new Distance(manholeRehabilitationManholeDetailsGateway.GetDownDepth(assetId)));
                lblRectangular2Depth.Text = tbxRehabilitationDataRectangle2Depth.Text;

                ckbxRehabilitationDataRectangle2Floor.Checked = false;
                tbxRehabilitationDataRectangle2Floor.Text = "";
                if (manholeRehabilitationManholeDetailsGateway.GetDownFloor(assetId) != "")
                {
                    ckbxRehabilitationDataRectangle2Floor.Checked = true;
                    tbxRehabilitationDataRectangle2Floor.Text = GetDistance(new Distance(manholeRehabilitationManholeDetailsGateway.GetDownFloor(assetId)));
                }

                ckbxRehabilitationDataRectangle2Ceiling.Checked = false;
                tbxRehabilitationDataRectangle2Ceiling.Text = "";
                if (manholeRehabilitationManholeDetailsGateway.GetDownCeiling(assetId) != "")
                {
                    ckbxRehabilitationDataRectangle2Ceiling.Checked = true;
                    tbxRehabilitationDataRectangle2Ceiling.Text = GetDistance(new Distance(manholeRehabilitationManholeDetailsGateway.GetDownCeiling(assetId)));
                    lblRectangular2CeilingLabel.Text = tbxRehabilitationDataRectangle2Ceiling.Text;
                }

                ckbxRehabilitationDataRectangle2Benching.Checked = false;
                tbxRehabilitationDataRectangle2Benching.Text = "";
                if (manholeRehabilitationManholeDetailsGateway.GetDownBenching(assetId) != "")
                {
                    ckbxRehabilitationDataRectangle2Benching.Checked = true;
                    tbxRehabilitationDataRectangle2Benching.Text = GetDistance(new Distance(manholeRehabilitationManholeDetailsGateway.GetDownBenching(assetId)));
                }

                tbxRehabilitationDataRectangle2SurfaceArea.Text = GetDistance(new Distance(manholeRehabilitationManholeDetailsGateway.GetDownSurfaceArea(assetId)));
                lblRectangle2SurfaceAreaLabel.Text = tbxRehabilitationDataRectangle2SurfaceArea.Text;

                if (manholeRehabilitationManholeDetailsGateway.GetManholeRugs(assetId).HasValue)
                {
                    ddlRehabilitationDataRectangularManholeRugs.SelectedValue = manholeRehabilitationManholeDetailsGateway.GetManholeRugs(assetId).ToString();
                }
                else
                {
                    ddlRehabilitationDataRectangularManholeRugs.SelectedIndex = 1;
                }

                // ... ... Totals
                tbxRehabilitationDataRectangularTotalDepth.Text = GetDistance(new Distance(manholeRehabilitationManholeDetailsGateway.GetTotalDepth(assetId)));
                lblRectangularTotalDepthLabel.Text = tbxRehabilitationDataRectangularTotalDepth.Text;
                tbxRehabilitationDataRectangularTotalSurfaceArea.Text = GetDistance(new Distance(manholeRehabilitationManholeDetailsGateway.GetTotalSurfaceArea(assetId)));
                lblRectangularTotalSurfaceAreaLabel.Text = tbxRehabilitationDataRectangularTotalSurfaceArea.Text;

                // ... Mix Shape
                // ... ... Top
                tbxRehabilitationDataRoundDiameter.Text = GetDistance(new Distance(manholeRehabilitationManholeDetailsGateway.GetTopDiameter(assetId)));
                lblDataRoundDiameterLabel.Text = tbxRehabilitationDataRoundDiameter.Text;
                tbxRehabilitationDataRoundDepth.Text = GetDistance(new Distance(manholeRehabilitationManholeDetailsGateway.GetTopDepth(assetId)));
                lblDataRoundDepthLabel.Text = tbxRehabilitationDataRoundDepth.Text;

                ckbxRehabilitationDataRoundFloor.Checked = false;
                tbxRehabilitationDataRoundFloor.Text = "";
                if (manholeRehabilitationManholeDetailsGateway.GetTopFloor(assetId) != "")
                {
                    ckbxRehabilitationDataRoundFloor.Checked = true;
                    tbxRehabilitationDataRoundFloor.Text = GetDistance(new Distance(manholeRehabilitationManholeDetailsGateway.GetTopFloor(assetId)));
                }

                ckbxRehabilitationDataRoundCeiling.Checked = false;
                tbxRehabilitationDataRoundCeiling.Text = "";
                if (manholeRehabilitationManholeDetailsGateway.GetTopCeiling(assetId) != "")
                {
                    ckbxRehabilitationDataRoundCeiling.Checked = true;
                    tbxRehabilitationDataRoundCeiling.Text = GetDistance(new Distance(manholeRehabilitationManholeDetailsGateway.GetTopCeiling(assetId)));
                    lblDataRoundCeilingLabel.Text = tbxRehabilitationDataRoundCeiling.Text;
                }

                ckbxRehabilitationDataRoundBenching.Checked = false;
                tbxRehabilitationDataRoundBenching.Text = "";
                if (manholeRehabilitationManholeDetailsGateway.GetTopBenching(assetId) != "")
                {
                    ckbxRehabilitationDataRoundBenching.Checked = true;
                    tbxRehabilitationDataRoundBenching.Text = GetDistance(new Distance(manholeRehabilitationManholeDetailsGateway.GetTopBenching(assetId)));
                }

                tbxRehabilitationDataRoundSurfaceArea.Text = GetDistance(new Distance(manholeRehabilitationManholeDetailsGateway.GetTopSurfaceArea(assetId)));
                lblDataRoundSurfaceAreaLabel.Text = tbxRehabilitationDataRoundSurfaceArea.Text;

                // ... ... Down
                tbxRehabilitationDataRectangleLongSide.Text = GetDistance(new Distance(manholeRehabilitationManholeDetailsGateway.GetRectangle2LongSide(assetId)));
                lblRectangleLongSideLabel.Text = tbxRehabilitationDataRectangleLongSide.Text;
                tbxRehabilitationDataRectangleShortSide.Text = GetDistance(new Distance(manholeRehabilitationManholeDetailsGateway.GetRectangle2ShortSide(assetId)));
                lblRectangleShortSideLabel.Text = tbxRehabilitationDataRectangleShortSide.Text;
                tbxRehabilitationDataRectangleDepth.Text = GetDistance(new Distance(manholeRehabilitationManholeDetailsGateway.GetDownDepth(assetId)));
                lblRectangleDephtLabel.Text = tbxRehabilitationDataRectangleDepth.Text;

                ckbxRehabilitationDataRectangleFloor.Checked = false;
                tbxRehabilitationDataRectangleFloor.Text = "";
                if (manholeRehabilitationManholeDetailsGateway.GetDownFloor(assetId) != "")
                {
                    ckbxRehabilitationDataRectangleFloor.Checked = true;
                    tbxRehabilitationDataRectangleFloor.Text = GetDistance(new Distance(manholeRehabilitationManholeDetailsGateway.GetDownFloor(assetId)));
                }

                ckbxRehabilitationDataRectangleCeiling.Checked = false;
                tbxRehabilitationDataRectangleCeiling.Text = "";
                if (manholeRehabilitationManholeDetailsGateway.GetDownCeiling(assetId) != "")
                {
                    ckbxRehabilitationDataRectangleCeiling.Checked = true;
                    tbxRehabilitationDataRectangleCeiling.Text = GetDistance(new Distance(manholeRehabilitationManholeDetailsGateway.GetDownCeiling(assetId)));
                    lblRectangleCeilingLabel.Text = tbxRehabilitationDataRectangleCeiling.Text;
                }

                ckbxRehabilitationDataRectangleBenching.Checked = false;
                tbxRehabilitationDataRectangleBenching.Text = "";
                if (manholeRehabilitationManholeDetailsGateway.GetDownBenching(assetId) != "")
                {
                    ckbxRehabilitationDataRectangleBenching.Checked = true;
                    tbxRehabilitationDataRectangleBenching.Text = GetDistance(new Distance(manholeRehabilitationManholeDetailsGateway.GetDownBenching(assetId)));
                }

                tbxRehabilitationDataRectangleSufaceArea.Text = GetDistance(new Distance(manholeRehabilitationManholeDetailsGateway.GetDownSurfaceArea(assetId)));
                lblRectangleSurfaceAreaLabel.Text = tbxRehabilitationDataRectangleSufaceArea.Text;

                if (manholeRehabilitationManholeDetailsGateway.GetManholeRugs(assetId).HasValue)
                {
                    ddlRehabilitationDataMixManholeRugs.SelectedValue = manholeRehabilitationManholeDetailsGateway.GetManholeRugs(assetId).ToString();
                }
                else
                {
                    ddlRehabilitationDataMixManholeRugs.SelectedIndex = 1;
                }

                // ... ... Totals
                tbxRehabilitationDataMixedTotalDepth.Text = GetDistance(new Distance(manholeRehabilitationManholeDetailsGateway.GetTotalDepth(assetId)));
                lblMixedTotalDepthLabel.Text = tbxRehabilitationDataMixedTotalDepth.Text;
                tbxRehabilitationDataMixedTotalSurfaceArea.Text = GetDistance(new Distance(manholeRehabilitationManholeDetailsGateway.GetTotalSurfaceArea(assetId)));
                lblTotalMixedSurfaceAreaLabel.Text = tbxRehabilitationDataMixedTotalSurfaceArea.Text;

                // ... Other shape
                tbxRehabilitationDataOtherStructure.Text = GetDistance(new Distance(manholeRehabilitationManholeDetailsGateway.GetTotalSurfaceArea(assetId)));
            }
        }
Ejemplo n.º 2
0
        private void LoadManholeRectangularShape(int assetId, ManholeRehabilitationManholeDetailsGateway manholeRehabilitationManholeDetailsGateway)
        {
            // ... Rectangular Shape
            // ... ... Rectangular 1
            tbxRehabilitationDataRectangle1LongSide.Text = GetValueValidForCalculationsInString(manholeRehabilitationManholeDetailsGateway.GetRectangle1LongSide(assetId));
            lblRectangular1LongSideLabel.Text = tbxRehabilitationDataRectangle1LongSide.Text;
            tbxRehabilitationDataRectangle1ShortSide.Text = GetValueValidForCalculationsInString(manholeRehabilitationManholeDetailsGateway.GetRectangle1ShortSide(assetId));
            lblRectangular1ShortSideLabel.Text = tbxRehabilitationDataRectangle1ShortSide.Text;
            tbxRehabilitationDataRectangle1Depth.Text = GetValueValidForCalculationsInString(manholeRehabilitationManholeDetailsGateway.GetTopDepth(assetId));
            lblRectangular1DephtLabel.Text = tbxRehabilitationDataRectangle1Depth.Text;

            ckbxRehabilitationDataRectangle1Floor.Checked = false;
            tbxRehabilitationDataRectangle1Floor.Text = "";
            if (manholeRehabilitationManholeDetailsGateway.GetTopFloor(assetId) != "")
            {
                ckbxRehabilitationDataRectangle1Floor.Checked = true;
                tbxRehabilitationDataRectangle1Floor.Text = GetValueValidForCalculationsInString(manholeRehabilitationManholeDetailsGateway.GetTopFloor(assetId));
            }

            ckbxRehabilitationDataRectangle1Ceiling.Checked = false;
            tbxRehabilitationDataRectangle1Ceiling.Text = "";
            if (manholeRehabilitationManholeDetailsGateway.GetTopCeiling(assetId) != "")
            {
                ckbxRehabilitationDataRectangle1Ceiling.Checked = true;
                tbxRehabilitationDataRectangle1Ceiling.Text = GetValueValidForCalculationsInString(manholeRehabilitationManholeDetailsGateway.GetTopCeiling(assetId));
                lblRectangular1CeilingLabel.Text = tbxRehabilitationDataRectangle1Ceiling.Text;
            }

            ckbxRehabilitationDataRectangle1Benching.Checked = false;
            tbxRehabilitationDataRectangle1Benching.Text = "";
            if (manholeRehabilitationManholeDetailsGateway.GetTopBenching(assetId) != "")
            {
                ckbxRehabilitationDataRectangle1Benching.Checked = true;
                tbxRehabilitationDataRectangle1Benching.Text = GetValueValidForCalculationsInString(manholeRehabilitationManholeDetailsGateway.GetTopBenching(assetId));
            }

            tbxRehabilitationDataRectangle1SurfaceArea.Text = GetValueValidForCalculationsInString(manholeRehabilitationManholeDetailsGateway.GetTopSurfaceArea(assetId));
            lblRectangle1SurfaceAreaLabel.Text = tbxRehabilitationDataRectangle1SurfaceArea.Text;

            // Recalculate rectangle 1 total surface area
            decimal rectangle1SurfaceArea = GetValueValidForCalculations(tbxRehabilitationDataRectangle1SurfaceArea.Text);
            decimal rectangle1Floor = GetValueValidForCalculations(tbxRehabilitationDataRectangle1Floor.Text);
            decimal rectangle1Ceiling = GetValueValidForCalculations(tbxRehabilitationDataRectangle1Ceiling.Text);
            decimal rectangle1Benching = GetValueValidForCalculations(tbxRehabilitationDataRectangle1Benching.Text);

            decimal rectangle1TotalSurfaceArea = decimal.Round(rectangle1SurfaceArea + rectangle1Floor + rectangle1Ceiling + rectangle1Benching, 2);
            Distance rectangle1TotalSurfaceAreaDistance = new Distance(rectangle1TotalSurfaceArea.ToString());
            tbxRehabilitationDataRectangle1TotalSurfaceArea.Text = rectangle1TotalSurfaceAreaDistance.ToStringInEng3();

            // ... ... Rectangular 2
            tbxRehabilitationDataRectangle2LongSide.Text = GetValueValidForCalculationsInString(manholeRehabilitationManholeDetailsGateway.GetRectangle2LongSide(assetId));
            lblRectangle2LongSideLabel.Text = tbxRehabilitationDataRectangle2LongSide.Text;
            tbxRehabilitationDataRectangle2ShortSide.Text = GetValueValidForCalculationsInString(manholeRehabilitationManholeDetailsGateway.GetRectangle2ShortSide(assetId));
            lblRectangular2ShortSideLabel.Text = tbxRehabilitationDataRectangle2ShortSide.Text;
            tbxRehabilitationDataRectangle2Depth.Text = GetValueValidForCalculationsInString(manholeRehabilitationManholeDetailsGateway.GetDownDepth(assetId));
            lblRectangular2Depth.Text = tbxRehabilitationDataRectangle2Depth.Text;

            ckbxRehabilitationDataRectangle2Floor.Checked = false;
            tbxRehabilitationDataRectangle2Floor.Text = "";
            if (manholeRehabilitationManholeDetailsGateway.GetDownFloor(assetId) != "")
            {
                ckbxRehabilitationDataRectangle2Floor.Checked = true;
                tbxRehabilitationDataRectangle2Floor.Text = GetValueValidForCalculationsInString(manholeRehabilitationManholeDetailsGateway.GetDownFloor(assetId));
            }

            ckbxRehabilitationDataRectangle2Ceiling.Checked = false;
            tbxRehabilitationDataRectangle2Ceiling.Text = "";
            if (manholeRehabilitationManholeDetailsGateway.GetDownCeiling(assetId) != "")
            {
                ckbxRehabilitationDataRectangle2Ceiling.Checked = true;
                tbxRehabilitationDataRectangle2Ceiling.Text = GetValueValidForCalculationsInString(manholeRehabilitationManholeDetailsGateway.GetDownCeiling(assetId));
                lblRectangular2CeilingLabel.Text = tbxRehabilitationDataRectangle2Ceiling.Text;
            }

            ckbxRehabilitationDataRectangle2Benching.Checked = false;
            tbxRehabilitationDataRectangle2Benching.Text = "";
            if (manholeRehabilitationManholeDetailsGateway.GetDownBenching(assetId) != "")
            {
                ckbxRehabilitationDataRectangle2Benching.Checked = true;
                tbxRehabilitationDataRectangle2Benching.Text = GetValueValidForCalculationsInString(manholeRehabilitationManholeDetailsGateway.GetDownBenching(assetId));
            }

            tbxRehabilitationDataRectangle2SurfaceArea.Text = GetValueValidForCalculationsInString(manholeRehabilitationManholeDetailsGateway.GetDownSurfaceArea(assetId));
            lblRectangle2SurfaceAreaLabel.Text = tbxRehabilitationDataRectangle2SurfaceArea.Text;

            // Recalculate rectangle 2 total surface area
            decimal rectangle2SurfaceArea = GetValueValidForCalculations(tbxRehabilitationDataRectangle2SurfaceArea.Text);
            decimal rectangle2Floor = GetValueValidForCalculations(tbxRehabilitationDataRectangle2Floor.Text);
            decimal rectangle2Ceiling = GetValueValidForCalculations(tbxRehabilitationDataRectangle2Ceiling.Text);
            decimal rectangle2Benching = GetValueValidForCalculations(tbxRehabilitationDataRectangle2Benching.Text);

            decimal rectangle2TotalSurfaceArea = decimal.Round(rectangle2SurfaceArea + rectangle2Floor + rectangle2Ceiling + rectangle2Benching, 2);
            Distance rectangle2TotalSurfaceAreaDistance = new Distance(rectangle2TotalSurfaceArea.ToString());
            tbxRehabilitationDataRectangle2TotalSurfaceArea.Text = rectangle2TotalSurfaceAreaDistance.ToStringInEng3();

            tbxRehabilitationDataRectangularManholeRugs.Text = manholeRehabilitationManholeDetailsGateway.GetManholeRugs(assetId).ToString();

            // ... ... Totals
            tbxRehabilitationDataRectangularTotalDepth.Text = GetValueValidForCalculationsInStringWithoutDecimals(manholeRehabilitationManholeDetailsGateway.GetTotalDepth(assetId));
            lblRectangularTotalDepthLabel.Text = tbxRehabilitationDataRectangularTotalDepth.Text;
            tbxRehabilitationDataRectangularTotalSurfaceArea.Text = GetValueValidForCalculationsInStringWithoutDecimals(manholeRehabilitationManholeDetailsGateway.GetTotalSurfaceArea(assetId));
            lblRectangularTotalSurfaceAreaLabel.Text = tbxRehabilitationDataRectangularTotalSurfaceArea.Text;
        }
        /// <summary>
        ///Save
        /// </summary>
        /// <param name="countryId">countryId</param>
        /// <param name="provinceId">provinceId</param>
        /// <param name="countyId">countyId</param>
        /// <param name="cityId">cityId</param>
        /// <param name="projectId">projectId</param>
        /// <param name="companyId">companyId</param>
        public void Save(Int64? countryId, Int64? provinceId, Int64? countyId, Int64? cityId, int projectId, int companyId)
        {
            //Update Section
            ManholeRehabilitationTDS manholeChanges = (ManholeRehabilitationTDS)Data.GetChanges();

            if (manholeChanges.ManholeDetails.Rows.Count > 0)
            {
                ManholeRehabilitationManholeDetailsGateway manholeRehabilitationManholeDetailsGateway = new ManholeRehabilitationManholeDetailsGateway(manholeChanges);

                // Update sections
                foreach (ManholeRehabilitationTDS.ManholeDetailsRow manholeDetailsRow in (ManholeRehabilitationTDS.ManholeDetailsDataTable)manholeChanges.ManholeDetails)
                {
                    // Unchanged values
                    int assetId = manholeDetailsRow.AssetID;
                    string mhId = manholeDetailsRow.MHID;

                    // Original values
                    string originalLatitud = manholeRehabilitationManholeDetailsGateway.GetLatitudOriginal(assetId);
                    string originalLongitude = manholeRehabilitationManholeDetailsGateway.GetLongitudeOriginal(assetId);
                    string originalAddress = manholeRehabilitationManholeDetailsGateway.GetAddressOriginal(assetId);
                    string originalManholeShape = manholeRehabilitationManholeDetailsGateway.GetManholeShapeOriginal(assetId);
                    string originalLocation = manholeRehabilitationManholeDetailsGateway.GetLocationOriginal(assetId);
                    int? originalMaterialID = manholeRehabilitationManholeDetailsGateway.GetMaterialIDOriginal(assetId);
                    string originalTopDiameter = manholeRehabilitationManholeDetailsGateway.GetTopDiameterOriginal(assetId);
                    string originalTopDepth = manholeRehabilitationManholeDetailsGateway.GetTopDepthOriginal(assetId);
                    string originalTopFloor = manholeRehabilitationManholeDetailsGateway.GetTopFloorOriginal(assetId);
                    string originalTopCeiling = manholeRehabilitationManholeDetailsGateway.GetTopCeilingOriginal(assetId);
                    string originalTopBenching = manholeRehabilitationManholeDetailsGateway.GetTopBenchingOriginal(assetId);
                    string originalDownDiameter = manholeRehabilitationManholeDetailsGateway.GetDownDiameterOriginal(assetId);
                    string originalDownDepth = manholeRehabilitationManholeDetailsGateway.GetDownDepthOriginal(assetId);
                    string originalDownFloor = manholeRehabilitationManholeDetailsGateway.GetDownFloorOriginal(assetId);
                    string originalDownCeiling = manholeRehabilitationManholeDetailsGateway.GetDownCeilingOriginal(assetId);
                    string originalDownBenching = manholeRehabilitationManholeDetailsGateway.GetDownBenchingOriginal(assetId);
                    string originalRectangle1LongSide = manholeRehabilitationManholeDetailsGateway.GetRectangle1LongSideOriginal(assetId);
                    string originalRectangle1ShortSide = manholeRehabilitationManholeDetailsGateway.GetRectangle1ShortSideOriginal(assetId);
                    string originalRectangle2LongSide = manholeRehabilitationManholeDetailsGateway.GetRectangle2LongSideOriginal(assetId);
                    string originalRectangle2ShortSide = manholeRehabilitationManholeDetailsGateway.GetRectangle2ShortSideOriginal(assetId);
                    string originalTopSurfaceArea = manholeRehabilitationManholeDetailsGateway.GetTopSurfaceAreaOriginal(assetId);
                    string originalDownSurfaceArea = manholeRehabilitationManholeDetailsGateway.GetDownSurfaceAreaOriginal(assetId);
                    int? originalManholeRugs = manholeRehabilitationManholeDetailsGateway.GetManholeRugsOriginal(assetId);
                    string originalTotalDepth = manholeRehabilitationManholeDetailsGateway.GetTotalDepthOriginal(assetId);
                    string originalTotalSurfaceArea = manholeRehabilitationManholeDetailsGateway.GetTotalSurfaceAreaOriginal(assetId);
                    int? originalConditionRating = manholeRehabilitationManholeDetailsGateway.GetConditionRatingOriginal(assetId);

                    // New variables
                    string newLatitud = manholeRehabilitationManholeDetailsGateway.GetLatitud(assetId);
                    string newLongitude = manholeRehabilitationManholeDetailsGateway.GetLongitude(assetId);
                    string newAddress = manholeRehabilitationManholeDetailsGateway.GetAddress(assetId);
                    string newManholeShape = manholeRehabilitationManholeDetailsGateway.GetManholeShape(assetId);
                    string newLocation = manholeRehabilitationManholeDetailsGateway.GetLocation(assetId);
                    int? newMaterialID = manholeRehabilitationManholeDetailsGateway.GetMaterialID(assetId);
                    string newTopDiameter = manholeRehabilitationManholeDetailsGateway.GetTopDiameter(assetId);
                    string newTopDepth = manholeRehabilitationManholeDetailsGateway.GetTopDepth(assetId);
                    string newTopFloor = manholeRehabilitationManholeDetailsGateway.GetTopFloor(assetId);
                    string newTopCeiling = manholeRehabilitationManholeDetailsGateway.GetTopCeiling(assetId);
                    string newTopBenching = manholeRehabilitationManholeDetailsGateway.GetTopBenching(assetId);
                    string newDownDiameter = manholeRehabilitationManholeDetailsGateway.GetDownDiameter(assetId);
                    string newDownDepth = manholeRehabilitationManholeDetailsGateway.GetDownDepth(assetId);
                    string newDownFloor = manholeRehabilitationManholeDetailsGateway.GetDownFloor(assetId);
                    string newDownCeiling = manholeRehabilitationManholeDetailsGateway.GetDownCeiling(assetId);
                    string newDownBenching = manholeRehabilitationManholeDetailsGateway.GetDownBenching(assetId);
                    string newRectangle1LongSide = manholeRehabilitationManholeDetailsGateway.GetRectangle1LongSide(assetId);
                    string newRectangle1ShortSide = manholeRehabilitationManholeDetailsGateway.GetRectangle1ShortSide(assetId);
                    string newRectangle2LongSide = manholeRehabilitationManholeDetailsGateway.GetRectangle2LongSide(assetId);
                    string newRectangle2ShortSide = manholeRehabilitationManholeDetailsGateway.GetRectangle2ShortSide(assetId);
                    string newTopSurfaceArea = manholeRehabilitationManholeDetailsGateway.GetTopSurfaceArea(assetId);
                    string newDownSurfaceArea = manholeRehabilitationManholeDetailsGateway.GetDownSurfaceArea(assetId);
                    int? newManholeRugs = manholeRehabilitationManholeDetailsGateway.GetManholeRugs(assetId);
                    string newTotalDepth = manholeRehabilitationManholeDetailsGateway.GetTotalDepth(assetId);
                    string newTotalSurfaceArea = manholeRehabilitationManholeDetailsGateway.GetTotalSurfaceArea(assetId);
                    int? newConditionRating = manholeRehabilitationManholeDetailsGateway.GetConditionRating(assetId);

                    // Update
                    AssetSewerMHGateway assetSewerMHGateway = new AssetSewerMHGateway();
                    assetSewerMHGateway.LoadByAssetId(assetId, companyId);

                    if (assetSewerMHGateway.Table.Rows.Count > 0)
                    {
                        // ... update asset manhole
                        AssetSewerMH assetSewerMH = new AssetSewerMH(assetSewerMHGateway.Data);
                        assetSewerMH.UpdateDirect(assetId, mhId, originalLatitud, originalLongitude, originalAddress, originalManholeShape, originalLocation, originalMaterialID, originalTopDiameter, originalTopDepth, originalTopFloor, originalTopCeiling, originalTopBenching, originalDownDiameter, originalDownDepth, originalDownFloor, originalDownCeiling, originalDownBenching, originalRectangle1LongSide, originalRectangle1ShortSide, originalRectangle2LongSide, originalRectangle2ShortSide, originalTopSurfaceArea, originalDownSurfaceArea, originalManholeRugs, originalTotalDepth, originalTotalSurfaceArea, false, companyId, assetId, mhId, newLatitud, newLongitude, newAddress, newManholeShape, newLocation, newMaterialID, newTopDiameter, newTopDepth, newTopFloor, newTopCeiling, newTopBenching, newDownDiameter, newDownDepth, newDownFloor, newDownCeiling, newDownBenching, newRectangle1LongSide, newRectangle1ShortSide, newRectangle2LongSide, newRectangle2ShortSide, newTopSurfaceArea, newDownSurfaceArea, newManholeRugs, newTotalDepth, newTotalSurfaceArea, false, companyId);

                        // ... update lfs manhole
                        LfsAssetSewerMH lfsAssetSewerMH = new LfsAssetSewerMH(null);
                        lfsAssetSewerMH.UpdateDirect(assetId, false, companyId, originalConditionRating, false, companyId, newConditionRating);
                    }
                }
            }
        }
Ejemplo n.º 4
0
        private void LoadManholeMixShape(int assetId, ManholeRehabilitationManholeDetailsGateway manholeRehabilitationManholeDetailsGateway)
        {
            // ... Mix Shape
            // ... ... Top
            tbxRehabilitationDataRoundDiameter.Text = GetValueValidForCalculationsInString(manholeRehabilitationManholeDetailsGateway.GetTopDiameter(assetId));
            lblDataRoundDiameterLabel.Text = tbxRehabilitationDataRoundDiameter.Text;
            tbxRehabilitationDataRoundDepth.Text = GetValueValidForCalculationsInString(manholeRehabilitationManholeDetailsGateway.GetTopDepth(assetId));
            lblDataRoundDepthLabel.Text = tbxRehabilitationDataRoundDepth.Text;

            ckbxRehabilitationDataRoundFloor.Checked = false;
            tbxRehabilitationDataRoundFloor.Text = "";
            if (manholeRehabilitationManholeDetailsGateway.GetTopFloor(assetId) != "")
            {
                ckbxRehabilitationDataRoundFloor.Checked = true;
                tbxRehabilitationDataRoundFloor.Text = GetValueValidForCalculationsInString(manholeRehabilitationManholeDetailsGateway.GetTopFloor(assetId));
            }

            ckbxRehabilitationDataRoundCeiling.Checked = false;
            tbxRehabilitationDataRoundCeiling.Text = "";
            if (manholeRehabilitationManholeDetailsGateway.GetTopCeiling(assetId) != "")
            {
                ckbxRehabilitationDataRoundCeiling.Checked = true;
                tbxRehabilitationDataRoundCeiling.Text = GetValueValidForCalculationsInString(manholeRehabilitationManholeDetailsGateway.GetTopCeiling(assetId));
                lblDataRoundCeilingLabel.Text = tbxRehabilitationDataRoundCeiling.Text;
            }

            ckbxRehabilitationDataRoundBenching.Checked = false;
            tbxRehabilitationDataRoundBenching.Text = "";
            if (manholeRehabilitationManholeDetailsGateway.GetTopBenching(assetId) != "")
            {
                ckbxRehabilitationDataRoundBenching.Checked = true;
                tbxRehabilitationDataRoundBenching.Text = GetValueValidForCalculationsInString(manholeRehabilitationManholeDetailsGateway.GetTopBenching(assetId));
            }

            tbxRehabilitationDataRoundSurfaceArea.Text = GetValueValidForCalculationsInString(manholeRehabilitationManholeDetailsGateway.GetTopSurfaceArea(assetId));
            lblDataRoundSurfaceAreaLabel.Text = tbxRehabilitationDataRoundSurfaceArea.Text;

            // Recalculate Top total surface area
            decimal roundSurfaceArea = GetValueValidForCalculations(tbxRehabilitationDataRoundSurfaceArea.Text);
            decimal roundFloor = GetValueValidForCalculations(tbxRehabilitationDataRoundFloor.Text);
            decimal roundCeiling = GetValueValidForCalculations(tbxRehabilitationDataRoundCeiling.Text);
            decimal roundBenching = GetValueValidForCalculations(tbxRehabilitationDataRoundBenching.Text);

            decimal roundTotalSurfaceArea = decimal.Round(roundSurfaceArea + roundFloor + roundCeiling + roundBenching, 2);
            Distance roundTotalSurfaceAreaDistance = new Distance(roundTotalSurfaceArea.ToString());
            tbxRehabilitationDataMixedRoundTotalSurfaceArea.Text = roundTotalSurfaceAreaDistance.ToStringInEng3();

            // ... ... Down
            tbxRehabilitationDataRectangleLongSide.Text = GetValueValidForCalculationsInString(manholeRehabilitationManholeDetailsGateway.GetRectangle2LongSide(assetId));
            lblRectangleLongSideLabel.Text = tbxRehabilitationDataRectangleLongSide.Text;
            tbxRehabilitationDataRectangleShortSide.Text = GetValueValidForCalculationsInString(manholeRehabilitationManholeDetailsGateway.GetRectangle2ShortSide(assetId));
            lblRectangleShortSideLabel.Text = tbxRehabilitationDataRectangleShortSide.Text;
            tbxRehabilitationDataRectangleDepth.Text = GetValueValidForCalculationsInString(manholeRehabilitationManholeDetailsGateway.GetDownDepth(assetId));
            lblRectangleDepthLabel.Text = tbxRehabilitationDataRectangleDepth.Text;

            ckbxRehabilitationDataRectangleFloor.Checked = false;
            tbxRehabilitationDataRectangleFloor.Text = "";
            if (manholeRehabilitationManholeDetailsGateway.GetDownFloor(assetId) != "")
            {
                ckbxRehabilitationDataRectangleFloor.Checked = true;
                tbxRehabilitationDataRectangleFloor.Text = GetValueValidForCalculationsInString(manholeRehabilitationManholeDetailsGateway.GetDownFloor(assetId));
            }

            ckbxRehabilitationDataRectangleCeiling.Checked = false;
            tbxRehabilitationDataRectangleCeiling.Text = "";
            if (manholeRehabilitationManholeDetailsGateway.GetDownCeiling(assetId) != "")
            {
                ckbxRehabilitationDataRectangleCeiling.Checked = true;
                tbxRehabilitationDataRectangleCeiling.Text = GetValueValidForCalculationsInString(manholeRehabilitationManholeDetailsGateway.GetDownCeiling(assetId));
                lblRectangleCeilingLabel.Text = tbxRehabilitationDataRectangleCeiling.Text;
            }

            ckbxRehabilitationDataBenching.Checked = false;
            tbxRehabilitationDataBenching.Text = "";
            if (manholeRehabilitationManholeDetailsGateway.GetDownBenching(assetId) != "")
            {
                ckbxRehabilitationDataBenching.Checked = true;
                tbxRehabilitationDataBenching.Text = GetValueValidForCalculationsInString(manholeRehabilitationManholeDetailsGateway.GetDownBenching(assetId));
            }

            tbxRehabilitationDataRectangularSufaceArea.Text = GetValueValidForCalculationsInString(manholeRehabilitationManholeDetailsGateway.GetDownSurfaceArea(assetId));
            lblRectangleSurfaceAreaLabel.Text = tbxRehabilitationDataRectangularSufaceArea.Text;

            // Recalculate Top total surface area
            decimal mixesRectangleSurfaceArea = GetValueValidForCalculations(tbxRehabilitationDataRectangularSufaceArea.Text);
            decimal mixesRectangleFloor = GetValueValidForCalculations(tbxRehabilitationDataRectangleFloor.Text);
            decimal mixesRectangleCeiling = GetValueValidForCalculations(tbxRehabilitationDataRectangleCeiling.Text);
            decimal mixesRectangleBenching = GetValueValidForCalculations(tbxRehabilitationDataBenching.Text);

            decimal mixesRectangleTotalSurfaceArea = decimal.Round(mixesRectangleSurfaceArea + mixesRectangleFloor + mixesRectangleCeiling + mixesRectangleBenching, 2);
            Distance mixesRectangleTotalSurfaceAreaDistance = new Distance(mixesRectangleTotalSurfaceArea.ToString());
            tbxRehabilitationDataMixedRectangleTotalSurfaceArea.Text = mixesRectangleTotalSurfaceAreaDistance.ToStringInEng3();

            tbxRehabilitationDataManholeRugs.Text = manholeRehabilitationManholeDetailsGateway.GetManholeRugs(assetId).ToString();

            // ... ... Totals
            tbxRehabilitationDataTotalDepth.Text = GetValueValidForCalculationsInStringWithoutDecimals(manholeRehabilitationManholeDetailsGateway.GetTotalDepth(assetId));
            lblMixedTotalDepthLabel.Text = tbxRehabilitationDataTotalDepth.Text;
            tbxRehabilitationDataTotalSurfaceArea.Text = GetValueValidForCalculationsInStringWithoutDecimals(manholeRehabilitationManholeDetailsGateway.GetTotalSurfaceArea(assetId));
            lblTotalMixedSurfaceAreaLabel.Text = tbxRehabilitationDataTotalSurfaceArea.Text;
        }