public String[] GetMHList(string prefixText, int count, string contextKey) { // split country, province, ... string[] location = Regex.Split(contextKey, ","); Int64 countryId = Int64.Parse(location[0]); Int64? provinceId = null; if (location[1] != "0") provinceId = Int64.Parse(location[1]); Int64? countyId = null; if (location[2] != "0") countyId = Int64.Parse(location[2]); Int64? cityId = null; if (location[3] != "0") cityId = Int64.Parse(location[3]); int companyId = int.Parse(location[4]); // load MHs AssetSewerMHGateway assetSewerMhGateway = new AssetSewerMHGateway(); assetSewerMhGateway.LoadSimilarTop12ByCountryIdProvinceIdCountyIdCityIdMhId(countryId, provinceId, countyId, cityId, prefixText, companyId); // process list and return if (assetSewerMhGateway.Table.Rows.Count == 0) { return new string[0]; } else { List<string> items = new List<string>(count); for (int i = 0; (i < count) & (i < assetSewerMhGateway.Table.Rows.Count); i++) { items.Add(assetSewerMhGateway.Table.Rows[i]["MHID"].ToString()); } return items.ToArray(); } }
/// <summary> /// DeleteDirect /// </summary> /// <param name="assetId">assetId</param> /// <param name="companyId">companyId</param> public bool DeleteDirect(int assetId, int companyId) { if (!InUse(assetId, companyId)) { AssetSewerMHGateway assetSewerMhGateway = new AssetSewerMHGateway(null); assetSewerMhGateway.Delete(assetId, companyId); AssetSewer assetSewer = new AssetSewer(null); assetSewer.DeleteDirect(assetId, companyId); Asset asset = new Asset(null); asset.DeleteDirect(assetId, companyId); return true; } else { return false; } }
protected void cvUsmhDsmhDBEdit_ServerValidate(object source, ServerValidateEventArgs args) { // Initialize args.IsValid = true; // Validate if mh already exists int companyId = Int32.Parse(hdfCompanyId.Value); Int64? countryId = null; if (hdfCountryId.Value != "0") countryId = Int64.Parse(hdfCountryId.Value); Int64? provinceId = null; if (hdfProvinceId.Value != "0") provinceId = Int64.Parse(hdfProvinceId.Value); Int64? countyId = null; if (hdfCountyId.Value != "0") countyId = Int64.Parse(hdfCountyId.Value); Int64? cityId = null; if (hdfCityId.Value != "0") cityId = Int64.Parse(hdfCityId.Value); int projectId = int.Parse(hdfProjectId.Value); CustomValidator cvUsmhDsmhDBEdit = (CustomValidator)source; GridViewRow gridRow = (GridViewRow)cvUsmhDsmhDBEdit.NamingContainer; string usmh = ((TextBox)gridRow.FindControl("tbxUsmhEdit")).Text; string dsmh = ((TextBox)gridRow.FindControl("tbxDsmhEdit")).Text; AssetSewerMHGateway assetSewerMhGatewayUSMH = new AssetSewerMHGateway(); assetSewerMhGatewayUSMH.LoadByCountryIdProvinceIdCountyIdCityIdMhId(countryId, provinceId, countyId, cityId, usmh, companyId, "", "", "");//TODO MH AssetSewerMHGateway assetSewerMhGatewayDSMH = new AssetSewerMHGateway(); assetSewerMhGatewayDSMH.LoadByCountryIdProvinceIdCountyIdCityIdMhId(countryId, provinceId, countyId, cityId, dsmh, companyId, "", "", "");//TODO MH if (assetSewerMhGatewayUSMH.Table.Rows.Count > 0 && assetSewerMhGatewayDSMH.Table.Rows.Count > 0) { int assetIdUsmh = assetSewerMhGatewayUSMH.GetAssetID(usmh); int assetIdDsmh = assetSewerMhGatewayDSMH.GetAssetID(dsmh); AssetSewerMHGateway assetSewerMhGateway = new AssetSewerMHGateway(null); if (assetSewerMhGateway.USmhDsmhInUseForSections(assetIdUsmh, assetIdDsmh, companyId)) { args.IsValid = false; } } }
protected void cvUsmhDsmhDBAdd_ServerValidate(object source, ServerValidateEventArgs args) { bool usmhAndDsmhValid = true; args.IsValid = true; // Validate if mh already exists int companyId = Int32.Parse(hdfCompanyId.Value); Int64? countryId = null; if (hdfCountryId.Value != "0") countryId = Int64.Parse(hdfCountryId.Value); Int64? provinceId = null; if (hdfProvinceId.Value != "0") provinceId = Int64.Parse(hdfProvinceId.Value); Int64? countyId = null; if (hdfCountyId.Value != "0") countyId = Int64.Parse(hdfCountyId.Value); Int64? cityId = null; if (hdfCityId.Value != "0") cityId = Int64.Parse(hdfCityId.Value); int projectId = int.Parse(hdfProjectId.Value); string usmh = ((TextBox)grdProjectAddSectionsNew.FooterRow.FindControl("tbxUsmhAdd")).Text; string dsmh = ((TextBox)grdProjectAddSectionsNew.FooterRow.FindControl("tbxDsmhAdd")).Text; AssetSewerMHGateway assetSewerMhGatewayUSMH = new AssetSewerMHGateway(); assetSewerMhGatewayUSMH.LoadByCountryIdProvinceIdCountyIdCityIdMhId(countryId, provinceId, countyId, cityId, usmh, companyId, "", "", "");// TODO MH AssetSewerMHGateway assetSewerMhGatewayDSMH = new AssetSewerMHGateway(); assetSewerMhGatewayDSMH.LoadByCountryIdProvinceIdCountyIdCityIdMhId(countryId, provinceId, countyId, cityId, dsmh, companyId, "", "", ""); // TODO MH if (assetSewerMhGatewayUSMH.Table.Rows.Count > 0 && assetSewerMhGatewayDSMH.Table.Rows.Count > 0) { int assetIdUsmh = assetSewerMhGatewayUSMH.GetAssetID(usmh); int assetIdDsmh = assetSewerMhGatewayDSMH.GetAssetID(dsmh); AssetSewerMHGateway assetSewerMhGateway = new AssetSewerMHGateway(null); if (assetSewerMhGateway.USmhDsmhInUseForSections(assetIdUsmh, assetIdDsmh, companyId)) { usmhAndDsmhValid = false; } } if (usmhAndDsmhValid) { foreach (GridViewRow row in grdProjectAddSectionsNew.Rows) { string usmhRow = ((TextBox)row.FindControl("tbxUsmh")).Text; string dsmhRow = ((TextBox)row.FindControl("tbxDsmh")).Text; if ((usmhRow == usmh && dsmhRow == dsmh) || (usmhRow == dsmh && dsmhRow == usmh)) { usmhAndDsmhValid = false; } } } args.IsValid = usmhAndDsmhValid; }
/// <summary> /// UpdateMH /// </summary> /// <param name="countryId">countryId</param> /// <param name="provinceId">provinceId</param> /// <param name="countyId">countyId</param> /// <param name="cityId">cityId</param> /// <param name="mhId">mhId</param> /// <param name="originalUsmhAddress">originalUsmhAddress</param> /// <param name="newUsmhAddress">newUsmhAddress</param> /// <param name="companyId">companyId</param> private void UpdateMH(Int64? countryId, Int64? provinceId, Int64? countyId, Int64? cityId, string mhId, string originalAddress, string newAddress, int companyId) { // Get unchanged data // ... mh AssetSewerMHGateway assetSewerMHGateway = new AssetSewerMHGateway(); assetSewerMHGateway.LoadByCountryIdProvinceIdCountyIdCityIdMhId(countryId, provinceId, countyId, cityId, mhId, companyId, "", "", ""); //TODO MH // Update mh if (assetSewerMHGateway.Table.Rows.Count > 0) { int originalAssetId = assetSewerMHGateway.GetAssetID(mhId); string originalLatitude = assetSewerMHGateway.GetLatitude(mhId); string originalLongitude = assetSewerMHGateway.GetLongitude(mhId); bool originalDeleted = assetSewerMHGateway.GetDeleted(mhId); int originalCompanyId = assetSewerMHGateway.GetCompanyId(mhId); string originalManholeShape = assetSewerMHGateway.GetManholeShape(mhId); string originalLocation = assetSewerMHGateway.GetLocation(mhId); int? originalMaterialID = assetSewerMHGateway.GetMaterialID(mhId); string originalTopDiameter = assetSewerMHGateway.GetTopDepth(mhId); string originalTopDepth = assetSewerMHGateway.GetTopDepth(mhId); string originalTopFloor = assetSewerMHGateway.GetTopFloor(mhId); string originalTopCeiling = assetSewerMHGateway.GetTopFloor(mhId); string originalTopBenching = assetSewerMHGateway.GetTopBenching(mhId); string originalDownDiameter = assetSewerMHGateway.GetDownDiameter(mhId); string originalDownDepth = assetSewerMHGateway.GetDownDepth(mhId); string originalDownFloor = assetSewerMHGateway.GetDownFloor(mhId); string originalDownCeiling = assetSewerMHGateway.GetDownCeiling(mhId); string originalDownBenching = assetSewerMHGateway.GetDownBenching(mhId); string originalRectangle1LongSide = assetSewerMHGateway.GetRectangle1LongSide(mhId); string originalRectangle1ShortSide = assetSewerMHGateway.GetRectangle1ShortSide(mhId); string originalRectangle2LongSide = assetSewerMHGateway.GetRectangle2LongSide(mhId); string originalRectangle2ShortSide = assetSewerMHGateway.GetRectangle2ShortSide(mhId); string originalTopSurfaceArea = assetSewerMHGateway.GetTopSurfaceArea(mhId); string originalDownSurfaceArea = assetSewerMHGateway.GetDownSurfaceArea(mhId); int? originalManholeRugs = assetSewerMHGateway.GetManholeRugs(mhId); string originalTotalDepth = assetSewerMHGateway.GetTotalDepth(mhId); string originalTotalSurfaceArea = assetSewerMHGateway.GetTotalSurfaceArea(mhId); AssetSewerMH assetSewerMH = new AssetSewerMH(assetSewerMHGateway.Data); assetSewerMH.UpdateDirect(originalAssetId, mhId, originalLatitude, originalLongitude, originalAddress, originalManholeShape, originalLocation, originalMaterialID, originalTopDiameter, originalTopDepth, originalTopFloor, originalTopCeiling, originalTopBenching, originalDownDiameter, originalDownDepth, originalDownFloor, originalDownCeiling, originalDownBenching, originalRectangle1LongSide, originalRectangle1ShortSide, originalRectangle2LongSide, originalRectangle2ShortSide, originalTopSurfaceArea, originalDownSurfaceArea, originalManholeRugs, originalTotalDepth, originalTotalSurfaceArea, originalDeleted, originalCompanyId, originalAssetId, mhId, originalLatitude, originalLongitude, newAddress, originalManholeShape, originalLocation, originalMaterialID, originalTopDiameter, originalTopDepth, originalTopFloor, originalTopCeiling, originalTopBenching, originalDownDiameter, originalDownDepth, originalDownFloor, originalDownCeiling, originalDownBenching, originalRectangle1LongSide, originalRectangle1ShortSide, originalRectangle2LongSide, originalRectangle2ShortSide, originalTopSurfaceArea, originalDownSurfaceArea, originalManholeRugs, originalTotalDepth, originalTotalSurfaceArea, originalDeleted, originalCompanyId); } }
/// <summary> /// Save a section /// </summary> /// <param name="row">row</param> /// <param name="projectId">projectId</param> /// <param name="countryId">countryId</param> /// <param name="provinceId">provinceId</param> /// <param name="countyId">countyId</param> /// <param name="cityId">cityId</param> /// <param name="companyId">companyId</param> /// <returns>section_assetId</returns> private int SaveSection(ProjectAddSectionsTDS.ProjectAddSectionsTempRow row, int projectId, Int64? countryId, Int64? provinceId, Int64? countyId, Int64? cityId, int companyId) { string street = ""; if (!row.IsStreetNull()) street = row.Street; string usmh = ""; if (!row.IsUSMHNull()) usmh = row.USMH; string dsmh = ""; if (!row.IsDSMHNull()) dsmh = row.DSMH; string usmhStreet = ""; if (!row.IsUsmhStreetNull()) usmhStreet = row.UsmhStreet; string usmhLatitude = ""; if (!row.IsUsmhLatitudeNull()) usmhLatitude = row.UsmhLatitude; string usmhLongitude = ""; if (!row.IsUsmhLongitudeNull()) usmhLongitude = row.UsmhLongitude; string usmhShape = ""; if (!row.IsUsmhShapeNull()) usmhShape = row.UsmhShape; string usmhLocation = ""; if (!row.IsUsmhLocationNull()) usmhLocation = row.UsmhLocation; int? usmhConditionRating = null; if (!row.IsUsmhConditionRatingNull()) usmhConditionRating = row.UsmhConditionRating; int? usmhMaterialId = null; if (!row.IsUsmhMaterialIdNull()) usmhMaterialId = row.UsmhMaterialId; string usmhTopDiameter = ""; if (!row.IsUsmhTopDiameterNull()) usmhTopDiameter = row.UsmhTopDiameter; string usmhTopDepth = ""; if (!row.IsUsmhTopDepthNull()) usmhTopDepth = row.UsmhTopDepth; string usmhDownDiameter = ""; if (!row.IsUsmhDownDiameterNull()) usmhDownDiameter = row.UsmhDownDiameter; string usmhDownDepth = ""; if (!row.IsUsmhDownDepthNull()) usmhDownDepth = row.UsmhDownDepth; int? usmhManholeRugs = null; if (!row.IsUsmhManholeRugsNull()) usmhManholeRugs = row.UsmhManholeRugs; string usmhRectangle1LongSide = ""; if (!row.IsUsmhRectangle1LongSideNull()) usmhRectangle1LongSide = row.UsmhRectangle1LongSide; string usmhRectangle1ShortSide = ""; if (!row.IsUsmhRectangle1ShortSideNull()) usmhRectangle1ShortSide = row.UsmhRectangle1ShortSide; string usmhRectangle2LongSide = ""; if (!row.IsUsmhRectangle2LongSideNull()) usmhRectangle2LongSide = row.UsmhRectangle2LongSide; string usmhRectangle2ShortSide = ""; if (!row.IsUsmhRectangle2ShortSideNull()) usmhRectangle2ShortSide = row.UsmhRectangle2ShortSide; string usmhTotalSurfaceArea = ""; if (!row.IsUsmhTotalSurfaceAreaNull()) usmhTotalSurfaceArea = row.UsmhTotalSurfaceArea; string dsmhStreet = ""; if (!row.IsDsmhStreetNull()) dsmhStreet = row.DsmhStreet; string dsmhLatitude = ""; if (!row.IsDsmhLatitudeNull()) dsmhLatitude = row.DsmhLatitude; string dsmhLongitude = ""; if (!row.IsDsmhLongitudeNull()) dsmhLongitude = row.DsmhLongitude; string dsmhShape = ""; if (!row.IsDsmhShapeNull()) dsmhShape = row.DsmhShape; string dsmhLocation = ""; if (!row.IsDsmhLocationNull()) dsmhLocation = row.DsmhLocation; int? dsmhConditionRating = null; if (!row.IsDsmhConditionRatingNull()) dsmhConditionRating = row.DsmhConditionRating; int? dsmhMaterialId = null; if (!row.IsDsmhMaterialIdNull()) dsmhMaterialId = row.DsmhMaterialId; string dsmhTopDiameter = ""; if (!row.IsDsmhTopDiameterNull()) dsmhTopDiameter = row.DsmhTopDiameter; string dsmhTopDepth = ""; if (!row.IsDsmhTopDepthNull()) dsmhTopDepth = row.DsmhTopDepth; string dsmhDownDiameter = ""; if (!row.IsDsmhDownDiameterNull()) dsmhDownDiameter = row.DsmhDownDiameter; string dsmhDownDepth = ""; if (!row.IsDsmhDownDepthNull()) dsmhDownDepth = row.DsmhDownDepth; int? dsmhManholeRugs = null; if (!row.IsDsmhManholeRugsNull()) dsmhManholeRugs = row.DsmhManholeRugs; string dsmhRectangle1LongSide = ""; if (!row.IsDsmhRectangle1LongSideNull()) dsmhRectangle1LongSide = row.DsmhRectangle1LongSide; string dsmhRectangle1ShortSide = ""; if (!row.IsDsmhRectangle1ShortSideNull()) dsmhRectangle1ShortSide = row.DsmhRectangle1ShortSide; string dsmhRectangle2LongSide = ""; if (!row.IsDsmhRectangle2LongSideNull()) dsmhRectangle2LongSide = row.DsmhRectangle2LongSide; string dsmhRectangle2ShortSide = ""; if (!row.IsDsmhRectangle2ShortSideNull()) dsmhRectangle2ShortSide = row.DsmhRectangle2ShortSide; string dsmhTotalSurfaceArea = ""; if (!row.IsDsmhTotalSurfaceAreaNull()) dsmhTotalSurfaceArea = row.DsmhTotalSurfaceArea; // insert usmh (if not exists) int? usmh_assetId = null; if (usmh != "") { LfsAssetSewerMH lfsAssetSewerUsmh = new LfsAssetSewerMH(null); usmh_assetId = lfsAssetSewerUsmh.InsertDirect(countryId, provinceId, countyId, cityId, usmh, usmhLatitude, usmhLongitude, usmhStreet, false, companyId, usmhShape, usmhLocation, usmhMaterialId, usmhTopDiameter, usmhTopDepth, "", "", "", usmhDownDiameter, usmhDownDepth, "", "", "", usmhRectangle1LongSide, usmhRectangle1ShortSide, usmhRectangle2LongSide, usmhRectangle2ShortSide, "", "", usmhManholeRugs, "", usmhTotalSurfaceArea, usmhConditionRating); // insert in LFS tables (only if not exists) AssetSewerMHGateway assetSewerMHGateway = new AssetSewerMHGateway(); if (!assetSewerMHGateway.IsUsedInMHProject(projectId, usmh_assetId.Value)) { AssetSewerMHGateway assetSewerMhGatewayForUSMH = new AssetSewerMHGateway(null); assetSewerMhGatewayForUSMH.InsertMHProject(usmh_assetId.Value, projectId, DateTime.Now, false, companyId); } if (row.MHRehabUsmh) { //TODO MH SaveMHRehabWork(projectId, usmh_assetId.Value, companyId); } } // insert dsmh (if not exists) int? dsmh_assetId = null; if (dsmh != "") { LfsAssetSewerMH lfsAssetSewerDsmh = new LfsAssetSewerMH(null); dsmh_assetId = lfsAssetSewerDsmh.InsertDirect(countryId, provinceId, countyId, cityId, dsmh, dsmhLatitude, dsmhLongitude, dsmhStreet, false, companyId, dsmhShape, dsmhLocation, dsmhMaterialId, dsmhTopDiameter, dsmhTopDepth, "", "", "", dsmhDownDiameter, dsmhDownDepth, "", "", "", dsmhRectangle1LongSide, dsmhRectangle1ShortSide, dsmhRectangle2LongSide, dsmhRectangle2ShortSide, "", "", dsmhManholeRugs, "", dsmhTotalSurfaceArea, dsmhConditionRating); // insert in LFS tables (only if not exists) AssetSewerMHGateway assetSewerMHGateway = new AssetSewerMHGateway(); if (!assetSewerMHGateway.IsUsedInMHProject(projectId, dsmh_assetId.Value)) { AssetSewerMHGateway assetSewerMhGatewayForDSMH = new AssetSewerMHGateway(null); assetSewerMhGatewayForDSMH.InsertMHProject(dsmh_assetId.Value, projectId, DateTime.Now, false, companyId); } if (row.MHRehabDsmh) { //TODO MH SaveMHRehabWork(projectId, dsmh_assetId.Value, companyId); } } // insert section LfsAssetSewerSection lfsAssetSewerSection = new LfsAssetSewerSection(null); string mapSize = ""; if (!row.IsMapSizeNull()) mapSize = row.MapSize; string mapLength = ""; if (!row.IsMapLengthNull()) mapLength = row.MapLength; int sectionMaterialRefId = 1; // first material when adding new section string sectionMaterial = ""; if (!row.IsSectionMaterialNull()) sectionMaterial = row.SectionMaterial; DateTime sectionMaterialDate = DateTime.Now; int section_assetId = lfsAssetSewerSection.InsertDirect(countryId, provinceId, countyId, cityId, row.SectionID, street, usmh_assetId, dsmh_assetId, mapSize, "", mapLength, "", null, null, "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", false, companyId, "", "", sectionMaterialRefId, sectionMaterial, sectionMaterialDate); return section_assetId; }
/// <summary> /// UpdateFieldsForSections /// </summary> /// <param name="companyId">companyId</param> /// <param name="currentProjectId">currentProjectId</param> private void UpdateFieldsForSections(int companyId, int currentProjectId) { AssetSewerSectionGateway assetSewerFindSectionGateway = new AssetSewerSectionGateway(); AssetSewerMHGateway assetSewerFindMHGateway = new AssetSewerMHGateway(); WorkGateway workGateway = new WorkGateway(); foreach (ProjectSectionsNavigatorTDS.LFS_PROJECT_SECTIONS_NAVIGATORRow row in (ProjectSectionsNavigatorTDS.LFS_PROJECT_SECTIONS_NAVIGATORDataTable)Table) { //General data for asset assetSewerFindSectionGateway.LoadByAssetId(row.AssetID, companyId); //COMPANY_ID // ... For usmh row.USMHDescription = ""; if (!row.IsUSMHNull()) { assetSewerFindMHGateway.LoadByAssetId(row.USMH, companyId); row.USMHDescription = assetSewerFindMHGateway.GetMHID(row.USMH); } // ... For dsmh row.DSMHDescription = ""; if (!row.IsDSMHNull()) { assetSewerFindMHGateway.LoadByAssetId(row.DSMH, companyId); row.DSMHDescription = assetSewerFindMHGateway.GetMHID(row.DSMH); } // ... For Works row.RehabAssessment = workGateway.ExistsProjectIdAssetIdWorkTypeCompanyId(row.AssetID, currentProjectId, "Rehab Assessment", companyId); row.FullLengthLining = workGateway.ExistsProjectIdAssetIdWorkTypeCompanyId(row.AssetID, currentProjectId, "Full Length Lining", companyId); row.JunctionLining = workGateway.ExistsProjectIdAssetIdWorkTypeCompanyId(row.AssetID, currentProjectId, "Junction Lining Section", companyId); row.WorksDescription = ""; if (row.RehabAssessment) row.WorksDescription = row.WorksDescription + "Rehab Assessment"; if (row.FullLengthLining) { if (row.WorksDescription.Trim().Length > 0) { row.WorksDescription = row.WorksDescription + ", Full Length Lining"; } else { row.WorksDescription = row.WorksDescription + "Full Length Lining"; } } if (row.JunctionLining) { if (row.WorksDescription.Trim().Length > 0) { row.WorksDescription = row.WorksDescription + ", Junction Lining"; } else { row.WorksDescription = row.WorksDescription + "Junction Lining"; } } // ... For Laterals AssetSewerLateralGateway assetSewerLateralGateway = new AssetSewerLateralGateway(); assetSewerLateralGateway.LoadBySectionId(row.AssetID, companyId); AssetSewerLateral assetSewerLateral = new AssetSewerLateral(assetSewerLateralGateway.Data); row.LateralsDescription = assetSewerLateral.GetAllLaterals(row.AssetID, companyId); } }
/// <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); } } } }
// //////////////////////////////////////////////////////////////////////// // EVENTS // protected void Page_Load(object sender, EventArgs e) { // Register client scripts this.RegisterClientScripts(); if (!IsPostBack) { // Security check if (!Convert.ToBoolean(Session["sgLFS_PROJECTS_VIEW"])) { Response.Redirect("./../../error_page.aspx?error=" + "You are not authorized to view this page. Contact your system administrator."); } // Validate query string if (Request.QueryString["source_page"] == null) { Response.Redirect("./../../error_page.aspx?error=" + "Invalid query string in projects2.aspx"); } // Tag page hdfCompanyId.Value = Session["companyID"].ToString(); hdfProjectId.Value = Request.QueryString["project_id"]; hdfAssetID.Value = Request.QueryString["asset_id"]; Session.Remove("projectSectionsNavigatorLateralsNewDummy"); Session.Remove("projectSectionsNavigatorLaterals"); // Initialize data projectTDS = (ProjectTDS)Session["lfsProjectTDS"]; assetsTDS = new AssetsTDS(); lfsAssetsTDS = new LfsAssetsTDS(); workTDS = new WorkTDS(); projectSectionsNavigatorTDS = new ProjectSectionsNavigatorTDS(); // Load data int companyId = Int32.Parse(hdfCompanyId.Value); int assetId = Int32.Parse(hdfAssetID.Value); int projectId = Int32.Parse(hdfProjectId.Value); AssetSewerSectionGateway assetSewerSectionGateway = new AssetSewerSectionGateway(); assetSewerSectionGateway.LoadByAssetId(assetId, companyId); if (assetSewerSectionGateway.Table.Rows.Count > 0) { tbxSectionId.Text = assetSewerSectionGateway.GetFlowOrderID(assetId); tbxStreet.Text = assetSewerSectionGateway.GetStreet(assetId); // ... For usmh if (assetSewerSectionGateway.GetUSMH(assetId).HasValue) { AssetSewerMHGateway assetSewerFindMHGateway = new AssetSewerMHGateway(); int USMH = (int)assetSewerSectionGateway.GetUSMH(assetId); assetSewerFindMHGateway.LoadByAssetId(USMH, companyId); tbxUSMH.Text = assetSewerFindMHGateway.GetMHID(USMH); } // ... For usmh if (assetSewerSectionGateway.GetDSMH(assetId).HasValue) { AssetSewerMHGateway assetSewerFindMHGateway = new AssetSewerMHGateway(); int DSMH = (int)assetSewerSectionGateway.GetDSMH(assetId); assetSewerFindMHGateway.LoadByAssetId(DSMH, companyId); tbxDSMH.Text = assetSewerFindMHGateway.GetMHID(DSMH); } // ... For Works WorkGateway workGateway = new WorkGateway(); if (workGateway.ExistsProjectIdAssetIdWorkTypeCompanyId(assetId, projectId, "Rehab Assessment", companyId)) ckbxRehabAssessment.Checked = true; if (workGateway.ExistsProjectIdAssetIdWorkTypeCompanyId(assetId, projectId, "Full Length Lining", companyId)) ckbxFullLengthLining.Checked = true; if (workGateway.ExistsProjectIdAssetIdWorkTypeCompanyId(assetId, projectId, "Junction Lining Section", companyId)) ckbxJunctionLining.Checked = true; // ... For Laterals if (assetSewerSectionGateway.GetLaterals(int.Parse(hdfAssetID.Value)).HasValue) { tbxTotalLaterals.Text = ((int)assetSewerSectionGateway.GetLaterals(assetId)).ToString(); } else { tbxTotalLaterals.Text = "0"; } ProjectSectionsNavigatorLateralsGateway projectSectionsNavigatorLateralsGateway = new ProjectSectionsNavigatorLateralsGateway(projectSectionsNavigatorTDS); projectSectionsNavigatorLateralsGateway.LoadBySection_ProjectId(assetId, projectId, companyId); AssetSewerLateralGateway assetSewerLateralGateway = new AssetSewerLateralGateway(assetsTDS); assetSewerLateralGateway.LoadBySectionProjectId(assetId, projectId, companyId); // ... store datasets Session["projectSectionsNavigatorTDS"] = projectSectionsNavigatorTDS; projectSectionsNavigatorLaterals = projectSectionsNavigatorTDS.ProjectSectionNavigatorLaterals; Session["projectSectionsNavigatorLaterals"] = projectSectionsNavigatorLaterals; } } else { // Restore dataset projectTDS = (ProjectTDS)Session["lfsProjectTDS"]; projectSectionsNavigatorTDS = (ProjectSectionsNavigatorTDS)Session["lfsProjectSectionsNavigatorTDS"]; projectSectionsNavigatorLaterals = (ProjectSectionsNavigatorTDS.ProjectSectionNavigatorLateralsDataTable)Session["projectSectionsNavigatorLaterals"]; assetsTDS = (AssetsTDS)Session["assetsTDS"]; lfsAssetsTDS = (LfsAssetsTDS)Session["lfsAssetsTDS"]; workTDS = (WorkTDS)Session["workTDS"]; } }
/// <summary> /// UpdateDirect /// </summary> /// <param name="originalAssetId">originalAssetId</param> /// <param name="originalMhId">originalMhId</param> /// <param name="originalLatitud">originalLatitud</param> /// <param name="originalLongitude">originalLongitude</param> /// <param name="originalAddress">originalAddress</param> /// <param name="originalManholeShape">originalManholeShape</param> /// <param name="originalLocation">originalLocation</param> /// <param name="originalMaterialID">originalMaterialID</param> /// <param name="originalTopDiameter">originalTopDiameter</param> /// <param name="originalTopDepth">originalTopDepth</param> /// <param name="originalTopFloor">originalTopFloor</param> /// <param name="originalTopCeiling">originalTopCeiling</param> /// <param name="originalTopBenching">originalTopBenching</param> /// <param name="originalDownDiameter">originalDownDiameter</param> /// <param name="originalDownDepth">originalDownDepth</param> /// <param name="originalDownFloor">originalDownFloor</param> /// <param name="originalDownCeiling">originalDownCeiling</param> /// <param name="originalDownBenching">originalDownBenching</param> /// <param name="originalRectangle1LongSide">originalRectangle1LongSide</param> /// <param name="originalRectangle1ShortSide">originalRectangle1ShortSide</param> /// <param name="originalRectangle2LongSide">originalRectangle2LongSide</param> /// <param name="originalRectangle2ShortSide">originalRectangle2ShortSide</param> /// <param name="originalTopSurfaceArea">originalTopSurfaceArea</param> /// <param name="originalDownSurfaceArea">originalDownSurfaceArea</param> /// <param name="originalManholeRugs">originalManholeRugs</param> /// <param name="originalTotalDepth">originalTotalDepth</param> /// <param name="originalTotalSurfaceArea">originalTotalSurfaceArea</param> /// <param name="originalDeleted">originalDeleted</param> /// <param name="originalCompanyId">originalCompanyId</param> /// /// <param name="newAssetId">newAssetId</param> /// <param name="newMhId">newMhId</param> /// <param name="newLatitude">newLatitude</param> /// <param name="newLongitude">newLongitude</param> /// <param name="newAddress">newAddress</param> /// <param name="newManholeShape">newManholeShape</param> /// <param name="newLocation">newLocation</param> /// <param name="newMaterialID">newMaterialID</param> /// <param name="newTopDiameter">newTopDiameter</param> /// <param name="newTopDepth">newTopDepth</param> /// <param name="newTopFloor">newTopFloor</param> /// <param name="newTopCeiling">newTopCeiling</param> /// <param name="newTopBenching">newTopBenching</param> /// <param name="newDownDiameter">newDownDiameter</param> /// <param name="newDownDepth">newDownDepth</param> /// <param name="newDownFloor">newDownFloor</param> /// <param name="newDownCeiling">newDownCeiling</param> /// <param name="newDownBenching">newDownBenching</param> /// <param name="newRectangle1LongSide">newRectangle1LongSide</param> /// <param name="newRectangle1ShortSide">newRectangle1ShortSide</param> /// <param name="newRectangle2LongSide">newRectangle2LongSide</param> /// <param name="newRectangle2ShortSide">newRectangle2ShortSide</param> /// <param name="newTopSurfaceArea">newTopSurfaceArea</param> /// <param name="newDownSurfaceArea">newDownSurfaceArea</param> /// <param name="newManholeRugs">newManholeRugs</param> /// <param name="newTotalDepth">newTotalDepth</param> /// <param name="newTotalSurfaceArea">newTotalSurfaceArea</param> /// <param name="newDeleted">newDeleted</param> /// <param name="newCompanyId">newCompanyId</param> public void UpdateDirect(int originalAssetId, string originalMhId, string originalLatitud, string originalLongitude, string originalAddress, string originalManholeShape, string originalLocation, int? originalMaterialID, string originalTopDiameter, string originalTopDepth, string originalTopFloor, string originalTopCeiling, string originalTopBenching, string originalDownDiameter, string originalDownDepth, string originalDownFloor, string originalDownCeiling, string originalDownBenching, string originalRectangle1LongSide, string originalRectangle1ShortSide, string originalRectangle2LongSide, string originalRectangle2ShortSide, string originalTopSurfaceArea, string originalDownSurfaceArea, int? originalManholeRugs, string originalTotalDepth, string originalTotalSurfaceArea, bool originalDeleted, int originalCompanyId, int newAssetId, string newMhId, string newLatitud, string newLongitude, string newAddress, string newManholeShape, string newLocation, int? newMaterialID, string newTopDiameter, string newTopDepth, string newTopFloor, string newTopCeiling, string newTopBenching, string newDownDiameter, string newDownDepth, string newDownFloor, string newDownCeiling, string newDownBenching, string newRectangle1LongSide, string newRectangle1ShortSide, string newRectangle2LongSide, string newRectangle2ShortSide, string newTopSurfaceArea, string newDownSurfaceArea, int? newManholeRugs, string newTotalDepth, string newTotalSurfaceArea, bool newDeleted, int newCompanyId) { AssetSewerMHGateway assetSewerMhGateway = new AssetSewerMHGateway(null); assetSewerMhGateway.Update(originalAssetId, originalMhId, 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, originalDeleted, originalCompanyId, newAssetId, newMhId, 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, newDeleted, newCompanyId); }
/// <summary> /// Verify if MH is in use for any entity /// </summary> /// <param name="assetId">assetId</param> /// <param name="companyId">companyId</param> /// <returns>true if MH is in use for any entity, not if it not in use</returns> public bool InUse(int assetId, int companyId) { // verify use for sections like USMH or DSMH AssetSewerMHGateway assetSewerMhGateway = new AssetSewerMHGateway(null); if (assetSewerMhGateway.InUseForSections(assetId, companyId)) { return true; } // default return return false; }
// //////////////////////////////////////////////////////////////////////// // PUBLIC METHODS // /// <summary> /// InsertDirect /// </summary> /// <param name="countryId">countryId</param> /// <param name="provinceId">provinceId</param> /// <param name="countyId">countyId</param> /// <param name="cityId">cityId</param> /// <param name="mhid">mhid</param> /// <param name="latitude">latitude</param> /// <param name="longitude">longitude</param> /// <param name="address">address</param> /// <param name="deleted">deleted</param> /// <param name="companyId">companyId</param> /// <param name="manholeShape">manholeShape</param> /// <param name="location">location</param> /// <param name="materialID">materialID</param> /// <param name="topDiameter">topDiameter</param> /// <param name="topDepth">topDepth</param> /// <param name="topFloor">topFloor</param> /// <param name="topCeiling">topCeiling</param> /// <param name="topBenching">topBenching</param> /// <param name="downDiameter">downDiameter</param> /// <param name="downDepth">downDepth</param> /// <param name="downFloor">downFloor</param> /// <param name="downCeiling">downCeiling</param> /// <param name="downBenching">downBenching</param> /// <param name="rectangle1LongSide">rectangle1LongSide</param> /// <param name="rectangle1ShortSide">rectangle1ShortSide</param> /// <param name="rectangle2LongSide">rectangle2LongSide</param> /// <param name="rectangle2ShortSide">rectangle2ShortSide</param> /// <param name="topSurfaceArea">topSurfaceArea</param> /// <param name="downSurfaceArea">downSurfaceArea</param> /// <param name="manholeRugs">manholeRugs</param> /// <param name="totalDepth">totalDepth</param> /// <param name="totalSurfaceArea">totalSurfaceArea</param> public int InsertDirect(Int64? countryId, Int64? provinceId, Int64? countyId, Int64? cityId, string mhid, string latitude, string longitude, string address, bool deleted, int companyId, string manholeShape, string location, int? materialID, string topDiameter, string topDepth, string topFloor, string topCeiling, string topBenching, string downDiameter, string downDepth, string downFloor, string downCeiling, string downBenching, string rectangle1LongSide, string rectangle1ShortSide, string rectangle2LongSide, string rectangle2ShortSide, string topSurfaceArea, string downSurfaceArea, int? manholeRugs, string totalDepth, string totalSurfaceArea) { AssetSewerMHGateway assetSewerMhGateway = new AssetSewerMHGateway(); assetSewerMhGateway.LoadByCountryIdProvinceIdCountyIdCityIdMhId(countryId, provinceId, countyId, cityId, mhid, companyId, latitude, longitude, address); int mh_assetId = 0; if (assetSewerMhGateway.Table.Rows.Count == 0) { mh_assetId = new Asset(new DataSet()).InsertDirect("Sewer", countryId, provinceId, countyId, cityId, deleted, companyId); new AssetSewer(new DataSet()).InsertDirect(mh_assetId, "MH", deleted, companyId); assetSewerMhGateway.Insert(mh_assetId, mhid, latitude, longitude, address, deleted, companyId, manholeShape, location, materialID, topDiameter, topDepth, topFloor, topCeiling, topBenching, downDiameter, downDepth, downFloor, downCeiling, downBenching, rectangle1LongSide, rectangle1ShortSide, rectangle2LongSide, rectangle2ShortSide, topSurfaceArea, downSurfaceArea, manholeRugs, totalDepth, totalSurfaceArea); } else { mh_assetId = assetSewerMhGateway.GetAssetID(mhid); } return mh_assetId; }
/// <summary> /// Save all manhole to database (direct) /// </summary> /// <param name="countryId">countryId</param> /// <param name="provinceId">provinceId</param> /// <param name="countyId">countyId</param> /// <param name="cityId">cityId</param> /// <param name="companyId">companyId</param> public void Save(Int64? countryId, Int64? provinceId, Int64? countyId, Int64? cityId, int companyId, int projectId) { AddManholeTDS mrManholesAddChanges = (AddManholeTDS)Data.GetChanges(); if (mrManholesAddChanges.AddManholeNew.Rows.Count > 0) { AddManholeNewGateway addManholeNewGateway = new AddManholeNewGateway(mrManholesAddChanges); foreach (AddManholeTDS.AddManholeNewRow row in (AddManholeTDS.AddManholeNewDataTable)mrManholesAddChanges.AddManholeNew) { // Insert new manhole if ((!row.Deleted) && (!row.InDatabase)) { // ... Insert manhole int? manholeRugs = null; if (!row.IsManholeRugsNull()) manholeRugs = row.ManholeRugs; int? conditionRating = null; if (!row.IsConditionRatingNull()) conditionRating = row.ConditionRating; int? materialId = null; if (!row.IsMaterialIDNull()) materialId = row.MaterialID; LfsAssetSewerMH lfsAssetSewerMH = new LfsAssetSewerMH(); int assetId = lfsAssetSewerMH.InsertDirect(countryId, provinceId, countyId, cityId, row.MHID, row.Latitud, row.Longitude, row.Address, row.Deleted, companyId, row.ManholeShape, row.Location, materialId, row.TopDiameter, row.TopDepth, row.TopFloor, row.TopCeiling, row.TopBenching, row.DownDiameter, row.DownDepth, row.DownFloor, row.DownCeiling, row.DownBenching, row.Rectangle1LongSide, row.Rectangle1ShortSide, row.Rectangle2LongSide, row.Rectangle2ShortSide, row.TopSurfaceArea, row.DownSurfaceArea, manholeRugs, row.TotalDepth, row.TotalSurfaceArea, conditionRating); // insert in LFS tables (only if not exists) AssetSewerMHGateway assetSewerMHGateway = new AssetSewerMHGateway(); if (!assetSewerMHGateway.IsUsedInMHProject(projectId, assetId)) { AssetSewerMHGateway assetSewerMhGateway = new AssetSewerMHGateway(null); assetSewerMhGateway.InsertMHProject(assetId, projectId, DateTime.Now, false, companyId); } } } } }
protected void tbxMhIdAdd_TextChanged(object sender, EventArgs e) { try { mWizard2 master = (mWizard2)this.Master; ScriptManager scriptManager = (ScriptManager)master.FindControl("ScriptManager1"); if (scriptManager.IsInAsyncPostBack) { // cast DropDownList control which has initiated the call: TextBox tbxMhIdAdd = (TextBox)sender; int companyId = Int32.Parse(hdfCompanyId.Value); string mhId = tbxMhIdAdd.Text; Int64? countryId = null; if (hdfCountryId.Value != "0") countryId = Int64.Parse(hdfCountryId.Value); Int64? provinceId = null; if (hdfProvinceId.Value != "0") provinceId = Int64.Parse(hdfProvinceId.Value); Int64? countyId = null; if (hdfCountyId.Value != "0") countyId = Int64.Parse(hdfCountyId.Value); Int64? cityId = null; if (hdfCityId.Value != "0") cityId = Int64.Parse(hdfCityId.Value); AssetSewerMHGateway assetSewerMHGateway = new AssetSewerMHGateway(); assetSewerMHGateway.LoadByCountryIdProvinceIdCountyIdCityIdMhId(countryId, provinceId, countyId, cityId, mhId, companyId, "", "", ""); //TODO MH if (assetSewerMHGateway.Table.Rows.Count > 0) { ((TextBox)grdAddManholeNew.FooterRow.FindControl("tbxStreetAdd")).Text = assetSewerMHGateway.GetAddress(mhId); ((TextBox)grdAddManholeNew.FooterRow.FindControl("tbxLatitudeAdd")).Text = assetSewerMHGateway.GetLatitude(mhId); ((TextBox)grdAddManholeNew.FooterRow.FindControl("tbxLongitudeAdd")).Text = assetSewerMHGateway.GetLongitude(mhId); } } } catch { } }
protected void cvMhIdFooter_ServerValidate(object source, ServerValidateEventArgs args) { // Validate if mh already exists int companyId = Int32.Parse(hdfCompanyId.Value); string mhId = ((TextBox)grdAddManholeNew.FooterRow.FindControl("tbxMhIdAdd")).Text; Int64? countryId = null; if (hdfCountryId.Value != "0") countryId = Int64.Parse(hdfCountryId.Value); Int64? provinceId = null; if (hdfProvinceId.Value != "0") provinceId = Int64.Parse(hdfProvinceId.Value); Int64? countyId = null; if (hdfCountyId.Value != "0") countyId = Int64.Parse(hdfCountyId.Value); Int64? cityId = null; if (hdfCityId.Value != "0") cityId = Int64.Parse(hdfCityId.Value); int projectId = Convert.ToInt32(ddlProject.SelectedValue); string latitud = ((TextBox)grdAddManholeNew.FooterRow.FindControl("tbxLatitudeAdd")).Text; string longitude = ((TextBox)grdAddManholeNew.FooterRow.FindControl("tbxLongitudeAdd")).Text; string address = ((TextBox)grdAddManholeNew.FooterRow.FindControl("tbxStreetAdd")).Text; AssetSewerMHGateway assetSewerMhGateway = new AssetSewerMHGateway(); assetSewerMhGateway.LoadByCountryIdProvinceIdCountyIdCityIdMhId(countryId, provinceId, countyId, cityId, mhId, companyId, latitud, longitude, address); if (assetSewerMhGateway.Table.Rows.Count > 0) { int assetIdMh = assetSewerMhGateway.GetAssetID(mhId); if (assetSewerMhGateway.IsUsedInMHProject(projectId, assetIdMh)) { args.IsValid = false; } else { assetSewerMhGateway.LoadTop1ByMhIdProjectId(mhId, Convert.ToInt32(ddlProject.SelectedValue), companyId); if (assetSewerMhGateway.Table.Rows.Count > 0) { args.IsValid = false; } else { args.IsValid = true; } } } else { args.IsValid = true; } //AssetSewerMHGateway assetSewerMHGateway = new AssetSewerMHGateway(); //if (ddlProject.SelectedIndex != 0) //{ // assetSewerMHGateway.LoadTop1ByMhIdProjectId(mhId, Convert.ToInt32(ddlProject.SelectedValue), companyId); //} //else //{ // assetSewerMHGateway.LoadTop1ByMhId(mhId, companyId); //} //if (assetSewerMHGateway.Table.Rows.Count > 0) //{ // args.IsValid = false; //} //else //{ // args.IsValid = true; //} }