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));
}
