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