// // GET: /AssessmentClassScore/ public ActionResult Search(AssessmentClassScoreViewModel model) { try { db = new dbTIREntities(); siteUser = ((SiteUser)Session["SiteUser"]); assessmentClassScoreService = new AssessmentClassScoreService(siteUser, db); if (assessmentClassScoreService.IsAssessmentWeightingExists(model)) { InitializeAssessmentScoreMetadata(model); if (model.ScoresDetails.Count == 0) { ViewBag.Message = "No Record Found."; } } else { ViewBag.Message = "This combination of subject and assessment does not exist in the system for the selected school year."; } FillDropDowns(model, true); return View("Index", model); } catch (Exception ex) { Logging log = new Logging(); log.LogException(ex); return View("GeneralError"); } }
public ActionResult Create() { db = new dbTIREntities(); siteUser = ((SiteUser)Session["SiteUser"]); commonService = new CommonService(siteUser, db); WeightingViewModel model = new WeightingViewModel(); FillDropDowns(model); return View(model); }
public ActionResult Index() { db = new dbTIREntities(); siteUser = ((SiteUser)Session["SiteUser"]); assScoreService = new AssessmentScoreService(siteUser, db); commonService = new CommonService(siteUser, db); AssessmentScoreViewModel model = new AssessmentScoreViewModel(); model.DistrictName = siteUser.Districts[0].Name; model.DistrictId = siteUser.Districts[0].Id; FillDropDowns(model); return View(model); }
public ActionResult Search(AssessmentScoreViewModel model) { db = new dbTIREntities(); siteUser = ((SiteUser)Session["SiteUser"]); assScoreService = new AssessmentScoreService(siteUser, db); model.DistrictName = siteUser.Districts[0].Name; model.DistrictId = siteUser.Districts[0].Id; model.StudentScores = assScoreService.GetAssessmentScoreData(model); FillDropDowns(model); TempData["AssessmentModel"] = model; return View("Index", model); }
public static ReportFilterViewModel PopulateReportFilterViewModel(FilterParameter filterParameter, ModelServices modelService, SiteUser siteUser) { string defaultText = "All"; var reportFilterViewModel = new ReportFilterViewModel(); reportFilterViewModel.TeacherName = modelService.GetUserNameByUserId(filterParameter.Teacher); reportFilterViewModel.ClassName = filterParameter.ClassId != -1 ? modelService.GetClassDesc(filterParameter.ClassId) : defaultText; reportFilterViewModel.Race = (filterParameter.Race == -1) ? defaultText : modelService.GetRaceDesc(filterParameter.Race); reportFilterViewModel.Gender = (filterParameter.Gender == -1) ? defaultText : modelService.GetGenderDesc(filterParameter.Gender); //TODO: till now first record with district name and Id is picked up. Need to refactor if user belongs to multiple district. reportFilterViewModel.DistrictName = siteUser.Districts.First().Name; reportFilterViewModel.IsAdmin = HelperService.AllowUiEdits(siteUser.RoleDesc, "REPORT"); reportFilterViewModel.DisplayAdminFilters = DecideFilterDisplay(filterParameter); reportFilterViewModel.FrlIndicator = filterParameter.FrlIndicator; reportFilterViewModel.LepIndicator = filterParameter.LEPIndicator; reportFilterViewModel.IepIndicator = filterParameter.IEPIndicator; reportFilterViewModel.Hispanic = filterParameter.Hispanic; reportFilterViewModel.SchoolYear = filterParameter.SchoolYear; return reportFilterViewModel; }
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 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 ClassService(SiteUser siteUser, dbTIREntities db) { _db = db; _siteUser = siteUser; }
private void FillDropDowns(AssessmentClassScoreViewModel model, bool isPostBack) { siteUser = ((SiteUser)Session["SiteUser"]); db = new dbTIREntities(); commonService = new CommonService(siteUser, db); modelServices = new ModelServices(); model.DropDown = new DropDownData(); int schoolYearId = int.Parse(model.SchoolYearId); model.DistrictName = siteUser.Districts[0].Name; model.DistrictId = siteUser.Districts[0].Id; model.Assessment = commonService.GetAssessmentType(); model.SchoolYears = commonService.GetSchoolYear(); model.SchoolTerms = commonService.GetSchoolTerm(); model.Subjects = commonService.GetSubjects(); int[] userSchools = modelServices.getSchoolsByUserId(siteUser.EdsUserId).ToArray(); model.DropDown.School = new SchoolDropDown(modelServices.GetSchoolDropDownData(siteUser.EdsUserId, schoolYearId), true, "--SELECT--", ""); int[] schoolsTeacher = modelServices.getTeachersBySchoolsId(userSchools).ToArray(); if (isPostBack) { model.DropDown.Teacher = new TeacherDropDown(modelServices.TeacherDropDownDataBySchoolAndYear(new int[] { int.Parse(model.SchoolId) }, schoolYearId, model.DistrictId), "--SELECT--", ""); model.DropDown.SchoolClass = new ClassDropDown(modelServices.GetClassesByTeacher(schoolYearId, new[] { int.Parse(model.TeacherId) }), "--SELECT--", ""); } else { model.DropDown.Teacher = new TeacherDropDown(modelServices.TeacherDropDownDataBySchoolAndYear(userSchools, schoolYearId, model.DistrictId), "--SELECT--", ""); model.DropDown.SchoolClass = new ClassDropDown(modelServices.GetClassesByTeacher(schoolYearId, schoolsTeacher), "--SELECT--", ""); } }
public StudentService(SiteUser siteUser, dbTIREntities db) { _db = db; _siteUser = siteUser; }
private void AssignMePercentForAssessment(HeirarchicalScoreData scoreData, ModelServices service, SiteUser su, TIRDetailReportParameter detailReportParameter, ref List<AssessmentMEPerc> AssessmentMePercentages) { if (scoreData != null) { detailReportParameter.AssessmentTypeId = scoreData.AssessmentTypeId; var mePercentForAssessment = service.GetMEPercentForAssessment(su.Districts.First().Id, scoreData.AssessmentId, detailReportParameter); AssessmentMePercentages.Add(mePercentForAssessment); } }
public static void SetUserLoginInfo(SiteUser siteUser, dbTIREntities db) { var userLoggedInInfo = db.tblUserLoginInfoes.Where(l => l.UserId == siteUser.EdsUserId).FirstOrDefault(); if (userLoggedInInfo != null) { userLoggedInInfo.LoginDate = DateTime.Now.ToUniversalTime(); db.Entry(userLoggedInInfo).State = EntityState.Modified; } else { tblUserLoginInfo userLoginInfo = new tblUserLoginInfo() { UserId = siteUser.EdsUserId, LoginDate = DateTime.Now.ToUniversalTime() }; db.tblUserLoginInfoes.Add(userLoginInfo); } db.SaveChanges(); }
public static void UpdateSiteUserProfile(SiteUser su, dbTIREntities db) { SiteUser siteUser = su; siteUser.Schools = (from userSchool in db.tblUserSchools join school in db.tblSchools on userSchool.SchoolId equals school.SchoolId where userSchool.UserId == su.EdsUserId select new UserSchool() { Id = userSchool.SchoolId, Name = school.SchoolDesc, DistrictId = school.DistrictId, SchoolYearId = userSchool.SchoolYearId }).ToList(); HttpContext.Current.Session["SiteUser"] = siteUser; }
/// <summary> /// Pulls user profile from ASPNet Identity and TIR databases. /// </summary> /// <param name="aspnetUser"></param> /// <param name="db"></param> /// <returns></returns> public static SiteUser GetUserProfile(ApplicationUser aspnetUser, dbTIREntities db) { int currentSchoolYear = SchoolYear(); int schoolYearId = GetSchoolYearId(currentSchoolYear, new dbTIREntities()); var edsUserId = (from e in db.tblUsers where e.AspNetUserId == aspnetUser.Id select e.UserId).SingleOrDefault(); var edsUser = (from user in db.tblUsers join ud in db.tblUserDistricts on user.UserId equals ud.UserId join role in db.tblRoles on ud.RoleId equals role.RoleId where user.AspNetUserId == aspnetUser.Id && ud.SchoolYearId == schoolYearId select new { FullName = user.FirstName + " " + user.LastName, RoleId = role.RoleId, RoleDesc = role.RoleDesc }).FirstOrDefault(); SiteUser siteUser = new SiteUser() { EdsUserId = edsUserId, IdentityUserId = aspnetUser.Id, IdentityUserName = aspnetUser.UserName, UserFullName = edsUser.FullName, Role = edsUser.RoleId, RoleDesc = edsUser.RoleDesc, isAdministrator = edsUser.RoleDesc.Equals(SiteRole_Administrator, StringComparison.OrdinalIgnoreCase), isDataAdministrator = edsUser.RoleDesc.Equals(SiteRole_DataAdministrator, StringComparison.OrdinalIgnoreCase), isEdsAdministrator = edsUser.RoleDesc.Equals(SiteRole_EdsAdministrator, StringComparison.OrdinalIgnoreCase), isTeacher = edsUser.RoleDesc.Equals(SiteRole_Teacher, StringComparison.OrdinalIgnoreCase), Districts = (from userDistrict in db.tblUserDistricts join district in db.tblDistricts on userDistrict.DistrictId equals district.DistrictId where userDistrict.UserId == edsUserId && userDistrict.SchoolYearId == schoolYearId select new UserDisctrict() { Id = district.DistrictId, Name = district.DistrictDesc }).ToList(), Schools = (from userSchool in db.tblUserSchools join school in db.tblSchools on userSchool.SchoolId equals school.SchoolId where userSchool.UserId == edsUserId select new UserSchool() { Id = userSchool.SchoolId, Name = school.SchoolDesc, DistrictId = school.DistrictId, SchoolYearId = userSchool.SchoolYearId }).ToList() }; return siteUser; }
public SchoolService(SiteUser siteUser, dbTIREntities db) { _siteUser = siteUser; _db = db; }
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 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"); } }
private void FillDropDowns(WeightingViewModel model) { siteUser = ((SiteUser)Session["SiteUser"]); commonService = new CommonService(siteUser, db); model.AssessmentTypes = commonService.GetAssessmentType(); model.Subjects = commonService.GetSubjects(); model.SchoolYears = commonService.GetSchoolYear(); model.Districts = commonService.GetDistrict(); }
public AssessmentScoreService(SiteUser siteUser, dbTIREntities db) { _db = db; _siteUser = siteUser; }
public KnowledgeBaseService(SiteUser siteUser, dbTIREntities db) { _siteUser = siteUser; _db = db; }
public ActionResult Create(WeightingViewModel model) { if (ModelState.IsValid) { try { db = new dbTIREntities(); siteUser = ((SiteUser)Session["SiteUser"]); commonService = new CommonService(siteUser, db); weightingService = new WeightingService(siteUser, db); bool weightingAlreadyExist = weightingService.SaveWeightingDetail(model); if (!weightingAlreadyExist) { ViewBag.UserMessage = "Data Saved Successfully."; model = new WeightingViewModel(); FillDropDowns(model); ModelState.Clear(); } else { ViewBag.UserMessage = "Data already exists."; FillDropDowns(model); } } catch (Exception ex) { Logging log = new Logging(); log.LogException(ex); return View("GeneralError"); } } return View(model); }
private void FillDropDowns(AssessmentScoreViewModel model) { siteUser = ((SiteUser)Session["SiteUser"]); commonService = new CommonService(siteUser, db); assScoreService = new AssessmentScoreService(siteUser, db); model.AssessmentTypes = commonService.GetAssessmentType(); model.SchoolYears = commonService.GetSchoolYear(); model.SchoolTerms = commonService.GetSchoolTerm(); }
public SupportService(SiteUser siteUser, dbTIREntities db) { _siteUser = siteUser; _db = db; }
public WeightingService(SiteUser siteUser, dbTIREntities db) { _db = db; _siteUser = siteUser; }