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 LoadManholeStructureDataForChange(int assetId)
{
ManholeRehabilitationManholeDetailsGateway manholeRehabilitationManholeDetailsGateway = new ManholeRehabilitationManholeDetailsGateway(manholeRehabilitationTDS);
if (manholeRehabilitationManholeDetailsGateway.Table.Rows.Count > 0)
{
// Load manhole structure information
if (hdfSavedShape.Value == ddlShape.SelectedValue)
{
LoadManholeStructureData(assetId);
}
else
{
// ... Round shape
// ... ... Chimney
tbxRehabilitationDataChimneyDiameter.Text = "";
tbxRehabilitationDataChimneyDepth.Text = "";
ckbxRehabilitationDataChimneyFloor.Checked = false;
tbxRehabilitationDataChimneyFloor.Text = "";
ckbxRehabilitationDataChimneyCeiling.Checked = false;
tbxRehabilitationDataChimneyCeiling.Text = "";
ckbxRehabilitationDataChimneyBenching.Checked = false;
tbxRehabilitationDataChimneyBenching.Text = "";
tbxRehabilitationDataChimneySurfaceArea.Text = "";
// ... ... Barrel
tbxRehabilitationDataBarrelDiameter.Text = "";
tbxRehabilitationDataBarrelDepth.Text = "";
ckbxRehabilitationDataBarrelFloor.Checked = false;
tbxRehabilitationDataBarrelFloor.Text = "";
ckbxRehabilitationDataBarrelCeiling.Checked = false;
tbxRehabilitationDataBarrelCeiling.Text = "";
ckbxRehabilitationDataBarrelBenching.Checked = false;
tbxRehabilitationDataBarrelBenching.Text = "";
tbxRehabilitationDataBarrelSurfaceArea.Text = "";
ddlRehabilitationDataRoundManholeRugs.SelectedIndex = 1;
// ... ... Totals
tbxRehabilitationDataRoundTotalDepth.Text = "";
tbxRehabilitationDataRoundTotalSurfaceArea.Text = "";
// ... Rectangular Shape
// ... ... Rectangular 1
tbxRehabilitationDataRectangle1LongSide.Text = "";
tbxRehabilitationDataRectangle1ShortSide.Text = "";
tbxRehabilitationDataRectangle1Depth.Text = "";
ckbxRehabilitationDataRectangle1Floor.Checked = false;
tbxRehabilitationDataRectangle1Floor.Text = "";
ckbxRehabilitationDataRectangle1Ceiling.Checked = false;
tbxRehabilitationDataRectangle1Ceiling.Text = "";
ckbxRehabilitationDataRectangle1Benching.Checked = false;
tbxRehabilitationDataRectangle1Benching.Text = "";
tbxRehabilitationDataRectangle1SurfaceArea.Text = "";
// ... ... Rectangular 2
tbxRehabilitationDataRectangle2LongSide.Text = "";
tbxRehabilitationDataRectangle2ShortSide.Text = "";
tbxRehabilitationDataRectangle2Depth.Text = "";
ckbxRehabilitationDataRectangle2Floor.Checked = false;
tbxRehabilitationDataRectangle2Floor.Text = "";
ckbxRehabilitationDataRectangle2Ceiling.Checked = false;
tbxRehabilitationDataRectangle2Ceiling.Text = "";
ckbxRehabilitationDataRectangle2Benching.Checked = false;
tbxRehabilitationDataRectangle2Benching.Text = "";
tbxRehabilitationDataRectangle2SurfaceArea.Text = "";
ddlRehabilitationDataRectangularManholeRugs.SelectedIndex = 1;
// ... ... Totals
tbxRehabilitationDataRectangularTotalDepth.Text = "";
tbxRehabilitationDataRectangularTotalSurfaceArea.Text = "";
// ... Mix Shape
// ... ... Top
tbxRehabilitationDataRoundDiameter.Text = "";
tbxRehabilitationDataRoundDepth.Text = "";
ckbxRehabilitationDataRoundFloor.Checked = false;
tbxRehabilitationDataRoundFloor.Text = "";
ckbxRehabilitationDataRoundCeiling.Checked = false;
tbxRehabilitationDataRoundCeiling.Text = "";
ckbxRehabilitationDataRoundBenching.Checked = false;
tbxRehabilitationDataRoundBenching.Text = "";
tbxRehabilitationDataRoundSurfaceArea.Text = "";
// ... ... Down
tbxRehabilitationDataRectangleLongSide.Text = "";
tbxRehabilitationDataRectangleShortSide.Text = "";
tbxRehabilitationDataRectangleDepth.Text = "";
ckbxRehabilitationDataRectangleFloor.Checked = false;
tbxRehabilitationDataRectangleFloor.Text = "";
ckbxRehabilitationDataRectangleCeiling.Checked = false;
tbxRehabilitationDataRectangleCeiling.Text = "";
ckbxRehabilitationDataRectangleBenching.Checked = false;
tbxRehabilitationDataRectangleBenching.Text = "";
tbxRehabilitationDataRectangleSufaceArea.Text = "";
ddlRehabilitationDataMixManholeRugs.SelectedIndex = 1;
// ... ... Totals
tbxRehabilitationDataMixedTotalDepth.Text = "";
tbxRehabilitationDataMixedTotalSurfaceArea.Text = "";
// ... Other shape
tbxRehabilitationDataOtherStructure.Text = "";
// ... graphic
lblRoudChimneyDiameterLabel.Text = "";
lblRoudChimneyCeilingLabel.Text = "";
lblRoudChimneyDepthLabel.Text = "";
lblRoundChimneySurfaceAreaLabel.Text = "";
lblRoundTotalDepthLabel.Text = "";
lblRoundBarrelCeilingLabel.Text = "";
lblRoudBarrelDepthLabel.Text = "";
lblRoundBarrelSurfaceAreaLabel.Text = "";
lblRoudBarrelDiameterLabel.Text = "";
lblRoundTotalSurfaceArea.Text = "";
lblRectangular1ShortSideLabel.Text = "";
lblRectangular1CeilingLabel.Text = "";
lblRectangular1LongSideLabel.Text = "";
lblRectangle1SurfaceAreaLabel.Text = "";
lblRectangular1DephtLabel.Text = "";
lblRectangularTotalDepthLabel.Text = "";
lblRectangular2CeilingLabel.Text = "";
lblRectangular2Depth.Text = "";
lblRectangle2LongSideLabel.Text = "";
lblRectangle2SurfaceAreaLabel.Text = "";
lblRectangular2ShortSideLabel.Text = "";
lblRectangularTotalSurfaceAreaLabel.Text = "";
lblRectangleShortSideLabel.Text = "";
lblRectangleCeilingLabel.Text = "";
lblRectangleLongSideLabel.Text = "";
lblRectangleSurfaceAreaLabel.Text = "";
lblRectangleDephtLabel.Text = "";
lblMixedTotalDepthLabel.Text = "";
lblDataRoundCeilingLabel.Text = "";
lblDataRoundDepthLabel.Text = "";
lblDataRoundSurfaceAreaLabel.Text = "";
lblDataRoundDiameterLabel.Text = "";
lblTotalMixedSurfaceAreaLabel.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 LoadManholeData(int assetId)
{
ManholeRehabilitationManholeDetailsGateway manholeRehabilitationManholeDetailsGateway = new ManholeRehabilitationManholeDetailsGateway(manholeRehabilitationTDS);
if (manholeRehabilitationManholeDetailsGateway.Table.Rows.Count > 0)
{
// Load Manhole Details for header
tbxManholeNumber.Text = manholeRehabilitationManholeDetailsGateway.GetMHID(assetId);
tbxStreet.Text = manholeRehabilitationManholeDetailsGateway.GetAddress(assetId);
tbxLongitude.Text = manholeRehabilitationManholeDetailsGateway.GetLongitude(assetId);
tbxLatitude.Text = manholeRehabilitationManholeDetailsGateway.GetLatitud(assetId);
if (manholeRehabilitationManholeDetailsGateway.GetManholeShape(assetId) == "")
{
ddlShape.SelectedValue = "";
hdfSavedShape.Value = "";
}
else
{
ddlShape.SelectedValue = manholeRehabilitationManholeDetailsGateway.GetManholeShape(assetId);
hdfSavedShape.Value = manholeRehabilitationManholeDetailsGateway.GetManholeShape(assetId);
}
if (manholeRehabilitationManholeDetailsGateway.GetMaterialID(assetId).HasValue)
{
int? materialId = manholeRehabilitationManholeDetailsGateway.GetMaterialID(assetId);
int materialsId = (int)materialId;
ddlMaterial.SelectedValue = materialsId.ToString();
}
else
{
ddlMaterial.SelectedIndex = 0;
}
if (manholeRehabilitationManholeDetailsGateway.GetLocation(assetId) == "")
{
ddlLocation.SelectedValue = "";
}
else
{
ddlLocation.SelectedValue = manholeRehabilitationManholeDetailsGateway.GetLocation(assetId);
}
if (manholeRehabilitationManholeDetailsGateway.GetConditionRating(assetId).HasValue)
{
ddlConditioningRating.SelectedValue = manholeRehabilitationManholeDetailsGateway.GetConditionRating(assetId).ToString();
}
else
{
ddlConditioningRating.SelectedValue = "-1";
}
}
}
private void LoadManholeRoundShape(int assetId, ManholeRehabilitationManholeDetailsGateway manholeRehabilitationManholeDetailsGateway)
{
// Load manhole structure information
// ... Round shape
// ... ... Chimney
tbxRehabilitationDataChimneyDiameter.Text = GetValueValidForCalculationsInString(manholeRehabilitationManholeDetailsGateway.GetTopDiameter(assetId));
lblRoudChimneyDiameterLabel.Text = tbxRehabilitationDataChimneyDiameter.Text;
tbxRehabilitationDataChimneyDepth.Text = GetValueValidForCalculationsInString(manholeRehabilitationManholeDetailsGateway.GetTopDepth(assetId));
lblRoudChimneyDepthLabel.Text = tbxRehabilitationDataChimneyDepth.Text;
ckbxRehabilitationDataChimneyFloor.Checked = false;
tbxRehabilitationDataChimneyFloor.Text = "";
if (manholeRehabilitationManholeDetailsGateway.GetTopFloor(assetId) != "")
{
ckbxRehabilitationDataChimneyFloor.Checked = true;
tbxRehabilitationDataChimneyFloor.Text = GetValueValidForCalculationsInString(manholeRehabilitationManholeDetailsGateway.GetTopFloor(assetId));
}
ckbxRehabilitationDataChimneyCeiling.Checked = false;
tbxRehabilitationDataChimneyCeiling.Text = "";
if (manholeRehabilitationManholeDetailsGateway.GetTopCeiling(assetId) != "")
{
ckbxRehabilitationDataChimneyCeiling.Checked = true;
tbxRehabilitationDataChimneyCeiling.Text = GetValueValidForCalculationsInString(manholeRehabilitationManholeDetailsGateway.GetTopCeiling(assetId));
lblRoudChimneyCeilingLabel.Text = tbxRehabilitationDataChimneyCeiling.Text;
}
ckbxRehabilitationDataChimneyBenching.Checked = false;
tbxRehabilitationDataChimneyBenching.Text = "";
if (manholeRehabilitationManholeDetailsGateway.GetTopBenching(assetId) != "")
{
ckbxRehabilitationDataChimneyBenching.Checked = true;
tbxRehabilitationDataChimneyBenching.Text = GetValueValidForCalculationsInString(manholeRehabilitationManholeDetailsGateway.GetTopBenching(assetId));
}
ckbxRehabilitationDataChimneySurfaceArea.Checked = false;
tbxRehabilitationDataChimneySurfaceArea.Text = "";
if (manholeRehabilitationManholeDetailsGateway.GetTopSurfaceArea(assetId) != "")
{
ckbxRehabilitationDataChimneySurfaceArea.Checked = true;
tbxRehabilitationDataChimneySurfaceArea.Text = GetValueValidForCalculationsInString(manholeRehabilitationManholeDetailsGateway.GetTopSurfaceArea(assetId));
lblRoundChimneySurfaceAreaLabel.Text = tbxRehabilitationDataChimneySurfaceArea.Text;
}
// Recalculate Top total surface area
decimal chimneySurfaceArea = GetValueValidForCalculations(tbxRehabilitationDataChimneySurfaceArea.Text);
decimal chimneyFloor = GetValueValidForCalculations(tbxRehabilitationDataChimneyFloor.Text);
decimal chimneyCeiling = GetValueValidForCalculations(tbxRehabilitationDataChimneyCeiling.Text);
decimal chimneyBenching = GetValueValidForCalculations(tbxRehabilitationDataChimneyBenching.Text);
decimal chimneyTotalSurfaceArea = decimal.Round(chimneySurfaceArea + chimneyFloor + chimneyCeiling + chimneyBenching, 2);
Distance chimneyTotalSurfaceAreaDistance = new Distance(chimneyTotalSurfaceArea.ToString());
tbxRehabilitationDataChimneyTotalSurfaceArea.Text = chimneyTotalSurfaceAreaDistance.ToStringInEng3();
// ... ... Barrel
tbxRehabilitationDataBarrelDiameter.Text = GetValueValidForCalculationsInString(manholeRehabilitationManholeDetailsGateway.GetDownDiameter(assetId));
lblRoudBarrelDiameterLabel.Text = tbxRehabilitationDataBarrelDiameter.Text;
tbxRehabilitationDataBarrelDepth.Text = GetValueValidForCalculationsInString(manholeRehabilitationManholeDetailsGateway.GetDownDepth(assetId));
lblRoudBarrelDepthLabel.Text = tbxRehabilitationDataBarrelDepth.Text;
ckbxRehabilitationDataBarrelFloor.Checked = false;
tbxRehabilitationDataBarrelFloor.Text = "";
if (manholeRehabilitationManholeDetailsGateway.GetDownFloor(assetId) != "")
{
ckbxRehabilitationDataBarrelFloor.Checked = true;
tbxRehabilitationDataBarrelFloor.Text = GetValueValidForCalculationsInString(manholeRehabilitationManholeDetailsGateway.GetDownFloor(assetId));
}
ckbxRehabilitationDataBarrelCeiling.Checked = false;
tbxRehabilitationDataBarrelCeiling.Text = "";
if (manholeRehabilitationManholeDetailsGateway.GetDownCeiling(assetId) != "")
{
ckbxRehabilitationDataBarrelCeiling.Checked = true;
tbxRehabilitationDataBarrelCeiling.Text = GetValueValidForCalculationsInString(manholeRehabilitationManholeDetailsGateway.GetDownCeiling(assetId));
lblRoundBarrelCeilingLabel.Text = tbxRehabilitationDataBarrelCeiling.Text;
}
ckbxRehabilitationDataBarrelBenching.Checked = false;
tbxRehabilitationDataBarrelBenching.Text = "";
if (manholeRehabilitationManholeDetailsGateway.GetDownBenching(assetId) != "")
{
ckbxRehabilitationDataBarrelBenching.Checked = true;
tbxRehabilitationDataBarrelBenching.Text = GetValueValidForCalculationsInString(manholeRehabilitationManholeDetailsGateway.GetDownBenching(assetId));
}
tbxRehabilitationDataBarrelSurfaceArea.Text = manholeRehabilitationManholeDetailsGateway.GetDownSurfaceArea(assetId);
lblRoundBarrelSurfaceAreaLabel.Text = tbxRehabilitationDataBarrelSurfaceArea.Text;
// Recalculate Top total surface area
decimal barrelSurfaceArea = GetValueValidForCalculations(tbxRehabilitationDataBarrelSurfaceArea.Text);
decimal barrelFloor = GetValueValidForCalculations(tbxRehabilitationDataBarrelFloor.Text);
decimal barrelCeiling = GetValueValidForCalculations(tbxRehabilitationDataBarrelCeiling.Text);
decimal barrelBenching = GetValueValidForCalculations(tbxRehabilitationDataBarrelBenching.Text);
decimal barrelTotalSurfaceArea = decimal.Round(barrelSurfaceArea + barrelFloor + barrelCeiling + barrelBenching, 2);
Distance barrelTotalSurfaceAreaDistance = new Distance(barrelTotalSurfaceArea.ToString());
tbxRehabilitationDataBarrelTotalSurfaceArea.Text = barrelTotalSurfaceAreaDistance.ToStringInEng3();
tbxRehabilitationDataBarrelManholeRugs.Text = manholeRehabilitationManholeDetailsGateway.GetManholeRugs(assetId).ToString();
// ... ... Totals
tbxRehabilitationDataRoundTotalDepth.Text = GetValueValidForCalculationsInStringWithoutDecimals(manholeRehabilitationManholeDetailsGateway.GetTotalDepth(assetId));
lblRoundTotalDepthLabel.Text = tbxRehabilitationDataRoundTotalDepth.Text;
tbxRehabilitationDataRoundTotalSurfaceArea.Text = GetValueValidForCalculationsInStringWithoutDecimals(manholeRehabilitationManholeDetailsGateway.GetTotalSurfaceArea(assetId));
lblRoundTotalSurfaceArea.Text = tbxRehabilitationDataRoundTotalSurfaceArea.Text;
}
// ////////////////////////////////////////////////////////////////////////
// PUBLIC METHODS
//
/// <summary>
/// LoadByAssetId
/// </summary>
/// <param name="assetId">assetId</param>
/// <param name="companyId">companyId</param>
public void LoadByAssetId(int assetId, int companyId)
{
ManholeRehabilitationManholeDetailsGateway manholeRehabilitationManholeDetailsGateway = new ManholeRehabilitationManholeDetailsGateway(Data);
manholeRehabilitationManholeDetailsGateway.LoadByAssetId(assetId, companyId);
}
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;
}
private void LoadManholeOtherShape(int assetId, ManholeRehabilitationManholeDetailsGateway manholeRehabilitationManholeDetailsGateway)
{
// ... Other shape
tbxRehabilitationDataOtherStructure.Text = GetValueValidForCalculationsInString(manholeRehabilitationManholeDetailsGateway.GetTotalSurfaceArea(assetId));
}
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;
}
private void LoadManholeGeneralDetailDate(int assetId, ManholeRehabilitationManholeDetailsGateway manholeRehabilitationManholeDetailsGateway)
{
// Load Manhole Details for header
tbxManholeNumber.Text = manholeRehabilitationManholeDetailsGateway.GetMHID(assetId);
tbxStreet.Text = manholeRehabilitationManholeDetailsGateway.GetAddress(assetId);
tbxLongitude.Text = manholeRehabilitationManholeDetailsGateway.GetLongitude(assetId);
tbxLatitude.Text = manholeRehabilitationManholeDetailsGateway.GetLatitud(assetId);
tbxShape.Text = manholeRehabilitationManholeDetailsGateway.GetManholeShape(assetId);
if (manholeRehabilitationManholeDetailsGateway.GetMaterialID(assetId).HasValue)
{
int companyId = Int32.Parse(hdfCompanyId.Value);
int? materialId = manholeRehabilitationManholeDetailsGateway.GetMaterialID(assetId);
AssetSewerMHMaterialTypeGateway assetSewerMHMaterialTypeGateway = new AssetSewerMHMaterialTypeGateway();
assetSewerMHMaterialTypeGateway.LoadByMaterialId((int)materialId, companyId);
tbxMaterial.Text = assetSewerMHMaterialTypeGateway.GetMaterialType((int)materialId);
}
else
{
tbxMaterial.Text = "";
}
tbxLocation.Text = manholeRehabilitationManholeDetailsGateway.GetLocation(assetId);
tbxConditioningRating.Text = "";
if (manholeRehabilitationManholeDetailsGateway.GetConditionRating(assetId).HasValue)
{
tbxConditioningRating.Text = manholeRehabilitationManholeDetailsGateway.GetConditionRating(assetId).ToString();
}
}
private void LoadManholeData(int assetId)
{
ManholeRehabilitationManholeDetailsGateway manholeRehabilitationManholeDetailsGateway = new ManholeRehabilitationManholeDetailsGateway(manholeRehabilitationTDS);
if (manholeRehabilitationManholeDetailsGateway.Table.Rows.Count > 0)
{
LoadManholeGeneralDetailDate(assetId, manholeRehabilitationManholeDetailsGateway);
LoadManholeRoundShape(assetId, manholeRehabilitationManholeDetailsGateway);
LoadManholeRectangularShape(assetId, manholeRehabilitationManholeDetailsGateway);
LoadManholeMixShape(assetId, manholeRehabilitationManholeDetailsGateway);
LoadManholeOtherShape(assetId, manholeRehabilitationManholeDetailsGateway);
}
}
