// GET: /SchoolTeacher/ public ActionResult Index() { try { // TODO: DG: This controller is not used for March release. // Need to select the correct school id. SiteUser siteUser = ((SiteUser)Session["SiteUser"]); List<UserSchool> userSchool = ((SiteUser)Session["SiteUser"]).Schools.Take(1).ToList(); int schoolId = userSchool[0].Id; List<int> teacherIds = modelServices.GetSchoolTeacherIds(schoolId); //var tblschooluserroles = (from s in db.tblSchoolUserRoles.Include(t => t.tblRole).Include(t => t.tblSchool).Include(t => t.tblUser) // where (teacherIds.Contains(s.UserId)) // select s); //return View(tblschooluserroles.ToList()); return View(); } catch (Exception ex) { Logging log = new Logging(); log.LogException(ex); throw; } }
// GET: /SchoolTeacher/Create public ActionResult Create() { try { ViewBag.RoleId = new SelectList(db.tblRoles, "RoleId", "RoleDesc"); ViewBag.SchoolId = new SelectList(db.tblSchools, "SchoolId", "SchoolDesc"); ViewBag.UserId = new SelectList(db.tblUsers, "UserId", "FirstName"); return View(); } catch (Exception ex) { Logging log = new Logging(); log.LogException(ex); throw; } }