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