public Cell GetCell(int arenaId, int positionX, int positionY)
{
IDatabase database = Database.Instance();
var parameters = new List <SqlParameter> {
new SqlParameter("@ARENA_ID", arenaId),
new SqlParameter("@POSITION_X", positionX),
new SqlParameter("@POSITION_Y", positionY),
};
var commonData = database.ExecuteQuery(
"SELECT PLAYER_ID, IS_MINE FROM ARENA_CELL WHERE ARENA_ID=@ARENA_ID AND POSITION_X=@POSITION_X AND POSITION_Y=@POSITION_Y",
parameters.ToArray());
var parameters2 = new List <SqlParameter> {
new SqlParameter("@ARENA_ID", arenaId),
new SqlParameter("@POSITION_X", positionX),
new SqlParameter("@POSITION_Y", positionY),
};
var nearMinesCounterStatement = "select count(*) as near_mines from ARENA_CELL where ARENA_ID=@ARENA_ID and " +
"( (POSITION_X=(@POSITION_X -1) AND POSITION_Y=@POSITION_Y AND IS_MINE=1) OR " +
"(POSITION_X=(@POSITION_X +1) AND POSITION_Y=@POSITION_Y AND IS_MINE=1) OR " +
"(POSITION_X=@POSITION_X AND POSITION_Y=(@POSITION_Y +1) AND IS_MINE=1) OR " +
"(POSITION_X=@POSITION_X AND POSITION_Y=(@POSITION_Y -1) AND IS_MINE=1) OR " +
"(POSITION_X=(@POSITION_X +1) AND POSITION_Y=(@POSITION_Y +1) AND IS_MINE=1) OR " +
"(POSITION_X=(@POSITION_X -1) AND POSITION_Y=(@POSITION_Y -1) AND IS_MINE=1) OR " +
"(POSITION_X=(@POSITION_X +1) AND POSITION_Y=(@POSITION_Y -1) AND IS_MINE=1) OR " +
"(POSITION_X=(@POSITION_X -1) AND POSITION_Y=(@POSITION_Y +1) AND IS_MINE=1) )";
var nearMinesDS = database.ExecuteQuery(nearMinesCounterStatement, parameters2.ToArray());
var cell = ArenaMapper.ToCelEntity(commonData, nearMinesDS);
return(cell);
}
public void Delete(int id)
{
IDatabase database = Database.Instance();
var parameters = new List <SqlParameter> {
new SqlParameter("@ID", id)
};
database.ExecuteNonQuery(@"DELETE PLAYER WHERE ID = @ID", parameters.ToArray());
}
public void Update(Player player)
{
IDatabase database = Database.Instance();
var parameters = new List <SqlParameter> {
new SqlParameter("@NICKNAME", player.NickName)
};
database.ExecuteNonQuery(@"UPDATE PLAYER SET NICKNAME = @NICKNAME",
parameters.ToArray());
}
public Player FindById(int id)
{
IDatabase database = Database.Instance();
var parameters = new List <SqlParameter> {
new SqlParameter("@ID", id)
};
var dataSet = database.ExecuteQuery(@"SELECT * from PLAYER WHERE ID = @ID", parameters.ToArray());
return(PlayerMapper.ToEntity(dataSet));
}
public void Delete(int id)
{
IDatabase database = Database.Instance();
database.ExecuteNonQuery("DELETE GAME_PLAYER WHERE GAME_ID=@ID",
new List <SqlParameter> {
new SqlParameter("@ID", id)
}.ToArray());
database.ExecuteNonQuery("DELETE GAME WHERE ID=@ID",
new List <SqlParameter> {
new SqlParameter("@ID", id)
}.ToArray());
}
public void UpdateCellPlayer(int arenaId, int positionX, int positionY, int playerId)
{
IDatabase database = Database.Instance();
var parameters = new List <SqlParameter> {
new SqlParameter("@PLAYER_ID", playerId),
new SqlParameter("@ARENA_ID", arenaId),
new SqlParameter("@POSITION_X", positionX),
new SqlParameter("@POSITION_Y", positionY),
};
database.ExecuteNonQuery("UPDATE ARENA_CELL SET PLAYER_ID=@PLAYER_ID WHERE ARENA_ID=@ARENA_ID AND POSITION_X=@POSITION_X AND POSITION_Y=@POSITION_Y",
parameters.ToArray());
}
public Game FindById(int id)
{
IDatabase database = Database.Instance();
var parameters = new List <SqlParameter> {
new SqlParameter("@ID", id)
};
var gameDs = database.ExecuteQuery(@"SELECT * from GAME WHERE ID = @ID", parameters.ToArray());
var gameParameters = new List <SqlParameter> {
new SqlParameter("@ID", id)
};
var cellsDs = database.ExecuteQuery(@"SELECT * from GAME_PLAYER WHERE GAME_ID = @ID", gameParameters.ToArray());
return(GameMapper.ToEntity(gameDs, cellsDs));
}
public Arena FindById(int id)
{
IDatabase database = Database.Instance();
var parameters = new List <SqlParameter> {
new SqlParameter("@ID", id)
};
var arenaDs = database.ExecuteQuery(@"SELECT * from ARENA WHERE ID = @ID", parameters.ToArray());
var cellParameters = new List <SqlParameter> {
new SqlParameter("@ID", id)
};
var cellsDs = database.ExecuteQuery(@"SELECT * from ARENA_CELL WHERE ARENA_ID = @ID", cellParameters.ToArray());
return(ArenaMapper.ToArenaEntity(arenaDs, cellsDs));
}
public void Delete(int id)
{
IDatabase database = Database.Instance();
var transaction = database.BeginTransaction();
try
{
DeleteArenaTable(id, database, transaction);
DeleteArenaCellTable(id, database, transaction);
transaction.Commit();
}
catch (Exception e)
{
Console.WriteLine("There was an issue deleting Arena: " + e.Message);
transaction.Rollback();
}
}
public void Update(Arena arena)
{
IDatabase database = Database.Instance();
var transaction = database.BeginTransaction();
try
{
UpdateArenaTable(arena, database, transaction);
UpdateArenaCellTable(arena, database, transaction);
transaction.Commit();
}
catch (Exception e)
{
Console.WriteLine("There was an issue updating Arena: " + e.Message);
transaction.Rollback();
}
}
public int Create(Player player)
{
var columns = "";
var values = "";
IDatabase database = Database.Instance();
var parameters = new List <SqlParameter> {
new SqlParameter("@NICKNAME", player.NickName)
};
columns += "NICKNAME";
values += "@NICKNAME";
return((int)database.ExecuteScalar(
"INSERT INTO PLAYER(" + columns + ") " +
"OUTPUT INSERTED.ID VALUES (" + values + ")",
parameters.ToArray()));
}
public void Update(Game game)
{
IDatabase database = Database.Instance();
var transaction = database.BeginTransaction();
try
{
UpdateGameTable(game, database, transaction);
UpdateGamePlayerTable(game.Players, game.Id, database, transaction);
transaction.Commit();
Console.WriteLine("Game [" + game.Id + "] successfully updated.");
}
catch (Exception e)
{
Console.WriteLine("There was an issue updating Game: " + e.Message);
transaction.Rollback();
}
}
public int Create(Game game)
{
IDatabase database = Database.Instance();
var transaction = database.BeginTransaction();
var gameId = -1;
try
{
gameId = InsertGameTable(game, database, transaction);
InsertGamePlayerTable(game.Players, gameId, database, transaction);
transaction.Commit();
Console.WriteLine("Game [" + gameId + "] successfully persisted.");
}
catch (Exception e)
{
Console.WriteLine("There was an issue persisting Game: " + e.Message);
transaction.Rollback();
}
return(gameId);
}
public int Create(Arena arena)
{
IDatabase database = Database.Instance();
var transaction = database.BeginTransaction();
try
{
var columns = "";
var values = "";
var arenaId = InsertArena(arena, columns, values, database, transaction);
InsertCell(arena.Cells, arenaId, database, transaction);
Console.WriteLine("Arena [" + arenaId + "] successfully persisted.");
transaction.Commit();
return(arenaId);
}
catch (Exception e)
{
Console.WriteLine("There was an issue persisting Arena: " + e.Message);
transaction.Rollback();
return(-1);
}
}
