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