public SampleExam.Domain.Exam SelectExamIgnoreQueryFiltersTakeFirst(int examId) { SampleExam.Domain.Exam exam = null; using (var dbContext = this.dbContextFactory.CreateDbContext()) { exam = dbContext.Exams.Where(e => e.Id == examId).IgnoreQueryFilters().First(); } return(exam); }
public async Task <SampleExam.Domain.Exam> FindExamAsync(int examId) { SampleExam.Domain.Exam exam = null; using (var dbContext = this.dbContextFactory.CreateDbContext()) { exam = await dbContext.Exams.FindAsync(examId); } return(exam); }
public SampleExam.Domain.Exam SelectExamFirstOrDefault(int examId) { SampleExam.Domain.Exam exam = null; using (var dbContext = this.dbContextFactory.CreateDbContext()) { exam = dbContext.Exams.Where(e => e.Id == examId).FirstOrDefault(); } return(exam); }
public SampleExam.Domain.Exam SelectExamWitTags(int examId) { SampleExam.Domain.Exam exam = null; using (var dbContext = this.dbContextFactory.CreateDbContext()) { exam = dbContext.Exams.Where(e => e.Id == examId).Include(e => e.ExamTags).First(); } return(exam); }
public async Task <SampleExam.Domain.Exam> SetPublishExamAsync(int examId, bool isPublished = true) { SampleExam.Domain.Exam exam = null; using (var dbContext = this.dbContextFactory.CreateDbContext()) { exam = await dbContext.Exams.FindAsync(examId); exam.IsPublished = isPublished; await dbContext.SaveChangesAsync(); } return(exam); }