public virtual StandardizedAddress StandardizeAddress(string street, string city, string state, string zipCode) { string endpointUri = ""; StandardizedAddress result = new StandardizedAddress { Street = street, City = city, State = state, ZipCode = zipCode, MelissaAddressWashSucceeded = false, ErrorOccurred = "true" }; try { endpointUri = BuildStandarizedAddressEndpointUri(street, city, state, zipCode); XElement xml = GetXml(endpointUri); result = xml.ToStandardizedAddress(endpointUri); if (String.IsNullOrWhiteSpace(result.CountyName)) { result.CountyID = LookupCountyID(zipCodeNumber: zipCode); } else { result.CountyID = LookupCountyID(countyName: result.CountyName); } } catch (Exception ex) { using (ICERSRepositoryManager repo = ServiceLocator.GetRepositoryManager()) { ICERSSystemServiceManager services = ServiceLocator.GetSystemServiceManager(repo); services.ErrorReporting.Report(StandardizedAddressErrorMessage("AddressServiceProxy::StandardizeAddress", endpointUri, ex), ex); } } return(result); }
private void SummaryDeltaButton_Click(object sender, RoutedEventArgs e) { ICERSSystemServiceManager services = ServiceLocator.GetSystemServiceManager(DataRepository); try { int fsid = 0; fsid = Convert.ToInt32(SDFsidTB.Text); XElement submittalDeltaElement = services.SubmittalDelta.DeltaFS(fsid); this.OutputTB.Text = submittalDeltaElement.ToString(); } catch (Exception ex) { this.OutputTB.Text = "Error: " + ex.Message; } }
private void InventorySummaryButton_Click(object sender, RoutedEventArgs e) { ICERSSystemServiceManager services = ServiceLocator.GetSystemServiceManager(DataRepository); try { int fsid = 0; fsid = Convert.ToInt32(ISFsidTB.Text); services.BusinessLogic.SubmittalElements.HazardousMaterialsInventory.InventorySummary.Summary(Convert.ToInt32(fsid)); // all this was done in Summary but we need the information to get the output FacilitySubmittal fs = (from fsRec in DataRepository.DataModel.FacilitySubmittals where fsRec.ID == fsid select fsRec).FirstOrDefault(); FacilitySubmittalElement fse = (from fseRec in DataRepository.DataModel.FacilitySubmittalElements where fseRec.FacilitySubmittal.ID == fs.ID && fseRec.Voided == false && fseRec.SubmittalElementID == (int)SubmittalElementType.HazardousMaterialsInventory select fseRec).FirstOrDefault(); FacilitySubmittalElementResource fser = (from fserRec in DataRepository.DataModel.FacilitySubmittalElementResources where fserRec.FacilitySubmittalElementID == fse.ID && fserRec.Voided == false && fserRec.ResourceTypeID == (int)ResourceType.HazardousMaterialInventory select fserRec).FirstOrDefault(); InventorySummary inventory = DataRepository.InventorySummaries.GetByFSERID(fser.ID); StringBuilder results = new StringBuilder(); results.Append("Inventory Summary FSE: " + fse.ID + " CERSID: " + fse.CERSID + "\n"); results.Append(" Solid Material Count: " + inventory.SolidMaterialCount + " EHS Count: " + inventory.SolidEHSCount + " Maximum Daily Value: " + inventory.SolidMaximumDailyValue + " pounds\n"); results.Append(" Liquid Material Count: " + inventory.LiquidMaterialCount + " EHS Count: " + inventory.LiquidEHSCount + " Maximum Daily Value: " + inventory.LiquidMaximumDailyValue + " gallons\n"); results.Append(" Gas Material Count: " + inventory.GasMaterialCount + " EHS Count: " + inventory.GasEHSCount + " Maximum Daily Value: " + inventory.GasMaximumDailyValue + " cubic feet\n"); results.Append(" Unique Location Count: " + inventory.UniqueLocationCount + "\n"); this.OutputTB.Text = results.ToString(); } catch (Exception ex) { this.OutputTB.Text = "Error: " + ex.Message; } }
public ParsedAddress ParseAddress(string street) { string endpointUri = ""; ParsedAddress result = new ParsedAddress(); try { endpointUri = BuildParseAddressEndpointUri(street); XElement xml = GetXml(endpointUri); result = xml.ToParsedAddress(endpointUri); } catch (Exception ex) { using (ICERSRepositoryManager repo = ServiceLocator.GetRepositoryManager()) { ICERSSystemServiceManager services = ServiceLocator.GetSystemServiceManager(repo); services.ErrorReporting.Report(StandardizedAddressErrorMessage("AddressServiceProxy::ParseAddress", endpointUri, ex), ex); } } return(result); }
public virtual StandardizedBusinessName StandardizeBusinessName(string businessName) { string endpointUri = ""; StandardizedBusinessName result = new StandardizedBusinessName { BusinessName = businessName, EndPointUri = "", Message = "" }; try { endpointUri = BuildStandardizedBusinessNameEndpointUri(businessName); XElement xml = GetXml(endpointUri); result = xml.ToStandardizedBusinessName(endpointUri); } catch (Exception ex) { using (ICERSRepositoryManager repo = ServiceLocator.GetRepositoryManager()) { ICERSSystemServiceManager services = ServiceLocator.GetSystemServiceManager(repo); services.ErrorReporting.Report(StandardizedAddressErrorMessage("AddressServiceProxy::StandardizedBusinessName", endpointUri, ex), ex); } } return(result); }
public virtual CityZipValidationResult VerifyCityByZip(string city, string state, string zip) { string endpointUri = ""; CityZipValidationResult result = new CityZipValidationResult { CityFound = false, ErrorsOccurred = true, ZipCodeFound = false }; try { endpointUri = BuildVerifyCityByZipEndpointUri(city, state, zip); XElement xml = GetXml(endpointUri); result = xml.ToCityZipValidationResult(endpointUri); } catch (Exception ex) { using (ICERSRepositoryManager repo = ServiceLocator.GetRepositoryManager()) { ICERSSystemServiceManager services = ServiceLocator.GetSystemServiceManager(repo); services.ErrorReporting.Report(StandardizedAddressErrorMessage("AddressServiceProxy::VerifyCityByZip", endpointUri, ex), ex); } } return(result); }
private static void Main(string[] args) { Console.WriteLine("CERS2 Address Washing Utility, v0.01"); Console.WriteLine("Initializing Data Registry..."); DataRegistry.Initialize(); int successCount = 0; int failureCount = 0; int lengthViolationsCount = 0; int skippedDueToMissingStreet = 0; bool lengthViolation = false; using (ICERSRepositoryManager repo = ServiceLocator.GetRepositoryManager()) { ICERSSystemServiceManager services = ServiceLocator.GetSystemServiceManager(repo); Console.WriteLine("Gathering Facilities..."); //DateTime washDate = DateTime.Now.Date.AddDays( -3 ); //DateTime washDate = Convert.ToDateTime( "12/31/2013" ); DateTime washDate = Convert.ToDateTime("6/30/2014"); //var facilities = repo.Facilities.Search(washDate: washDate).ToList(); var facilities = (from fac in repo.DataModel.Facilities where !fac.Voided && !fac.IsAddressWashed && fac.WashDate > washDate select fac).ToList(); //var facilities = ( from facil in repo.DataModel.Facilities where facil.Voided == false select facil ).ToList(); Console.WriteLine("Found " + facilities.Count() + " Facilities..."); foreach (var facility in facilities) { lengthViolation = false; Console.WriteLine("CERSID: " + facility.CERSID); Console.WriteLine("Facility Name: " + facility.Name); Console.Write("\tSource Address: "); Console.WriteLine(GetSourceAddress(facility)); if (!string.IsNullOrWhiteSpace(facility.Street)) { Console.Write("\tWashed Address:"); AddressInformation result = services.Geo.GetAddressInformation(facility.Street, facility.City, facility.ZipCode, facility.State); if (result != null) { CheckLength("WashedStreet", result.Street, 100, ref lengthViolation); CheckLength("WashedCity", result.City, 100, ref lengthViolation); CheckLength("WashedState", result.State, 2, ref lengthViolation); CheckLength("WashedZipCode", result.ZipCode, 10, ref lengthViolation); if (!lengthViolation) { int washConfidence; if (int.TryParse(result.MelissaAddressWashConfidence, out washConfidence) == false) { washConfidence = 0; } if (result.MelissaAddressWashSucceeded && Convert.ToInt32(washConfidence) > 0) { facility.IsAddressWashed = true; facility.WashDate = DateTime.Now; facility.WashedStreet = result.Street; facility.WashedStreetWithoutSuite = result.StreetWithoutSuiteNumber; facility.WashedSuite = result.Suite; facility.WashedCity = result.City; facility.WashedState = result.State; facility.WashedZipCode = result.ZipCode; facility.WashedStreetName = result.StreetName; facility.WashedStreetPostDirection = result.PostDirection; facility.WashedStreetPreDirection = result.PreDirection; facility.WashedStreetRange = result.Range; facility.WashedStreetSuffix = result.Suffix; facility.WashConfidence = washConfidence; facility.WashSourceID = (int)WashSource.Melissa; if (facility.CountyID == null) { facility.CountyID = result.CountyID; } CERSFacilityGeoPoint geoPoint = facility.CERSFacilityGeoPoint; if (geoPoint == null) { geoPoint = new CERSFacilityGeoPoint(); } //make sure the result coordinates are in range before saving them if ((result.Latitude >= 32 && result.Latitude < 43) && (result.Longitude >= -114 && result.Longitude < 125)) { geoPoint.CERSID = facility.CERSID; geoPoint.LatitudeMeasure = result.Latitude; geoPoint.LongitudeMeasure = result.Longitude; geoPoint.HorizontalAccuracyMeasure = result.HorizontalAccuracyMeasure; geoPoint.HorizontalCollectionMethodID = result.HorizontalCollectionMethodID; geoPoint.HorizontalReferenceDatumID = result.HorizontalReferenceDatumID; geoPoint.GeographicReferencePointID = result.GeographicReferencePointID; geoPoint.SetCommonFields(); repo.CERSFacilityGeoPoints.Save(geoPoint); } } else if (result.MelissaAddressWashSucceeded) { //Use the parsed street values to get a standardized address facility.IsAddressWashed = false; facility.WashDate = DateTime.Now; facility.WashSourceID = (int)WashSource.Melissa; facility.WashedStreet = result.Street; facility.WashedStreetWithoutSuite = result.StreetWithoutSuiteNumber; facility.WashedSuite = result.Suite; facility.WashedCity = result.City; facility.WashedState = result.State; facility.WashedZipCode = result.ZipCode; facility.WashedStreetName = result.StreetName; facility.WashedStreetPostDirection = null; facility.WashedStreetPreDirection = null; facility.WashedStreetRange = result.Range; facility.WashedStreetSuffix = result.Suffix; } Console.WriteLine(GetWashedAddress(result)); Console.WriteLine("\tUpdating Facility..."); repo.Facilities.Save(facility); Console.WriteLine("\tFacility Updated"); successCount++; } else { Console.WriteLine("\tFacility NOT Updated"); lengthViolationsCount++; } } else { Console.WriteLine("Unable to obtain washed address."); failureCount++; } } else { skippedDueToMissingStreet++; Console.WriteLine("\tSkipped Due to Missing Street!"); } } Console.WriteLine("Process Completed."); Console.WriteLine("Successfully Washed: " + successCount); Console.WriteLine("Failed To Wash: " + failureCount); Console.WriteLine("Length Violations (NOT Washed): " + lengthViolationsCount); Console.WriteLine("Skipped Due to Missing Street: " + skippedDueToMissingStreet); } Console.Write("Press enter to quit."); Console.ReadLine(); }