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