private void btnSaveUser_Click(object sender, RoutedEventArgs e)
{
bool validName = true;
if (txtName.Text != null && txtName.Text != "")
{
using (db = new G2776_2Entities1())
{
var pelaajat = from p in db.Player
select p;
foreach (var p in pelaajat)
{
if (p.PlayerName == txtName.Text)
{
validName = false;
MessageBox.Show("Selected Player name already in use! Please select another");
}
}
if (validName)
{
db.Player.Add(new Player(txtName.Text));
db.SaveChanges();
MessageBox.Show("New Player created successfully");
refreshComboboxes();
}
}
}
}
private void cmbGame_SelectionChanged(object sender, SelectionChangedEventArgs e)
{
lblOpponent.Content = "Opponent: ";
lblMap.Content = "Map: ";
if (cmbGame.SelectedIndex < 0)
{
return;
}
try
{
using (db = new G2776_2Entities1())
{
int gID = (int)cmbGame.Items[cmbGame.SelectedIndex];
int ghpID = ghpIDs[cmbGame.SelectedIndex];
//string asd = cmbPlayer.Items[cmbGame.SelectedIndex].ToString();
//int.TryParse(asd, out gID);
var info = from a in db.Player
join ghp in db.Game_has_Player
on a.PlayerID equals ghp.PlayerID
where ghp.GameID == gID
//where ghp.Game_has_PlayerID != ghpID
select a;
foreach (var q in info)
{
lblOpponent.Content = "Opponent: " + q.PlayerName;
}
}
// MySqlCommand cmd = new MySqlCommand("SELECT Game_has_Player.PlayerID FROM Game_has_Player WHERE Game_has_Player.Game_has_PlayerID = '" + cmbGame.Items[cmbGame.SelectedIndex] + "';", con);
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
}
private void btnNewGame_Click(object sender, RoutedEventArgs e)
{
Game g = new Game(mapIDs[cmbMap.SelectedIndex]);
Game_has_Player ghp1;
Game_has_Player ghp2;
using (db = new G2776_2Entities1())
{
db.Game.Add(g);
db.SaveChanges();
var game = from gam in db.Game
orderby gam.GameID descending
select gam;
foreach (var a in game) // purkkaa, foreachin sijaan pitäis vaan ensimmäistä alkiota käyttää...
{
ghp1 = new Game_has_Player(a.GameID, pID[cmbPlayer.SelectedIndex]);
ghp2 = new Game_has_Player(a.GameID, pID[cmbOpponent.SelectedIndex]);
db.Game_has_Player.Add(ghp1);
db.Game_has_Player.Add(ghp2);
break;
}
db.SaveChanges();
}
// start game with given map and players
}
private void cmbPlayer_SelectionChanged(object sender, SelectionChangedEventArgs e)
{
cmbGame.Items.Clear();
ghpIDs.Clear();
lblOpponent.Content = "Opponent: ";
lblMap.Content = "Map: ";
try
{
using (db = new G2776_2Entities1())
{
int pnro = pID[cmbPlayer.SelectedIndex];
var game = from g in db.Game
join ghp in db.Game_has_Player
on g.GameID equals ghp.GameID
where ghp.PlayerID.Equals(pnro)
select new
{
g,
ghp
};
foreach (var a in game)
{
if (cmbGame.Items.Contains(a.g.GameID))
{
continue;
}
cmbGame.Items.Add(a.g.GameID);
ghpIDs.Add(a.ghp.Game_has_PlayerID);
}
}
//MySqlCommand cmd = new MySqlCommand("SELECT Game_has_PlayerID FROM Game_has_Player WHERE Game_has_Player.PlayerID ='" + cmbPlayer.Items[cmbPlayer.SelectedIndex] + "';", con);
/*
*
* var game = from g in db.Game_has_Player
* where g.PlayerID == pID[cmbPlayer.SelectedIndex]
* select g;
*
*
*
* int pid;
* MySqlCommand cmd1 = new MySqlCommand("SELECT GameID FROM Game_has_Player WHERE PlayerID = '" + cmbPlayer.Items[cmbPlayer.SelectedIndex] + "';",con);
* MySqlDataReader reader;
* reader = cmd1.ExecuteReader();
* while (reader.Read())
* {
* int.TryParse(reader.GetString(0), out pid);
* MySqlCommand cmd2 = new MySqlCommand("SELECT PlayerName FROM Player WHERE PlayerID ='" + pid + "';", con);
*
* }
*/
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
}
public StartWindow()
{
InitializeComponent();
pID = new List <int>();
ghpIDs = new List <int>();
mapIDs = new List <int>();
db = new G2776_2Entities1();
refreshComboboxes();
/*
* try
* {
*
*
* con = new MySqlConnection(str);
* con.Open();
* MySqlCommand cmd = new MySqlCommand("SELECT PlayerID FROM Player", con);
*
* MySqlDataReader reader;
* reader = cmd.ExecuteReader();
* pelaajaIDt = new List<int>();
* int apu = -1;
* while (reader.Read())
* {
* int.TryParse(reader.GetString(0), out apu);
* pelaajaIDt.Add(apu);
* cmbPlayer.Items.Add(apu);
* apu = -1;
* }
*
* }
* catch (Exception ex)
* {
* MessageBox.Show(ex.ToString());
* MessageBox.Show(ex.InnerException.ToString());
*
* }
* finally
* {
* con.Close();
* }
* */
}
public StartWindow()
{
InitializeComponent();
pID = new List<int>();
ghpIDs = new List<int>();
mapIDs = new List<int>();
db = new G2776_2Entities1();
refreshComboboxes();
/*
try
{
con = new MySqlConnection(str);
con.Open();
MySqlCommand cmd = new MySqlCommand("SELECT PlayerID FROM Player", con);
MySqlDataReader reader;
reader = cmd.ExecuteReader();
pelaajaIDt = new List<int>();
int apu = -1;
while (reader.Read())
{
int.TryParse(reader.GetString(0), out apu);
pelaajaIDt.Add(apu);
cmbPlayer.Items.Add(apu);
apu = -1;
}
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
MessageBox.Show(ex.InnerException.ToString());
}
finally
{
con.Close();
}
* */
}
public MapEditor()
{
InitializeComponent();
fillTemplate();
map = new List <Tile>();
mapID = -1;
using (G2776_2Entities1 db = new G2776_2Entities1())
{
}
for (int i = 0; i < 15; i++)
{
for (int j = 0; j < 15; j++)
{
map.Add(new Tile(i, j, -3, new Terrain(1, "Plains", "LightYellow"), null, null, null));
}
}
drawMap();
}
public MapEditor()
{
InitializeComponent();
fillTemplate();
map = new List<Tile>();
mapID = -1;
using (G2776_2Entities1 db = new G2776_2Entities1())
{
}
for (int i = 0; i < 15; i++)
{
for (int j = 0; j < 15; j++)
{
map.Add(new Tile(i, j, -3, new Terrain(1, "Plains", "LightYellow"), null, null, null));
}
}
drawMap();
}
public MapEditor(int mappi)
{
InitializeComponent();
fillTemplate();
map = new List <Tile>();
mapID = mappi;
using (G2776_2Entities1 db = new G2776_2Entities1())
{
var m = from b in db.Map.Include("Tile")
where b.MapID == mappi
select b;
foreach (Map c in m)
{
oldMapName = c.MapName;
txtMapname.Text = c.MapName;
}
}
try
{
using (G2776_2Entities1 db = new G2776_2Entities1())
{
var tiles = from a in db.Tile
where a.MapID == mappi
select a;
foreach (Tile t in tiles)
{
if (t.PlayerID != null)
{
using (G2776_2Entities1 player = new G2776_2Entities1())
{
var pla = (from pl in player.Player
where pl.PlayerID == t.PlayerID
select pl).First();
t.Player = pla;
}
}
if (t.TerrainID != null)
{
using (G2776_2Entities1 terrain = new G2776_2Entities1())
{
var ter = (from te in terrain.Terrain
where te.TerrainID == t.TerrainID
select te).First();
t.Terrain = ter;
}
}
if (t.ConstructionID != null)
{
using (G2776_2Entities1 construction = new G2776_2Entities1())
{
var con = (from co in construction.Construction
where co.ConstructionID == t.ConstructionID
select co).First();
t.Construction = con;
}
}
if (t.CityID != null)
{
using (G2776_2Entities1 city = new G2776_2Entities1())
{
var cit = (from ci in city.City
where ci.CityID == t.CityID
select ci).First();
t.City = cit;
}
}
if (t.ArmyID != null)
{
using (G2776_2Entities1 army = new G2776_2Entities1())
{
var arm = (from ar in army.Army.Include("Unit")
where ar.ArmyID == t.ArmyID
select ar).First();
t.Army = arm;
foreach (Unit u in arm.Unit)
{
arm.AddUnit(u);
}
}
/*
* using (G2776_2Entities1 units = new G2776_2Entities1())
* {
* var uni = from un in units.Unit
* where un.ArmyID == t.ArmyID
* select un;
* foreach (Unit unit in uni)
* {
* t.Army.Unit.Add(new Unit(unit.UnitName,unit.UnitHealth,(int)unit.UnitOffense,(int)unit.UnitDefense,unit.UnitRanged,(int)unit.UnitRangedDefense,(int)unit.UnitPosition));
* //t.Army.Unit.Add(unit);
* }
* }*/
}
/*
* Tile temp = new Tile(t.TileX,t.TileY);
* if (t.PlayerID != null)
* {
* temp.PlayerID = t.PlayerID;
* }
*
* if (t.Terrain != null)
* {
* temp.Terrain = t.Terrain;
* temp.TerrainID = t.TerrainID;
* }
* if (t.Construction != null)
* {
* temp.Construction = t.Construction;
* temp.ConstructionID = t.ConstructionID;
* }
* if (t.City != null)
* {
* temp.City = t.City;
* temp.CityID = t.CityID;
* }
* if (t.Army != null)
* {
* temp.Army = t.Army;
* temp.ArmyID = t.ArmyID;
* }
* map.Add(temp);
* */
map.Add(t);
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
MessageBox.Show(ex.InnerException.ToString());
}
drawMap();
}
private void btnSaveAndExit_Click(object sender, RoutedEventArgs e)
{
//int mapID = -1;
try
{
using (G2776_2Entities1 db = new G2776_2Entities1())
{
if (mapID < 0 || txtMapname.Text != oldMapName)
{
if (txtMapname.Text != null && txtMapname.Text != "")
{
db.Map.Add(new Map(txtMapname.Text));
}
else
{
MessageBox.Show("Give a name for the map");
return;
}
db.SaveChanges();
var mappi = from m in db.Map
orderby m.MapID descending
select m;
foreach (var a in mappi)
{
mapID = a.MapID;
break;
}
}
foreach (Tile t in map)
{
t.MapID = mapID;
/*
* if (t.Army != null)
* {
* db.Army.Add(t.Army);
* foreach (Unit u in t.Army.Unit)
* {
* db.Unit.Add(u);
* }
* }
* if (t.City != null)
* {
* db.City.Add(t.City);
* }
* if (t.Construction != null)
* {
* db.Construction.Add(t.Construction);
* }
* if (t.Terrain != null)
* {
* db.Terrain.Add(t.Terrain);
* }*/
var player = (from p in db.Player
where p.PlayerID == t.PlayerID
select p).First();
t.Player = player;
var terrain = (from ter in db.Terrain
where ter.TerrainType == t.Terrain.TerrainType
select ter).First();
t.Terrain = terrain;
db.Tile.Add(t);
db.SaveChanges();
}
db.SaveChanges();
}
MessageBox.Show("Map saved successfully.");
this.Close();
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
MessageBox.Show(ex.InnerException.ToString());
}
}
public MapEditor(int mappi)
{
InitializeComponent();
fillTemplate();
map = new List<Tile>();
mapID = mappi;
using (G2776_2Entities1 db = new G2776_2Entities1())
{
var m = from b in db.Map.Include("Tile")
where b.MapID == mappi
select b;
foreach (Map c in m)
{
oldMapName = c.MapName;
txtMapname.Text = c.MapName;
}
}
try
{
using (G2776_2Entities1 db = new G2776_2Entities1())
{
var tiles = from a in db.Tile
where a.MapID == mappi
select a;
foreach (Tile t in tiles)
{
if (t.PlayerID != null)
{
using (G2776_2Entities1 player = new G2776_2Entities1())
{
var pla = (from pl in player.Player
where pl.PlayerID == t.PlayerID
select pl).First();
t.Player = pla;
}
}
if (t.TerrainID != null)
{
using (G2776_2Entities1 terrain = new G2776_2Entities1())
{
var ter = (from te in terrain.Terrain
where te.TerrainID == t.TerrainID
select te).First();
t.Terrain = ter;
}
}
if (t.ConstructionID != null)
{
using (G2776_2Entities1 construction = new G2776_2Entities1())
{
var con = (from co in construction.Construction
where co.ConstructionID == t.ConstructionID
select co).First();
t.Construction = con;
}
}
if (t.CityID != null)
{
using (G2776_2Entities1 city = new G2776_2Entities1())
{
var cit = (from ci in city.City
where ci.CityID == t.CityID
select ci).First();
t.City = cit;
}
}
if (t.ArmyID != null)
{
using (G2776_2Entities1 army = new G2776_2Entities1())
{
var arm = (from ar in army.Army.Include("Unit")
where ar.ArmyID == t.ArmyID
select ar).First();
t.Army = arm;
foreach (Unit u in arm.Unit)
{
arm.AddUnit(u);
}
}
/*
using (G2776_2Entities1 units = new G2776_2Entities1())
{
var uni = from un in units.Unit
where un.ArmyID == t.ArmyID
select un;
foreach (Unit unit in uni)
{
t.Army.Unit.Add(new Unit(unit.UnitName,unit.UnitHealth,(int)unit.UnitOffense,(int)unit.UnitDefense,unit.UnitRanged,(int)unit.UnitRangedDefense,(int)unit.UnitPosition));
//t.Army.Unit.Add(unit);
}
}*/
}
/*
Tile temp = new Tile(t.TileX,t.TileY);
if (t.PlayerID != null)
{
temp.PlayerID = t.PlayerID;
}
if (t.Terrain != null)
{
temp.Terrain = t.Terrain;
temp.TerrainID = t.TerrainID;
}
if (t.Construction != null)
{
temp.Construction = t.Construction;
temp.ConstructionID = t.ConstructionID;
}
if (t.City != null)
{
temp.City = t.City;
temp.CityID = t.CityID;
}
if (t.Army != null)
{
temp.Army = t.Army;
temp.ArmyID = t.ArmyID;
}
map.Add(temp);
* */
map.Add(t);
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
MessageBox.Show(ex.InnerException.ToString());
}
drawMap();
}
private void btnSaveAndExit_Click(object sender, RoutedEventArgs e)
{
//int mapID = -1;
try
{
using (G2776_2Entities1 db = new G2776_2Entities1())
{
if (mapID < 0 || txtMapname.Text != oldMapName)
{
if (txtMapname.Text != null && txtMapname.Text != "")
{
db.Map.Add(new Map(txtMapname.Text));
}
else
{
MessageBox.Show("Give a name for the map");
return;
}
db.SaveChanges();
var mappi = from m in db.Map
orderby m.MapID descending
select m;
foreach (var a in mappi)
{
mapID = a.MapID;
break;
}
}
foreach (Tile t in map)
{
t.MapID = mapID;
/*
if (t.Army != null)
{
db.Army.Add(t.Army);
foreach (Unit u in t.Army.Unit)
{
db.Unit.Add(u);
}
}
if (t.City != null)
{
db.City.Add(t.City);
}
if (t.Construction != null)
{
db.Construction.Add(t.Construction);
}
if (t.Terrain != null)
{
db.Terrain.Add(t.Terrain);
}*/
var player = (from p in db.Player
where p.PlayerID == t.PlayerID
select p).First();
t.Player = player;
var terrain = (from ter in db.Terrain
where ter.TerrainType == t.Terrain.TerrainType
select ter).First();
t.Terrain = terrain;
db.Tile.Add(t);
db.SaveChanges();
}
db.SaveChanges();
}
MessageBox.Show("Map saved successfully.");
this.Close();
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
MessageBox.Show(ex.InnerException.ToString());
}
}
private void cmbPlayer_SelectionChanged(object sender, SelectionChangedEventArgs e)
{
cmbGame.Items.Clear();
ghpIDs.Clear();
lblOpponent.Content = "Opponent: ";
lblMap.Content = "Map: ";
try
{
using (db = new G2776_2Entities1())
{
int pnro = pID[cmbPlayer.SelectedIndex];
var game = from g in db.Game
join ghp in db.Game_has_Player
on g.GameID equals ghp.GameID
where ghp.PlayerID.Equals(pnro)
select new
{
g,
ghp
};
foreach (var a in game)
{
if (cmbGame.Items.Contains(a.g.GameID)) continue;
cmbGame.Items.Add(a.g.GameID);
ghpIDs.Add(a.ghp.Game_has_PlayerID);
}
}
//MySqlCommand cmd = new MySqlCommand("SELECT Game_has_PlayerID FROM Game_has_Player WHERE Game_has_Player.PlayerID ='" + cmbPlayer.Items[cmbPlayer.SelectedIndex] + "';", con);
/*
*
* var game = from g in db.Game_has_Player
where g.PlayerID == pID[cmbPlayer.SelectedIndex]
select g;
*
*
*
int pid;
MySqlCommand cmd1 = new MySqlCommand("SELECT GameID FROM Game_has_Player WHERE PlayerID = '" + cmbPlayer.Items[cmbPlayer.SelectedIndex] + "';",con);
MySqlDataReader reader;
reader = cmd1.ExecuteReader();
while (reader.Read())
{
int.TryParse(reader.GetString(0), out pid);
MySqlCommand cmd2 = new MySqlCommand("SELECT PlayerName FROM Player WHERE PlayerID ='" + pid + "';", con);
}
*/
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
}
private void btnSaveUser_Click(object sender, RoutedEventArgs e)
{
bool validName = true;
if (txtName.Text != null && txtName.Text != "")
{
using (db = new G2776_2Entities1())
{
var pelaajat = from p in db.Player
select p;
foreach (var p in pelaajat)
{
if (p.PlayerName == txtName.Text)
{
validName = false;
MessageBox.Show("Selected Player name already in use! Please select another");
}
}
if (validName)
{
db.Player.Add(new Player(txtName.Text));
db.SaveChanges();
MessageBox.Show("New Player created successfully");
refreshComboboxes();
}
}
}
}
private void btnNewGame_Click(object sender, RoutedEventArgs e)
{
Game g = new Game(mapIDs[cmbMap.SelectedIndex]);
Game_has_Player ghp1;
Game_has_Player ghp2;
using (db = new G2776_2Entities1())
{
db.Game.Add(g);
db.SaveChanges();
var game = from gam in db.Game
orderby gam.GameID descending
select gam;
foreach (var a in game) // purkkaa, foreachin sijaan pitäis vaan ensimmäistä alkiota käyttää...
{
ghp1 = new Game_has_Player(a.GameID, pID[cmbPlayer.SelectedIndex]);
ghp2 = new Game_has_Player(a.GameID, pID[cmbOpponent.SelectedIndex]);
db.Game_has_Player.Add(ghp1);
db.Game_has_Player.Add(ghp2);
break;
}
db.SaveChanges();
}
// start game with given map and players
}
private void cmbGame_SelectionChanged(object sender, SelectionChangedEventArgs e)
{
lblOpponent.Content = "Opponent: ";
lblMap.Content = "Map: ";
if (cmbGame.SelectedIndex < 0) return;
try
{
using (db = new G2776_2Entities1())
{
int gID = (int)cmbGame.Items[cmbGame.SelectedIndex];
int ghpID = ghpIDs[cmbGame.SelectedIndex];
//string asd = cmbPlayer.Items[cmbGame.SelectedIndex].ToString();
//int.TryParse(asd, out gID);
var info = from a in db.Player
join ghp in db.Game_has_Player
on a.PlayerID equals ghp.PlayerID
where ghp.GameID == gID
//where ghp.Game_has_PlayerID != ghpID
select a;
foreach (var q in info)
{
lblOpponent.Content = "Opponent: " + q.PlayerName;
}
}
// MySqlCommand cmd = new MySqlCommand("SELECT Game_has_Player.PlayerID FROM Game_has_Player WHERE Game_has_Player.Game_has_PlayerID = '" + cmbGame.Items[cmbGame.SelectedIndex] + "';", con);
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
}
