public ActionResult AssignSubject(SET_CLASS set_class) { decimal?USER_NO = Session["sess_USER_NO"] as decimal?; decimal?LOGON_NO = Session["sess_LOGON_NO"] as decimal?; List <Class_Subject> subjects = set_class.Subjects; foreach (var subject in subjects) { decimal is_active = subject.IS_ACTIVE == true ? 1 : 0; db.SET_CLASS_SUBJECT_ASSIGN(set_class.CLASS_NO, subject.SUBJECT_NO, is_active, USER_NO, LOGON_NO); } subjects = (from ss in db.SET_SUBJECT join cs in db.SET_CLASS_SUBJECT on ss.SUBJECT_NO equals cs.SUBJECT_NO into joined from j in joined.Where(a => a.CLASS_NO == set_class.CLASS_NO || a.CLASS_NO == null).DefaultIfEmpty() //where (j.CLASS_NO == set_class.CLASS_NO || j.CLASS_NO == null) select new Class_Subject { SUBJECT_NO = ss.SUBJECT_NO, SUBJECT_NAME = ss.SUBJECT_NAME, SUBJECT_NAME_BNG = ss.SUBJECT_NAME_BNG, IS_ACTIVE = j.IS_ACTIVE == 1 ? true : false }).OrderBy(a => a.SUBJECT_NO).ToList(); ViewBag.Subjects = subjects; return(View(set_class)); }
public ActionResult DeleteConfirmed(decimal id) { SET_CLASS set_class = db.SET_CLASS.Single(s => s.CLASS_NO == id); db.SET_CLASS.DeleteObject(set_class); db.SaveChanges(); return(RedirectToAction("Index")); }
// // GET: /SetClass/Delete/5 public ActionResult Delete(decimal id = 0) { SET_CLASS set_class = db.SET_CLASS.Single(s => s.CLASS_NO == id); if (set_class == null) { return(HttpNotFound()); } return(View(set_class)); }
public ActionResult Edit(SET_CLASS set_class) { if (ModelState.IsValid) { db.SET_CLASS.Attach(set_class); db.ObjectStateManager.ChangeObjectState(set_class, EntityState.Modified); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(set_class)); }
public ActionResult Create(SET_CLASS set_class) { if (ModelState.IsValid) { db.SET_CLASS.AddObject(set_class); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(set_class)); }
public ActionResult AssignSubject(decimal id = 0) { SET_CLASS set_class = db.SET_CLASS.Single(s => s.CLASS_NO == id); List <Class_Subject> subjects = (from ss in db.SET_SUBJECT join cs in db.SET_CLASS_SUBJECT on ss.SUBJECT_NO equals cs.SUBJECT_NO into joined from j in joined.Where(a => a.CLASS_NO == set_class.CLASS_NO || a.CLASS_NO == null).DefaultIfEmpty() //where j.CLASS_NO == id || j.CLASS_NO == null select new Class_Subject { SUBJECT_NO = ss.SUBJECT_NO, SUBJECT_NAME = ss.SUBJECT_NAME, SUBJECT_NAME_BNG = ss.SUBJECT_NAME_BNG, IS_ACTIVE = j.IS_ACTIVE == 1 ? true : false }).OrderBy(a => a.SUBJECT_NO).ToList(); ViewBag.Subjects = subjects; return(View(set_class)); }