public ActionResult ExamManager()
{
string user = User.Identity.GetUserId();
int?department = (from u in db.Users where u.Id == user select u.DepartmentId).FirstOrDefault();
List <int> departments = new List <int>(from d in db.Departments where (d.DepartmentId == department || d.DepartmentParentId == department) select d.DepartmentId);
List <string> subjects = new List <string> (from s in db.Subjects where departments.Contains(s.DepartmentId) select s.SubjectId);
List <ExamSession> exams = new List <ExamSession> (from e in db.ExamSessions where subjects.Contains(e.SubjectId) && e.Invigilations.Count == 0 select e);
List <string> examlist = new List <string>(from e in db.ExamSessions where subjects.Contains(e.SubjectId) select e.ExamId);
List <Invigilation> invigilations = new List <Invigilation>(from i in db.Invigilations.Include(e => e.RelatedExamSession).Include(l => l.RelatedUser) where examlist.Contains(i.ExamId) where examlist.Contains(i.ExamId) select i);
ExamDetailsViewModel examDetails = new ExamDetailsViewModel {
Sessions = exams,
Invigilations = invigilations,
Department = department
};
return(View(examDetails));
}
public ExamDetailsViewModel GetExam(int id)
{
Exam exam = _repos.Exams.GetWith(id, "Unit",
"Unit.Course",
"Unit.Lecturer",
"Unit.Lecturer.Profile",
"Questions",
"Questions.Answers",
"Likes",
"Comments");
if (exam == null)
{
throw new Exception("Exam with that id does not exist in records.");
}
var model = new ExamDetailsViewModel()
{
Code = exam.Code,
Comments = exam.Comments,
Date = exam.Date,
End = exam.End,
Id = exam.Id,
Instructor = exam.Unit.Lecturer.Profile,
Unit = new ExamUnit()
{
Id = exam.Unit.Id,
Name = exam.Unit.Name
},
Course = new ExamCourse()
{
Id = exam.Unit.Course.Id,
Code = exam.Unit.Course.Code,
Name = exam.Unit.Course.Name,
Type = exam.Unit.Course.Type
},
Name = exam.Name,
Likes = exam.Likes,
Start = exam.Start,
Moment = exam.Moment,
Questions = exam.Questions.Select(q => new ExamQuestion()
{
Id = q.Id,
Marks = q.Marks,
Text = q.Text,
Answers = q.Answers.Select(a => new QuestionAnswer()
{
Id = a.Id,
Text = a.Text
}).ToList()
}).ToList()
};
return(model);
}
public ActionResult AddorEdit(int id = 0)
{
ExamDetailsViewModel evm = new ExamDetailsViewModel();
if (id > 0)
{
evm = repo.ExamDetailById(id);
}
return(View(evm));
}
public ActionResult Create(ExamDetailsViewModel viewmodel)
{
var question = viewmodel.QuestionModel;
question.ExamId = viewmodel.DomainModel.Id;
if (ModelState.IsValid)
{
_Context.Question.Add(question);
_Context.SaveChanges();
return(RedirectToAction("Details", "Exams", new { id = viewmodel.DomainModel.Id }));
}
return(RedirectToAction("Details", "Exams", new { id = viewmodel.DomainModel.Id }));
}
public int Insert(ExamDetailsViewModel repo)
{
seat_exam_details exam_Info = new seat_exam_details()
{
building_id = repo.building_id,
classroom_id = repo.classroom_id,
exam_id = repo.exam_id,
roll_no_from = repo.roll_no_from,
roll_no_to = repo.roll_no_to,
college_name = repo.college_name,
};
db.seat_exam_details.Add(exam_Info);
return(db.SaveChanges());
}
public int Update(ExamDetailsViewModel repo, int id)
{
var exam = db.seat_exam_details.Where(x => x.exam_detail_id == id).FirstOrDefault();
if (exam != null)
{
exam.exam_id = repo.exam_id;
exam.building_id = repo.building_id;
exam.roll_no_to = repo.roll_no_to;
exam.roll_no_from = repo.roll_no_from;
exam.college_name = repo.college_name;
exam.classroom_id = repo.classroom_id;
}
return(db.SaveChanges());
}
// GET: Exams
public ActionResult Details(int id)
{
var ViewModel = new ExamDetailsViewModel
{
DomainModel = _Context.Exam.Include(m => m.Questions).
SingleOrDefault(m => m.Id == id),
QuestionModel = new Question()
};
if (User.IsInRole("Admin"))
{
return(View(ViewModel));
}
return(View("PublicDetails", ViewModel));
}
public ActionResult AddorEdit(ExamDetailsViewModel evm)
{
try
{
if (evm.exam_detail_id == 0)
{
repo.Insert(evm);
return(Json(new { success = true, html = GlobalClass.RenderRazorViewToString(this, "ViewAll", repo.GetExamDetail()), message = "Exam Details Added Successfully" }, JsonRequestBehavior.AllowGet));
}
else if (evm.exam_detail_id > 0)
{
repo.Update(evm, evm.exam_detail_id);
return(Json(new { success = true, html = GlobalClass.RenderRazorViewToString(this, "ViewAll", repo.GetExamDetail()), message = "Updated Successfully" }, JsonRequestBehavior.AllowGet));
}
else
{
return(Json(new { success = false, message = "Item Already Exists" }, JsonRequestBehavior.AllowGet));
}
}
catch (Exception ex)
{
return(Json(new { success = false, message = ex.Message.ToString() }, JsonRequestBehavior.AllowGet));
}
}
public IActionResult Details(int id)
{
ExamDetailsViewModel viewModel = this.examsService.GetById <ExamDetailsViewModel>(id);
return(this.View(viewModel));
}
