Example #1
0
 MonsterManager monsterManager; 

 public MapManager(string conString, string providerName) 
            : base(conString, providerName) 
{
 portalManager = new PortalManager(conString, providerName); 
 npcManager = new NpcManager(conString, providerName);
                                                                                                                                           monsterManager = new MonsterManager(conString, providerName); 
} 

 public Map[] GetAllMaps() 

Example #2
0
 MonsterManager monsterManager;

        public MapManager(string conString, string providerName)
            : base(conString, providerName)
        {
            portalManager = new PortalManager(conString, providerName);
            npcManager = new NpcManager(conString, providerName);
     monsterManager = new MonsterManager(conString, providerName);
        }

        public Map[] GetAllMaps()
        {
            _db.Open();

            DbDataReader reader = _db.ExcecuteReader(DbNames.GETALLMAPS_STOREDPROC, System.Data.CommandType.StoredProcedure, null);

            int ordinalId = reader.GetOrdinal(DbNames.MAP_ID);
            int ordinalName = reader.GetOrdinal(DbNames.MAP_NAME);
            int ordinalMultiplyValue = reader.GetOrdinal(DbNames.MAP_MULTIPLYVALUE);
            int ordinalSpawnX = reader.GetOrdinal(DbNames.MAP_SPAWNX);
            int ordinalSpawnY = reader.GetOrdinal(DbNames.MAP_SPAWNY);

            List<Map> maps = new List<Map>();

            while (reader.Read())
            {
                Map m = new Map()
                {
                    MapID = reader.GetInt32(ordinalId),
                    Name = reader.GetString(ordinalName),
                    MultiplyValue = reader.GetInt32(ordinalMultiplyValue),
                    SpawnX = reader.GetInt32(ordinalSpawnX),
                    SpawnY = reader.GetInt32(ordinalSpawnY)
                };

                maps.Add(m);
            }

            reader.Close();
            _db.Close();

            foreach (Map map in maps)
            {
                map.Portals = portalManager.GetPortalsByMapId(map.MapID);
                map.Npcs = npcManager.GetNpcsByMapId(map.MapID);