public ActionResult Detail(int id)
{
var dao = new AdminDao();
var session = (AdminLogin)Session[CommonConstants.USER_SESSION];
if (session.id_permission == 2)
{
return(View("Error"));
}
ViewBag.AdminName = session.name;
var dao2 = new SubjectDao().ViewDetail(id);
var dao1 = new ThematicDao().ListThematicInSubject(id);
if (dao2 == null)
{
return(View("Error"));
}
else
{
dao.UpdateLastLogin(session.id_admin);
dao.UpdateLastSeen("Xem thông tin của môn học " + dao2.subject_name, "/Admin/Subject/Detail" + dao2.id_subject, session.id_admin);
TempData["subject_name"] = dao2.subject_name;
TempData["id_subject"] = id;
return(View(dao1));
}
}
public ActionResult Edit(int id)
{
var dao = new AdminDao();
var session = (AdminLogin)Session[CommonConstants.USER_SESSION];
if (session.id_permission == 2)
{
return(View("Error"));
}
ViewBag.AdminName = session.name;
var dao1 = new SubjectDao().ViewDetail(id);
if (dao1 == null)
{
return(View("Error"));
}
else
{
dao.UpdateLastLogin(session.id_admin);
dao.UpdateLastSeen("Sửa thông tin của môn " + dao1.subject_name, "/Admin/Subject/Edit" + dao1.id_subject, session.id_admin);
return(View(dao1));
}
}
public ActionResult Edit(Model.EF.Subject collection)
{
var session = (AdminLogin)Session[CommonConstants.USER_SESSION];
if (session.id_permission == 2)
{
return(View("Error"));
}
ViewBag.AdminName = session.name;
var dao = new SubjectDao();
var id = dao.Update(collection);
if (id)
{
SetNotice("Hệ thống đã sửa thành công môn " + collection.subject_name + ".", "success");
return(RedirectToAction("Index"));
}
else
{
SetNotice("Có lỗi xảy ra!!", "danger");
ModelState.AddModelError("", "Cập nhật thông tin môn không thành công.");
}
return(View());
}
public SubjectDetailsViewModel(string id, MainWindowViewModel mainWindowViewModel)
{
_mainWindowViewModel = mainWindowViewModel;
_adding = false;
Subject = SubjectDao.FindById(id);
var softwareList = SoftwareDao.FindAll();
foreach (var software in softwareList)
{
var softwareViewModel = new SoftwareViewModel(software)
{
IsChecked = Subject.RequiredSoftware.FirstOrDefault(s => s.Id == software.Id) != null
};
SoftwareList.Add(softwareViewModel);
}
var courses = CourseDao.FindAll();
courses.ForEach(c => Courses.Add(c));
foreach (var subject in SubjectDao.FindAll())
{
_takenIds.Add(subject.Id);
}
}
public ActionResult QEdit(int id)
{
var dao = new AdminDao();
var session = (AdminLogin)Session[CommonConstants.USER_SESSION];
if (session.id_permission == 2)
{
return(View("Error"));
}
ViewBag.AdminName = session.name;
var dao1 = new QuestionDao().ViewDetail(id);
if (dao1 == null || dao1.is_essay == 1)
{
return(View("Error"));
}
else
{
var dao3 = new ThematicDao().ViewDetail(dao1.id_thematic);
var dao2 = new SubjectDao().ViewDetail(dao3.id_subject);
dao.UpdateLastLogin(session.id_admin);
dao.UpdateLastSeen("Sửa câu hỏi của môn " + dao2.subject_name, "/Admin/Subject/QEdit/" + id, session.id_admin);
TempData["subject_name"] = dao2.subject_name;
TempData["id_subject"] = dao2.id_subject;
//dao1.img = Server.MapPath("~/Assets/img_questions/") + dao1.img;
SetViewBag(dao3.id_subject, dao1.id_thematic);
return(View(dao1));
}
}
public ActionResult AddQuest(int id)
{
var dao = new AdminDao();
var dao2 = new SubjectDao().ViewDetail(id);
if (dao2 == null)
{
return(View("Error"));
}
else
{
var session = (AdminLogin)Session[CommonConstants.USER_SESSION];
if (session.id_permission == 2)
{
return(View("Error"));
}
ViewBag.AdminName = session.name;
dao.UpdateLastLogin(session.id_admin);
dao.UpdateLastSeen("Thêm câu hỏi cho môn " + dao2.subject_name, "Admin/Subject/QCreate/" + dao2.id_subject, session.id_admin);
TempData["subject_name"] = dao2.subject_name;
TempData["id_subject"] = id;
SetViewBag(id);
}
return(View());
}
public ActionResult EThematic(Model.EF.Thematic collection)
{
var session = (AdminLogin)Session[CommonConstants.USER_SESSION];
if (session.id_permission == 2)
{
return(View("Error"));
}
ViewBag.AdminName = session.name;
var dao = new ThematicDao();
var id = dao.Update(collection);
if (id)
{
SetNotice("Hệ thống đã sửa thành công chuyên đề " + collection.thematic_name + ".", "success");
return(RedirectToAction("Detail", new { id = collection.id_subject }));
}
else
{
var dao2 = new SubjectDao().ViewDetail(collection.id_subject);
TempData["subject_name"] = dao2.subject_name;
TempData["id_subject"] = collection.id_subject;
SetNotice("Có lỗi xảy ra!!", "danger");
ModelState.AddModelError("", "Cập nhật thông tin chuyên đề không thành công.");
}
var dao3 = new SubjectDao().ViewDetail(collection.id_subject);
TempData["subject_name"] = dao3.subject_name;
TempData["id_subject"] = collection.id_subject;
return(View());
}
public ActionResult Create(Subject collection)
{
var session = (AdminLogin)Session[CommonConstants.USER_SESSION];
if (session.id_permission == 2)
{
return(View("Error"));
}
ViewBag.AdminName = session.name;
if (ModelState.IsValid)
{
var dao = new SubjectDao();
int id = dao.Insert(collection);
if (id > 0)
{
//để thông báo thêm thành công
SetNotice("Hệ thống đã thêm thành công.", "success");
return(RedirectToAction("Create"));
}
else
{
ModelState.AddModelError("", "Thêm môn học không thành công.");
}
}
return(View());
}
public ActionResult EThematic(int id)
{
var dao = new AdminDao();
var session = (AdminLogin)Session[CommonConstants.USER_SESSION];
if (session.id_permission == 2)
{
return(View("Error"));
}
ViewBag.AdminName = session.name;
var dao1 = new ThematicDao().ViewDetail(id);
if (dao1 == null)
{
return(View("Error"));
}
else
{
var dao2 = new SubjectDao().ViewDetail(dao1.id_subject);
dao.UpdateLastLogin(session.id_admin);
dao.UpdateLastSeen("Sửa tên chuyên đề của môn " + dao2.subject_name, "/Admin/Subject/EThematic/" + dao2.id_subject, session.id_admin);
TempData["subject_name"] = dao2.subject_name;
TempData["id_subject"] = dao2.id_subject;
return(View(dao1));
}
}
/// <summary>
/// Gets the DAO subject.
/// </summary>
/// <returns></returns>
public override SubjectDao GetSubjectDao()
{
if (subjectDao == null)
{
subjectDao = new SubjectDao(connString);
}
return(subjectDao);
}
/// <summary>
/// Initializes a new instance of the SessionResult class.
/// </summary>
/// <param name="factory"></param>
public SessionResult(DaoFactory factory)
{
groupDao = factory.GetGroupDao();
subjectDao = factory.GetSubjectDao();
studentDao = factory.GetStudentDao();
examDao = factory.GetExamDao();
resultDao = factory.GetResultDao();
}
public ActionResult Delete(int id)
{
var result = new SubjectDao().Delete(id);
if (result == true)
{
}
return(RedirectToAction("Index"));
}
public void OnGet()
{
var courseDao = new CourseDao();
Courses = courseDao.GetAll();
var subjectDao = new SubjectDao();
Subjects = subjectDao.GetAll();
}
public ActionResult AddQuest(HttpPostedFileBase file, int id_subject, int id_thematic)
{
try
{
var dao = new QuestionDao();
var session = (AdminLogin)Session[CommonConstants.USER_SESSION];
if (session.id_permission == 2)
{
return(View("Error"));
}
ViewBag.AdminName = session.name;
var ad = new ImportExport();
HttpPostedFileBase upload = Request.Files["file"];
string path = Path.Combine(Server.MapPath("~/App_Data/uploads"), "cauhoi.xlsx");
if (file.ContentLength > 0)
{
var fileName = Path.GetFileName(file.FileName);
path = Path.Combine(Server.MapPath("~/App_Data/uploads"), fileName);
file.SaveAs(path);
}
var data = ad.ReadFromExcelfile(path, "");
int id = dao.InsertList(data, id_thematic);
if (id > 0)
{
SetViewBag(id_subject);
//để thông báo thêm thành công
SetNotice("Hệ thống đã thêm thành công " + id.ToString() + " câu hỏi", "success");
return(RedirectToAction("QDetail", new { id = id_subject }));
}
else
{
var dao2 = new SubjectDao().ViewDetail(id_subject);
TempData["subject_name"] = dao2.subject_name;
TempData["id_subject"] = id_subject;
SetViewBag(id_subject);
ModelState.AddModelError("", "Thêm câu hỏi không thành công.");
}
}
catch
{
var dao2 = new SubjectDao().ViewDetail(id_subject);
TempData["subject_name"] = dao2.subject_name;
TempData["id_subject"] = id_subject;
SetViewBag(id_subject);
ModelState.AddModelError("", "Thêm câu hỏi không thành công. Vui lòng kiểm tra file!");
}
var dao3 = new SubjectDao().ViewDetail(id_subject);
TempData["subject_name"] = dao3.subject_name;
TempData["id_subject"] = id_subject;
SetViewBag(id_subject);
return(View());
}
public Subject SaveSubject()
{
Subject.RequiredSoftware = new List <Software>();
foreach (var softwareViewModel in SoftwareList)
{
if (softwareViewModel.IsChecked)
{
Subject.RequiredSoftware.Add(softwareViewModel.Software);
}
}
if (_adding)
{
SubjectDao.Add(Subject);
}
else
{
var subject = SubjectDao.FindById(Subject.Id);
subject.Update(Subject);
var sessions = SessionDao.GetIncompatibleSessions(subject);
if (sessions.Count > 0)
{
var dialog = new ConfirmDelete(sessions,
"Are you sure you want to update this subject? Some of the sessions have already been placed in the schedule. Following is the list of all sessions that will be deleted if you proceed with this update.")
{
HelpState = Constants.ApplicationState.SubjectsAdd
};
dialog.ShowDialog();
if (dialog.Confirm)
{
SubjectDao.Update(subject);
foreach (var session in sessions)
{
SessionDao.Remove(session.Id);
}
_mainWindowViewModel.InitRemainigSessions();
_mainWindowViewModel.InitSessions();
}
else
{
return(null);
}
}
else
{
SubjectDao.Update(subject);
_mainWindowViewModel.InitRemainigSessions();
_mainWindowViewModel.InitSessions();
}
}
return(Subject);
}
private void SubjectDetails(string[] request)
{
serverStatus = ServerStatus.SEND_DB_INFO;
SubjectDao subjectDao = new SubjectDao();
subjectDao.SetConnection(connection);
subjectDao.ShowForSubject(request);
tablesToSend.AddRange(subjectDao.tablesToSend);
serverDataStatus = subjectDao.serverDataStatus;
}
private static void InitialiazeSubjects()
{
SubjectDao subjectDao = factory.GetSubjectDao();
foreach (string subjectName in subjectNames)
{
Subject subject = new Subject(subjectName);
subjectDao.Create(subject);
}
}
static DependencyResolver()
{
AccountDao = new AccountDao();
AccountLogic = new AccountLogic(AccountDao);
CategoryDao = new CategoryDao();
CategoryLogic = new CategoryLogic(CategoryDao);
SubjectDao = new SubjectDao();
SubjectLogic = new SubjectLogic(SubjectDao);
TestDao = new TestDao();
TestLogic = new TestLogic(TestDao);
}
public ActionResult QEssayCreate(Question collection, int id_subject)
{
var session = (AdminLogin)Session[CommonConstants.USER_SESSION];
if (session.id_permission == 2)
{
return(View("Error"));
}
ViewBag.AdminName = session.name;
if (ModelState.IsValid)
{
var dao = new QuestionDao();
collection.question_content = System.Net.WebUtility.HtmlDecode(collection.question_content);
collection.A = System.Net.WebUtility.HtmlDecode(collection.A);
collection.is_essay = 1;
collection.is_change = 0;
collection.B = "-1";
collection.C = "-1";
collection.D = "-1";
int id = dao.Insert(collection);
if (id > 0)
{
SetViewBag(id_subject);
//để thông báo thêm thành công
SetNotice("Hệ thống đã thêm thành công.", "success");
return(RedirectToAction("QDetail", new { id = id_subject }));
}
else
{
var dao2 = new SubjectDao().ViewDetail(id_subject);
TempData["subject_name"] = dao2.subject_name;
TempData["id_subject"] = id_subject;
SetViewBag(id_subject);
ModelState.AddModelError("", "Thêm câu hỏi tự luận không thành công.");
}
}
var dao3 = new SubjectDao().ViewDetail(id_subject);
TempData["subject_name"] = dao3.subject_name;
TempData["id_subject"] = id_subject;
SetViewBag(id_subject);
return(View());
}
public ActionResult CThematic(int id)
{
var dao = new AdminDao();
var dao2 = new SubjectDao().ViewDetail(id);
var session = (AdminLogin)Session[CommonConstants.USER_SESSION];
if (session.id_permission == 2)
{
return(View("Error"));
}
ViewBag.AdminName = session.name;
dao.UpdateLastLogin(session.id_admin);
dao.UpdateLastSeen("Thêm chuyên đề cho môn " + dao2.subject_name, "Admin/Subject/CThematic/" + dao2.id_subject, session.id_admin);
TempData["subject_name"] = dao2.subject_name;
TempData["id_subject"] = id;
return(View());
}
// GET: Admin/Subject
//phần về thông tin môn :D
public ActionResult Index()
{
var dao = new AdminDao();
var session = (AdminLogin)Session[CommonConstants.USER_SESSION];
if (session.id_permission == 2)
{
return(View("Error"));
}
ViewBag.AdminName = session.name;
dao.UpdateLastLogin(session.id_admin);
dao.UpdateLastSeen("Quản lý môn học", "Admin/Subject/", session.id_admin);
var dap1 = new SubjectDao();
var model = dap1.LissAll();
return(View(model));
}
public ActionResult Create()
{
var dao = new AdminDao();
var session = (AdminLogin)Session[CommonConstants.USER_SESSION];
if (session.id_permission == 0)
{
return(View("Error"));
}
ViewBag.AdminName = session.name;
SetViewBag();
var dao1 = new SubjectDao();
ViewBag.ListSubject = dao1.ListAll();
dao.UpdateLastLogin(session.id_admin);
dao.UpdateLastSeen("Tạo kì thi", "/Admin/Thread/Create", session.id_admin);
return(View());
}
public SubjectDetailsViewModel(MainWindowViewModel mainWindowViewModel)
{
_mainWindowViewModel = mainWindowViewModel;
_adding = true;
Subject = new Subject();
var softwareList = SoftwareDao.FindAll();
softwareList.ForEach(s => SoftwareList.Add(new SoftwareViewModel(s)));
var courses = CourseDao.FindAll();
courses.ForEach(c => Courses.Add(c));
foreach (var subject in SubjectDao.FindAll())
{
_takenIds.Add(subject.Id);
}
}
public Report()
{
StudentDao studentDao = new StudentDao();
students = studentDao.GetAll();
StudentGradeDao studentGradeDao = new StudentGradeDao();
grades = studentGradeDao.GetAll();
SubjectDao subjectDao = new SubjectDao();
subjects = subjectDao.GetAll();
ExaminationDao examinationDao = new ExaminationDao();
examinations = examinationDao.GetAll();
SessionDao sessionDao = new SessionDao();
sessions = sessionDao.GetAll();
GroupDao groupDao = new GroupDao();
groups = groupDao.GetAll();
}
public void InitRemainigSessions()
{
RemainingSessions.Clear();
if (_classroom == null)
{
return;
}
var classroom = ClassroomDao.FindById(_classroom.Id);
var schedule = LastOpenedSchedule;
var subjects = SubjectDao.FindAll();
var sessionsDictionary = subjects.ToDictionary(subject => subject.Id, subject => new RemainingSession()
{
RemainingTerms = subject.RequiredTerms,
Subject = subject
});
var sessions = SessionDao.FindByScheduleId(schedule.Id);
foreach (var session in sessions)
{
var currSession = sessionsDictionary[session.Subject.Id];
currSession.RemainingTerms -= session.Terms;
}
RemainingSessions.Clear();
var sessionList = sessionsDictionary.ToList();
sessionList.Sort(
(pair1, pair2) =>
String.Compare(pair1.Value.Subject.Name, pair2.Value.Subject.Name, StringComparison.Ordinal));
foreach (var remainingSession in sessionList)
{
var session = remainingSession.Value;
session.Compatible = classroom.CanHostSubject(session.Subject);
RemainingSessions.Add(session);
}
}
public ActionResult QDetail(int id)
{
var dao = new AdminDao();
var session = (AdminLogin)Session[CommonConstants.USER_SESSION];
if (session.id_permission == 2)
{
return(View("Error"));
}
ViewBag.AdminName = session.name;
var dao2 = new SubjectDao().ViewDetail(id);
var dao1 = new QuestionDao().ListQuestionInSubject(id);
if (dao2 == null)
{
return(View("Error"));
}
else
{
dao.UpdateLastLogin(session.id_admin);
dao.UpdateLastSeen("Xem các câu hỏi của môn học " + dao2.subject_name, "/Admin/Subject/QDetail" + dao2.id_subject, session.id_admin);
TempData["subject_name"] = dao2.subject_name;
TempData["id_subject"] = id;
var list = dao1.ToList();
foreach (var item in list)
{
item.question_content = RemoveHtml(RemoveFomula(item.question_content));
if (item.question_content.Length >= 90)
{
item.question_content = item.question_content.Substring(0, 90) + "....";
}
}
return(View(list));
}
}
public ActionResult QEssayEdit(Question collection, int id_subject)
{
var session = (AdminLogin)Session[CommonConstants.USER_SESSION];
if (session.id_permission == 2)
{
return(View("Error"));
}
ViewBag.AdminName = session.name;
var dao = new QuestionDao();
collection.correct_answer = System.Net.WebUtility.HtmlDecode(collection.question_content);
collection.A = System.Net.WebUtility.HtmlDecode(collection.A);
var id = dao.Update(collection);
if (id)
{
SetNotice("Hệ thống đã sửa thành công câu hỏi có id " + collection.id_question + ".", "success");
return(RedirectToAction("QDetail", new { id = id_subject }));
}
else
{
var dao2 = new SubjectDao().ViewDetail(id_subject);
TempData["subject_name"] = dao2.subject_name;
TempData["id_subject"] = id_subject;
SetNotice("Có lỗi xảy ra!!", "danger");
ModelState.AddModelError("", "Cập nhật thông tin câu hỏi không thành công.");
}
var dao3 = new SubjectDao().ViewDetail(id_subject);
TempData["subject_name"] = dao3.subject_name;
TempData["id_subject"] = id_subject;
SetViewBag(id_subject);
return(View());
}
public ActionResult CThematic(Thematic collection)
{
var session = (AdminLogin)Session[CommonConstants.USER_SESSION];
if (session.id_permission == 2)
{
return(View("Error"));
}
ViewBag.AdminName = session.name;
if (ModelState.IsValid)
{
var dao = new ThematicDao();
int id = dao.Insert(collection);
if (id > 0)
{
//để thông báo thêm thành công
SetNotice("Hệ thống đã thêm thành công.", "success");
return(RedirectToAction("Detail", new { id = collection.id_subject }));
}
else
{
var dao2 = new SubjectDao().ViewDetail(collection.id_subject);
TempData["subject_name"] = dao2.subject_name;
TempData["id_subject"] = collection.id_subject;
ModelState.AddModelError("", "Thêm chuyên đề không thành công.");
}
}
var dao3 = new SubjectDao().ViewDetail(collection.id_subject);
TempData["subject_name"] = dao3.subject_name;
TempData["id_subject"] = collection.id_subject;
return(View());
}
public SubjectFormPresenter()
{
_subjectDao = new SubjectDao();
}
public ActionResult Create(Thread entity, FormCollection collection)
{
var session = (AdminLogin)Session[CommonConstants.USER_SESSION];
if (session.id_permission == 0)
{
return(View("Error"));
}
ViewBag.AdminName = session.name;
if (ModelState.IsValid)
{
var dao = new ThreadDao();
var dao1 = new ThematicDao();
var dao2 = new QuestionDao();
var dao3 = new ExamDao();
int id_subject = Convert.ToInt32(collection["id_subject"]);
int total_exam = Convert.ToInt32(collection["total_exam"]);
int id_thread = dao.Insert(entity);
if (id_thread > 0)
{
//tạo bộ câu hỏi cho đề thi
List <ThematicModel> list_thematic = dao1.GetThematic(id_subject);
List <int> idExamOfThread = new List <int>();
for (int i = 1; i <= total_exam; i++)
{
int id_exam = dao3.Insert(id_thread);
idExamOfThread.Add(id_exam);
}
foreach (ThematicModel thematic in list_thematic)
{
//lấy danh sách câu hỏi trắc nghiệm ngẫu nhiên
int quest_of_thematic = Convert.ToInt32(collection["unit-" + thematic.id_thematic]);
List <Question> list_question = dao2.GetQuestionsByThematic(thematic.id_thematic, quest_of_thematic);
foreach (Question item in list_question)
{
foreach (int id_exam in idExamOfThread)
{
dao2.AddQuestionsToExam(id_exam, item.id_question);
}
}
//lấy danh sách câu hỏi tự luận ngẫu nhiên
quest_of_thematic = Convert.ToInt32(collection["unit-essay-" + thematic.id_thematic]);
List <Question> list_essay = dao2.GetEssayByThematic(thematic.id_thematic, quest_of_thematic);
foreach (Question item in list_essay)
{
foreach (int id_exam in idExamOfThread)
{
dao2.AddEssaysToExam(item, id_exam);
}
}
}
//để thông báo thêm thành công
SetNotice("Hệ thống đã thêm thành công.", "success");
return(RedirectToAction("Create"));
}
else
{
ModelState.AddModelError("", "Thêm kì thi không thành công.");
}
}
var dao4 = new SubjectDao();
ViewBag.ListSubject = dao4.ListAll();
SetViewBag();
return(View());
}
