コード例 #1
0
ファイル: PostalCodes.cs プロジェクト: anthonywoodard/postal
 public PostalCode getCityByZip(int zipcode=0)
 {
     PostalCode pc = new PostalCode ();
     List<PostalCode> postalcodes = execute ("WHERE Zipcode = " + zipcode);
     if (postalcodes.Count > 0) {
         pc = postalcodes [0];
     }
     return pc;
 }
コード例 #2
0
ファイル: PostalCodes.cs プロジェクト: anthonywoodard/postal
 private List<PostalCode> execute(string sqlwhere)
 {
     List<PostalCode> postalcodes = new List<PostalCode>();
     var connection = DbHelper.GetConnection();
     if (!connection.Equals (null)) {
         using (var cmd = connection.CreateCommand()) {
             connection.Open();
             cmd.CommandText = "SELECT * FROM vw_zipcodes " + sqlwhere;
             using (var reader = cmd.ExecuteReader()) {
                 while (reader.Read()) {
                     PostalCode pc = new PostalCode();
                     pc.zipcode = reader.GetInt32(reader.GetOrdinal("Zipcode"));
                     pc.city = StringHelper.ToTitleCase(reader.GetString(reader.GetOrdinal("City")));
                     pc.state = reader.GetString(reader.GetOrdinal("State"));
                     pc.state_abbr = reader.GetString(reader.GetOrdinal("Abbr"));
                     postalcodes.Add(pc);
                 }
             }
             connection.Close();
         }
     }
     return postalcodes;
 }