public IEnumerable <PlayerAchievement> GetAllByPlayerId(string playerId)
{
using (var ctx = new SuperCubeContext())
{
return(ctx.PlayerAchievements.Where(pa => pa.PlayerId == playerId).ToList());
}
}
public PlayerAchievement Get(string playerId, int achievementId)
{
using (var ctx = new SuperCubeContext())
{
return(ctx.PlayerAchievements.FirstOrDefault(pa => pa.PlayerId == playerId && pa.AchievementId == achievementId));
}
}
public IEnumerable <Score> GetAll()
{
using (var ctx = new SuperCubeContext())
{
return(ctx.HighScores.Include(s => s.Player).ToList());
}
}
public void Create(Score score)
{
using (var ctx = new SuperCubeContext())
{
ctx.HighScores.Add(score);
ctx.SaveChanges();
}
}
//for admin maybe
public void Update(Achievement achievement)
{
using (var ctx = new SuperCubeContext())
{
ctx.Achievements.AddOrUpdate(achievement);
ctx.SaveChanges();
}
}
public Achievement Get(int id)
{
using (var ctx = new SuperCubeContext())
{
var achievements = ctx.Achievements.Include(ach => ach.PlayerAchievements);
return(achievements.FirstOrDefault(ach => ach.Id.Equals(id)));
}
}
public void Create(string playerId, int achievementId)
{
using (var ctx = new SuperCubeContext())
{
var itemToAdd = new PlayerAchievement
{
PlayerId = playerId,
AchievementId = achievementId
};
ctx.PlayerAchievements.Add(itemToAdd);
ctx.SaveChanges();
}
}
public IEnumerable <Achievement> GetAllByPlayerId(string playerId)
{
using (var ctx = new SuperCubeContext())
{
var playerAchievements = ctx.PlayerAchievements.Where(pa => pa.PlayerId == playerId).ToList();
var achievements = ctx.Achievements.ToList();
var result = achievements.Join(playerAchievements,
a => a.Id,
pa => pa.AchievementId,
(a, pa) => new Achievement
{
Id = a.Id,
Description = a.Description,
Title = a.Title
})
.ToList();
return(result);
}
}
