public ActionResult endexam() { if (Session["us_id"] == null) { return(RedirectToAction("Index")); } EXAM ex = new EXAM(); try { ex.EXAM_ID = Convert.ToInt32(TempData["examid"]); ex.EXAM_FK_USER = Convert.ToInt32(Session["us_id"]); ex.EXAM_DATE = System.DateTime.Now; int total = Convert.ToInt32(TempData["examid"]); ex.EXAM_USER_SCORE = (int)Convert.ToInt32(TempData["score"].ToString()); p.EXAMs.Add(ex); p.SaveChanges(); } catch (Exception) { } Session.RemoveAll(); TempData["score"] = ex.EXAM_USER_SCORE; return(View()); }
public ActionResult DeleteConfirmed(int id) { EXAM eXAM = db.EXAMs.Find(id); db.EXAMs.Remove(eXAM); db.SaveChanges(); return(RedirectToAction("Index")); }
public ActionResult Edit([Bind(Include = "id,examSubject,startTime,examDate,examDuration,classRoom,faculty")] EXAM eXAM) { if (ModelState.IsValid) { db.Entry(eXAM).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.classRoom = new SelectList(db.Classes, "id", "name", eXAM.classRoom); ViewBag.examSubject = new SelectList(db.Subjects, "id", "name", eXAM.examSubject); ViewBag.faculty = new SelectList(db.Faculties, "id", "name", eXAM.faculty); return(View(eXAM)); }
// GET: EXAMs/Details/5 public ActionResult Details(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } EXAM eXAM = db.EXAMs.Find(id); if (eXAM == null) { return(HttpNotFound()); } return(View(eXAM)); }
// GET: EXAMs/Edit/5 public ActionResult Edit(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } EXAM eXAM = db.EXAMs.Find(id); if (eXAM == null) { return(HttpNotFound()); } ViewBag.classRoom = new SelectList(db.Classes, "id", "name", eXAM.classRoom); ViewBag.examSubject = new SelectList(db.Subjects, "id", "name", eXAM.examSubject); ViewBag.faculty = new SelectList(db.Faculties, "id", "name", eXAM.faculty); return(View(eXAM)); }
static public USINGEXAM AutoMakeExam(USINGEXAM usingExam_, EXAM exam, DateTime startdate, DateTime endDate) { USINGEXAM usingExam = new USINGEXAM(usingExam_); DateTime selectedDate = startdate; List <ROOM> listRoomFiltered = (from r in DataProvider.Ins.DB.ROOMs where r.Capacity >= exam.Population_ orderby r.Capacity ascending select r).ToList(); while (selectedDate <= endDate) { if (selectedDate.DayOfWeek != DayOfWeek.Sunday) { foreach (ROOM room in listRoomFiltered) { usingExam.Date_ = selectedDate; usingExam.StartPeriod = 1; usingExam.RoomID = room.RoomID; while (CalcEndPeriod(usingExam.StartPeriod, usingExam.Duration) != -1) { var listOverlapExam = CheckOverlapExam(usingExam); var listOverlapEvent = CheckOverlapEvent(usingExam); int maxOverlapEndPeriod = 0; if (listOverlapEvent == null && listOverlapExam == null) { return(usingExam); } if (listOverlapExam != null) { foreach (var overlapExam in listOverlapExam) { int overlapEndPeriod = CalcEndPeriod(overlapExam.StartPeriod, overlapExam.Duration); if (maxOverlapEndPeriod < overlapEndPeriod) { maxOverlapEndPeriod = overlapEndPeriod; } } } if (listOverlapEvent != null) { foreach (var overlapEvent in listOverlapEvent) { int overlapEndPeriod = CalcEndPeriod(overlapEvent.StartPeriod, overlapEvent.Duration); if (maxOverlapEndPeriod < overlapEndPeriod) { maxOverlapEndPeriod = overlapEndPeriod; } } } int newStartPeriod = maxOverlapEndPeriod + 1; int newEndperiod = CalcEndPeriod(newStartPeriod, usingExam.Duration); if (newStartPeriod <= 5 && newEndperiod > 5) { newStartPeriod = 6; } usingExam.StartPeriod = newStartPeriod; } } } selectedDate = selectedDate.AddDays(1); } return(null); }