C# Class gov.va.medora.mdo.dao.sql.zipcodeDB.ZipcodeDao

Datei anzeigen Open project: OSEHRA/mdo Class Usage Examples

Public Methods

Method	Description
ZipcodeDao ( string connectionString ) : System
getCitiesInState ( string stateAbbr ) : Zipcode[]
getGeographicLocations ( string zipcode ) : GeographicLocation[]
getStates ( ) : State[]
getZipcode ( string city, string stateAbbr ) : string
matchCityAndState ( string city, string stateAbbr ) : string[]

Private Methods

Method	Description
connect ( ) : void
getDouble ( object arg ) : double
getInt ( object arg ) : int
query ( SqlCommand command ) : DataTable

Method Details

ZipcodeDao() public method

public ZipcodeDao ( string connectionString ) : System
connectionString	string
return	System

getCitiesInState() public method

public getCitiesInState ( string stateAbbr ) : Zipcode[]
stateAbbr	string
return	Zipcode[]

getGeographicLocations() public method

public getGeographicLocations ( string zipcode ) : GeographicLocation[]
zipcode	string
return	GeographicLocation[]

getStates() public method

public getStates ( ) : State[]
return	State[]

getZipcode() public method

public getZipcode ( string city, string stateAbbr ) : string
city	string
stateAbbr	string
return	string

matchCityAndState() public method

public matchCityAndState ( string city, string stateAbbr ) : string[]
city	string
stateAbbr	string
return	string[]