public load_window() { InitializeComponent(); Bj_interaction.instance().Save_Name = ""; saves = new ObservableCollection<string>(); save_list.DataContext = saves; using (var db = new Blackjack_DBEntities1()) { var query = from s in db.Saves_DB select s.save_name; foreach (var item in query) { saves.Add(item); } } filename.DataContext = Bj_interaction.instance(); }
internal void save_Saves_DB() { using (var db = new Blackjack_DBEntities1()) { s_id = (from s in db.Saves_DB select s).Count(); Saves_DB new_save = new Saves_DB() { save_name = Save_Name, id = s_id, active_player = players.Active_Player, active_players = players.Active_Players, deal_visibility = Deal_Button_Visibility, move_visibility = Move_Visibility, done_visibility = Done_Button_Visibility }; db.Saves_DB.Add(new_save); try { db.SaveChanges(); } catch (DbEntityValidationException e) { foreach (var eve in e.EntityValidationErrors) { Console.WriteLine("Entity of type \"{0}\" in state \"{1}\" has the following validation errors:", eve.Entry.Entity.GetType().Name, eve.Entry.State); foreach (var ve in eve.ValidationErrors) { Console.WriteLine("- Property: \"{0}\", Error: \"{1}\"", ve.PropertyName, ve.ErrorMessage); } } } } }
internal void save_Player_DB() { using (var db = new Blackjack_DBEntities1()) { int pk = (from s in db.Player_hands_DB select s).Count(); Players_DB players_db; Player_hands_DB player_hands_db; string player_rowguid; for (int i = 0; i < 5; ++i) { if (players.is_active(i)) { player_rowguid = s_id.ToString() + i.ToString(); int p_id = Convert.ToInt32(player_rowguid); players_db = new Players_DB() { player_id = p_id, save_id = s_id, name = players.get_player(i).Player_Name, money = players.get_player(i).Player_Money, total_bet = players.get_player(i).Player_Bet, bet0 = players.get_player(i).get_bet(0), bet1 = players.get_player(i).get_bet(1), bet2 = players.get_player(i).get_bet(2), bet3 = players.get_player(i).get_bet(3), active_hand = players.get_player(i).Active_Hand, nr_of_hands = players.get_player(i).nr_of_hands, player_nr = i }; db.Players_DB.Add(players_db); for (int s = 0; s <= players.get_player(i).nr_of_hands; ++s) { foreach (Card c in players.get_player(i).get_hand(s)) { player_hands_db = new Player_hands_DB() { id = pk, player_id = p_id, hand = s, image_name = c.Card_Image.Name }; db.Player_hands_DB.Add(player_hands_db); pk++; } } } } try { db.SaveChanges(); } catch (DbEntityValidationException e) { foreach (var eve in e.EntityValidationErrors) { Console.WriteLine("Entity of type \"{0}\" in state \"{1}\" has the following validation errors:", eve.Entry.Entity.GetType().Name, eve.Entry.State); foreach (var ve in eve.ValidationErrors) { Console.WriteLine("- Property: \"{0}\", Error: \"{1}\"", ve.PropertyName, ve.ErrorMessage); } } } catch(DbUpdateException e) { Console.WriteLine("Exception: ", e.Message); Console.WriteLine("Inner exception: ", e.InnerException); } } }
internal void save_Ontable_DB() { int a = s_id; using (var db = new Blackjack_DBEntities1()) { int pk = (from s in db.Ontable_DB select s).Count(); Ontable_DB ontable_db; foreach (Card c in deck.OnTable) { ontable_db = new Ontable_DB() { Id = pk, save_id = s_id, image_name = c.Card_Image.Name, c_value = c.Card_Value, fname = c.Card_Filename, x_coord = Canvas.GetLeft(c.Card_Image), y_coord = Canvas.GetTop(c.Card_Image), z_coord = Canvas.GetZIndex(c.Card_Image) }; db.Ontable_DB.Add(ontable_db); pk++; } try { db.SaveChanges(); } catch (DbEntityValidationException e) { foreach (var eve in e.EntityValidationErrors) { Console.WriteLine("Entity of type \"{0}\" in state \"{1}\" has the following validation errors:", eve.Entry.Entity.GetType().Name, eve.Entry.State); foreach (var ve in eve.ValidationErrors) { Console.WriteLine("- Property: \"{0}\", Error: \"{1}\"", ve.PropertyName, ve.ErrorMessage); } } } } }
internal void save_Dealer_DB() { using (var db = new Blackjack_DBEntities1()) { int pk = (from s in db.Dealer_DB select s).Count(); Dealer_DB dealer_db = new Dealer_DB() { Id = pk, save_id = s_id, hand_value = dealer.Hand_Value, x_offset = dealer.Xoffset }; db.Dealer_DB.Add(dealer_db); int fk = pk; pk = (from s in db.Dealer_Hand_DB select s).Count(); Dealer_Hand_DB dealer_hand_db; foreach (int i in dealer.Dealer_Hand) { dealer_hand_db = new Dealer_Hand_DB() { Id = pk, d_id = fk, c_value = i }; pk++; db.Dealer_Hand_DB.Add(dealer_hand_db); } try { db.SaveChanges(); } catch (DbEntityValidationException e) { foreach (var eve in e.EntityValidationErrors) { Console.WriteLine("Entity of type \"{0}\" in state \"{1}\" has the following validation errors:", eve.Entry.Entity.GetType().Name, eve.Entry.State); foreach (var ve in eve.ValidationErrors) { Console.WriteLine("- Property: \"{0}\", Error: \"{1}\"", ve.PropertyName, ve.ErrorMessage); } } } } }
internal void load_Players_DB() { using (var db = new Blackjack_DBEntities1()) { var query = from d in db.Players_DB where d.save_id == s_id select d; foreach (var item in query) { players.get_player(item.player_nr).Player_Bet = item.total_bet; players.get_player(item.player_nr).Player_Money = item.money; players.get_player(item.player_nr).Player_Name = item.name; players.get_player(item.player_nr).set_bet(0, item.bet0); players.get_player(item.player_nr).set_bet(1, item.bet1); players.get_player(item.player_nr).set_bet(2, item.bet2); players.get_player(item.player_nr).set_bet(3, item.bet3); players.get_player(item.player_nr).Active_Hand = item.active_hand; players.get_player(item.player_nr).nr_of_hands = item.nr_of_hands; players.get_player(item.player_nr).Is_Active = true; p_nr = item.player_nr; p_id = item.player_id; players.get_player(item.player_nr).Money_Bet_Name_Visibility = true; var query1 = from d in db.Player_hands_DB where d.player_id == p_id select d; foreach (var item1 in query1) { foreach (Card c in deck.OnTable) { if (c.Image_Name == item1.image_name) { players.add_card_hand(p_nr, item1.hand, c); break; } } } } } }
internal void load_Ontable_DB() { using (var db = new Blackjack_DBEntities1()) { var query = from d in db.Ontable_DB where d.save_id == s_id select d; foreach (var item in query) { Card c = new Card((int)item.c_value, item.fname); Uri src = new Uri("pack://application:,,,/Images/Deck/" + item.fname); BitmapImage img = new BitmapImage(src); Image card = new Image(); card.Source = img; card.Name = item.image_name; c.Image_Name = item.image_name; c.Card_Image = card; deck.OnTable.Add(c); Canvas.SetLeft(card, item.x_coord); Canvas.SetTop(card, item.y_coord); Canvas.SetZIndex(card, item.z_coord); } } }
internal void load_game(double canvas_width, double canvas_height) { using (var db = new Blackjack_DBEntities1()) { var query = from s in db.Saves_DB //where s.save_name == Save_Name; WHY THE F**K DOESN'T THIS WORK? select s; foreach (var item in query) { if (Save_Name == item.save_name) { s_id = item.id; players.Active_Players = item.active_players; players.Active_Player = item.active_player; Deal_Button_Visibility = item.deal_visibility; Done_Button_Visibility = item.done_visibility; Move_Visibility = item.move_visibility; } } } load_Deck_DB(); load_Ontable_DB(); load_Discard_DB(); load_Players_DB(); load_Dealer_DB(); set_coordinates(canvas_width, canvas_height); player_set_coordinates(canvas_width, canvas_height); set_visibility(); if (Move_Visibility == true || Done_Button_Visibility == true) set_active_player(); }
internal void load_Dealer_DB() { int d_id = 3; using (var db = new Blackjack_DBEntities1()) { var query = from d in db.Dealer_DB where d.save_id == s_id select d; foreach (var item in query) { d_id = item.Id; dealer.Xoffset = item.x_offset; dealer.Hand_Value = item.hand_value; } var query1 = from d in db.Dealer_Hand_DB where d.d_id == d_id select d; foreach (var item in query1) dealer.add_card(item.c_value); } }
// deck public void load() { /* * Loading from database comming soonish */ using (var db = new Blackjack_DBEntities1()) { var query = from deck in db.New_Deck_DB select deck; foreach (var item in query) { Console.WriteLine(item.card_value); Card c = new Card((int)item.card_value, item.fname); deck.Add(c); } } }