public ActionResult StartFight(string worldstring)
{
World world = World.DecodeWorld(worldstring);
world.WildMonster = MonsterInstantie.createMonsterInstantie();
world.WildMonster.Monsterseen(world.Player);
Session["World"] = world;
return(Redirect("Fight"));
}
public void UseMove()
{
MonsterInstantie monster = new MonsterInstantie();
MonsterInstantie enemymonster = new MonsterInstantie();
enemymonster.Health = 100;
Move move = new Move(1, "name", soort.Paper, 20);
monster.Moves[0] = move;
monster.usemove(0, enemymonster);
Assert.AreEqual(enemymonster.Health, 80);
}
public void UpdateMonster()
{
MonsterInstantie monster = MonsterInstantie.createMonsterInstantie();
Assert.IsNotNull(monster);
monster.Naam = "test";
monster.Xp = 1;
monster.GrowthStat = 2;
monster.Level = 3;
monster.Health = 4;
monster.UpdateMonster();
Assert.AreEqual(monster.Naam, "test");
Assert.AreEqual(monster.Xp, 1);
Assert.AreEqual(monster.GrowthStat, 2);
Assert.AreEqual(monster.Level, 3);
Assert.AreEqual(monster.Health, 4);
}
public void MonsterSeen(MonsterInstantie monsterInstantie, Player player)
{
try
{
string query = @"EXEC MonsterSeen @MonsterId, @PlayerId";
using (Database.command = new SqlCommand(query, Database.OpenConnection()))
{
Database.command.Parameters.Add("@MonsterId", SqlDbType.Int).Value = monsterInstantie.MonsterId;
Database.command.Parameters.Add("@PlayerId", SqlDbType.Int).Value = player.Id;
Database.command.ExecuteNonQuery();
}
}
catch (Exception e)
{
MessageBox.Show(e.Message);
}
}
public void UpdateMonster(MonsterInstantie monsterInstantie)
{
MonsterInstantie monster = null;
try
{
string query = @"EXEC UpdateMonster @MonsterInstantieId,@Name,@Growthstat,@xp,@Level,@CurrentHealth";
using (Database.command = new SqlCommand(query, Database.OpenConnection()))
{
Database.command.Parameters.Add("@MonsterInstantieId", SqlDbType.Int).Value = monsterInstantie.Id;
Database.command.Parameters.Add("@Name", SqlDbType.VarChar).Value = monsterInstantie.Naam;
Database.command.Parameters.Add("@Growthstat", SqlDbType.Int).Value = monsterInstantie.GrowthStat;
Database.command.Parameters.Add("@xp", SqlDbType.Int).Value = monsterInstantie.Xp;
Database.command.Parameters.Add("@Level", SqlDbType.Int).Value = monsterInstantie.Level;
Database.command.Parameters.Add("@CurrentHealth", SqlDbType.Int).Value = monsterInstantie.Health;
Database.command.ExecuteNonQuery();
}
}
catch (Exception e)
{
MessageBox.Show(e.Message);
}
}
public void MonsterSeen(MonsterInstantie monsterInstantie, Player player)
{
context.MonsterSeen(monsterInstantie, player);
}
public void UpdateMonster(MonsterInstantie monsterInstantie)
{
context.UpdateMonster(monsterInstantie);
}
public MonsterInstantie RandomMonster()
{
MonsterInstantie monster = null;
try
{
string query = @"insert into MonsterInstantie(MonsterId)
values (@MonsterId) ";
using (Database.command = new SqlCommand(query, Database.OpenConnection()))
{
Random r = new Random();
Database.command.Parameters.Add("@MonsterId", SqlDbType.Int).Value = r.Next(1, 150);
Database.command.ExecuteNonQuery();
}
query =
@"SELECT mi.MonsterInstantieId, mi.MonsterId, mi.Naam, m.Soort, mi.[Growth Stat], mi.xp, mi.CurrentHealth, m.MaxHealth, m.[Max xp], mi.Level, m.[Evolutie level], m.Attack, m.SpecialAttack, m.Defence, m.SpecialDefence from monsterinstantie mi
inner join Monster m
on mi.monsterid = m.monsterid
and mi.monsterinstantieid = (SELECT max(mi.MonsterInstantieId) from monsterinstantie mi)";
using (Database.command = new SqlCommand(query, Database.OpenConnection()))
{
using (var reader = Database.command.ExecuteReader()) // MySqlDataReader
{
while (reader.Read()) // Read advances to the next row.
{
monster = new MonsterInstantie(Convert.ToInt32(reader["MonsterInstantieId"]),
Convert.ToInt32(reader["MonsterId"]),
reader["Naam"] as string,
(soort)Enum.Parse(typeof(soort), reader["Soort"] as string),
Convert.ToInt32(reader["Growth Stat"]),
Convert.ToInt32(reader["xp"]),
Convert.ToInt32(reader["Max xp"]),
Convert.ToInt32(reader["level"]),
Convert.ToInt32(reader["Evolutie level"]),
Convert.ToInt32(reader["Attack"]),
Convert.ToInt32(reader["SpecialAttack"]),
Convert.ToInt32(reader["Defence"]),
Convert.ToInt32(reader["SpecialDefence"]),
Convert.ToInt32(reader["CurrentHealth"]),
Convert.ToInt32(reader["MaxHealth"])
);
}
}
}
query = @"SELECT m.MoveId,m.Naam,m.Soort,m.Attack,m.MaxPP ,mm.CurrentPP FROM MonsterInstantie mi
inner join MonsterMove mm on mi.MonsterInstantieId = mm.MonsterinstantieId and mi.MonsterInstantieId = @MonsterInstantieId
inner join Move m on m.MoveId = mm.MoveId";
using (Database.command = new SqlCommand(query, Database.OpenConnection()))
{
Database.command.Parameters.Add("@MonsterInstantieId", SqlDbType.Int).Value = monster.Id;
using (var reader = Database.command.ExecuteReader()) // MySqlDataReader
{
int movecount = 0;
if (!reader.HasRows)
{
throw new Exception("U heeft een onjuist gebruikersnaam of wachtwoorden opgegeven.");
}
while (reader.Read()) // Read advances to the next row.
{
monster.Moves[movecount] = new Move(Convert.ToInt32(reader["MoveId"]),
reader["Naam"] as string,
(soort)Enum.Parse(typeof(soort), reader["Soort"] as string),
Convert.ToInt32(reader["Attack"])
);
movecount++;
}
}
}
}
catch (Exception e)
{
MessageBox.Show(e.Message);
}
return(monster);
}
public Player Login(string username, string password)
{
Player player = null;
string query =
@" SELECT p.PlayerId, p.UserName, p.Name, p.Gender, i.Monsterballen FROM Player p
inner join inventory i on p.InventoryId = i.InventoryId and p.username = @username and p.password = @password";
using (Database.command = new SqlCommand(query, Database.OpenConnection()))
{
Database.command.Parameters.Add("@username", SqlDbType.NVarChar).Value = username;
Database.command.Parameters.Add("@password", SqlDbType.NVarChar).Value = password;
using (var reader = Database.command.ExecuteReader()) // MySqlDataReader
{
if (!reader.HasRows)
{
return(null);
}
// Check for rows, if 0 give error that user did not give correct username and password
while (reader.Read()) // Read advances to the next row.
{
player = new Player(Convert.ToInt32(reader["PlayerId"]),
reader["Name"] as string,
reader["Gender"] as string,
Convert.ToInt32(reader["Monsterballen"]));
}
}
}
MonsterInstantie monster = null;
query = @" SELECT mi.MonsterInstantieId, mi.MonsterId, mi.Naam, m.Soort, mi.[Growth Stat], mi.xp, mi.CurrentHealth, m.MaxHealth, m.[Max xp], mi.Level, m.[Evolutie level], m.Attack, m.SpecialAttack, m.Defence, m.SpecialDefence from Player p
inner join Party pa on pa.TrainerId = p.TrainerId and p.PlayerId = @playerId
inner join MonsterInstantie mi on mi.MonsterInstantieId = pa.MonsterInstantieId
inner join Monster m on mi.MonsterId = m.MonsterId";
using (Database.command = new SqlCommand(query, Database.OpenConnection()))
{
Database.command.Parameters.Add("@playerId", SqlDbType.Int).Value = player.Id;
using (var reader = Database.command.ExecuteReader()) // MySqlDataReader
{
int PartyCount = 0;
if (!reader.HasRows)
{
throw new Exception("U heeft een onjuist gebruikersnaam of wachtwoorden opgegeven.");
}
// Check for rows, if 0 give error that user did not give correct username and password
while (reader.Read()) // Read advances to the next row.
{
monster = new MonsterInstantie(Convert.ToInt32(reader["MonsterInstantieId"]),
Convert.ToInt32(reader["MonsterId"]),
reader["Naam"] as string,
(soort)Enum.Parse(typeof(soort), reader["Soort"] as string),
Convert.ToInt32(reader["Growth Stat"]),
Convert.ToInt32(reader["xp"]),
Convert.ToInt32(reader["Max xp"]),
Convert.ToInt32(reader["level"]),
Convert.ToInt32(reader["Evolutie level"]),
Convert.ToInt32(reader["Attack"]),
Convert.ToInt32(reader["SpecialAttack"]),
Convert.ToInt32(reader["Defence"]),
Convert.ToInt32(reader["SpecialDefence"]),
Convert.ToInt32(reader["CurrentHealth"]),
Convert.ToInt32(reader["MaxHealth"])
);
if (PartyCount == 0)
{
monster.Active = true;
}
player.Party[PartyCount] = monster;
PartyCount++;
}
}
}
int monstercount = 0;
foreach (MonsterInstantie monsteritem in player.Party)
{
if (monsteritem != null)
{
query = @"SELECT m.MoveId,m.Naam,m.Soort,m.Attack,m.MaxPP ,mm.CurrentPP FROM MonsterInstantie mi
inner join MonsterMove mm on mi.MonsterInstantieId = mm.MonsterinstantieId and mi.MonsterInstantieId = @MonsterInstantieId
inner join Move m on m.MoveId = mm.MoveId";
using (Database.command = new SqlCommand(query, Database.OpenConnection()))
{
Database.command.Parameters.Add("@MonsterInstantieId", SqlDbType.Int).Value = monsteritem.Id;
using (var reader = Database.command.ExecuteReader()) // MySqlDataReader
{
int movecount = 0;
if (!reader.HasRows)
{
throw new Exception("U heeft een onjuist gebruikersnaam of wachtwoorden opgegeven.");
}
while (reader.Read()) // Read advances to the next row.
{
monsteritem.Moves[movecount] = new Move(Convert.ToInt32(reader["MoveId"]),
reader["Naam"] as string,
(soort)Enum.Parse(typeof(soort), reader["Soort"] as string),
Convert.ToInt32(reader["Attack"])
);
movecount++;
}
}
}
}
}
return(player);
}
public void CreateRandomMonster()
{
MonsterInstantie monster = MonsterInstantie.createMonsterInstantie();
Assert.IsNotNull(monster);
}
