public static Collection <string> getCountyStreets() { MedfordToolsDAL.CData oData = new MedfordToolsDAL.CData(SConst.GISConnString); System.Data.DataSet ds = oData.returnTaxCode(); Collection <string> col = new Collection <string>(); return(col); //CMedToolsSubs.returnConfigNode("PropClass", "", SettingsLocation); }
public static Dictionary <string, string> getPropClass() { MedfordToolsDAL.CData oData = new MedfordToolsDAL.CData(SConst.GISConnString); System.Data.DataSet ds = oData.returnPropClass(); Dictionary <string, string> dct = new Dictionary <string, string>(ds.Tables[0].Rows.Count); try { foreach (System.Data.DataRow dr in ds.Tables[0].Rows) { dct.Add(dr["CLASS"].ToString(), dr["CLASS_DESC"].ToString()); } } catch { return(null); } return(dct); //CMedToolsSubs.returnConfigNode("PropClass", "", SettingsLocation); }
public static Dictionary <string, string> getTaxCodes() { MedfordToolsDAL.CData oData = new MedfordToolsDAL.CData(SConst.GISConnString); System.Data.DataSet ds = oData.returnTaxCode(); Dictionary <string, string> dct = new Dictionary <string, string>(ds.Tables[0].Rows.Count); string commaSeperatedVals = ""; try { foreach (System.Data.DataRow dr in ds.Tables[0].Rows) { commaSeperatedVals = dr["City"].ToString() + ", " + dr["schoolDist"].ToString() + "," + dr["waterDist"].ToString() + "," + dr["urbanRenewalDist"].ToString() + "," + dr["fireDist"].ToString(); dct.Add(dr["taxcode"].ToString(), commaSeperatedVals); } } catch { return(null); } return(dct); }