public ActionResult _identifyStaff(string selectedbadge)
        {
            var svm             = new SubstituteViewModel();
            var selectedTeacher = _db.SchoolTeachersWithADLogins.FirstOrDefault(x => x.BADGE_NUM == selectedbadge);

            svm.BadgeNumber = selectedTeacher.BADGE_NUM;
            svm.SchoolName  = selectedTeacher.Organization_Name;
            return(PartialView("partials/_create", svm));
        }
        public ActionResult Index()
        {
            var schools = _ren.PEMinutesTeacherCounts.Where(x => x.Organization_Name.Contains("Elemen")); // Limiting the dropdown to only elementary schools
            var svm     = new SubstituteViewModel();

            foreach (var item in schools)
            {
                var sl = new SchList {
                    SchoolName = item.Organization_Name
                };
                svm.SchoolList.Add(sl);
            }
            svm.SchoolList = svm.SchoolList.ToList();
            return(View(svm));
        }
        public ActionResult _GetTeachers(string selectedSchool)
        {
            var svm = new SubstituteViewModel();
            var selectedTeachers = _db.SchoolTeachersWithADLogins.Where(i => i.Organization_Name == selectedSchool && i.COURSE_TITLE.Contains("PS") == false && i.COURSE_TITLE.Contains("Kind") == false).OrderBy(i => i.TeacherLastName).ToList();

            foreach (var item in selectedTeachers)
            {
                var tl = new TeachList
                {
                    SchoolName  = item.Organization_Name,
                    TeacherName = item.TeacherLastName + ", " + item.TeacherFirstName,
                    BadgeNumber = item.BADGE_NUM
                };
                svm.TeacherList.Add(tl);
            }
            svm.TeacherList = svm.TeacherList.ToList();
            return(PartialView("partials/_getTeachers", svm));
        }