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)));
}
}
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);
}
}
}
}
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;
}