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