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