public static ZipCitiesDownloadedTable GetCityAliasesDataLikeCityAliasName( string cityAliasName, int commandTimeout) { var cmdText = SelectCityAliasesCommandText + " WHERE CityAliasName LIKE @CityAliasName"; var cmd = VoteZipNewLocalDb.GetCommand(cmdText, commandTimeout); VoteZipNewLocalDb.AddCommandParameter(cmd, "CityAliasName", cityAliasName); return(FillTable(cmd, ZipCitiesDownloadedTable.ColumnSet.CityAliases)); }
public static UszdTable GetDataByZip4List( string zip5, IEnumerable <string> zip4List, int commandTimeout = -1) { var cmdText = $"{SelectAllCommandText} WHERE ZIP5=@Zip5 AND ZIP4 IN ('{string.Join("','", zip4List)}')"; var cmd = VoteZipNewLocalDb.GetCommand(cmdText, commandTimeout); VoteZipNewLocalDb.AddCommandParameter(cmd, "Zip5", zip5); return(FillTable(cmd, UszdTable.ColumnSet.All)); }
public static UszdTable GetDataByZipPlus4Range( string zip5, string zip4Low, string zip4High, int commandTimeout = -1) { var cmdText = SelectAllCommandText + " WHERE ZIP5=@Zip5 AND ZIP4 >= @Zip4Low AND ZIP4 <= @Zip4High"; var cmd = VoteZipNewLocalDb.GetCommand(cmdText, commandTimeout); VoteZipNewLocalDb.AddCommandParameter(cmd, "Zip5", zip5); VoteZipNewLocalDb.AddCommandParameter(cmd, "Zip4Low", zip4Low); VoteZipNewLocalDb.AddCommandParameter(cmd, "Zip4High", zip4High); return(FillTable(cmd, UszdTable.ColumnSet.All)); }
public static ZipCitiesDownloadedTable GetCityAliasesDataByStateLikeCityAliasName (string state, string cityAliasName, int commandTimeout) { const string cityCondition = " CityAliasName LIKE @CityAliasName "; var cmdText = SelectCityAliasesCommandText + " WHERE State=@State AND" + cityCondition; var cmd = VoteZipNewLocalDb.GetCommand(cmdText, commandTimeout); VoteZipNewLocalDb.AddCommandParameter(cmd, "State", state); VoteZipNewLocalDb.AddCommandParameter(cmd, "CityAliasName", cityAliasName); return(FillTable(cmd, ZipCitiesDownloadedTable.ColumnSet.CityAliases)); }
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); }