public static TableRow GetPersonCurrentRoleInfo(int id)
{
lock (RolesCache) {
TableRow role = (TableRow)RolesCache[id];
if (role == null)
{
Database.Spec whenspec = RoleNow(id);
role = Util.Database.DBSelectFirst("people_roles", "type, state, district, party, title, url", whenspec, new Database.SpecOrder("startdate", false));
RolesCache[id] = role;
}
return(role);
}
}
public static double WhoWasPresidentAt(string date)
{
Database.Spec whenspec = RoleThen(-1, Util.DTToDateTime(date));
return((int)Util.Database.DBSelectFirst("people_roles", "personid", whenspec, new Database.SpecEQ("type", "prez"))["personid"]);
}
public static TableRow GetPersonRoleInfoAt(int id, int session)
{
Database.Spec whenspec = RoleThen(id, Util.EndOfSession(session), Util.StartOfSession(session));
return(Util.Database.DBSelectFirst("people_roles", "type, state, district, party, title, url", whenspec, new Database.SpecOrder("startdate", false)));
}
