public ClosestFacilityTO(ClosestFacility mdo) { this.visn = mdo.RegionId; this.city = mdo.City; this.state = mdo.State; this.county = mdo.County; this.zip = mdo.Zipcode; this.longitude = mdo.Longitude; this.latitude = mdo.Latitude; this.fips = mdo.Fips; this.msa = mdo.Msa; this.urb = mdo.Urb; if (mdo.NearestFacility != null) { this.nearestFacility = new SiteTO(mdo.NearestFacility); this.nearestFacilityDistance = mdo.NearestFacilityDistance; this.nearestFacilityMsa = mdo.NearestFacilityMsa; this.nearestFacilityUrb = mdo.NearestFacilityUrb; } if (mdo.NearestMedicalCenter != null) { this.nearestMedicalCenter = new SiteTO(mdo.NearestMedicalCenter); this.nearestMedicalCenterDistance = mdo.NearestMedicalCenterDistance; this.nearestMedicalCenterMsa = mdo.NearestMedicalCenterMsa; this.nearestMedicalCenterUrb = mdo.NearestMedicalCenterUrb; } if (mdo.NearestFacilityInRegion != null) { this.nearestFacilityInRegion = new SiteTO(mdo.NearestFacilityInRegion); this.nearestFacilityInRegionDistance = mdo.NearestFacilityInRegionDistance; this.nearestFacilityInRegionMsa = mdo.NearestFacilityInRegionMsa; this.nearestFacilityInRegionUrb = mdo.NearestFacilityInRegionUrb; } if (mdo.NearestMedicalCenterInRegion != null) { this.nearestMedicalCenterInRegion = new SiteTO(mdo.NearestMedicalCenterInRegion); this.nearestMedicalCenterInRegionDistance = mdo.NearestMedicalCenterInRegionDistance; this.nearestMedicalCenterInRegionMsa = mdo.NearestMedicalCenterInRegionMsa; this.nearestMedicalCenterInRegionUrb = mdo.NearestMedicalCenterInRegionUrb; } }
public ClosestFacilityTO getNearestFacility(string zipcode) { ClosestFacilityTO result = new ClosestFacilityTO(); if (zipcode == "") { result.fault = new FaultTO("Missing zipcode"); } if (result.fault != null) { return(result); } try { SitesApi api = new SitesApi(); ClosestFacility fac = api.getNearestFacility(zipcode, mySession.MdwsConfiguration.SqlConnectionString); result = new ClosestFacilityTO(fac); } catch (Exception e) { result.fault = new FaultTO(e.Message); } return(result); }
public ClosestFacility getNearestFacility(string zipcode) { if (String.IsNullOrEmpty(zipcode)) { throw new ArgumentNullException("Must include zipcode"); } if (!String.IsNullOrEmpty(zipcode) && zipcode.Length == 5 && zipcode.EndsWith("00")) { zipcode = zipcode.Substring(0, 3); zipcode += "01"; } string statement = "SELECT * FROM PSSG WHERE ZIPCODE = @ZIPCODE;"; SqlCommand command = new SqlCommand(statement); SqlParameter zipcodeParam = new SqlParameter("@ZIPCODE", SqlDbType.NVarChar, 50); zipcodeParam.Value = zipcode; command.Parameters.Add(zipcodeParam); DataTable results = query(command); if (results == null || results.Rows == null || results.Rows.Count == 0) { return null; } ClosestFacility result = new ClosestFacility(); result.RegionId = results.Rows[0][0] as string; result.State = results.Rows[0][1] as string; result.City = results.Rows[0][2] as string; result.Zipcode = results.Rows[0][3] as string; result.Latitude = results.Rows[0][4] as string; result.Longitude = results.Rows[0][5] as string; result.Fips = results.Rows[0][6] as string; result.County = results.Rows[0][7] as string; result.Urb = results.Rows[0][8] as string; result.Msa = results.Rows[0][9] as string; result.NearestFacility = new Site(results.Rows[0][10] as string, results.Rows[0][11] as string); result.NearestFacility.SiteType = results.Rows[0][12] as string; result.NearestFacility.RegionId = result.RegionId; result.NearestFacilityDistance = results.Rows[0][13] as string; result.NearestFacilityMsa = result.Msa; result.NearestFacilityUrb = result.Urb; result.NearestMedicalCenter = new Site(results.Rows[0][14] as string, results.Rows[0][15] as string); result.NearestMedicalCenter.RegionId = results.Rows[0][16] as string; result.NearestMedicalCenter.SiteType = "VAMC"; result.NearestMedicalCenterMsa = results.Rows[0][17] as string; result.NearestMedicalCenterUrb = results.Rows[0][18] as string; result.NearestMedicalCenterDistance = results.Rows[0][19] as string; result.NearestFacilityInRegion = new Site(results.Rows[0][20] as string, results.Rows[0][21] as string); result.NearestFacilityInRegion.SiteType = results.Rows[0][22] as string; result.NearestFacilityInRegionMsa = results.Rows[0][23] as string; result.NearestFacilityInRegionUrb = results.Rows[0][24] as string; result.NearestFacilityInRegionDistance = results.Rows[0][25] as string; result.NearestMedicalCenterInRegion = new Site(results.Rows[0][26] as string, results.Rows[0][27] as string); result.NearestMedicalCenterInRegion.SiteType = "VAMC"; result.NearestMedicalCenterInRegionMsa = results.Rows[0][28] as string; result.NearestMedicalCenterInRegionUrb = results.Rows[0][29] as string; result.NearestMedicalCenterInRegionDistance = results.Rows[0][30] as string; return result; }
public ClosestFacility getNearestFacility(string zipcode) { if (String.IsNullOrEmpty(zipcode)) { throw new ArgumentNullException("Must include zipcode"); } if (!String.IsNullOrEmpty(zipcode) && zipcode.Length == 5 && zipcode.EndsWith("00")) { zipcode = zipcode.Substring(0, 3); zipcode += "01"; } string statement = "SELECT * FROM PSSG WHERE ZIPCODE = @ZIPCODE;"; SqlCommand command = new SqlCommand(statement); SqlParameter zipcodeParam = new SqlParameter("@ZIPCODE", SqlDbType.NVarChar, 50); zipcodeParam.Value = zipcode; command.Parameters.Add(zipcodeParam); DataTable results = query(command); if (results == null || results.Rows == null || results.Rows.Count == 0) { return(null); } ClosestFacility result = new ClosestFacility(); result.RegionId = results.Rows[0][0] as string; result.State = results.Rows[0][1] as string; result.City = results.Rows[0][2] as string; result.Zipcode = results.Rows[0][3] as string; result.Latitude = results.Rows[0][4] as string; result.Longitude = results.Rows[0][5] as string; result.Fips = results.Rows[0][6] as string; result.County = results.Rows[0][7] as string; result.Urb = results.Rows[0][8] as string; result.Msa = results.Rows[0][9] as string; result.NearestFacility = new Site(results.Rows[0][10] as string, results.Rows[0][11] as string); result.NearestFacility.SiteType = results.Rows[0][12] as string; result.NearestFacility.RegionId = result.RegionId; result.NearestFacilityDistance = results.Rows[0][13] as string; result.NearestFacilityMsa = result.Msa; result.NearestFacilityUrb = result.Urb; result.NearestMedicalCenter = new Site(results.Rows[0][14] as string, results.Rows[0][15] as string); result.NearestMedicalCenter.RegionId = results.Rows[0][16] as string; result.NearestMedicalCenter.SiteType = "VAMC"; result.NearestMedicalCenterMsa = results.Rows[0][17] as string; result.NearestMedicalCenterUrb = results.Rows[0][18] as string; result.NearestMedicalCenterDistance = results.Rows[0][19] as string; result.NearestFacilityInRegion = new Site(results.Rows[0][20] as string, results.Rows[0][21] as string); result.NearestFacilityInRegion.SiteType = results.Rows[0][22] as string; result.NearestFacilityInRegionMsa = results.Rows[0][23] as string; result.NearestFacilityInRegionUrb = results.Rows[0][24] as string; result.NearestFacilityInRegionDistance = results.Rows[0][25] as string; result.NearestMedicalCenterInRegion = new Site(results.Rows[0][26] as string, results.Rows[0][27] as string); result.NearestMedicalCenterInRegion.SiteType = "VAMC"; result.NearestMedicalCenterInRegionMsa = results.Rows[0][28] as string; result.NearestMedicalCenterInRegionUrb = results.Rows[0][29] as string; result.NearestMedicalCenterInRegionDistance = results.Rows[0][30] as string; return(result); }