public List<User> getUsernames()
{
gameEntities3 db = new gameEntities3();
var rez = from item in db.User.AsEnumerable()
select item;
List<User> users = rez.ToList();
return users;
}
public List<SnakeGame> getSnakeRecordData()
{
gameEntities3 db = new gameEntities3();
var rez = from item in db.SnakeGame.AsEnumerable()
orderby item.score descending
select item;
List<SnakeGame> scores = rez.ToList();
return scores;
}
public List<SnakeGame> getSnakeScoreData(int id)
{
gameEntities3 db = new gameEntities3();
var rez = from item in db.SnakeGame.AsEnumerable()
where item.ID_user == id
orderby item.score descending
select item;
List<SnakeGame> scores = rez.ToList();
return scores;
}
public void addUser(User u)
{
gameEntities3 db = new gameEntities3();
db.User.Add(u);
db.SaveChanges();
}
