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