public static string GetPrimaryCityByZipCode(string zipCode)
{
const string cmdText = "SELECT City FROM ZipCitiesDownloaded" +
" WHERE ZipCode=@ZipCode" + " AND PrimaryRecord='P'";
var cmd = VoteZipNewLocalDb.GetCommand(cmdText, -1);
VoteZipNewLocalDb.AddCommandParameter(cmd, "ZipCode", zipCode);
var result = VoteZipNewLocalDb.ExecuteScalar(cmd);
if ((result == null) || (result == DBNull.Value))
{
return(null);
}
return(result as string);
}
public static string GetFirstStateByZipCode(string zipCode)
{
var cmdText = "SELECT State FROM ZipCitiesDownloaded WHERE ZipCode=@ZipCode";
cmdText = VoteDb.InjectSqlLimit(cmdText, 1);
var cmd = VoteZipNewLocalDb.GetCommand(cmdText, -1);
VoteZipNewLocalDb.AddCommandParameter(cmd, "ZipCode", zipCode);
var result = VoteZipNewLocalDb.ExecuteScalar(cmd);
if ((result == null) || (result == DBNull.Value))
{
return(null);
}
return(result as string);
}
