public IHttpActionResult InsertNewPlayer(PlayerModels player)
{
IDbConnection con = new ApplicationDbContext().Database.Connection;
string sql = "INSERT INTO dbo.Player (Id, FirstName, LastName, NickName, Email, BirthDate, City, BlobUri) " +
$"VALUES ('{player.Id}','{player.FirstName}','{player.LastName}','{player.NickName}','{player.Email}'," +
$"CONVERT(datetime2,'{player.BirthDate}'),'{player.City}','{player.BlobUri}')";
try
{
con.Execute(sql);
}
catch (Exception e)
{
return(BadRequest("Error inserting player in database, " + e.Message));
}
finally
{
con.Close();
}
return(Ok());
}
private void _RearrangeSeats()
{
Trace.Assert(_game.Players.Count == PlayerModels.Count);
int playerCount = _game.Players.Count;
for (int i = 0; i < playerCount; i++)
{
int gameSeat = (i + MainPlayerSeatNumber) % playerCount;
Player gamePlayer = _game.Players[gameSeat];
bool found = false;
for (int j = i; j < playerCount; j++)
{
PlayerViewModel playerModel = PlayerModels[j];
if (gamePlayer == playerModel.Player)
{
if (j != i)
{
PlayerModels.Move(j, i);
}
found = true;
break;
}
}
Trace.Assert(found);
}
}
public CombatFactory(PlayerModels.PlayerModel playerModel, string map, Func<int> randomNumberGenerator, Func<float> initiativeCalculator, Action onGameOver, Action onUpdate, Action<CombatEndType> onCombatComplete)
{
this.playerModel = playerModel;
this.map = map;
this.randomNumberGenerator = randomNumberGenerator;
this.initiativeCalculator = initiativeCalculator;
this.onGameOver = onGameOver;
this.onUpdate = onUpdate;
this.onCombatComplete = onCombatComplete;
}
public ActionResult Create(PlayerModels model)
{
if (ModelState.IsValid)
{
db.Players.Add(model);
db.SaveChanges();
return(RedirectToAction("Details", model.ID));
}
return(RedirectToAction("List"));
}
public ActionResult Details(int id)
{
PlayerModels model = db.Players.Find(id);
if (model == null)
{
return(HttpNotFound());
}
Player player = PlayerHelper.PlayerModeltoPlayer(model);
return(View(player));
}
public static Player PlayerModeltoPlayer(PlayerModels model)
{
Player player = new Player();
player.ID = model.ID;
player.FirstName = model.FirstName;
player.LastName = model.LastName;
player.Paid = model.Paid;
player.Level = model.Level;
player.Preference = model.Preference;
player.EnrollmentDate = model.EnrollmentDate;
player.Active = model.Active;
return(player);
}
//constructor
void Awake()
{
singleton = this;
maxSpeedPlayer = 1800;
accelerationPlayer = 275;
revMaxSpeedPlayer = -200;
rotationSpeedPlayer = 4;
maxStrengthPlayer = 2;
strengthPlayer = maxStrengthPlayer;
maxFuelPlayer = 350;
fuelPlayer = maxFuelPlayer;
bananaPlayer = 0;
orbsPlayer = 0;
}
public ActionResult Details(int?id)
{
if (id == null)
{
return(RedirectToAction("Index"));
}
var query = db.Player.Include(s => s.Player).Include(s => s.Advertisement).Where(i => i.ID == id);
PlayerModels player = query.Single();
if (player == null)
{
return(HttpNotFound());
}
return(View(player));
}
public ActionResult Delete(int id)
{
PlayerModels player = db.Player.Find(id);
try
{
db.Player.Remove(player);
db.SaveChanges();
return(RedirectToAction("Index"));
}
catch
{
ViewBag.Message = String.Format("This element is coneted with other DB you cant remove it!");
return(View(player));
}
}
public Models.PlayerModels ObterPlayer(int id)
{
SqlConnection conn = new SqlConnection();
SqlCommand sqlCom = new SqlCommand();
conn.ConnectionString = ConfigurationManager.ConnectionStrings["DB_SW"].ToString();
StringBuilder cmd = new StringBuilder();
cmd.Append("SELECT * FROM DB_SW.dbo.Player WHERE ID = @ID");
sqlCom.CommandText = cmd.ToString();
sqlCom.CommandType = System.Data.CommandType.Text;
sqlCom.Parameters.Add(new SqlParameter("@ID", System.Data.SqlDbType.Int));
sqlCom.Parameters["@ID"].Value = id;
try
{
Models.PlayerModels objPlayer = new PlayerModels();
conn.Open();
sqlCom.Connection = conn;
SqlDataReader reader = sqlCom.ExecuteReader();
while (reader.Read())
{
objPlayer = new Models.PlayerModels();
objPlayer.Id = Convert.ToInt32(reader["ID"].ToString());
objPlayer.Nome = reader["Nome"].ToString();
objPlayer.Level = Convert.ToInt32(reader["Level"].ToString());
objPlayer.PontoArena = Convert.ToInt32(reader["PontoArena"].ToString());
objPlayer.Ativo = (reader["Status"].ToString() == "S") ? true : false;
}
conn.Close();
conn.Dispose();
return(objPlayer);
}
catch (Exception ex)
{
throw ex;
}
}
public static Player ActivePlayertoPlayer(ActivePlayer activePlayer, BadmintonContext db)
{
Player player = new Player();
PlayerModels model = db.Players.SingleOrDefault(x => x.ID == activePlayer.PlayerID);
player.ID = model.ID;
player.FirstName = model.FirstName;
player.LastName = model.LastName;
player.Paid = model.Paid;
player.Level = model.Level;
player.Preference = model.Preference;
player.EnrollmentDate = model.EnrollmentDate;
player.OnCourt = activePlayer.OnCourt;
player.Active = model.Active;
player.Waits = activePlayer.Waits;
player.GamesPlayed = activePlayer.GamesPlayed;
return(player);
}
public ActionResult Create(PlayerModels player, int id /*int id, string content*/)
{
try
{
PlayerModels player1 = new PlayerModels();
var query = db.User.Where(i => i.Email == User.Identity.Name);
UserModels user = query.Single();
var query2 = db.Advertisement.Where(i => i.ID == id);
AdvertisementModels adv = query2.Single();
player1.Player = user;
player1.Advertisement = adv;
PlayerModels testPlayer = new PlayerModels();
testPlayer.Advertisement = adv;
testPlayer.Player = user;
var test = db.Player
.Where(b => b.Player.ID == user.ID)
.Where(c => c.Advertisement.ID == adv.ID)
.FirstOrDefault();
if (test != null)
{
System.Diagnostics.Debug.WriteLine("You are already added to the game!");
return(RedirectToAction("Details", "AdvertisementModel", new { id }));
}
if (ModelState.IsValid)
{
System.Diagnostics.Debug.WriteLine("IS WALID");
db.Player.Add(player1);
db.SaveChanges();
return(RedirectToAction("Details", "AdvertisementModel", new { id }));
}
return(RedirectToAction("Details", "AdvertisementModel", new { id }));
}
catch
{
return(View());
}
}
public ActionResult DeleteExacly(int?id)
{
var query = db.User.Where(i => i.Email == User.Identity.Name);
UserModels user = query.Single();
System.Diagnostics.Debug.WriteLine(id);
try
{
var query2 = db.Player.Where(i => i.Player.ID == user.ID).Where(j => j.Advertisement.ID == id);
PlayerModels player = query2.Single();
db.Player.Remove(player);
db.SaveChanges();
return(RedirectToAction("Details", "AdvertisementModel", new { id }));
}
catch
{
return(RedirectToAction("Details", "AdvertisementModel", new { id }));
}
}
public IHttpActionResult UpdatePlayer(PlayerModels player)
{
IDbConnection con = new ApplicationDbContext().Database.Connection;
string sql = "UPDATE dbo.Players " +
$"SET FirstName = '{player.FirstName}', LastName = '{player.LastName}', NickName = '{player.NickName}'" +
$"WHERE Id = '{player.Id}'";
try
{
con.Execute(sql);
}
catch (Exception e)
{
return(BadRequest("Error Update player in database, " + e.Message));
}
finally
{
con.Close();
}
return(Ok());
}
public IHttpActionResult EliminarCuenta(PlayerModels player)
{
IDbConnection con = new ApplicationDbContext().Database.Connection;
// Eliminar en la tabla dbo.Players
string sql = "DELETE FROM dbo.Player" +
$" WHERE Id = '{player.Id}'";
// Eliminar en la tabla dbo.AspNetUsers
string sql2 = "DELETE FROM dbo.AspNetUsers " +
$"WHERE Id = '{player.Id}'";
try
{
con.Execute(sql);
}
catch (Exception e)
{
return(BadRequest("Error Eliminar Jugador en la tabla Players, " + e.Message));
}
try
{
con.Execute(sql2);
}
catch (Exception ex)
{
return(BadRequest("Error Eliminar Usuario en la tabla AspNetUsers, " + ex.Message));
}
finally
{
con.Close();
}
return(Ok());
}
public GuildaPlayersModels ListarUsuariosGuilda(long idGuilda)
{
SqlConnection conexao = new SqlConnection();
SqlCommand command = new SqlCommand();
conexao.ConnectionString = ConfigurationManager.ConnectionStrings["DB_SW"].ToString();
StringBuilder select = new StringBuilder();
select.AppendLine("select ");
select.AppendLine("a.Ativo,a.IdGuilda,a.IdPlayer,a.IdUsuario, ");
select.AppendLine("b.Id,b.Nome, ");
select.AppendLine("c.ID,c.Imagem,c.Level,c.Nome NomePlayer, c.PontoArena,c.Status, ");
select.AppendLine("d.Id,d.Email,d.UserName ");
select.AppendLine("from dbo.Guilda_Player a ");
select.AppendLine("inner join dbo.Guilda b on b.Id = a.IdGuilda ");
select.AppendLine("inner join dbo.Player c on c.ID = a.IdPlayer ");
select.AppendLine("left join dbo.AspNetUsers d on d.Id = a.IdUsuario ");
select.AppendLine("where a.IdGuilda = @idGuilda ");
command.Parameters.Add(new SqlParameter("@idGuilda", System.Data.SqlDbType.Int));
command.Parameters["@idGuilda"].Value = idGuilda;
command.CommandText = select.ToString();
command.CommandType = System.Data.CommandType.Text;
try
{
conexao.Open();
command.Connection = conexao;
SqlDataReader reader = command.ExecuteReader();
GuildaPlayersModels objGuildaPlayer = new GuildaPlayersModels();
objGuildaPlayer.Guilda = ObterGuilda(idGuilda);
objGuildaPlayer.Usuarios = new List <UsuarioModels>();
objGuildaPlayer.Players = new List <PlayerModels>();
while (reader.Read())
{
UsuarioModels objUsuario = new UsuarioModels();
objUsuario.Id = reader["IdUsuario"].ToString();
objUsuario.Email = reader["Email"].ToString();
objUsuario.UserName = reader["UserName"].ToString();
objGuildaPlayer.Usuarios.Add(objUsuario);
PlayerModels objPlayer = new PlayerModels();
objPlayer.Id = Convert.ToInt32(reader["IdPlayer"].ToString());
objPlayer.Nome = reader["NomePlayer"].ToString();
objPlayer.Level = Convert.ToInt32(reader["Level"].ToString());
objPlayer.PontoArena = Convert.ToInt32(reader["PontoArena"].ToString());
objPlayer.Ativo = (reader["Status"].ToString() == "S") ? true : false;
objPlayer.Usuario = objUsuario;
objGuildaPlayer.Players.Add(objPlayer);
}
conexao.Close();
conexao.Dispose();
return(objGuildaPlayer);
}
catch (Exception ex)
{
throw ex;
}
}
public CombatDirector(PlayerModels.PlayerModel playerModel, string initialMap, Func<int> randomNumberGenerator, Func<float> initiativeCalculator, Action onGameOver, Action onUpdate, Action<CombatEndType> onCombatComplete)
{
factory = new LiveImplementation.CombatFactory(playerModel, initialMap, randomNumberGenerator, initiativeCalculator, onGameOver, onUpdate, onCombatComplete);
}
public void AddPlayer(string _name, PlayerType type)
{
PlayerModels.Add(new PlayerModel(TheBoard.AddPlayer(_name, type)));
}
private PlayerModel GetModelOfPlayer(Player Player)
{
PlayerModel PM = PlayerModels.First(pm => pm.Player == Player);
return(PM);
}
public Combat(PlayerModels.PlayerModel playerModel, string map, int encounterSelection, Func<float> initiativeCalculator, Action onGameOver, Action onUpdate, Action<CombatEndType> onCombatComplete)
{
int currentUniq = 1;
this.playerModel = playerModel;
uniqBridge = new Dictionary<int, int>();
pcs = new Dictionary<int, FullCombatCharacter>();
npcs = new Dictionary<int, FullCombatCharacter>();
currentEffects = new List<IEffect>();
currentCharacter = new FullCombatCharacter();
this.onGameOver = onGameOver;
this.onUpdate = onUpdate;
this.onCombatComplete = onCombatComplete;
this.map = map;
bool canFlee = true;
List<PlayerModels.Models.PartyCharacterModel> partyCharacterModels = PlayerModels.PlayerDataManager.getCurrentPartyPartyStats(playerModel);
List<int> characterUniqs = new List<int>();
foreach (PlayerModels.Models.PartyCharacterModel pcm in partyCharacterModels)
{
characterUniqs.Add(pcm.characterUniq);
}
List<PlayerModels.Models.CharacterModel> characterModels = PlayerModels.PlayerDataManager.getCurrentParty(playerModel, characterUniqs);
bool hasPreviousCombatModels = false;
if (playerModel.currentCombat == null)
{
combatCharacterModels = new List<PlayerModels.CombatDataModels.CombatCharacterModel>();
combatNPCModels = new List<CombatCharacterModel>();
playerModel.currentCombat = new CombatModel();
playerModel.currentCombat.currentTime = 0;
playerModel.currentCombat.pcs = combatCharacterModels;
playerModel.currentCombat.npcs = combatNPCModels;
}
else
{
combatCharacterModels = playerModel.currentCombat.pcs;
combatNPCModels = playerModel.currentCombat.npcs;
hasPreviousCombatModels = true;
}
foreach (int characterUniq in characterUniqs)
{
string name = string.Empty;
int hp = 0;
int maxHP = 0;
int mp = 0;
int maxMP = 0;
int turnOrder = 0;
string classType = string.Empty;
int level = 0;
int strength = 0;
int vitality = 0;
int agility = 0;
int intellect = 0;
int wisdom = 0;
int nextAttackTime = 0;
int classLevel = 0;
int combatUniq = currentUniq;
List<CombatModificationsModel> mods = new List<CombatModificationsModel>();
List<string> usedAbilities = new List<string>();
uniqBridge.Add(currentUniq, characterUniq);
foreach (PlayerModels.Models.CharacterModel cm in characterModels)
{
if (cm.uniq == characterUniq)
{
name = cm.name;
maxHP = cm.stats.maxHP;
maxMP = cm.stats.maxMP;
classType = cm.currentClass;
level = cm.lvl;
strength = cm.stats.strength;
vitality = cm.stats.vitality;
agility = cm.stats.agility;
intellect = cm.stats.intellect;
wisdom = cm.stats.wisdom;
foreach (PlayerModels.Models.CharacterClassModel ccm in cm.characterClasses)
{
if (ccm.className == classType)
{
classLevel = ccm.lvl;
}
}
}
}
foreach (PlayerModels.Models.PartyCharacterModel pcm in partyCharacterModels)
{
if (pcm.characterUniq == characterUniq)
{
hp = pcm.hp;
mp = pcm.mp;
usedAbilities = (pcm.usedAbilities == null ? new List<string>() : pcm.usedAbilities);
}
}
nextAttackTime = GeneralProcessor.calculateNextAttackTime(0, initiativeCalculator(), agility);
if (hasPreviousCombatModels)
{
foreach (CombatCharacterModel ccm in combatCharacterModels)
{
if (ccm.characterUniq == characterUniq)
{
nextAttackTime = ccm.nextAttackTime;
hp = ccm.stats.hp;
mp = ccm.stats.mp;
combatUniq = ccm.combatUniq;
}
}
}
else {
combatCharacterModels.Add(new PlayerModels.CombatDataModels.CombatCharacterModel()
{
characterUniq = characterUniq,
stats = new PlayerModels.CombatDataModels.TemporaryCombatStatsModel() { hp = hp, mp = mp },
nextAttackTime = nextAttackTime,
combatUniq = combatUniq
});
}
pcs.Add(characterUniq, new FullCombatCharacter() {
name = name,
maxHP = maxHP,
hp = hp,
maxMP = maxMP,
mp = mp,
characterUniq = characterUniq,
combatUniq = currentUniq,
className = classType,
classLevel = classLevel,
level = level,
strength = strength,
vitality = vitality,
intellect = intellect,
agility = agility,
wisdom = wisdom,
nextAttackTime = nextAttackTime,
mods = new List<CombatModificationsModel>(),
usedAbilities = usedAbilities
});
combatCharacterModels[combatCharacterModels.Count - 1].mods = pcs[characterUniq].mods;
currentUniq++;
}
if (hasPreviousCombatModels) //Combat was already initialized previously, just load the previous combatants
{
foreach (CombatCharacterModel ccm in combatNPCModels)
{
int hp = ccm.stats.hp;
int mp = ccm.stats.mp;
string name = ccm.name;
int nextAttackTime = ccm.nextAttackTime;
List<CombatModificationsModel> mods = ccm.mods;
List<string> usedAbilities = new List<string>();
MapDataClasses.MapDataClasses.Enemy enemy = MapDataClasses.MapDataManager.getEnemy(map, ccm.classType);
if (!this.npcs.ContainsKey(currentUniq))
{
this.npcs.Add(currentUniq, new FullCombatCharacter()
{
name = name,
hp = hp,
maxHP = enemy.maxHP,
mp = mp,
maxMP = enemy.maxMP,
characterUniq = 0,
combatUniq = currentUniq,
className = enemy.type,
level = enemy.level,
strength = enemy.strength,
vitality = enemy.vitality,
agility = enemy.agility,
intellect = enemy.intellect,
wisdom = enemy.wisdom,
nextAttackTime = nextAttackTime,
mods = mods,
usedAbilities = usedAbilities
});
}
currentUniq++;
}
}
else //Generate a new encounter based on the map type
{
Encounter encounter = MapDataClasses.MapDataManager.getEncounter(this.playerModel.getActiveParty().location, playerModel.rootX, playerModel.rootY, encounterSelection);
currentEffects.Add(new Effect(EffectTypes.Message, 0, encounter.message, 0));
combatNPCModels = new List<PlayerModels.CombatDataModels.CombatCharacterModel>();
canFlee = encounter.canFlee;
foreach (MapDataClasses.MapDataClasses.Enemy enemy in encounter.enemies)
{
int nextAttackTime = GeneralProcessor.calculateNextAttackTime(0, initiativeCalculator(), enemy.agility);
int hp = enemy.maxHP;
int mp = enemy.maxMP;
int combatUniq = currentUniq;
List<CombatModificationsModel> mods = new List<CombatModificationsModel>();
List<string> usedAbilities = new List<string>();
this.npcs.Add(currentUniq, new FullCombatCharacter()
{
name = enemy.name,
hp = hp,
maxHP = enemy.maxHP,
mp = mp,
maxMP = enemy.maxMP,
characterUniq = 0,
combatUniq = currentUniq,
className = enemy.type,
level = enemy.level,
strength = enemy.strength,
vitality = enemy.vitality,
agility = enemy.agility,
intellect = enemy.intellect,
wisdom = enemy.wisdom,
nextAttackTime = nextAttackTime,
mods = mods,
usedAbilities = usedAbilities
});
this.combatNPCModels.Add(new PlayerModels.CombatDataModels.CombatCharacterModel()
{
name = enemy.name,
stats = new PlayerModels.CombatDataModels.TemporaryCombatStatsModel()
{
hp = hp,
mp = mp
},
nextAttackTime = nextAttackTime,
combatUniq = currentUniq,
characterUniq = 0,
classType = enemy.type,
mods = this.npcs[currentUniq].mods
});
currentUniq++;
}
}
playerModel.currentCombat.npcs = combatNPCModels;
if (combatNPCModels.Count == 0)
{
throw new Exception("No NPCs were loaded :(");
}
calculateTurnOrder();
this.combatData = new CombatData(playerModel.currentCombat, canFlee);
if (!this.combatData.combatInitalized)
{
foreach (int key in pcs.Keys) //Check for initial code
{
FullCombatCharacter fcc = pcs[key];
List<IEffect> newEffects = GeneralProcessor.initialExecute(fcc)(getAllPcsAsList(), getAllNpcsAsList(), this.combatData);
currentEffects.AddRange(newEffects);
}
this.combatData.combatInitalized = true;
}
calculateTurn(false);
}
