public List <RecordedExam> GetAll() { using (var db = new ExamSystemEntities()) { return(db.RecordedExams.ToList()); } }
public List <RecordedExam> GetByFilter(Expression <Func <RecordedExam, bool> > filter) { using (var db = new ExamSystemEntities()) { return(db.RecordedExams.Where(filter).ToList()); } }
public RecordedExam Get(int id) { using (var db = new ExamSystemEntities()) { return(db.RecordedExams.Find(id)); } }
public List <Question> GetByFilter(Expression <Func <Question, bool> > filter) { using (var db = new ExamSystemEntities()) { return(db.Questions.Where(filter).ToList()); } }
public School Get(int id) { using (var db = new ExamSystemEntities()) { return(db.Schools.Find(id)); } }
public List <User> GetAll() { using (var db = new ExamSystemEntities()) { return(db.Users.ToList()); } }
public List <User> GetByFilter(Expression <Func <User, bool> > filter) { using (var db = new ExamSystemEntities()) { return(db.Users.Where(filter).ToList()); } }
public List <Lesson> GetAll() { using (var db = new ExamSystemEntities()) { return(db.Lessons.ToList()); } }
public User Get(int id) { using (var db = new ExamSystemEntities()) { return(db.Users.Find(id)); } }
public List <School> GetAll() { using (var db = new ExamSystemEntities()) { return(db.Schools.ToList()); } }
public Lesson Get(int id) { using (var db = new ExamSystemEntities()) { return(db.Lessons.Find(id)); } }
public Question GetFilter(int lessonid, string content, int qtypeid) { using (var db = new ExamSystemEntities()) { return(db.Questions.Where(x => x.LessonId == lessonid && x.Question1 == content && x.QuestionType == qtypeid).FirstOrDefault()); } }
public List <QuestionAnswer> GetAll() { using (var db = new ExamSystemEntities()) { return(db.QuestionAnswers.ToList()); } }
public QuestionAnswer Get(int id) { using (var db = new ExamSystemEntities()) { return(db.QuestionAnswers.Find(id)); } }
public bool Update(User model) { using (var db = new ExamSystemEntities()) { db.Entry <User>(model).State = EntityState.Modified; int result = db.SaveChanges(); return(result > 0 ? true : false); } }
public bool Remove(User model) { using (var db = new ExamSystemEntities()) { db.Users.Remove(model); int result = db.SaveChanges(); return(result > 0 ? true : false); } }
public bool Remove(int id) { using (var db = new ExamSystemEntities()) { var model = Get(id); db.Users.Attach(model); db.Entry(model).State = EntityState.Deleted; var result = db.SaveChanges(); return(result > 0 ? true : false); } }
public bool Remove(int id) { using (var db = new ExamSystemEntities()) { var model = db.QuestionAnswers.Where(x => x.QuestionId == id).FirstOrDefault(); db.QuestionAnswers.Attach(model); db.Entry(model).State = EntityState.Deleted; var result = db.SaveChanges(); return(result > 0 ? true : false); } }
public bool Insert(User model) { try { using (var db = new ExamSystemEntities()) { db.Set <User>().Add(model); int result = db.SaveChanges(); return(result > 0 ? true : false); } } catch (Exception ex) { return(false); } }
public ExamSystemEntities Init() { return(dbContext ?? (dbContext = new DbContentFactory().CreateDbContext(null))); }