public ActionResult Create([Bind(Include = "id,code,title,hours,class_length,have_final_exam,exam_length,program_id," + "is_deleted,created_by,class_weekday,class_start_time,room_id,faculty_id,program_id")] course course) { if (ModelState.IsValid) { course.created_on = DateTime.Now; db.courses.Add(course); course_exam tempCE = new course_exam(); tempCE.course_id = course.id; tempCE.created_by = course.created_by; tempCE.created_on = course.created_on; tempCE.exam_length = course.exam_length; tempCE.have_final_exam = course.have_final_exam; tempCE.final_exam_note = course.final_exam_note; tempCE.is_deleted = false; tempCE.required_room_type_id = db.rooms.Find(course.room_id).room_type_id; db.course_exam.Add(tempCE); section tempS = new section(); tempS.program_id = course.program_id; tempS.course_id = course.id; tempS.section_number = 1; tempS.faculty_id = course.faculty_id; tempS.class_weekday = course.class_weekday; tempS.class_start_time = course.class_start_time; tempS.room_id = course.room_id; tempS.student_enrolled = 30; tempS.is_deleted = false; tempS.created_by = course.created_by; tempS.created_on = course.created_on; db.sections.Add(tempS); db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.required_room1_type_id = new SelectList(db.room_type, "id", "type", course.required_room1_type_id); ViewBag.required_room2_type_id = new SelectList(db.room_type, "id", "type", course.required_room2_type_id); ViewBag.required_room_type_id = new SelectList(db.room_type.Where(c => c.is_deleted == false), "id", "type"); ViewBag.course_id = new SelectList(db.courses.Where(p => !(db.course_exam.Any(p2 => p2.course_id == p.id)) && p.is_deleted == false).OrderBy(o => o.code), "id", "courseDropdown"); //ViewBag.course_id = new SelectList(db.courses.Where(p => p.is_deleted == false).OrderBy(o => o.code), "id", "courseDropdown"); ViewBag.faculty_id = new SelectList(db.faculties.Where(c => c.is_deleted == false).OrderBy(o => o.first_name), "id", "fullName", 10015); ViewBag.program_id = new SelectList(db.programs.Where(c => c.is_deleted == false), "id", "title"); ViewBag.room_id = new SelectList(db.rooms.Where(p => p.is_deleted == false).OrderBy(o => o.name), "id", "name", 8); var weekDays = Enum.GetValues(typeof(DayOfWeek)).Cast <DayOfWeek>() .Select(dow => new { Value = (int)dow - 1, Text = dow.ToString() }) .ToList(); ViewBag.class_weekday = new SelectList(weekDays, "Value", "Text", 0); return(View(course)); }
// GET: CourseExam/Details/5 public ActionResult Details(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } course_exam course_exam = db.course_exam.Find(id); if (course_exam == null) { return(HttpNotFound()); } return(View(course_exam)); }
// GET: CourseExam/Edit/5 public ActionResult Edit(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } course_exam course_exam = db.course_exam.Find(id); if (course_exam == null) { return(HttpNotFound()); } ViewBag.required_room_type_id = new SelectList(db.room_type.Where(c => c.is_deleted == false), "id", "type", course_exam.required_room_type_id); ViewBag.course_id = new SelectList(db.courses.Where(c => c.is_deleted == false || c.id == course_exam.course_id).OrderBy(o => o.code), "id", "courseDropdown", course_exam.course_id); return(View(course_exam)); }
public ActionResult Create([Bind(Include = "id,course_id,have_final_exam,exam_length,required_room_type_id,final_exam_note,is_deleted,created_by,created_on,modified_by,modified_on")] course_exam course_exam) { if (ModelState.IsValid) { course_exam.created_on = DateTime.Now; db.course_exam.Add(course_exam); db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.required_room_type_id = new SelectList(db.room_type.Where(r => r.is_deleted == false), "id", "type", course_exam.required_room_type_id); ViewBag.course_id = new SelectList(db.courses.Where(p => !(db.course_exam.Any(p2 => p2.course_id == p.id)) && p.is_deleted == false).OrderBy(o => o.code), "id", "courseDropdown", course_exam.course_id); return(View(course_exam)); }
public ActionResult DeleteConfirmed(int id) { course_exam course_exam = db.course_exam.Find(id); //course_exam.is_deleted = true; //// set all related course to deleted = true //var tempC = db.courses.Where(e => e.id == course_exam.course_id); //if (tempC.ToList().Count > 0) //{ // foreach (var item in tempC) // { // item.is_deleted = true; // } //} //// set all related sections deleted = true //var tempS = db.sections.Where(e => e.course_id == course_exam.course_id); //if (tempS.ToList().Count > 0) //{ // foreach (var item in tempS) // { // item.is_deleted = true; // } //} //course_exam.modified_on = DateTime.Now; foreach (var item in db.sections.Where(s => s.course_id == course_exam.course_id)) { db.sections.Remove(item); } foreach (var c in db.courses.Where(c => c.id == course_exam.course_id)) { db.courses.Remove(c); } db.course_exam.Remove(course_exam); db.SaveChanges(); return(RedirectToAction("Index")); }
public ActionResult Edit([Bind(Include = "id,course_id,have_final_exam,exam_length,required_room_type_id,final_exam_note,is_deleted,created_by,created_on,modified_by,modified_on")] course_exam course_exam) { if (ModelState.IsValid) { db.Entry(course_exam).State = EntityState.Modified; if (course_exam.is_deleted == true) { // set all related course to deleted = true var tempC = db.courses.Where(e => e.id == course_exam.course_id); if (tempC.ToList().Count > 0) { foreach (var item in tempC) { item.is_deleted = true; } } // set all related sections deleted = true var tempS = db.sections.Where(e => e.course_id == course_exam.course_id); if (tempS.ToList().Count > 0) { foreach (var item in tempS) { item.is_deleted = true; } } } else { // set all related course to deleted = false var tempC = db.courses.Where(e => e.id == course_exam.course_id); if (tempC.ToList().Count > 0) { foreach (var item in tempC) { item.is_deleted = false; } } // set all related sections deleted = false var tempS = db.sections.Where(e => e.course_id == course_exam.course_id); if (tempS.ToList().Count > 0) { foreach (var item in tempS) { item.is_deleted = false; } } } course_exam.modified_on = DateTime.Now; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.required_room_type_id = new SelectList(db.room_type.Where(c => c.is_deleted == false), "id", "type", course_exam.required_room_type_id); ViewBag.course_id = new SelectList(db.courses.Where(c => c.is_deleted == false || c.id == course_exam.course_id).OrderBy(o => o.code), "id", "courseDropdown", course_exam.course_id); return(View(course_exam)); }
public ActionResult Edit([Bind(Include = "id,code,title,hours,class_length,have_final_exam,exam_length,program_id," + "is_deleted,created_by,class_weekday,class_start_time,room_id,faculty_id,program_id")] course course) { if (ModelState.IsValid) { db.Entry(course).State = EntityState.Modified; course.modified_on = DateTime.Now; course_exam tempCEX = db.course_exam.Where(w => w.course_id == course.id).First(); tempCEX.exam_length = course.exam_length; tempCEX.final_exam_note = course.final_exam_note; tempCEX.modified_on = DateTime.Now; section tempS = db.sections.Where(w => w.course_id == course.id).First(); tempS.program_id = course.program_id; tempS.faculty_id = course.faculty_id; tempS.class_weekday = course.class_weekday; tempS.class_start_time = course.class_start_time; tempS.room_id = course.room_id; tempS.modified_on = DateTime.Now; if (course.is_deleted == true) { // set this course-exam is_deleted = true var tempCE = db.course_exam.Where(e => e.course_id == course.id); if (tempCE.ToList().Count > 0) { foreach (var item in tempCE) { item.is_deleted = true; } } // set this course - section is_deleted = true var tempCS = db.sections.Where(e => e.course_id == course.id); if (tempCS.ToList().Count > 0) { foreach (var item in tempCS) { item.is_deleted = true; } } } else { // set this course-exam is_deleted = false var tempCE = db.course_exam.Where(e => e.course_id == course.id); if (tempCE.ToList().Count > 0) { foreach (var item in tempCE) { item.is_deleted = false; } } // set this course - section is_deleted = false var tempCS = db.sections.Where(e => e.course_id == course.id); if (tempCS.ToList().Count > 0) { foreach (var item in tempCS) { item.is_deleted = false; } } } course.modified_on = DateTime.Now.AddHours(1); db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.required_room_type_id = new SelectList(db.room_type.Where(c => c.is_deleted == false), "id", "type", db.course_exam.Where(w => w.course_id == course.id).First().required_room_type_id); ViewBag.course_id = new SelectList(db.courses.Where(p => !(db.course_exam.Any(p2 => p2.course_id == p.id)) && p.is_deleted == false).OrderBy(o => o.code), "id", "courseDropdown", course.id); ViewBag.faculty_id = new SelectList(db.faculties.Where(c => c.is_deleted == false).OrderBy(o => o.first_name), "id", "fullName", db.sections.Where(s => s.course_id == course.id && s.section_number == 1).First().faculty.id); ViewBag.program_id = new SelectList(db.programs.Where(c => c.is_deleted == false), "id", "title", db.sections.Where(s => s.course_id == course.id && s.section_number == 1).First().program.id); ViewBag.room_id = new SelectList(db.rooms.Where(p => p.is_deleted == false).OrderBy(o => o.name), "id", "name", db.sections.Where(s => s.course_id == course.id && s.section_number == 1).First().room.id); var weekDays = Enum.GetValues(typeof(DayOfWeek)).Cast <DayOfWeek>() .Select(dow => new { Value = (int)dow - 1, Text = dow.ToString() }) .ToList(); ViewBag.class_weekday = new SelectList(weekDays, "Value", "Text", db.sections.Where(s => s.course_id == course.id && s.section_number == 1).First().class_weekday); ViewBag.class_start_time = db.sections.Where(s => s.course_id == course.id && s.section_number == 1).First().class_start_time; ViewBag.exam_length = db.course_exam.Where(w => w.course_id == course.id).First().exam_length; ViewBag.note = db.course_exam.Where(w => w.course_id == course.id).First().final_exam_note; ViewBag.has_exam = db.course_exam.Where(w => w.course_id == course.id).First().have_final_exam; return(View(course)); }