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