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