public Cards GetCardPicture(int id) { Cards c = new Cards(); using (var db = new BJContext()) { var query = from C in db.Cards where C.CardID == id select C; foreach (var Card in query) { c = Card; } return(c); } }
public bool IsDBCardsetExist() { using (var db = new BJContext()) { bool exist = false; var query = from s in db.Cards select s; foreach (var cards in query) { if (cards.CardID >= 0) { exist = true; } } return(exist); } }
public int GetPLayerID(string NIck) { using (var db = new BJContext()) { int id = 0; var query = from s in db.PLAYERS where s.NickName == NIck select s; foreach (var student in query) { if (student.PlayerID != 0) { id = student.PlayerID; } } return(id); } }
public bool CheckPlayer(string nick) { using (var db = new BJContext()) { bool exist = false; var query = from s in db.PLAYERS where s.NickName == nick select s; foreach (var student in query) { if (student.PlayerID != 0) { exist = true; } } return(exist); } }
private PLAYERS GetPLAYERS(int playerID) { PLAYERS pl = new PLAYERS(); using (var db = new BJContext()) { var query = from s in db.PLAYERS where s.PlayerID == playerID select s; foreach (var student in query) { if (student.PlayerID != 0) { pl = student; } } } return(pl); }
List <Cards> IDeck.GetDeck(int size) { if (!IsDBCardsetExist()) { InserCardsToDb(); } List <Cards> deck = new List <Cards>(); using (var db = new BJContext()) { var query = from C in db.Cards where C.CardID <= DECK_SIZE * size select C; foreach (var card in query) { deck.Add(card); } } return(deck); }
public int getStatistic(string NIck, out double winrate) { int stats = 0; winrate = 0.0; using (var db = new BJContext()) { var query = from s in db.PLAYERS where s.NickName == NIck select s; foreach (var student in query) { if (student.PlayerID != 0) { stats = (int)student.GamesCount; winrate = ((double)student.WinCount * 100 / stats); } } } return(stats); }