public ActionResult Create(COURSE_TABLE course_table)
        {
            //reset the id
            if (ModelState.ContainsKey("COURSE_ID"))
                ModelState["COURSE_ID"].Errors.Clear();

            if (ModelState.IsValid)
            {
                db.COURSE_TABLE.Add(course_table);
                db.SaveChanges();
                TempData["notice"] = "New Course Has Been Successfully registered!";
                return RedirectToAction("Index");
            }

            ViewBag.FACULTY_ID = new SelectList(db.FACULTY_TABLE, "FACULTY_ID", "FACULTY_NAME", course_table.FACULTY_ID);
            return View(course_table);
        }
 public ActionResult Edit(COURSE_TABLE course_table)
 {
     if (ModelState.IsValid)
     {
         db.Entry(course_table).State = EntityState.Modified;
         db.SaveChanges();
         TempData["notice"] = "The Course Has Been Successfully Altered!";
         return RedirectToAction("Index");
     }
     ViewBag.FACULTY_ID = new SelectList(db.FACULTY_TABLE, "FACULTY_ID", "FACULTY_NAME", course_table.FACULTY_ID);
     return View(course_table);
 }