public override void Lookup(string name) { FilterName = name; var sql = String.Format(Queries.SelectQuery, ResolveArgs(Queries.SelectArgs)); var results = Database.QueryHelper.RunQuery(_connection, sql); NPCs.Clear(); UnlockObject(); foreach (var dictionary in results) { var npc = new Npc(_queryConfig); //npc.SetProperties(Queries, dictionary); npc.SetPropertiesFaster(Queries, dictionary); AddNPC(npc); npc.Created(); } Created(); }
public override void LookupByZone(string zone) { if (_lookupByZone != null) { var sql = String.Format(_lookupByZone.SelectQuery, zone); var results = QueryHelper.RunQuery(_connection, sql); NPCs.Clear(); foreach (var dict in results) { var npc = new Npc(_queryConfig); npc.SetProperties(Queries, dict); AddNPC(npc); npc.Created(); } } }