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