public Exam GetExam(int id)
{
using (var context = new OnlineTestContext(_dbContextOptionBuilder.Options))
{
return(context.Exams.FirstOrDefault(e => e.Id == id));
}
}
public User Get(string email, string password)
{
using (var context = new OnlineTestContext(_dbContextOptionBuilder.Options))
{
return(context.Users.FirstOrDefault(u => u.Email.Equals(email) && u.Password.Equals(password)));
}
}
public User Get(int Id)
{
using (var context = new OnlineTestContext(_dbContextOptionBuilder.Options))
{
return(context.Users.FirstOrDefault(u => u.Id == Id));
}
}
public List <Exam> GetExams()
{
using (var context = new OnlineTestContext(_dbContextOptionBuilder.Options))
{
return(context.Exams.OrderByDescending(e => e.CreatedOn).ToList());
}
}
public List <AnswerDetails> GetAnswerDetailsByExaminee(int examId, int examineeId)
{
using (var context = new OnlineTestContext(_dbContextOptionBuilder.Options))
{
var result = (from exam in context.Exams
join qus in context.Questions
on exam.Id equals qus.ExamId
join answer in context.Answers
on qus.Id equals answer.QuestionId
join examinee in context.Examinees
on answer.ExamineeId equals examinee.Id
where exam.Id == examId && answer.ExamineeId == examineeId
select new AnswerDetails
{
ExamId = exam.Id,
ExamineeId = answer.ExamineeId,
AnswerId = answer.Id,
QuestionId = qus.Id,
Text = qus.Text,
SubText = qus.SubText,
Point = qus.Point,
TypeId = qus.TypeId,
AnswerText = answer.Text,
AnswerPoint = answer.Point,
ExamineeName = examinee.Name,
ExamineeEmail = examinee.Email,
ExamineePhone = examinee.Phone,
Title = exam.Title,
Duration = exam.Duration,
AssessedBy = answer.AssessedBy ?? ""
}).OrderBy(a => a.QuestionId).ToList();
return(result);
}
}
public List <Question> GetByExam(int examId)
{
using (var context = new OnlineTestContext(_dbContextOptionBuilder.Options))
{
return(context.Questions.Where(q => q.ExamId == examId).ToList());
}
}
public Exam GetExamByCode(string code)
{
using (var context = new OnlineTestContext(_dbContextOptionBuilder.Options))
{
return(context.Exams.FirstOrDefault(e => e.ExameCode.Equals(code)));
}
}
public Examinee GetExamineeByExamAndEmail(int examId, string email)
{
using (var context = new OnlineTestContext(_dbContextOptionBuilder.Options))
{
return(context.Examinees.FirstOrDefault(e => e.Email.Equals(email) && e.ExamId == examId));
}
}
public ExamStatu GetExamStatus(int examId, int examineeId)
{
using (var context = new OnlineTestContext(_dbContextOptionBuilder.Options))
{
return(context.ExamStatus.FirstOrDefault(e => e.ExamId == examId && e.ExamineeId == examineeId));
}
}
public T Edit <T>(T entity) where T : class
{
using (var context = new OnlineTestContext(_dbContextOptionBuilder.Options))
{
context.Entry(entity).State = EntityState.Modified;
context.SaveChanges();
return(entity);
}
}
public T Get <T>(int id) where T : class
{
using (var context = new OnlineTestContext(_dbContextOptionBuilder.Options))
{
DbSet <T> dbSet = context.Set <T>();
var entity = dbSet.Find(id);
return(entity);
}
}
public List <T> GetAll <T>() where T : class
{
using (var context = new OnlineTestContext(_dbContextOptionBuilder.Options))
{
DbSet <T> dbSet = context.Set <T>();
var entityList = dbSet.AsNoTracking().ToList();
return(entityList);
}
}
public T Delete <T>(T entity) where T : class
{
using (var context = new OnlineTestContext(_dbContextOptionBuilder.Options))
{
DbSet <T> dbSet = context.Set <T>();
dbSet.Remove(entity);
context.SaveChanges();
return(entity);
}
}
public bool EditAll <T>(List <T> entityList) where T : class
{
using (var context = new OnlineTestContext(_dbContextOptionBuilder.Options))
{
try
{
foreach (var entity in entityList)
{
context.Entry(entity).State = EntityState.Modified;
}
context.SaveChanges();
return(true);
}
catch (Exception ex)
{
return(false);
}
}
}
public bool AddAll <T>(List <T> entityList) where T : class
{
using (var context = new OnlineTestContext(_dbContextOptionBuilder.Options))
{
try
{
DbSet <T> dbSet = context.Set <T>();
foreach (var entity in entityList)
{
dbSet.Add(entity);
}
context.SaveChanges();
return(true);
}
catch (Exception ex)
{
return(false);
}
}
}
public List <ExamineeDetails> GetExamStatus(int examId)
{
using (var context = new OnlineTestContext(_dbContextOptionBuilder.Options))
{
var submittedsQuestions = context.Answers.Where(a => a.ExamId == examId)
.GroupBy(a => a.ExamineeId)
.Select(a => new { ExamineeId = a.Key, Total = a.Select(x => x.QuestionId).Distinct().Count() });
var result = (from exam in context.Exams
join stat in context.ExamStatus
on exam.Id equals stat.ExamId
join examinee in context.Examinees
on stat.ExamineeId equals examinee.Id
where exam.Id == examId
select new ExamineeDetails
{
ExamId = exam.Id,
ExamineeId = examinee.Id,
ExamStatusId = stat.Id,
Title = exam.Title,
Name = examinee.Name,
Phone = examinee.Phone,
Email = examinee.Email,
Status = stat.Status,
TotalMarks = stat.TotalMarks,
ObtainedMarks = stat.ObtainedMarks
}).OrderByDescending(t => t.Status)
.ThenByDescending(t => t.ObtainedMarks).ToList();
foreach (var res in result)
{
var item = submittedsQuestions.FirstOrDefault(s => s.ExamineeId == res.ExamineeId);
res.TotalSubmission = item?.Total ?? 0;
}
return(result);
}
}
public ScoreRepository(OnlineTestContext dbContext)
{
DbContext = dbContext;
}
public MyService()
{
DbContext = new OnlineTestContext();
}
public BankRepository(OnlineTestContext _context)
{
DbContext = _context;
}
public UserRepository(OnlineTestContext dbContext)
{
DbContext = dbContext;
}
public QuestionRepository(OnlineTestContext _context)
{
DbContext = _context;
}
public ExamRepository(OnlineTestContext dbContext)
{
DbContext = dbContext;
}
public AnswerRepository(OnlineTestContext _DbContext)
{
DbContext = _DbContext;
}