public void Update(UserAchievement userAchievement)
{
using(var db = new EntityModel())
{
var achievement = db.UsersAchievements.Find(userAchievement.Id);
achievement = userAchievement;
db.SaveChanges();
}
}
public void BlockTask(int taskId)
{
using(var database = new EntityModel())
{
var task = database.Tasks.Find(taskId);
task.Activate = !task.Activate;
database.SaveChanges();
}
}
public void UpdateTrueAnswer(int taskId, int userId)
{
using (var db = new EntityModel())
{
var userAnswer = db.UserAnswers.Where(x => x.TaskId == taskId)
.FirstOrDefault(x => x.UserId == userId);
userAnswer.TrueAnswer = !userAnswer.TrueAnswer;
db.SaveChanges();
}
}
public void IncrementAnswerCount(int taskId, int userId)
{
using(var db = new EntityModel())
{
var userAnswer = db.UserAnswers.Where(x => x.TaskId == taskId)
.FirstOrDefault(x => x.UserId == userId);
userAnswer.Count++;
db.SaveChanges();
}
}
public void UpdateRate(int taskId, int rate,int userId)
{
using (var db = new EntityModel())
{
var task = db.Tasks.Find(taskId);
task.Rate = (((task.Rate * task.RateCount) + rate) /( task.RateCount + 1));
task.RateCount++;
db.SaveChanges();
}
context.Set<Rate>().Add(new Rate()
{
Rating = rate,
UserId = userId,
TaskId = taskId
});
}
public void UpdateRate(int rateCount, int userId)
{
using(var database = new EntityModel())
{
var user = database.Users.Find(userId);
user.Rate += rateCount;
database.SaveChanges();
}
}
