public List<Word> GetWords(int Page, int PageSize)
{
using (var db = new LanguageBoosterContext())
{
return db.Words.OrderBy(w => w.Id).Skip(Page * PageSize).Take(PageSize).ToList();
}
}
public int GetWordCount()
{
using (var db = new LanguageBoosterContext())
{
return db.Words.Count();
}
}
public void CreatePlayer(Player NewPlayer)
{
using (var db = new LanguageBoosterContext())
{
db.Players.Attach(NewPlayer);
db.Players.Add(NewPlayer);
db.SaveChanges();
}
}
public List<Score> GetHighscores()
{
List<Score> HighScores = new List<Score>();
using (var db = new LanguageBoosterContext())
{
var ActualHighScores = db.Scores.OrderBy(score => -score.Value).Take(10);
HighScores.AddRange(ActualHighScores);
}
return HighScores;
}
public Word GetNextWord(Player NewPlayer)
{
using (var db = new LanguageBoosterContext())
{
int Count = db.Words.Count();
if (Count == 0)
{
throw new Exception("No words set up!");
}
int RandomIndex = random.Next(Count - 1);
return db.Words.Skip(RandomIndex).Single();
}
}
public void SubmitScore(Score NewScore)
{
using (var db = new LanguageBoosterContext())
{
db.Scores.Attach(NewScore);
db.Scores.Add(NewScore);
db.SaveChanges();
}
}
public void RemoveWord(Word word)
{
using (var db = new LanguageBoosterContext())
{
db.Database.ExecuteSqlCommand("DELETE FROM words WHERE id = " + word.Id);
/*
db.Words.Attach(word);
db.Words.Remove(word);
db.SaveChanges();
*/
}
}
public void SubmitWord(Word NewWord)
{
using (var db = new LanguageBoosterContext())
{
db.Words.Add(NewWord);
db.SaveChanges();
}
}