public void SeedDatabase(bool force, List <Question> list) { using (var context = new MillionaireContext(list)) { context.Database.Initialize(force); } }
public void SaveChanges() { using (var context = new MillionaireContext()) { context.SaveChanges(); } }
public void Delete(StatisticsEntry entry) { using (var context = new MillionaireContext()) { context.Entry(entry).State = EntityState.Deleted; } }
public StatisticsEntry GetById(int id) { using (var context = new MillionaireContext()) { return(context.Set <StatisticsEntry>().Where(s => s.QuestionID == id).FirstOrDefault()); } }
public IList <StatisticsEntry> GetAll() { using (var context = new MillionaireContext()) { return(context.Set <StatisticsEntry>().ToList()); } }
public void Delete(User user) { using (var context = new MillionaireContext()) { context.Entry(user).State = EntityState.Deleted; } }
public User GetById(int id) { using (var context = new MillionaireContext()) { return(context.Set <User>().Where(u => u.UserID == id).FirstOrDefault()); } }
public IList <User> GetAll() { using (var context = new MillionaireContext()) { return(context.Set <User>().ToList()); } }
public StatisticsEntry GetByQuestion(Question question) { using (var context = new MillionaireContext()) { if (context.Statistics.Any(s => s.QuestionID == question.QuestionID)) { return(context.Statistics.Where(s => s.Question.QuestionID == question.QuestionID) .Include(s => s.Question.Answers).FirstOrDefault()); } else { return(null); } } }
public void Update(StatisticsEntry entry) { using (var context = new MillionaireContext()) { var question = context.Questions.Where(q => q.QuestionID == entry.QuestionID) .Include(q => q.Answers).FirstOrDefault(); int i = 0; foreach (var child in question.Answers) { context.Entry(child).Entity.TimesSelected = entry.Question.Answers[i++].TimesSelected; context.Entry(child).State = EntityState.Modified; } context.SaveChanges(); } }