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)));
}
