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