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