public static ArrayList GetReps3(DistrictMonitor district)
{
ArrayList ret = new ArrayList();
ret.AddRange(Util.Database.DBSelectVector(
"people_roles", "personid",
new Database.SpecLE("startdate", DateTime.Now),
new Database.SpecGE("enddate", DateTime.Now),
new Database.SpecEQ("state", district.State),
new Database.SpecEQ("type", "sen")
));
ret.AddRange(Util.Database.DBSelectVector(
"people_roles", "personid",
new Database.SpecLE("startdate", DateTime.Now),
new Database.SpecGE("enddate", DateTime.Now),
new Database.SpecEQ("state", district.State),
new Database.SpecEQ("district", district.District),
new Database.SpecEQ("type", "rep")
));
return(ret);
}
public string GetName(string district)
{
DistrictMonitor d = new DistrictMonitor(district);
return(Util.GetStateName(d.State) + "'s " + Util.Ordinate(d.District));
}
