// GET: /Students/ public ActionResult Index() { try { dbTIREntities db = new dbTIREntities(); SiteUser siteUser = ((SiteUser)Session["SiteUser"]); StudentService studentService = new StudentService(siteUser, db); SchoolService schoolService = new SchoolService(siteUser, db); ModelServices modelService = new ModelServices(); string currentSchoolYear = schoolService.GetCurrentSchoolYear(); ViewBag.DistrictDesc = siteUser.Districts[0].Name; int schoolYearId = modelService.SchoolYearId(); ViewBag.SchoolId = modelService.DropDownDataSchool("", siteUser.EdsUserId, schoolYearId, true); ViewBag.AllowEdit = HelperService.AllowUiEdits(siteUser.RoleDesc, "STUDENT"); //ViewBag.SchoolYear = HelperService.SchoolYearDescription(db); ViewBag.SchoolYearList = schoolService.DropDownDataSchoolYear(currentSchoolYear); ViewBag.AllowEdit = HelperService.AllowUiEdits(siteUser.RoleDesc, "STUDENT"); ViewBag.SchoolYear = currentSchoolYear; return View(new SiteModels() { Students = studentService.GetViewData(currentSchoolYear, "", "") }); } catch (Exception ex) { Logging log = new Logging(); log.LogException(ex); return View("GeneralError"); } }
public ActionResult UpdateGrid(string hiddenSchoolFilter, string hiddenSchoolYearFilter) { try { dbTIREntities db = new dbTIREntities(); SiteUser siteUser = ((SiteUser)Session["SiteUser"]); StudentService studentService = new StudentService(siteUser, db); SchoolService schoolService = new SchoolService(siteUser, db); ModelServices modelService = new ModelServices(); ViewBag.DistrictDesc = siteUser.Districts[0].Name; int schoolYearId = modelService.GetSchoolYearId(Convert.ToInt32(hiddenSchoolYearFilter)); ViewBag.SchoolId = modelService.DropDownDataSchool(hiddenSchoolFilter, siteUser.EdsUserId, schoolYearId, true); ViewBag.AllowEdit = HelperService.AllowUiEdits(siteUser.RoleDesc, "STUDENT"); ViewBag.SchoolYearList = schoolService.DropDownDataSchoolYear(hiddenSchoolYearFilter); ViewBag.SchoolYear = hiddenSchoolYearFilter; return View("Index", new SiteModels() { Students = studentService.GetViewData(hiddenSchoolYearFilter, hiddenSchoolFilter) }); } catch (Exception ex) { Logging log = new Logging(); log.LogException(ex); return View("GeneralError"); } }
public ActionResult UpdateGrid(string hiddenSchoolFilter, string schoolYearFilter) { try { db = new dbTIREntities(); siteUser = ((SiteUser)Session["SiteUser"]); userService = new UserService(siteUser, db); schoolService = new SchoolService(siteUser, db); modelService = new ModelServices(); ViewBag.SchoolYearList = schoolService.DropDownDataSchoolYear(schoolYearFilter); int schoolYearId = modelService.GetSchoolYearId(Convert.ToInt32(schoolYearFilter)); FillViewBagValues(siteUser.Districts[0].Name, hiddenSchoolFilter, siteUser.RoleDesc, schoolYearId); return View("Index", userService.GetViewData(schoolYearFilter, hiddenSchoolFilter, "")); } catch (Exception ex) { Logging log = new Logging(); log.LogException(ex); return View("GeneralError"); } }
public ActionResult Index() { try { db = new dbTIREntities(); siteUser = ((SiteUser)Session["SiteUser"]); userService = new UserService(siteUser, db); schoolService = new SchoolService(siteUser, db); modelService = new ModelServices(); int schoolYearId = modelService.SchoolYearId(); string currentSchoolYear = schoolService.GetCurrentSchoolYear(); ViewBag.SchoolYearList = schoolService.DropDownDataSchoolYear(currentSchoolYear); FillViewBagValues(siteUser.Districts[0].Name, string.Empty, siteUser.RoleDesc, schoolYearId); return View(userService.GetViewData(currentSchoolYear, "", "")); } catch (Exception ex) { Logging log = new Logging(); log.LogException(ex); return View("GeneralError"); //throw; } }
public ActionResult Edit(tblUserExt tblUserExtended) { try { db = new dbTIREntities(); modelService = new ModelServices(); siteUser = ((SiteUser)Session["SiteUser"]); userService = new UserService(siteUser, db); schoolService = new SchoolService(siteUser, db); int userAssignedDistrict = siteUser.Districts[0].Id; if (ModelState.IsValid) { if (tblUserExtended.SelectedSchools != null && tblUserExtended.SelectedSchools.Count() > 0) { bool isEmailAddressExist = db.tblUsers.Where(x => x.UserEmail == tblUserExtended.UserEmail && x.UserId != tblUserExtended.UserId).Count() > 0 ? true : false; bool isStateIdExist = db.tblUsers.Where(x => x.StateId == tblUserExtended.StateId && x.UserId != tblUserExtended.UserId).Count() > 0 ? true : false; if ((!isEmailAddressExist) && (!isStateIdExist)) { userService.UpdateUser(tblUserExtended); HelperService.UpdateSiteUserProfile(siteUser, db); return RedirectToAction("Index"); } else { if (isEmailAddressExist) ModelState.AddModelError("UserEmail", "Duplicate email - please choose a unique email."); if (isStateIdExist) ModelState.AddModelError("StateId", "Duplicate state id - please choose a unique state."); } } else { ViewBag.SchoolMessage = "Required"; } } tblUserExtended.Schools = userService.GetSelectedSchoolCheckBoxes(tblUserExtended); FillViewBagValues(siteUser.Districts[0].Name, string.Empty, siteUser.RoleDesc, tblUserExtended.SchoolYearId); FillUserExtendedCommanData(modelService, tblUserExtended); return View(tblUserExtended); } catch (Exception ex) { Logging log = new Logging(); log.LogException(ex); return View("GeneralError"); } }
public ActionResult Edit(int? id, int schoolYearId) { try { db = new dbTIREntities(); modelService = new ModelServices(); siteUser = ((SiteUser)Session["SiteUser"]); schoolService = new SchoolService(siteUser, db); userService = new UserService(siteUser, db); //tblUserExt tbluserExtended = null; if (id == null) { return new HttpStatusCodeResult(HttpStatusCode.BadRequest); } tblUser tbluser = db.tblUsers.Find(id); if (tbluser == null) { return new HttpStatusCodeResult(HttpStatusCode.BadRequest); } var context = new Models.ApplicationDbContext(); var userManager = new UserManager<ApplicationUser>(new UserStore<ApplicationUser>(context)); string aspNetUserName = "******"; if (!String.IsNullOrEmpty(tbluser.AspNetUserId)) { ApplicationUser aspNetUser = userManager.FindById(tbluser.AspNetUserId); if (aspNetUser != null) { aspNetUserName = aspNetUser.UserName; } } //Get RoleId from tblUserDistrict instead of tblUser int roleId = userService.GetRoleId(id, schoolYearId); tblUserExt tbluserExtended = new tblUserExt() { UserId = tbluser.UserId, UserName = aspNetUserName, FirstName = tbluser.FirstName, LastName = tbluser.LastName, UserEmail = tbluser.UserEmail, StateId = tbluser.StateId, Schools = tbluser.Schools, SchoolYearId = schoolYearId, RoleId = roleId }; //Check that edited user's school must be from EDSUser schools or edsUser must have permissions to view user school bool isUserHasPermissionForSchool = userService.IsUserHasPermissionForSchool(tbluserExtended); if (!isUserHasPermissionForSchool) { return RedirectToAction("Index"); } //Get User schools tbluserExtended.Schools = userService.GetUserSchoolWithCheckBoxes(tbluserExtended); var dropDownEmpty = Enumerable.Repeat(new SelectListItem { Value = "", Text = "" }, count: 1); FillViewBagValues(siteUser.Districts[0].Name, string.Empty, siteUser.RoleDesc, schoolYearId); FillUserExtendedCommanData(modelService, tbluserExtended); return View(tbluserExtended); } catch (Exception ex) { Logging log = new Logging(); log.LogException(ex); return View("GeneralError"); } }
public async Task<ActionResult> Create(tblUserExt tblUserExtended) { try { db = new dbTIREntities(); modelService = new ModelServices(); siteUser = ((SiteUser)Session["SiteUser"]); userService = new UserService(siteUser, db); schoolService = new SchoolService(siteUser, db); int userAssignedDistrict = siteUser.Districts[0].Id; string currentSchoolYear = schoolService.GetCurrentSchoolYear(); if (ModelState.IsValid) { if (tblUserExtended.SelectedSchools != null && tblUserExtended.SelectedSchools.Count() > 0) { var context = new Models.ApplicationDbContext(); var userManager = new UserManager<ApplicationUser>(new UserStore<ApplicationUser>(context)); // 1. Create ASPNET user string userName = tblUserExtended.UserName; string password = tblUserExtended.Password; var isPasswordValid = password != null && password.Length >= 6 ? true : false; var isUserNameExist = userManager.FindByName(userName); bool isEmailAddressExist = db.tblUsers.Where(x => x.UserEmail == tblUserExtended.UserEmail).Count() > 0 ? true : false; bool isStateIdExist = db.tblUsers.Where(x => x.StateId == tblUserExtended.StateId).Count() > 0 ? true : false; if ((isUserNameExist == null) && (!isEmailAddressExist) && (!isStateIdExist) && (isPasswordValid)) { var user = new ApplicationUser() { UserName = userName }; var result = await userManager.CreateAsync(user, password); if (result.Succeeded) { // 2. Create EDS user ApplicationUser newAspNetUser = userManager.FindByName(userName); if (newAspNetUser != null) { userService.CreateEdsUser(newAspNetUser.Id, tblUserExtended); } } else { throw new Exception(String.Format("ERROR: {0}", result.Errors)); } return RedirectToAction("Index"); } else { if (isUserNameExist != null) ModelState.AddModelError("UserName", "Duplicate name - please choose a unique name."); if (isEmailAddressExist) ModelState.AddModelError("UserEmail", "Duplicate email - please choose a unique email."); if (isStateIdExist) ModelState.AddModelError("StateId", "Duplicate state id - please choose a unique state."); if (!isPasswordValid) ModelState.AddModelError("Password", "Please enter password at least 6 characters."); } } else { ViewBag.SchoolMessage = "Required"; } } tblUserExtended.Schools = userService.GetSelectedSchoolCheckBoxes(tblUserExtended); ViewBag.RoleId = new SelectList(modelService.GetRolesForRole((int)(siteUser.Role)), "RoleId", "RoleDesc", tblUserExtended.RoleId); FillViewBagValues(siteUser.Districts[0].Name, string.Empty, siteUser.RoleDesc, tblUserExtended.SchoolYearId); return View(tblUserExtended); } catch (Exception ex) { Logging log = new Logging(); log.LogException(ex); return View("GeneralError"); } }
// GET: /User/Create public ActionResult Create() { try { db = new dbTIREntities(); siteUser = ((SiteUser)Session["SiteUser"]); modelService = new ModelServices(); schoolService = new SchoolService(siteUser, db); userService = new UserService(siteUser, db); int userAssignedDistrict = siteUser.Districts[0].Id; int schoolYearId = modelService.SchoolYearId(); tblUserExt userExtended = new tblUserExt(); userExtended.SchoolYearId = schoolYearId; userExtended.Schools = userService.GetSchoolWithCheckBoxes(userExtended); ViewBag.RoleId = new SelectList(modelService.GetRolesForRole((int)(siteUser.Role)), "RoleId", "RoleDesc"); FillViewBagValues(siteUser.Districts[0].Name, string.Empty, siteUser.RoleDesc, schoolYearId); return View(userExtended); } catch (Exception ex) { Logging log = new Logging(); log.LogException(ex); return View("GeneralError"); } }
public ActionResult Search(string searchClass, string hiddenSchoolFilterSearch, string hiddenSchoolYearFilterSearch) { try { dbTIREntities db = new dbTIREntities(); SiteUser siteUser = ((SiteUser)Session["SiteUser"]); ClassService classService = new ClassService(siteUser, db); SchoolService schoolService = new SchoolService(siteUser, db); ModelServices modelService = new ModelServices(); ViewBag.DistrictDesc = siteUser.Districts[0].Name; int schoolYearId = modelService.GetSchoolYearId(Convert.ToInt32(hiddenSchoolYearFilterSearch)); ViewBag.SchoolId = modelService.DropDownDataSchool(hiddenSchoolFilterSearch, siteUser.EdsUserId, schoolYearId, true); ViewBag.SchoolYear = schoolService.DropDownDataSchoolYear(hiddenSchoolYearFilterSearch); ViewBag.AllowEdit = HelperService.AllowUiEdits(siteUser.RoleDesc, "CLASS"); return View("Index", new SiteModels() { SchoolClasses = classService.GetViewData(hiddenSchoolYearFilterSearch, hiddenSchoolFilterSearch, searchClass) }); } catch (Exception ex) { Logging log = new Logging(); log.LogException(ex); return View("GeneralError"); } }
private void PopulateViewData(tblClass tblclass, ClassWizardSteps? defaultWizardStep, bool? showTeachersForDistrict, bool? showStudentsForDistrict) { ViewBag.DefaultWizardStep = defaultWizardStep; ViewBag.ShowTeachersForDistrict = !showTeachersForDistrict.GetValueOrDefault(); ViewBag.ShowStudentsForDistrict = !showStudentsForDistrict.GetValueOrDefault(); var db = new dbTIREntities(); SiteUser siteUser = (SiteUser)Session["SiteUser"]; SchoolService schoolService = new SchoolService(siteUser, db); ClassService classService = new ClassService(siteUser, db); ModelServices modelService = new ModelServices(); int userAssignedDistrict = siteUser.Districts[0].Id; bool filterTeachersByDistrict = showTeachersForDistrict.GetValueOrDefault(); int districtId = userAssignedDistrict; // Get teachers for this class var teachersForThisClass = classService.GetTeachersForThisClass(tblclass); // Get teachers not in this class var teachersNotForThisClass = classService.GetTeachersNotForThisClass(tblclass, filterTeachersByDistrict, districtId); //Get students for this class var studentsForThisClass = classService.GetStudentForThisClass(tblclass); // Get students not for this class var availableStudents = classService.GetStudentNotForThisClass(tblclass, districtId); var availableStudentsForSchool = classService.GetStudentForSchool(tblclass, districtId); // Add data to ViewBag for form ViewBag.TeachersForThisClass = new MultiSelectList(teachersForThisClass, "TeacherId", "FullName", null); ViewBag.AvailableTeachers = new MultiSelectList(teachersNotForThisClass, "TeacherId", "FullName", null); if (showStudentsForDistrict.GetValueOrDefault()) { ViewBag.AvailableStudents = new MultiSelectList(availableStudents, "StudentId", "FullName", null); } else { ViewBag.AvailableStudents = new MultiSelectList(availableStudentsForSchool, "StudentId", "FullName", null); } ViewBag.StudentsForThisClass = new MultiSelectList(studentsForThisClass, "StudentId", "FullName", null); ViewBag.StudentsForThisClassCount = studentsForThisClass.Count(); ViewBag.SchoolId = modelService.DropDownDataSchool(Convert.ToString(tblclass.SchoolId), siteUser.EdsUserId, tblclass.SchoolYearId, false); ViewBag.SchoolYearId = modelService.GetUserSchoolYear(siteUser.EdsUserId, siteUser.Districts[0].Id, tblclass.SchoolYearId); ViewBag.ClassDesc = db.tblClasses.Where(x => x.ClassId == tblclass.ClassId).Select(x => x.ClassDesc).SingleOrDefault(); ViewBag.SubjectId = new SelectList(db.tblSubjects.OrderBy(x => x.SubjectDesc), "SubjectId", "SubjectDesc", tblclass.SubjectId); ViewBag.AllowEdit = HelperService.AllowUiEdits(siteUser.RoleDesc, "CLASS"); }
public ActionResult Create([Bind(Include = "ClassId,SchoolId,ClassDesc,SchoolYearId,SubjectId,Grade,CreateDatetime,ChangeDatetime")] tblClass tblclass) { try { var db = new dbTIREntities(); SiteUser su = (SiteUser)Session["SiteUser"]; SchoolService schoolService = new SchoolService(su, db); ModelServices modelService = new ModelServices(); if (ModelState.IsValid) { ClassService classService = new ClassService((SiteUser)Session["SiteUser"], db); if (!(classService.IsClassExists(tblclass))) { classService.AddClass(newClass: tblclass); return RedirectToAction("Edit", new { id = tblclass.ClassId, defaultWizardStep = ClassWizardSteps.Teachers }); } else { int defaultDistrict = su.Districts[0].Id; ViewBag.DistrictDesc = su.Districts[0].Name; ModelState.AddModelError("ClassDesc", "Duplicate class name - please choose a unique name."); } } ViewBag.SchoolId = modelService.DropDownDataSchool("", su.EdsUserId, tblclass.SchoolYearId, false); ViewBag.SchoolYearId = modelService.GetUserSchoolYear(su.EdsUserId, su.Districts[0].Id, tblclass.SchoolYearId); ViewBag.SubjectId = new SelectList(db.tblSubjects.OrderBy(x => x.SubjectDesc), "SubjectId", "SubjectDesc", tblclass.SubjectId); return View(tblclass); } catch (Exception ex) { Logging log = new Logging(); log.LogException(ex); return View("GeneralError"); } }
// GET: /Classes/Create public ActionResult Create() { try { SiteUser siteUser = (SiteUser)Session["SiteUser"]; var db = new dbTIREntities(); SchoolService schoolService = new SchoolService(siteUser, db); ModelServices modelService = new ModelServices(); int defaultDistrict = siteUser.Districts[0].Id; ViewBag.DistrictDesc = siteUser.Districts[0].Name; int schoolYearId = modelService.SchoolYearId(); ViewBag.SchoolId = modelService.DropDownDataSchool("", siteUser.EdsUserId, schoolYearId, false); ViewBag.SchoolYearId = modelService.GetUserSchoolYear(siteUser.EdsUserId, defaultDistrict, schoolYearId); ViewBag.SubjectId = new SelectList(db.tblSubjects.OrderBy(x => x.SubjectDesc), "SubjectId", "SubjectDesc"); return View(); } catch (Exception ex) { Logging log = new Logging(); log.LogException(ex); return View("GeneralError"); } }
public ActionResult Edit([Bind(Include = "ClassId,SchoolId,ClassDesc,SchoolYearId,SubjectId,Grade")] tblClass tblclass) { try { var db = new dbTIREntities(); SiteUser siteUser = (SiteUser)Session["SiteUser"]; SchoolService schoolService = new SchoolService(siteUser, db); ModelServices modelService = new ModelServices(); if (ModelState.IsValid) { ClassService classService = new ClassService((SiteUser)Session["SiteUser"], db); if (!(classService.IsEditClassExists(tblclass))) { classService.EditClass(editClass: tblclass); return RedirectToAction("Edit", new { id = tblclass.ClassId, defaultWizardStep = ClassWizardSteps.Teachers }); } else { PopulateViewData(tblclass, null, null, null); ModelState.AddModelError("ClassDesc", "Duplicate class name - please choose a unique name."); return View(tblclass); } } ViewBag.SchoolYearId = modelService.GetUserSchoolYear(siteUser.EdsUserId, siteUser.Districts[0].Id, tblclass.SchoolYearId); ViewBag.SchoolId = modelService.DropDownDataSchool(tblclass.SchoolId.ToString(), siteUser.EdsUserId, tblclass.SchoolYearId, true); ViewBag.SubjectId = new SelectList(db.tblSubjects, "SubjectId", "SubjectDesc", tblclass.SubjectId); return View(tblclass); } catch (Exception ex) { Logging log = new Logging(); log.LogException(ex); return View("GeneralError"); } }