public static CatAgent GetSingleAgent(string FirmToSearch, string PCCToSearch)
{
CatAgent item = new CatAgent();
CatAgentDAL objCatAgent = new CatAgentDAL();
try
{
try
{
item = objCatAgent.GetSingleAgent(FirmToSearch, PCCToSearch, CommonENT.MYCTSDBSECURITY_CONNECTION);
}
catch (Exception ex)
{
new EventsManager.EventsManager(ex, EventsManager.EventsManager.OrigenError.BaseDeDatos);
item = objCatAgent.GetSingleAgent(FirmToSearch, PCCToSearch, CommonENT.MYCTSDBSECURITYBACKUP_CONNECTION);
}
}
catch { }
return(item);
}
public CatAgent GetSingleAgent(string FirmToSearch, string PCCToSearch, string connectionName)
{
Database db = DatabaseFactory.CreateDatabase(connectionName);
DbCommand dbCommand = db.GetStoredProcCommand(Resources.CatAgentResources.SP_GetAgent);
db.AddInParameter(dbCommand, Resources.CatAgentResources.PARAM_QUERY, DbType.String, FirmToSearch);
db.AddInParameter(dbCommand, Resources.CatAgentResources.PARAM_QUERY2, DbType.String, PCCToSearch);
CatAgent item = new CatAgent();
using (IDataReader dr = db.ExecuteReader(dbCommand))
{
int _agent = dr.GetOrdinal(Resources.CatAgentResources.PARAM_AGENT);
if (dr.Read())
{
item.Agent = (dr[_agent] == DBNull.Value) ? Types.StringNullValue : dr.GetString(_agent);
}
}
return(item);
}
// Generates the level from a multi-dimensional array
public void CreateBoard(char[,] map)
{
MAX_ROW = map.GetLength(0);
MAX_COL = map.GetLength(1);
Node.Walls = new HashSet <Location>();
Node.Pits = new HashSet <Location>();
for (int i = 0; i < MAX_ROW; i++)
{
for (int j = 0; j < MAX_COL; j++)
{
Location loc = new Location(i, j);
char symbol = map[i, j];
GameObject tile;
tile = Instantiate(tilePrefab, loc.ToVector(), Quaternion.identity);
tile.transform.SetParent(TileHolder.transform);
TileProperties tileProperties = tile.GetComponent <TileProperties>();
if (symbol == '+')
{
Node.Walls.Add(loc);
tileProperties.Type = Item.Wall;
}
else if (symbol == '-')
{
Node.Pits.Add(loc);
tileProperties.Type = Item.Pit;
}
else
{
tileProperties.Type = Item.Floor;
FloorTiles.Add(loc, tile);
}
if (char.ToLower(symbol) >= 'a' && char.ToLower(symbol) <= 'z')
{
char lwrSymbol = char.ToLower(symbol);
if (!Rooms.ContainsKey(lwrSymbol))
{
Rooms.Add(lwrSymbol, new Room(lwrSymbol));
}
Rooms[lwrSymbol].UnexploredTiles.Add(loc);
Util.SetColor(FloorTiles[loc], Color.gray);
}
else if (symbol == '0')
{
Cat = new CatAgent(symbol, loc);
}
else if (symbol >= '1' && symbol <= '9')
{
Children.Add(symbol, new ChildAgent(symbol, loc));
}
else if (symbol == '&')
{
Obstacles[loc] = new Obstacle(loc);
GameObject prefab = objectPrefabs[0];
GameObject go;
go = Instantiate(prefab, loc.ToVector(), Quaternion.identity);
go.transform.SetParent(ObjectHolder.transform);
ObjectPieces.Add(loc, go);
}
if (symbol >= 'A' && symbol <= 'Z')
{
Foods[loc] = new Food(loc);
GameObject go;
go = Instantiate(foodPrefab, loc.ToVector(), Quaternion.identity);
go.transform.SetParent(ObjectHolder.transform);
ObjectPieces.Add(loc, go);
}
}
}
foreach (Room r in Rooms.Values)
{
foreach (Location loc in r.UnexploredTiles)
{
HashSet <Location> neighbors = new HashSet <Location>()
{
new Location(loc.Row + 1, loc.Col),
new Location(loc.Row - 1, loc.Col),
new Location(loc.Row, loc.Col + 1),
new Location(loc.Row, loc.Col - 1)
};
foreach (Location neighbor in neighbors)
{
if (!Node.Walls.Contains(neighbor) && !Obstacles.ContainsKey(neighbor) &&
!r.UnexploredTiles.Contains(neighbor))
{
r.Entrances.Add(loc);
}
}
}
}
}
