public ActionResult EditDosen([Bind(Include = "Acd_Offered_Course_Lecturer1,Offered_Course_id,Employee_Id, Employees,Sks_Weight,Order_Id,Created_Date,Modified_By,Modified_Date")] Acd_Offered_Course_Lecturer acd_Offered_Course_Lecturer, string UrlReferrer) { var acd_Offered_Course_Lecturers = db.Acd_Offered_Course_Lecturer.Where(ocl => ocl.Offered_Course_id == acd_Offered_Course_Lecturer.Offered_Course_id).OrderBy(ocl => ocl.Order_Id); Acd_Offered_Course acd_Offered_Course = db.Acd_Offered_Course.Where(oc => oc.Offered_Course_id == acd_Offered_Course_Lecturer.Offered_Course_id).First(); if (ModelState.IsValid) { for (int i = 0; i < acd_Offered_Course_Lecturer.Employees.Length; i++) { short lastOrder = 0; if (acd_Offered_Course_Lecturers.ToList().Count() != 0) { lastOrder = acd_Offered_Course_Lecturers.Max(ocl => ocl.Order_Id); } acd_Offered_Course_Lecturer.Employee_Id = acd_Offered_Course_Lecturer.Employees[i]; acd_Offered_Course_Lecturer.Order_Id = Convert.ToInt16(lastOrder + 1); db.Acd_Offered_Course_Lecturer.Add(acd_Offered_Course_Lecturer); db.SaveChanges(); } return(RedirectToAction("EditDosen", new { id = acd_Offered_Course_Lecturer.Offered_Course_id, UrlReferrer = UrlReferrer })); } List <int> exceptionList = db.Acd_Offered_Course_Lecturer.Where(ocl => ocl.Offered_Course_id == acd_Offered_Course.Offered_Course_id).Select(ocl => ocl.Employee_Id).ToList(); ViewBag.UrlReferrer = UrlReferrer ?? System.Web.HttpContext.Current.Request.UrlReferrer.ToString(); ViewBag.Matakuliah = acd_Offered_Course.Acd_Course.Course_Name + "(" + acd_Offered_Course.Acd_Course.Course_Code + ")"; ViewBag.Kelas = acd_Offered_Course.Mstr_Class.Class_Name; ViewBag.Class_Prog_Id = acd_Offered_Course.Class_Prog_Id; ViewBag.Department_Id = acd_Offered_Course.Department_Id; ViewBag.Term_Year_Id = acd_Offered_Course.Term_Year_Id; ViewBag.Employee_Id = new SelectList(db.Acd_Department_Lecturer.Where(dl => !exceptionList.Contains(dl.Employee_Id)), "Emp_Employee.Employee_Id", "Emp_Employee.Full_Name"); ViewBag.Offered_Course_id = acd_Offered_Course_Lecturer.Offered_Course_id; return(View(acd_Offered_Course_Lecturers)); }
public ActionResult EditKelas([Bind(Include = "Offered_Course_id,Term_Year_Id,Department_Id,Class_Prog_Id,Course_Id,Class_Id,Classes,Total_Meeting,Class_Capacity,Created_By,Created_Date,Modified_By,Modified_Date")] Acd_Offered_Course acd_Offered_Course, string UrlReferrer) { if (ModelState.IsValid) { db.Entry(acd_Offered_Course).State = EntityState.Modified; try { db.SaveChanges(); } catch (DbUpdateException) { TempData["shortMessage"] = "Data telah ada."; TempData["UrlReferrer"] = UrlReferrer; return(RedirectToAction("EditKelas", acd_Offered_Course)); throw; } //return RedirectToAction("Index", new { Term_Year_Id = acd_Offered_Course.Term_Year_Id, Department_Id = acd_Offered_Course.Department_Id, Class_Prog_Id = acd_Offered_Course.Class_Prog_Id }); return(Redirect(UrlReferrer)); } List <short> exceptionKelas = db.Acd_Offered_Course.Where(oc => oc.Course_Id == acd_Offered_Course.Course_Id && oc.Term_Year_Id == acd_Offered_Course.Term_Year_Id && oc.Class_Prog_Id == acd_Offered_Course.Class_Prog_Id).Select(oc => oc.Class_Id).ToList(); ViewBag.Class_Id = new SelectList(db.Mstr_Class.Where(c => !exceptionKelas.Contains(c.Class_Id)), "Class_Id", "Class_Name", acd_Offered_Course.Class_Id); ViewBag.checkPeserta = db.Acd_Student_Krs.Count(sk => sk.Term_Year_Id == acd_Offered_Course.Term_Year_Id && sk.Class_Prog_Id == acd_Offered_Course.Class_Prog_Id && sk.Course_Id == acd_Offered_Course.Course_Id && sk.Class_Id == acd_Offered_Course.Class_Id); return(View(acd_Offered_Course)); }
// GET: OfferedCourseSched/Create public ActionResult Create(int?Offered_Course_id, short?Sched_Session_Id, string UrlReferrer) { if (TempData["gagalHapus"] != null) { ViewBag.gagalHapus = TempData["gagalHapus"].ToString(); } if (TempData["berhasilHapus"] != null) { ViewBag.berhasilHapus = TempData["berhasilHapus"].ToString(); } ViewBag.UrlReferrer = UrlReferrer ?? System.Web.HttpContext.Current.Request.UrlReferrer.ToString(); if (Offered_Course_id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } Acd_Offered_Course acd_Offered_Course = db.Acd_Offered_Course.Find(Offered_Course_id); if (acd_Offered_Course == null) { return(HttpNotFound()); } ViewBag.Prodi = acd_Offered_Course.Mstr_Department.Department_Name; List <short> SchedSessionx = db.Acd_Offered_Course_Sched.Where(ocs => ocs.Offered_Course_id == Offered_Course_id).Select(ocs => ocs.Sched_Session_Id).ToList(); List <short> Roomx = db.Acd_Offered_Course_Sched.Where(ocs => ocs.Sched_Session_Id == Sched_Session_Id).Select(ocs => ocs.Room_Id).ToList(); ViewBag.Matakuliah = acd_Offered_Course.Acd_Course.Course_Name + "(" + acd_Offered_Course.Acd_Course.Course_Code + ")"; ViewBag.Kelas = acd_Offered_Course.Mstr_Class.Class_Name; if (acd_Offered_Course.Mstr_Class_Program.Class_Program_Name == "Reguler" || acd_Offered_Course.Mstr_Class_Program.Class_Program_Name == "Eksekutif") { ViewBag.AcdSchedSession = db.Acd_Sched_Session.Where(ss => !SchedSessionx.Contains(ss.Sched_Session_Id) && ss.Mstr_Sched_Type.Sched_Type_Name == "KULIAH").OrderBy(ss => ss.Day_Id).ThenBy(ss => ss.Time_Start).ToList(); } else { ViewBag.AcdSchedSession = db.Acd_Sched_Session.Where(ss => !SchedSessionx.Contains(ss.Sched_Session_Id) && ss.Mstr_Sched_Type.Sched_Type_Name == "KULIAH" && ss.Class_Prog_Id == acd_Offered_Course.Class_Prog_Id).OrderBy(ss => ss.Day_Id).ThenBy(ss => ss.Time_Start).ToList(); } List <Mstr_Room> room = new List <Mstr_Room>(); room = db.Mstr_Room.Where(r => !Roomx.Contains(r.Room_Id)).ToList(); if (room.Count() == 0) { ViewBag.message = "Tidak ada ruang kosong untuk sesi yang anda pilih."; } ViewBag.Room_Id = room; ViewBag.Offered_Course_id = Offered_Course_id; var acd_Offered_Course_Sched = db.Acd_Offered_Course_Sched.Where(ocs => ocs.Offered_Course_id == Offered_Course_id); return(View(acd_Offered_Course_Sched.ToList())); }
// GET: OfferedCourse/Details/5 public ActionResult Details(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } Acd_Offered_Course acd_Offered_Course = db.Acd_Offered_Course.Find(id); if (acd_Offered_Course == null) { return(HttpNotFound()); } return(View(acd_Offered_Course)); }
// GET: OfferedCourse/Delete/5 //public ActionResult Delete(int? id) //{ // if (id == null) // { // return new HttpStatusCodeResult(HttpStatusCode.BadRequest); // } // Acd_Offered_Course acd_Offered_Course = db.Acd_Offered_Course.Find(id); // if (acd_Offered_Course == null) // { // return HttpNotFound(); // } // return View(acd_Offered_Course); //} // POST: OfferedCourse/Delete/5 //[HttpPost, ActionName("Delete")] //[ValidateAntiForgeryToken] public ActionResult Delete(int id, string UrlReferrer) { Acd_Offered_Course acd_Offered_Course = db.Acd_Offered_Course.Find(id); db.Acd_Offered_Course.Remove(acd_Offered_Course); try { db.SaveChanges(); } catch (DbUpdateException) { TempData["gagalHapus"] = "Gagal Hapus, Data sudah digunakan"; return(Redirect(UrlReferrer)); } TempData["berhasilHapus"] = "Berhasil Hapus Data."; //RedirectToAction("Index", new { Term_Year_Id = Convert.ToInt16(ViewData["ty"]) }); return(Redirect(UrlReferrer)); }
// GET: OfferedCourse/EditDosen/5 public ActionResult EditDosen(int?id, string UrlReferrer) { if (TempData["gagalHapus"] != null) { ViewBag.gagalHapus = TempData["gagalHapus"].ToString(); } if (TempData["berhasilHapus"] != null) { ViewBag.berhasilHapus = TempData["berhasilHapus"].ToString(); } ViewBag.UrlReferrer = UrlReferrer ?? System.Web.HttpContext.Current.Request.UrlReferrer.ToString(); if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } Acd_Offered_Course acd_Offered_Course = db.Acd_Offered_Course.Find(id); if (acd_Offered_Course == null) { return(HttpNotFound()); } List <int> exceptionList = db.Acd_Offered_Course_Lecturer.Where(ocl => ocl.Offered_Course_id == id).Select(ocl => ocl.Employee_Id).ToList(); ViewBag.Matakuliah = acd_Offered_Course.Acd_Course.Course_Name + "(" + acd_Offered_Course.Acd_Course.Course_Code + ")"; ViewBag.Kelas = acd_Offered_Course.Mstr_Class.Class_Name; ViewBag.Class_Prog_Id = acd_Offered_Course.Class_Prog_Id; ViewBag.Department_Id = acd_Offered_Course.Department_Id; ViewBag.Term_Year_Id = acd_Offered_Course.Term_Year_Id; ViewBag.Employee_Id = new SelectList(db.Acd_Department_Lecturer.Where(dl => !exceptionList.Contains(dl.Employee_Id) && dl.Department_Id == acd_Offered_Course.Department_Id), "Emp_Employee.Employee_Id", "Emp_Employee.Full_Name"); ViewBag.Offered_Course_id = id; var acd_Offered_Course_Lecturer = db.Acd_Offered_Course_Lecturer.Where(ocl => ocl.Offered_Course_id == id).OrderBy(ocl => ocl.Order_Id); //ViewBag.Course_Id = new SelectList(db.Acd_Course, "Course_Id", "Course_Code", acd_Offered_Course.Course_Id); //ViewBag.Class_Id = new SelectList(db.Mstr_Class, "Class_Id", "Class_Name", acd_Offered_Course.Class_Id); return(View(acd_Offered_Course_Lecturer.ToList())); }
// GET: OfferedCourse/EditKelas/5 public ActionResult EditKelas(int?id) { string UrlReferrer = null; if (TempData["UrlReferrer"] != null) { UrlReferrer = TempData["UrlReferrer"].ToString(); } ViewBag.UrlReferrer = UrlReferrer ?? System.Web.HttpContext.Current.Request.UrlReferrer.ToString(); if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } if (TempData["shortMessage"] != null) { ViewBag.message = TempData["shortMessage"].ToString(); } Acd_Offered_Course acd_Offered_Course = db.Acd_Offered_Course.Find(id); if (acd_Offered_Course == null) { return(HttpNotFound()); } List <short> exceptionKelas = db.Acd_Offered_Course.Where(oc => oc.Course_Id == acd_Offered_Course.Course_Id && oc.Term_Year_Id == acd_Offered_Course.Term_Year_Id && oc.Class_Prog_Id == acd_Offered_Course.Class_Prog_Id && oc.Class_Id != acd_Offered_Course.Class_Id).Select(oc => oc.Class_Id).ToList(); ViewBag.Class_Id = new SelectList(db.Mstr_Class.Where(c => !exceptionKelas.Contains(c.Class_Id)), "Class_Id", "Class_Name", acd_Offered_Course.Class_Id); ViewBag.checkPeserta = db.Acd_Student_Krs.Count(sk => sk.Term_Year_Id == acd_Offered_Course.Term_Year_Id && sk.Class_Prog_Id == acd_Offered_Course.Class_Prog_Id && sk.Course_Id == acd_Offered_Course.Course_Id && sk.Class_Id == acd_Offered_Course.Class_Id); return(View(acd_Offered_Course)); }
public ActionResult Create([Bind(Include = "Offered_Course_id,Term_Year_Id,Department_Id,Class_Prog_Id,Course_Id,Class_Id, Classes,Total_Meeting,Class_Capacity,Created_By,Created_Date,Modified_By,Modified_Date")] Acd_Offered_Course acd_Offered_Course, string UrlReferrer) { if (ModelState.IsValid) { for (int i = 0; i < acd_Offered_Course.Classes.Length; i++) { acd_Offered_Course.Class_Id = acd_Offered_Course.Classes[i]; db.Acd_Offered_Course.Add(acd_Offered_Course); db.SaveChanges(); } return(RedirectToAction("Create", new { Term_Year_Id = acd_Offered_Course.Term_Year_Id, Department_Id = acd_Offered_Course.Department_Id, Class_Prog_Id = acd_Offered_Course.Class_Prog_Id, Course_Id = acd_Offered_Course.Course_Id, UrlReferrer = UrlReferrer })); } var acd_Offered_Courses = db.Acd_Offered_Course.Where(oc => oc.Term_Year_Id == acd_Offered_Course.Term_Year_Id && oc.Course_Id == acd_Offered_Course.Course_Id).ToList(); var exceptionClass = db.Acd_Offered_Course.Where(oc => oc.Term_Year_Id == acd_Offered_Course.Term_Year_Id && oc.Course_Id == acd_Offered_Course.Course_Id && oc.Class_Prog_Id == acd_Offered_Course.Class_Prog_Id).Select(oc => oc.Class_Id).ToList(); ViewBag.Class_Id = new SelectList(db.Mstr_Class.Where(c => !exceptionClass.Contains(c.Class_Id)), "Class_Id", "Class_Name"); ViewBag.Course_Id = new SelectList(db.Acd_Course.Where(c => c.Department_Id == acd_Offered_Course.Department_Id), "Course_Id", "Course_Name", acd_Offered_Course.Course_Id); ViewBag.Class_Prog = db.Mstr_Class_Program.Where(cp => cp.Class_Prog_Id == acd_Offered_Course.Class_Prog_Id).FirstOrDefault(); ViewBag.Department = db.Mstr_Department.Where(d => d.Department_Id == acd_Offered_Course.Department_Id).FirstOrDefault(); ViewBag.Term_Year = db.Mstr_Term_Year.Where(ty => ty.Term_Year_Id == acd_Offered_Course.Term_Year_Id).FirstOrDefault(); ViewBag.UrlReferrer = UrlReferrer ?? System.Web.HttpContext.Current.Request.UrlReferrer.ToString(); return(View(acd_Offered_Courses)); }