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); }